Import a Clockify report
Export the correct detailed report, preview it, and import it into a firm workspace.
- For:
- Workspace admins, Platform admins
- Updated:
- Aug 26, 2026
Export from Clockify
- In Clockify, open Reports, then Detailed.
- Choose the date range and export as CSV or Excel.
- Keep the first-row column names unchanged.
- Use a file no larger than 15 MB.
Required columns
The file must contain: Project, Client, Description, User, Email, Billable, End Date, End Time, Duration (h), Duration (decimal), and Date of creation. Other Clockify columns may remain. Rate columns are optional, including currency-specific Billable Rate and Billable Amount columns.
Billable accepts Yes or No. Example durations are 2:38 or 1:02:03 for Duration (h), and 2.63 for Duration (decimal).
Preview and import
Open Settings → Import. Export instructions are available above the file picker.
| Control | What it does | Availability |
|---|---|---|
| Choose File | Selects a CSV or XLSX Clockify detailed report. | Firm Import |
| Preview | Parses rows and shows users, clients, matters, time totals, duplicates, skipped rows, and warnings without committing them. | After a valid file is selected |
| Assign billables to your team | Matches by email first and suggests unique full-name matches. Review or change each choice to a current firm profile, or leave it Unassigned. Original Clockify names remain on the source records. | After preview |
| Import | Saves entries with the reviewed assignments and shows progress. Importing does not create accounts or send invitations. | Authorized workspace or platform admins |
Review skipped rows and duplicate counts before import. Zero-duration rows are excluded explicitly. Unassigned entries remain available in the Firm view; invite lawyers separately from the Lawyers tab.