The Scenario
You're a freelance developer and last week you finally pulled the trigger on moving to Clockify from whatever time tracker you'd been limping along with for three years. You exported everything — 600 rows, one per time entry, each with a project name, description, start time, and end time — and pasted it into an Excel workbook. Now it's sitting there.
Clockify doesn't have a native spreadsheet import. The closest thing is a CSV import that expects a specific column order and falls apart if any field is wrong.
The bad version:
- Open each row in the workbook, copy the project name and description, open Clockify's timer, manually enter start and end, save — 600 times.
- Try Clockify's CSV import, get a format error on row 14 because the start time includes a timezone offset, spend 45 minutes reformatting the column, try again, fail on row 78.
- Write a Python script to call the API, get it working on 20 rows, discover the project IDs aren't the display names and you need to do a lookup first, abandon the script halfway through.
You migrated to Clockify to stop spending time on time-tracking infrastructure. Importing your own history shouldn't be the first thing it costs you.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your column structure, connects to Clockify via its built-in integration, and runs the import row by row — writing back the confirmation to the workbook as it goes.
Create a Clockify time entry for each row in my workbook using the project name in column A, description in column B, start time in column C, and end time in column D — write the returned entry ID into column E.
What You Get
- One new Clockify time entry per row, with the correct project, description, start, and end.
- The Clockify-returned entry ID written into column E for each successful row.
- Any row that fails (unrecognized project name, missing required field, API error) gets an error note in column E instead of an ID — so you can see exactly which rows need attention without re-running everything.
- The import runs sequentially, so your Clockify history ends up in chronological order.
What If the Data Is Not Quite Ready
The project names in my workbook don't match Clockify exactly
Your workbook has "Acme Corp - Phase 2" but Clockify has it as "Acme Corp Phase 2" — without the dash.
Import time entries from this workbook. For each row in column A, find the closest matching Clockify project name and use that. Write the matched project name into column F so I can review it, and write the entry ID into column E.
Some rows are missing a description
Column B has blanks for about 30 rows — the old tracker didn't require descriptions.
Create Clockify time entries for all rows in this workbook. For rows where column B is blank, use the project name from column A as the description. Write the entry ID into column E or the error into column F.
I need to import only entries for a specific project first
You want to import the "Website Redesign" project entries first to verify the format works before committing the full 600.
Create Clockify time entries only for rows in this workbook where column A contains "Website Redesign". Write the entry ID into column E and any error into column F. Leave all other rows untouched.
I need to import, flag duplicates, and verify totals in one pass
Create a Clockify time entry for each row in this workbook using columns A through D. Skip any row where column E already has an entry ID. Write "imported" or the error into column F. After the import, sum the total hours across all successfully imported entries and write that number into cell H1.
The pattern: cleanup logic and the import action belong in the same prompt — you don't have to pre-filter the workbook manually before running.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you've exported your historical time entries, then ask it to import all rows into Clockify. Also see: Pull a Clockify Detailed Report Into an Excel workbook for Client Billing and the Clockify integration overview.