Import data into Clockify
If you have historical timesheets data in Excel, you can easily import your workspace data, including Projekte, Aufgaben, Kunden, Tags, Zeiteinträge und ihre benutzerdefinierten Felder into Clockify using a CSV file.
Clockify’s import wizard is designed to guide you through the process and help you catch errors before you finalize the import.
Import data and permissions #
| Data | User role | Subscription plan |
| Projects, clients, tasks, tags | owner/admin | Any plan |
| Arbeitszeittabellen | owner/admin | Paid plans only |
The maximum file size for any CSV file is 10MB.
Format your data #
To make sure that the import is completed successfully, your CSV data need to match the format required by Clockify.
The easiest way to format your data correctly is by downloading our pre-made templates for Arbeitszeittabellen, Projekte und Kunden directly from the Importieren nicht sehen.
You also need to make sure that your CSV file contains all the required columns for your workspace and that the column headers are named correctly.
Start import #
To start the import process:
- Gehe zur Registerkarte Einstellungen and choose the Importieren -Registerkarte
- Drag & drop a CSV file, or upload it from your computer
Import wizard #
The import wizard guides you through two import steps that leave your data clean and accurate.
Step 1: Inspect data #
After you upload your file, a preview will appear. Here, you can review the data and correct any issues before you proceed.
Error detection
The wizard automatically highlights rows and errors. Use the Only show rows with errors option to quickly filter the list and see what needs to be fixed.
Fix errors & reupload
Clockify automatically detects common delimiters (commas and semicolons). If a column name is not recognized, it will be marked with a warning and that data won’t be imported.
If you find errors you need to fix, you can make changes to your file outside Clockify and reupload it directly from this step.
Timesheet-specific checks
If you are importing Timesheet data, the wizard will ask you to confirm the date format used in your file.
You will also be notified if you are importing Arbeitszeittabelle data for users who are not yet in your workspace, allowing you to add them first.
Step 2: Import summary #
Once you’ve reviewed your data and clicked Importieren, the progress bar will show the import status. The import will continue in the background if you leave the page.
When it’s complete, a summary will be displayed with a link to your newly-imported data in Clockify.
Check time and date formats
The formats used in your CSV file must exactly match the formats set in your Clockify account.
| Format | Where to check settings | Mismatch example |
| Time (12-hour / 24-hour) | Profileinstellungen | If your CSV has 1:00 PM, but your settings use 24-hour time, the import will fail. |
| Duration (hh:mm:ss, etc.) | Workspace Settings | Your CSV duration format (e.g. 1:30) doesn’t match the format set in your workspace. |
| Date (DD/MM/YYYY, etc.) | Profileinstellungen | Your CSV date format doesn’t match the one set in your profile. |
Maximale Zeichenbegrenzung #
- Beschreibung: 3000
- Aufgabe: 1000
- Projekt: 250
- Kunde: 100
- Tag: 100
Wichtiger Hinweis #
- Pflichtfelder beim Zeitimport: E-Mail, Startdatum, Startzeit, Dauer
- Optionale Felder beim Zeitimport: Abrechenbar, Beschreibung, Projekt, Aufgabe, Kunde, Tag (falls ein Pflichtfeld aktiviert ist, ist es auch in CSV erforderlich)
- If you don’t group projects by client, you should rename the client column in the CSV file accordingly
- End date and end time are calculated automatically based on start time and duration
- Zeiteinträge werden entsprechend der Zeitzone der Person importiert, die den Import ausführt.
- If you don’t specify an entry’s billable status, it will be inherited from its project
- Stundensätze werden entsprechend der Hierarchie übernommen.