Toggl Track: "Not allowed as header: Project;task;client"

A user in the Toggl Community forum got this error for a file with Project, Task and Client columns. Toggl read "Project;task;client" as one column name, because semicolons sat between the columns where Toggl expects commas. One-column files from the same person imported fine. The ClientHours Toggl file writes seven headers from Toggl's allowed list, with commas between them.

The error and what Toggl's help page says

Not allowed as header: Project;task;client

Columns must have headers in English.

The order of columns isn't important.

The first line is the error as a user quoted it in the Toggl Community forum. The other two are from Toggl's help page. Both pages are listed under Sources.

Why it happens

  • The CSV was saved with semicolons between columns. Toggl then sees the whole first line as a single header, and "Project;task;client" is not a header it knows. A reply in the same thread points to Excel with European regional settings, whose list separator is a semicolon.
  • In that thread a file holding only Client, or only Project, imported. With one column there is no separator to get wrong, which is why the problem showed up only once a second column was added.
  • The text after "Not allowed as header:" is whatever Toggl refused. A header in another language, or spelled unlike Toggl's list, is worth checking against the list as well.

How to fix it

  1. Open the CSV in Notepad or TextEdit and look at line 1. Toggl wants Project,Task,Client with commas, in any order.
  2. If the line has semicolons, upload the file to Google Sheets and choose File, Download, Comma-separated values (.csv), as the reply in the thread suggests. The other route is to set the list separator to a comma in your system's regional settings and save the CSV again from Excel. Changing the list separator affects other programs too, so set it back afterwards.
  3. Toggl's "Editing and uploading a CSV file" page allows User, Email, Client, Project, Task, Description, Billable, Start date, Start time, Duration, Tags and two External Reference columns. Compare each header with that list.
  4. For time from a calendar, make a new file instead: on the ClientHours Toggl page, type the workspace member's email, click "Toggl Track import (CSV)" and upload that file without opening it in Excel.

Calendar to Toggl Track CSV import

What the ClientHours file does

  • Line 1 of the file is exactly Email,Client,Project,Description,Start date,Start time,Duration. All seven names come from Toggl's allowed list and are written in English whatever language your browser uses.
  • Every line separates its values with commas. A semicolon inside an event title stays part of the Description value, since only commas split the columns.
  • A title that holds a comma or a double quote is wrapped in double quotes, so it cannot spill into the next column.
  • The file is UTF-8 with no byte order mark, so nothing invisible sits in front of "Email".
  • There is no Task column. Toggl's page says Task works on paid plans only and needs a Project to attach to.

Limits

  • The error text comes from one user's forum post. The two Toggl help pages read for this page do not print the message.
  • The thread title spells the start of the message "Invalid CSV-file" and the post body reads "Invalid CSV file". This page quotes only the part both agree on.
  • Saving the ClientHours file again from Excel can turn its commas into semicolons, depending on your regional settings.
  • No ClientHours file has been tested by importing into a real Toggl Track account. What the file contains is checked by tests. How Toggl Track reads it comes only from the help pages under Sources.

Questions

Why does the error show three column names stuck together?
They were one piece of text to Toggl. Its help page asks for comma-separated values, so a header row joined by semicolons reads as a single name.
Does the order of the columns matter to Toggl?
Toggl's page says the order of columns is not important. The names have to be on its list and in English.
Did my rows cause the error?
The message is about line 1, the header row. It names the header text Toggl refused and says nothing about the rows below it.

Sources

Other import problems

ClientHours is free, with no account and no payment. The calendar file never leaves your browser.