Import from Harvest, Toggl or Clockify

Export the detailed time report from Harvest, Toggl Track or Clockify as a CSV, choose it in Crisp Hours, read the preview, then import. Nothing is saved until you press the import button, and importing the same file twice adds nothing twice.

Who can import

Only an owner. Managers and members who open the page see “Only an owner can import time.” Owners reach it from the account menu (Import time) or the command menu (⌘K, then “Import time”).

What comes across

What an import brings across
ItemHow it is handled
ClientsMatched by name to an existing client, otherwise created. Currency comes from the file when it names one we know, else your firm’s currency. A row with no client goes under a client called “No client”.
ProjectsMatched by name within their client, otherwise created, with the project code if the file has one. A new project is billable if any of its rows is billable.
TasksMatched by name to your task list, otherwise created. A row with no task goes under “General”.
PeopleMatched by email, then by full name, otherwise created as a member. You can change any match in the preview.
Time entriesDate, duration, notes and billable or not. Durations are kept to the second.
RatesProposed for new projects only. Projects you already have keep their own rates.
Already-invoiced timeComes across as billed outside Crisp Hours, so it never appears as unbilled.

Matching ignores capitals and extra spaces.

How to import

  1. Export from the old tool

    Export the detailed time report as CSV for the whole range you want. The import screen lists where each tool keeps it: Harvest (Reports, New report, Detailed time, Export, CSV), Toggl Track (Reports, Detailed, Export, CSV) and Clockify (Reports, Detailed, Export, CSV). Menus change from time to time, so look for the detailed, per-entry report, not a summary. The limit is 20 MB a file; for a longer history, export in date ranges and import each file.
  2. Choose the file

    Open Import time and drop the file on the box, or choose choose a file. Only .csv files are accepted. The tool is recognised from the column headings.
  3. Read the preview

    The screen shows what would happen. Nothing is written yet. See below.
  4. Import

    Choose Import followed by the number of entries (the button reads, for example, “Import 14 entries”). When it finishes you see “Imported 14 entries” with the hours, the date range and what was added, and buttons to Open time, Open projects or Import another file.

What the preview shows

  • Totals: entries, hours, billable hours and the date range.
  • What comes across: a table with New and Already here counts for clients, projects, tasks, people and entries.
  • People: each person with their email, how they matched (by email, by name, or no match so a new person) and a menu to send their time to a different existing person or to “New person”. Changing a match refreshes the preview.
  • Already invoiced: shown only for files that do not say what was invoiced (see below).
  • Rates for new projects: the rate mode and amounts that would be set.
  • Good to know: plain notes, such as rows with no task or no client, new people with no email, notes that will be cut, and currencies we do not recognise.
  • Rows that won’t come across: the row number as a spreadsheet shows it, the reason, and what is in the row. The list shows up to 200 rows; the count is always complete.

If every entry in the file is already in Crisp Hours, the preview says “Nothing new to import” and offers no import button.

Rows that are skipped

A row is left out, and listed in the preview, when it has:

  • no date or a date that cannot be read (impossible dates are refused, not shifted);
  • no project;
  • no hours, unreadable hours, or zero hours;
  • more than 24 hours in one entry (the same limit as typing one in);
  • no person.

Fix these in the old tool and import the file again. Rows already imported are skipped, so only the fixed ones are added.

Telling Crisp Hours what was already invoiced

Harvest files have an “Invoiced?” column, so invoiced rows are brought across as billed automatically. Toggl Track and Clockify exports usually have no such column. For those, the preview shows an Already invoiced date field: time on or before that date comes across as billed. Leave it empty if none of it was invoiced, or you will see old time as unbilled on your first invoice.

How rates are set for new projects

Crisp Hours reads the billable rate on each row (or works it out from the amount and the hours, for Toggl). For each new project:

  • one rate everywhere: One rate on the project;
  • rates that depend on the person: Per person;
  • rates that depend on the task: Per task;
  • rates that follow neither: Per person, using each person’s most common rate, and the preview says rates varied.

Rates in a currency other than the client’s are not used, and the preview says so. Check the result against Rates afterwards.

Imported people and sign-in

New people are created as members with no rate and no sign-in. Add an email to someone the file did not have one for, then invite them from Settings, Team. When they sign in with the same email address they are linked to their imported history rather than becoming a second person. See Team and roles.

Limits and what to know

An entry you delete after importing stays deleted if you import the same file again. If something changed between the preview and the import (for instance, someone else imported), the import refuses and writes nothing: “Something changed since the preview, so nothing was imported.” Read the new preview and try again.