Clockify: "The file is not comma-delimited"

Clockify's import expects commas between the values in a CSV. A file with semicolons, which Excel writes in many regions, will not import. The ClientHours Clockify file always uses commas, so upload it as it was downloaded, without opening and saving it in Excel first.

What Clockify's help page says

Clockify expects CSV files to use commas as delimiters. If your file uses semicolons instead, the import will not work.

If you opened or edited your CSV file in Excel, it might have changed the formatting (e.g., dates, times, or stripped leading zeroes). This often breaks the import.

Quoted word for word from Clockify's help page, listed under Sources.

Why it happens

  • The file was saved from a spreadsheet set to use semicolons as the list separator.
  • The file was opened and saved again in Excel, which may have changed the dates and times as well.

How to fix it

  1. Open the CSV in a plain text editor, such as Notepad or TextEdit, and look at the character between the values. Commas are right. Semicolons need changing.
  2. Clockify's page suggests opening the file in Google Sheets and downloading it again as CSV, which writes commas.
  3. Or make a new file: on the ClientHours Clockify page, click "Clockify import (CSV)" and upload that file as it is.

Calendar to Clockify CSV import

What the ClientHours file does

  • Values are separated by commas in every row.
  • A value that holds a comma, a double quote or a line break is put in double quotes, with inner quotes doubled, so a title like "Acme, weekly" stays one value.
  • Lines end with a carriage return and line feed (CRLF).
  • The file is UTF-8 without a byte order mark, so the first header reads exactly "Project".

Limits

  • Opening the downloaded file in Excel and saving it again can bring back the problem, depending on your Excel and region settings.
  • Clockify's pages do not say which text encoding they expect. The file is UTF-8.
  • Clockify's import page lists timesheet import as available on any paid plan.
  • No ClientHours file has been tested by importing into a real Clockify account. What the file contains is checked by tests. How Clockify reads it comes only from the help pages under Sources.

Questions

How do I see the delimiter in a CSV?
Open it in a plain text editor. If the values on each line are separated by commas, the delimiter is right for Clockify. If you see semicolons, the file needs converting.
Why did my file get semicolons?
Spreadsheet programs in many regions use semicolons when they save CSV. Clockify's page says to convert them to commas, for example by downloading the file again from Google Sheets.
Can I edit the ClientHours file before importing?
Yes, but a plain text editor or Google Sheets is safer than Excel. Clockify's page says Excel may change dates and times, which breaks the import.

Sources

Other import problems

ClientHours is free, with no account and no payment. The calendar file never leaves your browser.