The Scenario
The import ran twice. You didn't notice until this morning, when the weekly utilization report showed 160 hours logged by a developer who works 40-hour weeks. You pulled a report, spot-checked a few entries, and there they are — every entry from last Tuesday through Thursday appearing twice, 85 duplicates in total, each with its own Clockify entry ID.
You have the IDs. You exported them into an Excel workbook. Now you need them gone.
The third time you opened an individual entry in Clockify's UI to delete it, you closed the tab.
The bad version:
- Open Clockify, navigate to the entry, click the three-dot menu, click Delete, confirm. Repeat for entry 2.
- Realize you can select multiple entries in the time tracker view — but only if you're viewing the right date and the right user. Navigate to Tuesday, select the duplicates, delete. Navigate to Wednesday. Select. Delete. Navigate to Thursday.
- Halfway through, notice that Clockify's multi-select caps out at 50 entries per page. Split the 85 into two batches manually.
Eighty-five deletions is not a task — it's a sentence. You have a workbook full of IDs and a working API. There should be a better way to apply them.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the entry IDs from column A, calls the Clockify delete endpoint for each one, and writes the result back to the workbook — so you know exactly which ones were removed and which ones errored.
Delete the Clockify time entries whose IDs are listed in column A — write 'deleted' in column B for each success and 'error' plus the reason if it fails.
What You Get
- Each entry ID in column A processed in sequence.
- "deleted" written into column B for every successful deletion.
- "error: [reason]" written into column B for any entry that couldn't be deleted — so you know which IDs to investigate separately.
- No silent skips: every row gets a result, whether or not the deletion worked.
What If the Data Is Not Quite Ready
The workbook has both user IDs and entry IDs and I need to delete by user
Your export includes workspace ID in cell A1, user ID in column A starting at row 2, and the corresponding entry IDs in column B.
Bulk-delete all time entries in this workbook: use the workspace ID in cell A1, the user ID in column A (rows 2 onward), and the time entry IDs in column B. Write 'deleted' or the error into column C for each row.
I want to delete only entries that are older than 60 days
The IDs cover a range of dates. You want to keep anything from the last 60 days but delete everything older.
Delete the Clockify time entries listed in column A, but only if the entry's date (written in column B) is more than 60 days before today. Write the result in column C — 'deleted', 'skipped (recent)', or 'error'.
Some entries may already be deleted from a previous partial run
You ran this once before and it failed halfway through. Column B has some 'deleted' results already.
Delete the Clockify time entries in column A. Skip any row where column B already says 'deleted'. Write 'deleted' or the error into column B for all remaining rows.
Delete entries, verify totals dropped, and flag if any IDs weren't found
Delete the Clockify time entries listed in column A. Write 'deleted' or 'error: [reason]' into column B. If any entry returns a 404 (not found), write 'not found' into column B for that row. After all deletions, write the total count of successful deletions into cell D1.
Cleaning up a bad import is a one-shot operation when the IDs are already in the workbook — you don't have to do it in batches or track progress manually.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you've listed the duplicate entry IDs, then ask it to bulk-delete them from Clockify. Also see: Bulk Import Historical Time Entries Into Clockify From an Excel workbook and the Clockify integration overview.