October DealsAmazon USOctober deal check: compare before you payAmazon US: current deals, useful picks and tech finds.Check DealsSlow PC?RecommendedPC slow today? Run a repair scan before it gets worseResolve common Windows issues and optimize system performance.Scan NowOctober DealsAmazon USDeal season is back - check today's better picksAmazon US: current deals, useful picks and tech finds.See Picks×
Skip to content
World desk4 min

How to Import Data Into Clockify From a CSV

Clockify imports projects, timesheets, and users from CSV, with different plan and permission requirements. Prepare the file, map its columns, review the preview, and check the import summary.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Clockify imports data from CSV files through Workspace settings > Import. The right import depends on what you’re moving: project structure, timesheet entries, or users. Project-structure imports are available to workspace owners and admins on any plan; timesheet and user imports require a paid plan, and user imports are unavailable during a free trial.

Choose the right Clockify import

Data to import Plan and access Important details
Projects, clients, tasks, and tags Any plan; workspace owner or admin Use this to add workspace structure. A new project can also be created when importing timesheets.
Timesheets Paid plan Entries are associated with users by email. Custom fields must already exist in the workspace.
Users Paid plan; unavailable during a free trial Use this for bulk onboarding.

Clockify’s import guide lists a maximum CSV file size of 10 MB and a maximum of 200,000 rows. It also lists field limits of 3,000 characters for Description, 1,000 for Task, 250 for Project, and 100 for Client or Tag.

As an Amazon Associate I earn from qualifying purchases.

Prepare a timesheet CSV

For a timesheet import, include these required columns using English field names: Email, Start date, Start time, and Duration. Email addresses must match active users in the destination workspace. Add fields such as Project, Client, Task, Tag, Billable, Description, or custom fields when needed. Any custom field you plan to import must first be created in Clockify.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Match the file’s date and time formats to the importing user’s Clockify profile preferences, and format Duration according to the workspace settings. The import guide gives MM/DD/YYYY as one possible date format and HH:mm or decimal duration as examples; these are not universal defaults. Imported entry times use the time zone of the person performing the import.

Workspace required fields also apply. If a project, client, task, or custom field is required by the workspace, provide its value in the CSV. For more on supported columns and formats, consult Clockify’s import instructions.

Import the file

  1. Sign in to the destination workspace with an owner or admin account. Confirm that the plan supports the type of import you need.
  2. Open Workspace settings > Import, then upload or drag in the CSV file.
  3. Confirm the displayed date, time, and duration formats against the file and the importing user’s settings.
  4. Map each CSV column to the corresponding Clockify field. Check that required fields and custom fields have values.
  5. Review the preview for incorrect mappings, missing values, and user emails that do not match active workspace users. Correct the CSV or mapping before proceeding.
  6. Choose Import, then check the import summary. For timesheets, the summary links to the Detailed report.

Import data from another time-tracking app

Clockify’s migration guidance covers exports from Harvest, Toggl, and ClickUp. Export the source data as CSV, then make sure the destination file uses Clockify’s field names and formats. The migration guide identifies Email, Project, Client, Description, Start Date, Start Time, and Duration as minimum columns for its migration workflow; requirements can differ by import type and workspace settings, so check the applicable import requirements rather than assuming every column is always mandatory. See the import guide and Clockify’s migration instructions.

For a move between Clockify workspaces, there is no direct merge. Export a Detailed report from the old workspace as CSV and import it into the destination. Time entries and related metadata can move, but workspace settings, roles, and access do not. Clockify says paid-plan users can export custom ranges spanning multiple years; free-plan users need to export one year at a time. Follow Clockify’s workspace migration guidance.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Handle historical entries for a former employee

Clockify documents an approach for retaining former employees’ historical time: import entries under an active admin and tag them with the former employee’s name. If reports need the former person’s name in the User field, Clockify also describes creating limited users, deactivating them, and later bulk-reassigning the tagged entries. See the import guide for the relevant instructions.

Rank #3
Express Schedule Free Employee Scheduling Software [PC/Mac Download]
  • Simple shift planning via an easy drag & drop interface
  • Add time-off, sick leave, break entries and holidays
  • Email schedules directly to your employees
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Fix common import problems

  • Columns are not recognized: Use the English field names Clockify expects and check spelling and capitalization against the import guide.
  • Dates, times, or durations are wrong: Match the CSV to the importing user’s profile formats and the workspace’s duration setting. Spreadsheet software can change date values or strip leading zeroes when a CSV is edited.
  • The file is rejected or values appear in the wrong columns: Check that the file is comma-delimited rather than semicolon-delimited, and confirm it is within the published file-size and row limits.
  • Required values are missing: Review workspace required-field settings and fill every required field, including required custom fields.
  • Some entries are skipped: Check that each email matches an active workspace user and that the user has accepted any invitation.

These troubleshooting checks are also covered in Clockify’s import guide and import troubleshooting instructions.

If an import hangs or stops responding, Clockify recommends a hard refresh or signing out and back in. Then inspect import history for partial data; the history provides a Revert option so you can undo an import before correcting and retrying it. Consult Clockify’s troubleshooting page.

Best Value
Spreadsheet Calculator Software Budget Templates Case for iPhone 11
  • The spreadsheet design is for accountants or calculator Lover who love to use a software for their budget or bills or need in business for projects. You love Accounting programs and Funny bookkeeping templates? Then you'll love this too!
  • Addicted To Spreadsheets
  • Two-part protective case made from a premium scratch-resistant polycarbonate shell and shock absorbent TPU liner protects against drops
  • Printed in the USA
  • Easy installation
Rank #4
MobiOffice Lifetime 4-in-1 Productivity Suite for Windows | Lifetime License | Includes Word Processor, Spreadsheet, Presentation, Email + Free PDF Reader
  • Not a Microsoft Product: This is not a Microsoft product and is not available in CD format. MobiOffice is a standalone software suite designed to provide productivity tools tailored to your needs.
  • 4-in-1 Productivity Suite + PDF Reader: Includes intuitive tools for word processing, spreadsheets, presentations, and mail management, plus a built-in PDF reader. Everything you need in one powerful package.
  • Full File Compatibility: Open, edit, and save documents, spreadsheets, presentations, and PDFs. Supports popular formats including DOCX, XLSX, PPTX, CSV, TXT, and PDF for seamless compatibility.
  • Familiar and User-Friendly: Designed with an intuitive interface that feels familiar and easy to navigate, offering both essential and advanced features to support your daily workflow.
  • Lifetime License for One PC: Enjoy a one-time purchase that gives you a lifetime premium license for a Windows PC or laptop. No subscriptions just full access forever.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More from the Wire

  1. World desk4 min
    How to Spot an AI Voice Scam Before Sending MoneyDon’t rely on how a caller sounds. Pause, call back through a known number, and verify the emergency with another trusted person before sending money.
  2. Mountain View desk4 min
    Google’s SynthID Detector: How to Check AI-Generated Images, Video and AudioGoogle’s SynthID Detector looks for an embedded watermark in supported images, video and audio. Here is what its results do—and do not—show.
  3. Redmond desk20 min
    How to create a link to File or Folder in Windows 11Windows 11 gives you several ways to point to a file or folder without moving or duplicating it. You can create a desktop shortcut,…
Recommended PC Tool
Recommended PC Tool
Outdated Drivers Are Slowing You DownFree scan - exact matches
Windows Errors? Fix Them Before They SpreadFree repair scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.