Importing a spreadsheet
Last updated 11 November 2026
If your time already lives in a spreadsheet, don't retype it. Download our three templates, fill them in, upload them and check the preview. Nothing is written until you click Import, and you can undo straight afterwards. Owners and admins only.
Step by step
- Open Import data in the sidebar (or Settings → "Import data").
- Choose "Spreadsheet — our templates".
- Download the clients, projects and time templates. Each is a CSV with a fixed header row and two example rows.
- Fill them in — one row per client, project or time entry — and delete the example rows. Keep the header row exactly as it is. Save as CSV.
- Drop one, two or all three files onto the upload box. Each is recognised by its header ("Clients template", "Projects template", "Time template").
- Click "Preview import →".
The dry run
The preview says "Dry run — nothing has been written yet" and counts what it found: clients (new and matched), projects, people and time entries.
Any row it could not use is listed with the file name, the line number (the header is line 1) and the column and value that failed — for example "doesn't look like an email address" or "No readable hours in Hours". Example rows left in from the template are skipped and said so. Fix the file and upload again, or carry on without those rows.
People, rates and the final step
- "Next: people & rates →": match each name in the time file to someone in your team, or "+ Add as new person" with their role, charge rate, cost rate and hours per week.
- "Review →" shows the totals one last time.
- Click "Import N entries".
- If anything looks wrong, "Undo import" is offered straight away, in the same browser tab.
Tick "Treat all imported time as already billed" if the file is pure history you will never invoice. Otherwise only rows marked as invoiced in the file are locked, and the rest can be invoiced from here. Settings → "Housekeeping" → "Review imported time" releases a batch later if you change your mind.
Rules that keep your data safe
- Existing records are never overwritten or deleted. Clients and tasks match by name, projects by client + name, people by email and then name.
- A time entry that already exists is skipped, not duplicated. Importing the same file twice adds nothing.
- Files are limited to 25 MB each.
- A file that is not one of our templates is refused with the reason. Use "Other / any CSV" to match the columns yourself.
Coming from another tool
The same page imports Harvest (CSV exports, or "Connect with API token"), Toggl Track, Clockify, Everhour and Productive exports, and "Other / any CSV" where you match the columns yourself ("Match columns →": Date, Project and Hours — or start and end times — are required). Each source shows where to find the export in that tool.
Read next: First week setup · Recently deleted · Roles and permissions · All articles