> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.toggl.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Toggl Track CSV Import Guide

Admins can use the [CSV importer](https://track.toggl.com/settings/import) to bring in existing time entries, projects, clients, tasks, and tags in bulk, instead of creating them one-by-one.

### In this guide:

* [Before you begin](#Before)
* [Importing Time Entries](#ITE)
* [Importing Projects (and Tasks)](#IPT)
* [Importing Clients or Tags](#ICT)
* [Importing Project Assignees](#IPA)

### Before you begin

The key to making this a simple process is to format the CSV correctly. For more information on formatting tips, [read this guide](https://support.toggl.com/en-us/article/editing-and-uploading-a-csv-file-bk155h) first.

While you can import users via CSV, as well as import time entries in the process, you can start by adding all users to your workspace if you wish. [Here’s how to invite teammates](https://support.toggl.com/en-us/article/managing-organization-and-workspace-members-13ydo73) in the app. Invitees become active users once they accept your invitation.

To see who hasn’t accepted their invitations into your workspace yet, go to the [Team page](https://track.toggl.com/team/members), and set the *Show* dropdown to *Inactive*.

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/Filter_Users_Team_Page-1.png)

To invite users via CSV, you need an Email column only. Like so:



| Email |
| [rico@toggl.com](mailto:rico@toggl.com) |
| [dwight.eisenhower@company.com](mailto:dwight.eisenhower@company.com) |
| [arthur.tedder@company.com](mailto:arthur.tedder@company.com) |
| [bernard.montgomery@company.com](mailto:bernard.montgomery@company.com) |
| [trafford.leigh-mallory@company.com](mailto:trafford.leigh-mallory@company.com) |
| [bertram.ramsay@company.com](mailto:bertram.ramsay@company.com) |

You can also include a User column, containing the names of each user:



| Email | User |
| [rico@toggl.com](mailto:rico@toggl.com) | Rico Mossesgeld |
| [dwight.eisenhower@company.com](mailto:dwight.eisenhower@company.com) | Dwight Eisenhower |
| [arthur.tedder@company.com](mailto:arthur.tedder@company.com) | Arthur Tedder |
| [bernard.montgomery@company.com](mailto:bernard.montgomery@company.com) | Bernard Montgomery |
| [trafford.leigh-mallory@company.com](mailto:trafford.leigh-mallory@company.com) | Trafford Leigh-Mallory |
| [bertram.ramsay@company.com](mailto:bertram.ramsay@company.com) | Bertram Ramsay |

If the imported user already has a Toggl Track account for that email address, whatever name they've set will be used.

Remember to use comma-separated CSVs with UTF-8 encoding. The importer will try to create items on Toggl Track, based on the CSV you use. Please also note that our imports are case sensitive, so **Acme** and **acme** will be created as two separate items.

Users imported as active users via CSV will be included in your subscription plan. **You cannot import time entries for inactive users.**

### Importing Time Entries

To import time entries, use a CSV with these columns:

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/image-Oct-01-2025-11-06-21-1956-AM-1.png)

This CSV would create 5 time entries for the user [rico@toggl.com](mailto:rico@toggl.com):

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_52_12.png)

***Note:***

* *Time entries with identical email, description, project, task, client, tags and billable status will be considered unique **only** if the start date/time stamp is different. Time entries with all data, including start date/time, being identical will be merged.*
* *When importing time entries, the end date and end time are ignored. These are calculated automatically by the importer, based on the start time and duration.*
* *As the Billable column indicates [if a time entry is billable or not](https://support.toggl.com/en-us/article/billable-rates-6jv44s), the three acceptable formats are y or n, yes or no, 1 or 0.*
* *If you are re-importing a Track Detailed Report, please make sure your [Profile](https://track.toggl.com/profile) has the Duration format set to Improved before you export the report.*

### Importing Projects (and Tasks)

Here are the CSV columns to use:

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_53_16.png)

Each Task must be one row. For example, if you wanted to import…

* A project called “Runway”...
* under the “Bravo” client...
* with three tasks named “Pre-Production”, “Production”, and “Post-Production”...

Here’s how the CSV would look like:

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_54_12.png)

You can have projects with the same name, if they have different clients (including not having a client):

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_55_37.png)

*Note: Tasks can only be imported on Paid plans. Please note, all new projects are private by default.*

### Importing Clients or Tags

For clients or tags, just use a one-column CSV:

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_57_29.png)

### Importing Project Assignees

Say you had an existing project called “Overlord”. Its client is “The Alliance”. You’d like to assign these teammates to the project:

* [dwight.eisenhower@company.com](mailto:dwight.eisenhower@company.com)
* [arthur.tedder@company.com](mailto:arthur.tedder@company.com)
* [bernard.montgomery@company.com](mailto:bernard.montgomery@company.com)
* [trafford.leigh-mallory@company.com](mailto:trafford.leigh-mallory@company.com)
* [bertram.ramsay@company.com](mailto:bertram.ramsay@company.com)

Here’s the CSV you would use:

![](https://21421994.fs1.hubspotusercontent-na1.net/hubfs/21421994/Knowledge%20Base%20Import/screenshot-docs_google_com-2020_04_16-13_58_55.png)

When importing users via CSV:

* Ticking the option to invite new users will make them active or invited users. This is chosen by default.
* Not ticking this option will make them inactive users. Inactive users can be seen on the Team page under the Inactive filter.

**Important:**

Please only uncheck the invite option if you are sure this user will never need to use Track in the future as a user made Inactive when importing cannot be reactivated at a later stage.

Additionally, two fields (one each for projects and clients) can be imported for use but are not exposed in the UI. They are meant for use with the API. These are:

* Client External Reference
* Project External Reference