I have tried several times to import a file into our environment that includes a client, a project, and a task, and I created the CSV file according to the instructions. Each time I receive the error message:
“Invalid CSV file: Not allowed as header: Project;task;client”, even though according to the instructions these should be the correct headers.
I am able to import clients via a CSV file when the header is only Client and the file contains just one column. The same applies if I import only a project using a single column. However, I am unable to import CSV containing Project, Task and Client.
Hi Marjaana, your CSV is using semicolons ; as the delimiter between columns instead of commas (,). Toggl Track’s importer expects standard comma-separated values, so when it sees Project;task;client as a single header string, it treats the whole thing as one invalid column name.
This is a really common issue when saving CSV files from Excel with European regional settings, where the default list separator is a semicolon rather than a comma.
Here are a couple of ways to fix it:
If you’re using Excel, you can change the separator before saving by going to your system’s regional settings and switching the list separator to a comma, then re-saving the file as CSV.
If you’re using Google Sheets, export the file via File → Download → Comma-separated values (.csv) - this will always produce the correct format.
Once the file is properly comma-delimited, your Project, Task, and Client headers should be recognised without issues.