You can import the following data:
Supported formats: JSON and CSV
Supported attributes (field names are case-insensitive):
Customer attribute | Supported field names |
---|---|
Name | customer, name |
Account | number, account, customer number, customer account |
Company name | company, company name, company-name |
Description | description, comment |
email, e-mail, e mail | |
Country | country |
Vat-ID | vat, vat-id, vat id, tax-id, tax id |
Address | address |
Contact | contact |
Currency | currency |
Timezone | timezone |
Phone | phone |
Mobile | mobile |
Fax | fax |
Homepage | homepage |
Color | color |
Budget | budget |
Time budget | time budget, time-budget |
Visible | visible |
Meta fields | meta.xxx |
A minimum CSV file (using semicolon as delimiter):
Name;Company
Acme,Acme university Ltd.
A multi column-example:
Name,Company,Number,Comment,Phone,Timezone,Meta.XYZ
Acme,Acme university Ltd.,12367800,A longer comment to talk about the project,0011234567890,Europe/Berlin,hello foo 123
Supported attributes (field names are case-insensitive):
Project attribute | Supported field names |
---|---|
Name | project, projectname, project name, project-name, name |
Customer name | customer, customername, customer-name, customer name |
Description | description, comment |
Order number | ordernumber, order-number, order number |
Order date | orderdate, order-date, order date |
Color | color |
Budget | budget |
Time budget | time budget, time-budget |
Visible | visible |
Meta fields | meta.xxx |
A minimum CSV example file (using semicolon as delimiter):
Name;Customer
Test project;Test customer
A multi column-example:
Name,Customer,Comment,OrderNumber,OrderDate,Meta.XYZ
My great project,Acme university,A longer comment to talk about the project,1234567890,2019-08-29,hello foo 123
This will import timesheets and create these elements on the fly:
Attribute | Supported field names |
---|---|
Duration | timesheet duration in seconds |
Tags | comma separated list of tag-names |
Exported | whether the timesheet should be marked as exported or not |
Rate | TODO … |
HourlyRate | TODO … |
InternalRate | TODO … |
FixedRate | TODO … |
Billable | TODO … |
Description | TODO … |
Tags | TODO … |
Project | TODO … |
Customer | TODO … |
Activity | TODO … |
Begin | TODO … |
End | TODO … |
Date | TODO … |
From | TODO … |
To | TODO … |
User | Username |
User email (required when creating users) |
If you let Kimai create new users on the fly, make sure that you configured the default timezone for new users at System > Settings before the import. The user timezone is used when importing the timesheets. If you import users from different timezones, you need create the users upfront manually.
If you want to let Kimai create users, you have to supply at least the Email
field.
"Date","From","To","Duration","Rate","User","Customer","Project","Activity","Description","Exported","Tags","Hourly rate","Fixed rate"
"2020-05-04","15:50","17:51","7260","231.92","user@example.com","Customer LLC","My project", "Testing","some work has been done","0","foo,bar","115.00","0"
Y-m-d
0
or 1
(0 = new, 1 = exported)Want to switch from Clockify to Kimai? Export the data in Clockify, open it in Excel and export it as CSV file.
Attribute | Supported field names |
---|---|
Project | Project name |
Client | Customer name |
Description | Timesheet description |
Task | Activity name |
User | Users name |
Group | not yet supported |
Users email | |
Tags | Comma separated list of tag-names |
Billable | Whether the timesheet is billable. Possible values: Yes/No |
Start Date | Start date of the timesheet, e.g. 7/27/22 |
Start Time | Start time of the timesheet, e.g. 1:00 PM |
End Date | End date of the timesheet, e.g. 2022-07-27 |
End Time | End time of the timesheet, e.g. 21:00 |
Duration (h) | ignored: instead the field “Duration (decimal)” is used |
Duration (decimal) | The timesheet duration |
Billable Rate (XXX) | Timesheet hourly rate. XXX = currency (which is not imported, but needs to be configured for the customer) |
Billable Amount (XXX) | Timesheet total rate. XXX = currency (which is not imported, but needs to be configured for the customer) |
BE AWARE you have to choose the correct date-format in Clockify, otherwise you will see errors like:
Failed to parse time string (14/04/2023 9:00) at position 0 (1): Unexpected character
There is a plugin for Mac invoicing software Grandtotal, which adds support for Kimai.
In case your leading system for customers is Grandtotal, you can import customers from a Grandtotal CSV export into Kimai.
Grandtotal calls CSV exports Numbers
in the export screen.
Attention: Grandtotal exports its data with column names in the UI language (just like Kimai).
Kimai only supports imports for GT exports from the languages english and german, so you might have to change it in Settings / Languages / User interface
.
Permission Name | Description |
---|---|
importer | access the administration screen to import CSV files |
By default, these are assigned to each user with the role ROLE_SUPER_ADMIN
.