What Clockify's help page says
Clockify reads your CSV file based on your account and workspace formatting settings. The start date, start time, and duration fields must follow these settings.
Your CSV file must match these formats exactly; otherwise, the file will be rejected.
Quoted word for word from Clockify's help page, listed under Sources.
Why it happens
- Your Clockify profile uses one date format (for example MM/DD/YYYY) and the file uses another (for example 2026-03-25).
- The file has 13:00 and your profile is set to 12-hour time, or the other way round.
- The workspace duration format is Decimal, Full or Compact, and the Duration column is written in a different one.
How to fix it
- In Clockify, click your profile picture in the upper right corner, select Preferences, and check the Date and Time formats under the General tab.
- Click the three dots next to your workspace name, select Workspace settings, and check the Duration format under the General tab: Decimal, Full or Compact.
- On the ClientHours Clockify page, open "Settings for the Toggl Track, Harvest and Clockify import files" and pick the same date format, time format and duration format. Then click "Clockify import (CSV)".
- When you upload the file in Clockify, select the same date and time formats in the pop-up window.
Calendar to Clockify CSV import
What the ClientHours file does
- Start date is written as YYYY-MM-DD (2026-03-25) or MM/DD/YYYY (03/25/2026), as you pick.
- Start time is written as 24-hour (13:00) or 12-hour (01:00 PM), as you pick.
- Duration is written as Full (01:30:00), Compact (1:30) or Decimal (1.50), as you pick, after rounding.
- Every row in one file uses the same three formats.
Limits
- The file offers two date formats only, YYYY-MM-DD and MM/DD/YYYY. If your Clockify profile uses another one, change the profile date format to one of these two before you import.
- Clockify's duration format page says Decimal format is a paid feature.
- Do not open and save the file in Excel before the upload. Clockify's troubleshooting page says Excel may change dates and times.
- 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
- Where do I see which formats my Clockify uses?
- Date and time formats are in your profile: profile picture, Preferences, General tab. The duration format is in the workspace: the three dots next to the workspace name, Workspace settings, General tab.
- Can ClientHours write a day/month date for Clockify?
- No. Its Clockify file offers YYYY-MM-DD and MM/DD/YYYY only. Set your Clockify profile to one of those two before you import.
- Is the file checked against my Clockify settings?
- No. ClientHours cannot see your Clockify account. It writes the formats you pick, so pick the ones your profile and workspace show.
Sources
Other import problems
- Clockify: "The file is not comma-delimited"
- Clockify: "Missing or incomplete field values"
- Toggl Track: "Adding new users increases your workspace fee"
- Toggl Track: "Not allowed as header: Project;task;client"
- Harvest: semicolons "will result in import errors"
- Google Calendar: "Processed zero events"
- Google Calendar: "Processed x of y events"
- "Google Calendar is temporarily unavailable" when importing
- Google Calendar: "Feed processing error"
- Calendar and time tracker import problems
ClientHours is free, with no account and no payment. The calendar file never leaves your browser.