{"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-10-14T13:04:21","modified_gmt":"2026-10-14T13:04:21","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=\"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>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>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\"><strong>Date and time format:<\/strong><\/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 class=\"translation-block\">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\"><strong>Duration format:<\/strong><\/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 size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-1024x539.png\" alt=\"\" class=\"wp-image-35342\" style=\"aspect-ratio:1.899848040428314;width:690px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-1024x539.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-300x158.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-766x403.png 766w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-18x9.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-1536x808.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Duration-format_new-1-2048x1077.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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\">Click <strong>Time tracking<\/strong> from the sidebar<\/li>\n\n\n\n<li class=\"translation-block\">Check if <strong>Timesheet<\/strong> <strong>view<\/strong> is enabled. If it is, Project becomes a required field by default<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"476\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-1024x476.png\" alt=\"\" class=\"wp-image-35344\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-1024x476.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-300x139.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-766x356.png 766w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-1536x714.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/Enable-timesheet-view-1-2048x952.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">5. Scroll down to the <strong>Time entry required fields<\/strong> section to see if additional fields (e.g., Description, Task, Tag) are marked as required<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-1024x576.png\" alt=\"\" class=\"wp-image-35345\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-1024x576.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-300x169.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-768x432.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-18x10.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1-1536x864.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/image1.png 1999w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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<div class=\"wp-block-custom-highlight-box custom-box color-green\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask-green\" style=\"mask-type:alpha\" maskUnits=\"userSpaceOnUse\" x=\"0\" y=\"0\" width=\"24\" height=\"24\"><rect width=\"24\" height=\"24\" fill=\"#D9D9D9\"><\/rect><\/mask><g mask=\"url(#mask-green)\"><path d=\"M5 21.0001C4.45 21.0001 3.97917 20.8043 3.5875 20.4126C3.19583 20.0209 3 19.5501 3 19.0001V5.0001C3 4.4501 3.19583 3.97926 3.5875 3.5876C3.97917 3.19593 4.45 3.0001 5 3.0001H13.925L11.925 5.0001H5V19.0001H19V12.0501L21 10.0501V19.0001C21 19.5501 20.8042 20.0209 20.4125 20.4126C20.0208 20.8043 19.55 21.0001 19 21.0001H5ZM9 15.0001V10.7501L18.175 1.5751C18.375 1.3751 18.6 1.2251 18.85 1.1251C19.1 1.0251 19.35 0.975098 19.6 0.975098C19.8667 0.975098 20.1208 1.0251 20.3625 1.1251C20.6042 1.2251 20.825 1.3751 21.025 1.5751L22.425 3.0001C22.6083 3.2001 22.75 3.42093 22.85 3.6626C22.95 3.90426 23 4.1501 23 4.4001C23 4.6501 22.9542 4.89593 22.8625 5.1376C22.7708 5.37926 22.625 5.6001 22.425 5.8001L13.25 15.0001H9ZM11 13.0001H12.4L18.2 7.2001L17.5 6.5001L16.775 5.8001L11 11.5751V13.0001Z\" fill=\"#4CAF50\"><\/path><\/g><\/svg><span class=\"box-label\">Note<\/span><\/div><div class=\"box-content\">\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<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>To streamline the import process:<\/strong><\/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":30,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions"}],"predecessor-version":[{"id":35558,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23670\/revisions\/35558"}],"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}]}}