Import time entries in bulk using Productive's CSV importer. This is useful for updating time entries across multiple projects or managing team timesheets at once.
How to Import Time Entries
Go to Settings > Data Import
Select Download .csv templates and download the Time entries CSV template.
Fill out the template with your data.
Drag and drop the filled file into the upload box, or upload it manually.
Productive checks for errors automatically. Rows with issues are marked with ⚠️. Hover over the symbol to see what needs fixing.
Edit data directly in the import popup without re-uploading the file. Select Check for errors after making changes.
Once all errors are resolved, click Proceed to import, then Import.
After a successful import, review the entries in the budget or deal's Time tab, under Company time, or in any Time Entries report.
Template Columns
The file you download will contain several columns. Do not delete any columns from the template. If a column doesn't apply, leave it empty.
Project (optional) | Exact project name. |
Budget | Exact budget name (if the time entry is on a budget). |
Deal | Exact deal name (if the time entry is on a deal). |
Client (optional) | Client company name. |
Service | Service name. |
Service Type | Service type name. |
Person | Email address of the user the time entry belongs to. |
Date | Date in YYYY-MM-DD or YYYY-M-D format. |
Note (optional*) | A note describing the time entry. |
Task number (optional*) | Task number. |
Time (minutes) | Duration in minutes. |
📌 If the budget or deal requires a note or task attached to time entries, those columns must be filled in. Otherwise, these columns are optional.
Prerequisites
Before importing, make sure the following conditions are met:
If no time tracking policy is in place, the maximum trackable time per day is 24 hours (1440 minutes).
If a time tracking policy defines a maximum, entries that exceed it will be capped at that limit, but the import will still go through.