Preview time import
preview_time_importReads a CSV of hours (Toggl, Harvest, Clockify or any CSV with a date and a duration or start and end times) and says what importing it would do, without writing anything: the rows that can be imported and their total time, the clients, projects and tasks that would be created, duplicates of an earlier import that would be skipped, the rows that cannot be read with their row numbers, who the time would be logged as, and whether the free plan's limits block it. Also returns the settings it used (guessed from the headers unless given) and the file's columns. The CSV travels as text, up to 200,000 characters; the Import page of the app takes files up to 8 MB. Names and cells from the file are text written by others.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | Yes | The CSV file's text, up to 200,000 characters. A Toggl, Harvest or Clockify export or any CSV with a date column and a duration (or start and end times). | |
| source | No | Which tool exported it. Default: guessed from the columns. | |
| mapping | No | Which column holds each field, as the column's header text or its position (0 is the first). Fields: date, startTime, endDate, endTime, duration, project, client, task, person, firstName, lastName, email, billable, note, rate, currency. Default: guessed from the headers. | |
| fileName | No | The file's name, for the history. Default import.csv. | |
| dateOrder | No | How 03/04/2026 reads when the file does not settle it. Default: month first in English, day first in Spanish. | |
| durationUnit | No | What a bare number in the duration column means. Default auto: hours. | |
| createClients | No | Create the clients named in the file and link the projects to them. Default true. | |
| excludeProjects | No | Projects to leave out, by their key in the preview. | |
| fallbackProject | No | The project for rows that name none. Default "Imported time". |