Daten in Clockify importieren

If you have historical timesheets data in Excel, or if you’re moving from other apps, you can import your workspace data, including projects, tasks, clients, tags, time entries and their custom fields into Clockify using a CSV file.

Clockify’s import data process is designed to guide you and help you catch errors before you finalize the import.

Daten und Berechtigungen importieren   #

Data	Benutzerrolle	Subscription plan
Projects, clients, tasks, tags	owner/admin	Any plan
Arbeitszeittabellen	owner/admin	Paid plans only
Users (Coming soon)	owner/admin	Standard plan and higher

Import details #

• File Size: The maximum file size for any CSV is 10 MB.
• Import limit: You can import up to 1,000 users per file.
• SCIM: If you have SCIM enabled, you must manage users through your Identity Provider (IdP) rather than this CSV tool.
• Trial Note: User import is not supported during the free trial period.

Format your data #

To ensure the import completes successfully, your CSV data must match the format required by Clockify.

Download templates (recommended)

The easiest way to format your data correctly is by downloading our pre-made templates. 

So funktioniert es: 

1. Klicke auf die drei Punkte neben deinem Arbeitsbereichsnamen
2. Wähle Arbeitsbereichseinstellungen
3. Click the Import tab
4. Click the relevant button (Timesheets, Projects & Clients, or Users) to download the correct file

IN KÜRZE VERFÜGBAR

For user imports, you can choose between: 

• Limited users: For users with restricted access (requires name)
• Full users: For standard team members (requires email)

Use English headers #

All CSV column headers must be in English and exactly match the names in your Workspace settings, even if you use the app in a different language.

Include all required columns 

• Time import: Email, Start date, Start time, and Duration are required
• Full user import: Email is always required. If the role is Project manager or Team manager, you must also fill in the Managing columns
• Limited user import: Name is the only required field

Multiple values

To assign multiple roles, managed projects, managed employees, or groups to a single user, separate each entry with a comma.

Project & client association

If a project belongs to a specific client (e.g., Project A under Client A), use the following format in the Projects Managed column:

Project Name: Client Name

The system will automatically recognize the project and its associated client using this syntax.

Optional fields

The following fields are optional. If left blank, the system will automatically apply your Workspace Defaults: 

• Daily Work Capacity
• Billable & Cost Rates
• Working Days & Week Start

Import starten #

So startest du den Importvorgang: 

1. Gehe zu Arbeitsbereichseinstellungen
2. Click the Import tab
3. Drag and drop a CSV file, or upload it from your computer 
4. Follow the two-step verification process:

Step 1: Inspect data (Preview screen) #

Nach dem Hochladen deiner Datei wird eine Vorschau angezeigt. Hier kannst du die Daten überprüfen und eventuelle Probleme beheben, bevor du fortfährst. 

Fehlererkennung 

Zeilen und Fehler werden automatisch markiert. Nutze die Option Nur Zeilen mit Fehlern anzeigen, um die Liste schnell zu filtern und zu sehen, was behoben werden muss. 

Fehler beheben und erneut hochladen

Clockify automatically detects common delimiters (commas and semicolons). If a column name is not recognized, it will be marked with a warning, and the data from that column will not be imported.

If you identify errors requiring correction, you can modify the file externally and then upload the corrected version directly from this step in Clockify.

Spezifische Prüfungen für Arbeitszeittabellen-Daten #

If you are importing Timesheet data, you need to confirm the date format used in your file.
You will also be notified if you are importing Timesheet data for users who are not yet in your workspace, allowing you to add them first.  

Admin import

If importing users with the Admin role, you need to verify their permissions.

Missing seats

If you are missing seats for new users, you can buy seats immediately, or cancel the import to review your list.

Schritt 2: Import-Zusammenfassung #

Once you click Import, a progress bar will track the status. When complete, a summary will display the results: 

• Timesheets/projects: Link to the imported data
• Users: Breakdown of new Admins, Managers and Members with links to your Team page 

Datum- und Zeitformate überprüfen  #

The formats in your CSV file must exactly match those configured in your Clockify account.

Format	Where to check settings	Mismatch example
Time (12-hour / 24-hour)	Profile settings	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.)	Profile settings	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

Wichtige Hinweise #

• All imported users receive an email invitation and existing Clockify users simply log in to accept the invite
• New users will be prompted to sign up using the name provided in the CSV as a suggested user name
• 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
• Enddatum und Endzeit werden anhand der Startzeit und Dauer automatisch berechnet
• 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