{"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-01-16T12:38:45","modified_gmt":"2026-01-16T12:38:45","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>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\">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\">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>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&nbsp;<\/h2>\n\n\n\n<p>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>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 \u201cPreferences.\u201d<\/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>Duration format:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on the three dots next to your workspace name<\/li>\n\n\n\n<li>Click on the \u201cWorkspace settings\u201d<\/li>\n\n\n\n<li>Under the General tab, check the Duration 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>Your CSV file must match these formats exactly; otherwise, the file will be rejected.&nbsp;<\/p>\n\n\n\n<p><strong>&nbsp;<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel formatting issues<\/h2>\n\n\n\n<p>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>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>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>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\">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>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>Check your workspace required field settings:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on the three dots next to your workspace name<\/li>\n\n\n\n<li>Select \u201cWorkspace settings\u201d<\/li>\n\n\n\n<li>At the top of the page, check if the Timesheet is enabled. If it is, Project becomes a required field by default<\/li>\n\n\n\n<li>Scroll down to the \u201cDo not allow saving time without\u201d section to see if additional fields (e.g., Description, Task, Tag) are marked as required.<\/li>\n<\/ol>\n\n\n\n<p>If any of these required fields are empty in your CSV, the import will not succeed.&nbsp;<\/p>\n\n\n\n<p>Custom fields:<\/p>\n\n\n\n<p>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>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>This approach saves time and avoids needing to populate every single field in advance.&nbsp;<\/p>\n\n\n\n<p class=\"translation-block\">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":7,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions"}],"predecessor-version":[{"id":26319,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions\/26319"}],"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}]}}