{"id":23670,"date":"2025-06-26T08:53:28","date_gmt":"2025-06-26T08:53:28","guid":{"rendered":"https:\/\/clockify.me\/help\/?p=23670"},"modified":"2026-07-01T09:00:03","modified_gmt":"2026-07-01T09:00:03","slug":"file-import-issues","status":"publish","type":"post","link":"https:\/\/clockify.me\/help\/troubleshooting\/account-workspace-issues\/file-import-issues","title":{"rendered":"CSV File import issues\u00a0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">If your CSV file fails to import into Clockify, it\u2019s usually due to formatting issues or missing required data. Below are the most common reasons why imports fail and how to fix them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Required headers are missing or incorrect<\/h2>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">Your CSV file must include the following required column headers, written in English.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list no-translation\">\n<li class=\"translation-block\">Project<\/li>\n\n\n\n<li>Client<\/li>\n\n\n\n<li>User<\/li>\n\n\n\n<li>Email<\/li>\n\n\n\n<li>Task&nbsp;<\/li>\n\n\n\n<li>Tag<\/li>\n\n\n\n<li>Start date<\/li>\n\n\n\n<li>Start time<\/li>\n\n\n\n<li class=\"translation-block\">Duration<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfmX4gbO7tSuWnq9QsjQ9BVnuPDlrJWGWICtNxVq7-cnL6pndoHqtWkgLJlkgZ8sBeP6vDBsTlLY09lTcFTwU0DZaQzExyX-obTCoSZkBbgRvhKfTHDkKe-VdN0sJOazdyhYQNB?key=XZmssafXgdhlV2XB9mRUkEGN\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">You can find the full list of supported columns <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/import-timesheets\">here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Headers must be spelled correctly in English, free of extra spaces or characters. If any of these are missing or incorrectly formatted, your import will fail.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Date, time, and duration formats don\u2019t match Clockify settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Clockify reads your CSV file based on your account and workspace formatting settings. The start date, start time, and duration fields must follow these settings.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Date and time format:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on your profile picture in the upper right corner<\/li>\n\n\n\n<li>Select <strong>Preferences<\/strong><\/li>\n\n\n\n<li>Under the General tab, check your Date and Time formats<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc98LJctDwe53snIQhsIWAqrYNv2OTw65cRHopA0Q2_7S73mOIgnVAP7bsZAgjXmBP4ejfOh085FUUL8t4tozApMp2NU6lEgywYcheQ-UUD9-oXvB326RsmnAKQau27ckNVmm32lQ?key=XZmssafXgdhlV2XB9mRUkEGN\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Duration format:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Click on the <img loading=\"lazy\" decoding=\"async\" width=\"20\" height=\"20\" class=\"wp-image-32624\" style=\"width: 20px;\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal.png\" alt=\"three dots icon\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal.png 40w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal-12x12.png 12w\" sizes=\"auto, (max-width: 20px) 100vw, 20px\" \/><strong>three dots icon<\/strong> next to your workspace name<\/li>\n\n\n\n<li class=\"translation-block\">Select <strong>Workspace settings<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Under the <strong>General<\/strong> tab, check the <strong>Duration <\/strong>format:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Decimal<\/li>\n\n\n\n<li>Full<\/li>\n\n\n\n<li>Compact<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcNCRxpmpt1pGE2uC4FLHWy7qM5DWvHkcHwD0Soz4L3a_ZNK-ZWq-DYdr54AkCC3CgWd0Js0swj_2A2awMuO5zOQZMdiZHo4M-c6v-vRiDIMU0SnKCdfXtKsXtM-EsPmXq-ssyrCw?key=XZmssafXgdhlV2XB9mRUkEGN\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Your CSV file must match these formats exactly; otherwise, the file will be rejected.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel formatting issues<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you opened or edited your CSV file in Excel, it might have changed the formatting (e.g., dates, times, or stripped leading zeroes). This often breaks the import.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To prevent that, we recommend opening and editing your CSV file in Google Sheets, which maintains correct formatting.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The file is not comma-delimited<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Clockify expects CSV files to use commas as delimiters. If your file uses semicolons instead, the import will not work.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">How to check if your file is comma-delimited:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the CSV file in a plain text editor (like Notepad)<\/li>\n\n\n\n<li>Check the character separating values:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If values are separated by commas, the format is correct&nbsp;<\/li>\n\n\n\n<li>If you see semicolons (;), you\u2019ll need to convert the delimiters to commas.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"note wp-block-paragraph\">You can also open the file in Google Sheets and re-download it as CSV. Google Sheets will automatically format it correctly using commas as delimiters.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Missing or incomplete field values<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Even if all required fields are present, your import can still fail if some fields are left empty in your CSV file.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check your workspace required field settings:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Click on the <img loading=\"lazy\" decoding=\"async\" width=\"20\" height=\"20\" class=\"wp-image-32624\" style=\"width: 20px;\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal.png\" alt=\"three dots icon\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal.png 40w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2021\/05\/menu-tn-more_horizontal-12x12.png 12w\" sizes=\"auto, (max-width: 20px) 100vw, 20px\" \/><strong>three dots<\/strong> <strong>icon<\/strong> next to your workspace name<\/li>\n\n\n\n<li class=\"translation-block\">Select <strong>Workspace settings<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">At the top of the page, check if the <strong>Timesheet<\/strong> is enabled. If it is, Project becomes a required field by default<\/li>\n\n\n\n<li class=\"translation-block\">Scroll down to the <strong>Do not allow saving time without <\/strong>section to see if additional fields (e.g., Description, Task, Tag) are marked as required<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">If any of these required fields are empty in your CSV, the import will not succeed.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Custom fields:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If your workspace requires custom fields, you must also include those in your CSV, with valid data for each entry.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdib4uAG_dSXJBD8p_WFNatmsUCoO_PBkEd35ksymJeDsUudFzW0geYj4TCOANcNP4LUrWD5uUg2lVQMdXpgxhnsSBzdLDVdmo8QVIF5h73uCObtSKU7z35vz3H0uHvFvHRLK5y-w?key=XZmssafXgdhlV2XB9mRUkEGN\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To streamline the import process:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Temporarily disable all required fields in your workspace settings&nbsp;<\/li>\n\n\n\n<li>Import only the essential time entry data<\/li>\n\n\n\n<li>After the import, re-enable your required fields<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">This approach saves time and avoids needing to populate every single field in advance.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The import is stuck at a specific percentage and will not cancel nor proceed<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If your CSV import gets stuck and the interface becomes unresponsive, try doing a hard refresh of the page or logging out and back into your account. <\/p>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">Check your import history to see if any data was partially imported. You can click <strong>Revert<\/strong> to undo the import and try again.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"267\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-1024x267.png\" alt=\"\" class=\"wp-image-32631\" style=\"aspect-ratio:3.8353427980309625;width:667px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-1024x267.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-300x78.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-768x200.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-1536x400.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-2048x533.png 2048w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Import-history-revert-18x5.png 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">Still having issues? The Clockify Support Team will be happy to look into it and assist you further. Please contact us at <a href=\"mailto:support@clockify.me\">support@clockify.me<\/a> and provide us with the following information:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>A copy of the CSV file you\u2019re trying to import<\/li>\n\n\n\n<li>A screenshot of any error messages you\u2019re getting when importing the file<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"If your CSV file fails to import into Clockify, it\u2019s usually due to formatting&#8230;","protected":false},"author":41,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_helpful_status":1,"_searchwp_excluded":"","footnotes":""},"categories":[88],"tags":[],"class_list":["post-23670","post","type-post","status-publish","format-standard","hentry","category-account-workspace-issues"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"Milena Dimic Vlajic","author_link":"https:\/\/clockify.me\/help\/author\/millenaclockify-me"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/comments?post=23670"}],"version-history":[{"count":19,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions"}],"predecessor-version":[{"id":32853,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions\/32853"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/media?parent=23670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/categories?post=23670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/tags?post=23670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}