{"id":5979,"date":"2020-10-13T10:15:35","date_gmt":"2020-10-13T10:15:35","guid":{"rendered":"https:\/\/clockify.me\/help\/?p=5979"},"modified":"2026-04-06T01:54:06","modified_gmt":"2026-04-06T01:54:06","slug":"import-timesheets","status":"publish","type":"post","link":"https:\/\/clockify.me\/help\/getting-started\/import-timesheets","title":{"rendered":"Import data into Clockify"},"content":{"rendered":"\n<p class=\"translation-block\">If you have historical timesheets data in Excel, or if you&#8217;re moving from other apps, you can import your workspace data, including <a href=\"https:\/\/clockify.me\/help\/projects\/creating-projects#creating-projects\">projects<\/a>, <a href=\"https:\/\/clockify.me\/help\/projects\/working-with-tasks\">tasks<\/a>, <a href=\"https:\/\/clockify.me\/help\/projects\/creating-projects#managing-clients\">clients<\/a>, <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/categorizing-time-entries\">tags<\/a>, <a href=\"https:\/\/clockify.me\/help\/getting-started\/clockify-glossary#time-entry\">time entries<\/a> and their <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/custom-fields\">custom fields<\/a> into Clockify using a <strong>CSV file<\/strong>. <br><\/p>\n\n\n\n<h2 class=\"wp-block-heading translation-block\">What\u2019s in this guide:<\/h2>\n\n\n\n<p class=\"translation-block\"><a href=\"#import-types\">Import types<\/a><br><a href=\"#before-importing\">Before you import<br><\/a><a href=\"#import-projects\">Import projects, clients, tasks, and tags<br><\/a><a href=\"#import-timesheets\">Import timesheets and custom fields<br><\/a><a href=\"#import-users\">Import users<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading translation-block\" id=\"import-types\">Import types<\/h2>\n\n\n\n<p>Clockify supports three different imports:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Projects, Clients, Tasks, Tags:<\/strong> Use this to set up your workspace by bringing over your existing organizational structure from a file or another tool<\/li>\n\n\n\n<li><strong>Timesheets:<\/strong> Use this when you are switching software and need to migrate historical time logs to maintain continuous reporting and billing records<\/li>\n\n\n\n<li><strong>Users:<\/strong> Use this when you need to onboard a large team or company in bulk<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"before-importing\">Before you import<\/h2>\n\n\n\n<p>To ensure your data maps correctly and to avoid import failures, review these requirements first.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"roles\">Roles and subscription<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Data<\/strong><\/td><td><strong>User role<\/strong><\/td><td><strong>Subscription plan<\/strong><\/td><\/tr><tr><td>Projects, clients, tasks, tags<\/td><td rowspan=\"3\">Workspace owner\/admin<\/td><td>Any plan<\/td><\/tr><tr><td>Timesheets<\/td><td>Paid plans only<\/td><\/tr><tr><td>Users<\/td><td>Basic plan and higher<\/td><\/tr><\/tbody><\/table><\/figure>\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>User import is not supported during the free trial period.<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Data fields<\/h3>\n\n\n\n<p>Use this guide when creating your CSV file.<\/p>\n\n\n\n<figure class=\"wp-block-table translation-block\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Field name<\/strong><\/td><td><strong>Definition<\/strong><\/td><td><strong>Import type<\/strong><\/td><td><strong>Formatting rule<\/strong><\/td><td><strong>Example<\/strong><\/td><\/tr><tr><td><strong>Email<\/strong><\/td><td>Unique identifier for the user<\/td><td><strong>Timesheet import<\/strong><\/td><td>Must match an <strong>active user<\/strong> email in the workspace<\/td><td>dev@company.com<\/td><\/tr><tr><td><strong>Start date<\/strong><\/td><td>Date the entry occurred<\/td><td><strong>Timesheet import<\/strong><\/td><td>Must exactly match your <strong>profile settings<\/strong> (e.g., MM\/DD\/YYYY)<\/td><td>12\/25\/2025<\/td><\/tr><tr><td><strong>Start time<\/strong><\/td><td>Time the entry began<\/td><td><strong>Timesheet import<\/strong><\/td><td>Must match your <strong>profile settings<\/strong> (12h vs 24h)<\/td><td>09:00 AM or 13:00<\/td><\/tr><tr><td><strong>Duration<\/strong><\/td><td>Length of the time entry<\/td><td><strong>Timesheet import<\/strong><\/td><td>Must match <strong>workspace settings<\/strong> (Clock HH:mm or Decimal 1.5)<\/td><td>01:30 or 1.5<\/td><\/tr><tr><td><strong>Project<\/strong><\/td><td>Name of the project<\/td><td>Optional<\/td><td>Max <strong>250 characters<\/strong>. Case-sensitive to existing projects<\/td><td>Website UI<\/td><\/tr><tr><td><strong>Client<\/strong><\/td><td>Client associated with project<\/td><td>Optional<\/td><td>Max <strong>100 characters<\/strong>. Use <em>Project: Client <\/em>syntax in Project column to link<\/td><td>ACME Corp<\/td><\/tr><tr><td><strong>Task<\/strong><\/td><td>Sub-unit of a project<\/td><td>Optional<\/td><td>Max <strong>1,000 characters<\/strong>. Project must exist for Task to import<\/td><td>Bug Fix<\/td><\/tr><tr><td><strong>Description<\/strong><\/td><td>Notes on the work done<\/td><td>Optional<\/td><td>Max <strong>3,000 characters<\/strong>. Plain text only<\/td><td>Updated API docs<\/td><\/tr><tr><td><strong>Tag<\/strong><\/td><td>Category labels<\/td><td>Optional<\/td><td>Max <strong>100 characters<\/strong>. Separate multiple tags with a <strong>comma<\/strong><\/td><td>Urgent, Internal<\/td><\/tr><tr><td><strong>Billable<\/strong><\/td><td>Billing status of the entry<\/td><td>Optional<\/td><td>Use Yes\/No. Inherits from Project if blank<\/td><td>Yes<\/td><\/tr><tr><td><strong>Custom Fields<\/strong><\/td><td>User-defined metadata<\/td><td>Paid feature<\/td><td>Header must match the <strong>exact name<\/strong> of the field created in Clockify<\/td><td>NYC-Office<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Formatting requirements<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>File Format:<\/strong> Must be a <strong>CSV<\/strong> file (maximum size <strong>10 MB<\/strong>)<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Headers:<\/strong> All column headers <strong>must be in English<\/strong> and match Clockify\u2019s naming conventions exactly, even if your app is set to another language<\/li>\n\n\n\n<li><strong>Required fields:<\/strong> If you have required fields (like Task or Tag) enabled in your workspace settings, those columns must be filled in your CSV.<\/li>\n\n\n\n<li><strong>Character Limits:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Description: 3,000&nbsp;<\/li>\n\n\n\n<li>Task: 1,000<\/li>\n\n\n\n<li>Project: 250<\/li>\n\n\n\n<li>Client\/Tag: 100<\/li>\n<\/ul>\n<\/li>\n<\/ul>\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=\"translation-block\">Clockify <strong>automatically<\/strong> matches your data, including <strong>date and time settings<\/strong>, based on your specific profile and workspace settings.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"import-projects\">Import projects, clients, tasks, and tags<\/h2>\n\n\n\n<p><strong>What is imported?<\/strong><\/p>\n\n\n\n<p>On the Free plan, you can import:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Projects<\/li>\n\n\n\n<li>Clients<\/li>\n\n\n\n<li>Tasks<\/li>\n\n\n\n<li>Tags<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create your CSV file<\/h3>\n\n\n\n<p>You can create your CSV file following the format below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"261\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import-1024x261.png\" alt=\"\" class=\"wp-image-30343\" style=\"aspect-ratio:3.9235148153554227;width:487px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import-1024x261.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import-300x77.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import-768x196.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import-18x5.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/CSV-example-project-client-import.png 1270w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>If you don&#8217;t group projects by client, you can remove the client column.<\/p>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-blue\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask0_1_85240\" 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(#mask0_1_85240)\"><path d=\"M8.275 7.72461L5.275 4.72461L6.7 3.29961L9.7 6.29961L8.275 7.72461ZM12 5.34961V1.09961H14V5.34961H12ZM19.275 18.7246L16.275 15.7246L17.7 14.2996L20.7 17.2996L19.275 18.7246ZM17.7 7.72461L16.275 6.29961L19.275 3.29961L20.7 4.72461L17.7 7.72461ZM18.65 11.9996V9.99961H22.9V11.9996H18.65ZM5.125 21.6996L2.3 18.8746C2.1 18.6746 2 18.4413 2 18.1746C2 17.9079 2.1 17.6746 2.3 17.4746L11.375 8.37461C11.9583 7.79128 12.6667 7.49961 13.5 7.49961C14.3333 7.49961 15.0417 7.79128 15.625 8.37461C16.2083 8.95794 16.5 9.66628 16.5 10.4996C16.5 11.3329 16.2083 12.0413 15.625 12.6246L6.525 21.6996C6.325 21.8996 6.09167 21.9996 5.825 21.9996C5.55833 21.9996 5.325 21.8996 5.125 21.6996ZM5.825 19.5996L12.1 13.3246L10.675 11.9246L4.425 18.1746L5.825 19.5996Z\" fill=\"#03A9F4\"><\/path><\/g><\/svg><span class=\"box-label\">Tip<\/span><\/div><div class=\"box-content\">\n<p class=\"translation-block\">You can also download the <strong>Clients &amp; Projects<\/strong> template to ensure a smooth import process.<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"126\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-1024x126.png\" alt=\"\" class=\"wp-image-30344\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-1024x126.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-300x37.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-768x95.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-1536x189.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects-18x2.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Download-template-clients-projects.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Upload your file<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Click on the <strong>three dots<\/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 the <strong>Import<\/strong> tab<\/li>\n\n\n\n<li>Drag and drop your file into the designated box or click the upload box to select the file<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-1024x547.png\" alt=\"\" class=\"wp-image-30345\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-1024x547.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-300x160.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-768x410.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-1536x821.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import-18x10.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Upload-box-import.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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>If a column header isn&#8217;t recognized, it will be marked with a warning and won\u2019t be included in the import.&nbsp;<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-1024x439.png\" alt=\"\" class=\"wp-image-30346\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-1024x439.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-300x129.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-768x329.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-1536x659.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Error-in-data-import.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Review and import your data<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Review the preview of your data<\/li>\n\n\n\n<li class=\"translation-block\">Click <strong>Import <\/strong>if there are no errors<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-blue\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask0_1_85240\" 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(#mask0_1_85240)\"><path d=\"M8.275 7.72461L5.275 4.72461L6.7 3.29961L9.7 6.29961L8.275 7.72461ZM12 5.34961V1.09961H14V5.34961H12ZM19.275 18.7246L16.275 15.7246L17.7 14.2996L20.7 17.2996L19.275 18.7246ZM17.7 7.72461L16.275 6.29961L19.275 3.29961L20.7 4.72461L17.7 7.72461ZM18.65 11.9996V9.99961H22.9V11.9996H18.65ZM5.125 21.6996L2.3 18.8746C2.1 18.6746 2 18.4413 2 18.1746C2 17.9079 2.1 17.6746 2.3 17.4746L11.375 8.37461C11.9583 7.79128 12.6667 7.49961 13.5 7.49961C14.3333 7.49961 15.0417 7.79128 15.625 8.37461C16.2083 8.95794 16.5 9.66628 16.5 10.4996C16.5 11.3329 16.2083 12.0413 15.625 12.6246L6.525 21.6996C6.325 21.8996 6.09167 21.9996 5.825 21.9996C5.55833 21.9996 5.325 21.8996 5.125 21.6996ZM5.825 19.5996L12.1 13.3246L10.675 11.9246L4.425 18.1746L5.825 19.5996Z\" fill=\"#03A9F4\"><\/path><\/g><\/svg><span class=\"box-label\">Tip<\/span><\/div><div class=\"box-content\">\n<p class=\"translation-block\">Use the <strong>Only show rows with errors<\/strong> filter to quickly identify and fix issues.<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: View import summary<\/h3>\n\n\n\n<p class=\"translation-block\">After your data successfully imports, you&#8217;ll land on the <strong>Import Summary <\/strong>page. This page breaks down the imported project data, showing you how many projects, clients, tasks, and tags were brought in. You can click the links to go see these items in more detail.<\/p>\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\/2020\/10\/Import-summary-projects-and-clients-1024x476.png\" alt=\"\" class=\"wp-image-30347\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients-1024x476.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients-300x139.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients-768x357.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients-1536x713.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-projects-and-clients.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-indigo\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask-indigo\" 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-indigo)\"><path d=\"M12 17C12.2833 17 12.5208 16.9042 12.7125 16.7125C12.9042 16.5208 13 16.2833 13 16C13 15.7167 12.9042 15.4792 12.7125 15.2875C12.5208 15.0958 12.2833 15 12 15C11.7167 15 11.4792 15.0958 11.2875 15.2875C11.0958 15.4792 11 15.7167 11 16C11 16.2833 11.0958 16.5208 11.2875 16.7125C11.4792 16.9042 11.7167 17 12 17ZM11 13H13V7H11V13ZM12 22C10.6167 22 9.31667 21.7375 8.1 21.2125C6.88333 20.6875 5.825 19.975 4.925 19.075C4.025 18.175 3.3125 17.1167 2.7875 15.9C2.2625 14.6833 2 13.3833 2 12C2 10.6167 2.2625 9.31667 2.7875 8.1C3.3125 6.88333 4.025 5.825 4.925 4.925C5.825 4.025 6.88333 3.3125 8.1 2.7875C9.31667 2.2625 10.6167 2 12 2C13.3833 2 14.6833 2.2625 15.9 2.7875C17.1167 3.3125 18.175 4.025 19.075 4.925C19.975 5.825 20.6875 6.88333 21.2125 8.1C21.7375 9.31667 22 10.6167 22 12C22 13.3833 21.7375 14.6833 21.2125 15.9C20.6875 17.1167 19.975 18.175 19.075 19.075C18.175 19.975 17.1167 20.6875 15.9 21.2125C14.6833 21.7375 13.3833 22 12 22ZM12 20C14.2333 20 16.125 19.225 17.675 17.675C19.225 16.125 20 14.2333 20 12C20 9.76667 19.225 7.875 17.675 6.325C16.125 4.775 14.2333 4 12 4C9.76667 4 7.875 4.775 6.325 6.325C4.775 7.875 4 9.76667 4 12C4 14.2333 4.775 16.125 6.325 17.675C7.875 19.225 9.76667 20 12 20Z\" fill=\"#3F51B5\"><\/path><\/g><\/svg><span class=\"box-label\">Info<\/span><\/div><div class=\"box-content\">\n<p class=\"translation-block\">Clockify prevents duplicate projects, clients, tags, and tasks by matching the <strong>exact name<\/strong> in your CSV to existing items. If a name matches, the data is linked instead of creating a new item. Be aware that this matching is <strong>case-sensitive<\/strong>. <em>Marketing<\/em> and <em>marketing<\/em> are treated as separate fields and will result in a duplicate.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"import-timesheets\">Import timesheets and custom fields<\/h2>\n\n\n\n<p><strong>What is imported?<\/strong><\/p>\n\n\n\n<p>On paid plans, you can import:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Time entries\n<ul class=\"wp-block-list\">\n<li>Emails<\/li>\n\n\n\n<li>Project<\/li>\n\n\n\n<li>Client<\/li>\n\n\n\n<li>Task<\/li>\n\n\n\n<li>Tags<\/li>\n\n\n\n<li>Billable<\/li>\n\n\n\n<li>Description<\/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\n\n\n<li>Description<\/li>\n\n\n\n<li class=\"translation-block\"><a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/custom-fields\">Custom fields<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Format timesheet data<\/h3>\n\n\n\n<p>You can create your own CSV file with the format below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"171\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-1024x171.png\" alt=\"\" class=\"wp-image-30348\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-1024x171.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-300x50.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-768x128.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-1536x256.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet-18x3.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/example-CSV-import-file-timesheet.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Required columns:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Email: User\u2019s email address<\/li>\n\n\n\n<li>Start date: Date the time entry was created<\/li>\n\n\n\n<li>Start time: Time the entry started<\/li>\n\n\n\n<li>Duration: Number of hours logged for a time entry<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"translation-block\">Time entries are imported according to the <strong>time zone<\/strong> of the person performing the import.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Custom fields in timesheet import<\/h4>\n\n\n\n<p>Custom time entry fields (e.g., Project ID, Mileage, etc.) can be imported alongside timesheets, provided the custom field already exists within your workspace. It&#8217;s important to note that imported custom fields will only be visible in the time entries themselves, not throughout the entire workspace.<\/p>\n\n\n\n<p><strong>Example custom field in CSV file:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"908\" height=\"280\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-CSV-example.png\" alt=\"\" class=\"wp-image-30349\" style=\"aspect-ratio:3.2430475960668397;width:425px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-CSV-example.png 908w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-CSV-example-300x93.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-CSV-example-768x237.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-CSV-example-18x6.png 18w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">Custom field imports will show in the time entries in <strong>Time Tracker<\/strong> and <strong>Detailed Report<\/strong> when imported.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"120\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-1024x120.png\" alt=\"\" class=\"wp-image-30350\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-1024x120.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-300x35.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-768x90.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-1536x180.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported-18x2.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/custom-field-in-time-entry-imported.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Start the import<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Go to <strong>Workspace settings &gt; Import<\/strong><\/li>\n\n\n\n<li>Select your CSV file or drag and drop it into the data import box<\/li>\n\n\n\n<li>Confirm the date and time formats used in your file in the pop-up window<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Timesheet-import.gif\" alt=\"\" class=\"wp-image-30351\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Verify users<\/h3>\n\n\n\n<p>Clockify will notify you if your CSV contains emails for users not yet in your workspace.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"431\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-1024x431.png\" alt=\"\" class=\"wp-image-30352\" style=\"aspect-ratio:2.375922570380519;width:663px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-1024x431.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-300x126.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-768x323.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-1536x646.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/user-doesnt-exist-in-workspace.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-blue\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask0_1_85240\" 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(#mask0_1_85240)\"><path d=\"M8.275 7.72461L5.275 4.72461L6.7 3.29961L9.7 6.29961L8.275 7.72461ZM12 5.34961V1.09961H14V5.34961H12ZM19.275 18.7246L16.275 15.7246L17.7 14.2996L20.7 17.2996L19.275 18.7246ZM17.7 7.72461L16.275 6.29961L19.275 3.29961L20.7 4.72461L17.7 7.72461ZM18.65 11.9996V9.99961H22.9V11.9996H18.65ZM5.125 21.6996L2.3 18.8746C2.1 18.6746 2 18.4413 2 18.1746C2 17.9079 2.1 17.6746 2.3 17.4746L11.375 8.37461C11.9583 7.79128 12.6667 7.49961 13.5 7.49961C14.3333 7.49961 15.0417 7.79128 15.625 8.37461C16.2083 8.95794 16.5 9.66628 16.5 10.4996C16.5 11.3329 16.2083 12.0413 15.625 12.6246L6.525 21.6996C6.325 21.8996 6.09167 21.9996 5.825 21.9996C5.55833 21.9996 5.325 21.8996 5.125 21.6996ZM5.825 19.5996L12.1 13.3246L10.675 11.9246L4.425 18.1746L5.825 19.5996Z\" fill=\"#03A9F4\"><\/path><\/g><\/svg><span class=\"box-label\">Tip<\/span><\/div><div class=\"box-content\">\n<p>Ensure all team members have accepted their workspace invitations before importing their time, or the entries for those users can&#8217;t be imported.<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Summary review<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Review the data in the preview<\/li>\n\n\n\n<li class=\"translation-block\">Click <strong>Import<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"translation-block\">Once finished, the <strong>Import Summary<\/strong> will provide links to the imported data in your <strong>Detailed Report<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"481\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-1024x481.png\" alt=\"\" class=\"wp-image-30353\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-1024x481.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-300x141.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-768x361.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-1536x722.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-timesheet.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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>If you didn&#8217;t specify a Billable status in the CSV, the entry will automatically inherit the billable status of the Project it is assigned to.<br><\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"import-users\">Import users<\/h2>\n\n\n\n<p><strong>What is imported?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Limited users<\/strong>: For users with restricted access\n<ul class=\"wp-block-list\">\n<li>Name<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Full users<\/strong>: For standard team members\n<ul class=\"wp-block-list\">\n<li>Name<\/li>\n\n\n\n<li>Email<\/li>\n\n\n\n<li>Role<\/li>\n\n\n\n<li>Projects managed<\/li>\n\n\n\n<li>Groups managed<\/li>\n\n\n\n<li>Employees managed<\/li>\n\n\n\n<li>Assigned team manager<\/li>\n\n\n\n<li>Group<\/li>\n\n\n\n<li>Billable rate<\/li>\n\n\n\n<li>Cost rate<\/li>\n\n\n\n<li>Week start<\/li>\n\n\n\n<li>Working days<\/li>\n\n\n\n<li>Daily work capacity (hours)<\/li>\n\n\n\n<li class=\"translation-block\"><a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/user-fields\">User custom field <\/a>(e.g., Department, Location, etc.)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\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>User custom fields can only be imported for new users and not for existing ones in your workspace.<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create CSV file<\/h3>\n\n\n\n<p class=\"translation-block\">Include all required columns when creating your file.<br><br>The email address is required for <strong>Full user imports<\/strong>. If a user is being added as a manager, you must also fill in the <strong>Projects Managed\/Groups Managed\/Employees Managed<\/strong> columns.<\/p>\n\n\n\n<p><strong>Example CSV of full user import<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"188\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-1024x188.png\" alt=\"\" class=\"wp-image-30354\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-1024x188.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-300x55.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-768x141.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-1536x282.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import-18x3.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-CSV-full-user-import.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">In a <strong>Limited user import<\/strong>, Name is the only required field.<\/p>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-blue\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask0_1_85240\" 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(#mask0_1_85240)\"><path d=\"M8.275 7.72461L5.275 4.72461L6.7 3.29961L9.7 6.29961L8.275 7.72461ZM12 5.34961V1.09961H14V5.34961H12ZM19.275 18.7246L16.275 15.7246L17.7 14.2996L20.7 17.2996L19.275 18.7246ZM17.7 7.72461L16.275 6.29961L19.275 3.29961L20.7 4.72461L17.7 7.72461ZM18.65 11.9996V9.99961H22.9V11.9996H18.65ZM5.125 21.6996L2.3 18.8746C2.1 18.6746 2 18.4413 2 18.1746C2 17.9079 2.1 17.6746 2.3 17.4746L11.375 8.37461C11.9583 7.79128 12.6667 7.49961 13.5 7.49961C14.3333 7.49961 15.0417 7.79128 15.625 8.37461C16.2083 8.95794 16.5 9.66628 16.5 10.4996C16.5 11.3329 16.2083 12.0413 15.625 12.6246L6.525 21.6996C6.325 21.8996 6.09167 21.9996 5.825 21.9996C5.55833 21.9996 5.325 21.8996 5.125 21.6996ZM5.825 19.5996L12.1 13.3246L10.675 11.9246L4.425 18.1746L5.825 19.5996Z\" fill=\"#03A9F4\"><\/path><\/g><\/svg><span class=\"box-label\">Tip<\/span><\/div><div class=\"box-content\">\n<p>Download the User template to avoid import errors.<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"196\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-1024x196.png\" alt=\"\" class=\"wp-image-30355\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-1024x196.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-300x57.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-768x147.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-1536x294.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template-18x3.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Users-template.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Multiple values<\/strong><\/p>\n\n\n\n<p class=\"translation-block\">To assign multiple roles, managed projects, managed employees, or groups to a single user, separate each entry with a <strong>comma<\/strong>.<\/p>\n\n\n\n<p><strong>Project &amp; client association<\/strong><\/p>\n\n\n\n<p class=\"translation-block\">If a project belongs to a specific client (e.g., Project A under Client A), use the following format in the <strong>Projects Managed<\/strong> column:<\/p>\n\n\n\n<p><em>Project Name:Client Name<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"127\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-1024x127.png\" alt=\"\" class=\"wp-image-30356\" style=\"aspect-ratio:8.063596820158992;width:669px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-1024x127.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-300x37.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-768x95.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-1536x190.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field-18x2.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/project-client-field.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The system will automatically recognize the project and its associated client using this syntax.<\/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>When left blank, optional fields will inherit your workspace defaults.&nbsp;<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">User custom field in user import<\/h3>\n\n\n\n<p class=\"translation-block\">When you import users, you can include<a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/user-fields\"> user custom fields<\/a> like Department, Location, or Employee ID. Just make sure these user custom fields are already set up in the workspace before you start the import.<\/p>\n\n\n\n<p><strong>Example user custom field in CSV<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"982\" height=\"416\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-of-user-CF-in-CSV.png\" alt=\"\" class=\"wp-image-30357\" style=\"aspect-ratio:2.3605866338807413;width:427px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-of-user-CF-in-CSV.png 982w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-of-user-CF-in-CSV-300x127.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-of-user-CF-in-CSV-768x325.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Example-of-user-CF-in-CSV-18x8.png 18w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Upload your file<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Go to <strong>Workspace settings &gt; Import<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Click the <strong>upload<\/strong> button<\/li>\n\n\n\n<li>Select the CSV file you want to import<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import.gif\" alt=\"\" class=\"wp-image-30358\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Review your data<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check that all data is correct and properly mapped in the table<\/li>\n\n\n\n<li class=\"translation-block\">Click<strong> Import <\/strong>if there are no errors<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-1024x515.png\" alt=\"\" class=\"wp-image-30359\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-1024x515.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-300x151.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-768x386.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-1536x773.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page-18x9.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-import-confirm-page.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">Adding admins will trigger a pop-up window informing you of their privileges. Click <strong>Confirm<\/strong> to continue.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"647\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window-1024x647.png\" alt=\"\" class=\"wp-image-30360\" style=\"aspect-ratio:1.5827126328495305;width:495px;height:auto\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window-1024x647.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window-300x189.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window-768x485.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window-18x12.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Add-admins-window.png 1498w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: View import summary<\/h3>\n\n\n\n<p class=\"translation-block\">Upon successful completion of the import, the <strong>Import Summary<\/strong> page will display the number of users added. Click on <strong>Total New Users<\/strong> to go to the <strong>Team<\/strong> page and view the newly imported users.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"461\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-1024x461.png\" alt=\"\" class=\"wp-image-30361\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-1024x461.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-300x135.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-768x346.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-1536x691.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users-18x8.png 18w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/Import-summary-users.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-blue\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask0_1_85240\" 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(#mask0_1_85240)\"><path d=\"M8.275 7.72461L5.275 4.72461L6.7 3.29961L9.7 6.29961L8.275 7.72461ZM12 5.34961V1.09961H14V5.34961H12ZM19.275 18.7246L16.275 15.7246L17.7 14.2996L20.7 17.2996L19.275 18.7246ZM17.7 7.72461L16.275 6.29961L19.275 3.29961L20.7 4.72461L17.7 7.72461ZM18.65 11.9996V9.99961H22.9V11.9996H18.65ZM5.125 21.6996L2.3 18.8746C2.1 18.6746 2 18.4413 2 18.1746C2 17.9079 2.1 17.6746 2.3 17.4746L11.375 8.37461C11.9583 7.79128 12.6667 7.49961 13.5 7.49961C14.3333 7.49961 15.0417 7.79128 15.625 8.37461C16.2083 8.95794 16.5 9.66628 16.5 10.4996C16.5 11.3329 16.2083 12.0413 15.625 12.6246L6.525 21.6996C6.325 21.8996 6.09167 21.9996 5.825 21.9996C5.55833 21.9996 5.325 21.8996 5.125 21.6996ZM5.825 19.5996L12.1 13.3246L10.675 11.9246L4.425 18.1746L5.825 19.5996Z\" fill=\"#03A9F4\"><\/path><\/g><\/svg><span class=\"box-label\">Tip<\/span><\/div><div class=\"box-content\">\n<p class=\"translation-block\">To verify the successful import of the user custom field, click the three-dot icon next to the new user, and then select <strong>Edit profile<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/10\/User-field-imported-in-profile.gif\" alt=\"\" class=\"wp-image-30362\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">FAQs<\/h2>\n\n\n\n<p><strong>Can I import Client&#8217;s details (address, email)?<\/strong><\/p>\n\n\n\n<p class=\"translation-block\">No. Currently, the CSV import tool only supports importing the Client Name. Additional details such as address, email, or notes must be added manually by <a href=\"https:\/\/clockify.me\/help\/projects\/creating-projects#how-to-edit-already-existing-clients\">editing the client&#8217;s profile<\/a> after they have been created.<\/p>\n\n\n\n<p><strong>I made a mistake, how to undo\/delete imported data?<\/strong><\/p>\n\n\n\n<p class=\"translation-block\">To remove incorrectly imported data, you must delete the entries manually. For bulk removal, go to the relevant page (e.g., <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/editing-time-entries#bulk-edit-overview\">Time Tracker<\/a>, <a href=\"https:\/\/clockify.me\/help\/projects\/creating-projects#delete-projects\">Projects<\/a>, or <a href=\"https:\/\/clockify.me\/help\/projects\/creating-projects#delete-clients\">Clients<\/a>), use the <strong>Bulk Edit<\/strong> feature to select the items, and choose <strong>Delete.<\/strong><\/p>\n\n\n\n<p><strong>What happens if a project already exists with the same name? Will it duplicate?<\/strong><\/p>\n\n\n\n<p>No. Clockify matches projects by name (case-sensitive). If the project name in your CSV file matches an existing project in your workspace exactly, the system will recognize it and assign the imported tasks or time entries to that existing project instead of creating a duplicate.<\/p>\n\n\n\n<p><strong>Can I import expenses using the CSV tool?<\/strong><\/p>\n\n\n\n<p>No. The import tool currently supports time entries, projects, clients, tasks, tags, and users. Expenses cannot be imported via CSV and must be added manually or through the Clockify API.<\/p>\n\n\n\n<p><strong>Can I import Time Off or Leave requests?<\/strong><\/p>\n\n\n\n<p>No. The CSV import process is designed for historical timesheets and workspace metadata (like projects and users). Time off entries and balances cannot be imported via the CSV tool and should be managed within the Time Off feature or via the API.<\/p>\n\n\n\n<p><strong>Does the importer automatically check for duplicate entries?<\/strong><\/p>\n\n\n\n<p>No. Clockify does not have a built-in duplicate detection for CSV imports. If your file contains entries that already exist in your workspace, the system will import them again, resulting in duplicates. It is recommended to review your CSV file carefully before uploading.<\/p>\n","protected":false},"excerpt":{"rendered":"If you have historical timesheets data in Excel, or if you&#8217;re moving from &#8230;","protected":false},"author":3,"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":[8,80],"tags":[],"class_list":["post-5979","post","type-post","status-publish","format-standard","hentry","category-getting-started","category-introduction-to-clockify"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"aleksandar.olic","author_link":"https:\/\/clockify.me\/help\/author\/aleksandar-olic"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/5979","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/comments?post=5979"}],"version-history":[{"count":167,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/5979\/revisions"}],"predecessor-version":[{"id":30725,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/5979\/revisions\/30725"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/media?parent=5979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/categories?post=5979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/tags?post=5979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}