{"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\/pt\/troubleshooting\/account-workspace-issues\/file-import-issues","title":{"rendered":"Problemas de importa\u00e7\u00e3o de arquivo CSV\u00a0"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Se o seu arquivo CSV n\u00e3o for importado para o Clockify, geralmente \u00e9 devido a problemas de formata\u00e7\u00e3o ou dados obrigat\u00f3rios ausentes. Abaixo est\u00e3o os motivos mais comuns pelos quais as importa\u00e7\u00f5es falham e como corrigi-los.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cabe\u00e7alhos obrigat\u00f3rios ausentes ou incorretos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Seu arquivo CSV deve incluir os seguintes cabe\u00e7alhos de coluna obrigat\u00f3rios, escritos em ingl\u00eas.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list no-translation\" data-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\">Voc\u00ea pode encontrar a lista completa de colunas suportadas <a href=\"https:\/\/clockify.me\/help\/pt\/getting-started\/import-timesheets\">aqui<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Os cabe\u00e7alhos devem ser escritos corretamente em ingl\u00eas, sem espa\u00e7os ou caracteres extras. Se algum deles estiver ausente ou formatado incorretamente, sua importa\u00e7\u00e3o falhar\u00e1.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Os formatos de data, hora e dura\u00e7\u00e3o n\u00e3o correspondem \u00e0s configura\u00e7\u00f5es do Clockify<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">O Clockify l\u00ea seu arquivo CSV com base nas configura\u00e7\u00f5es de formata\u00e7\u00e3o da sua conta e do seu espa\u00e7o de trabalho. Os campos de data de in\u00edcio, hora de in\u00edcio e dura\u00e7\u00e3o devem seguir essas configura\u00e7\u00f5es.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Formato de data e hora:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Clique na sua foto de perfil no canto superior direito<\/li>\n\n\n\n<li class=\"translation-block\">Selecione <strong>Prefer\u00eancias<\/strong><\/li>\n\n\n\n<li>Na aba Geral, verifique os formatos de Data e Hora<\/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>Formato de Dura\u00e7\u00e3o:<\/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\">Selecione <strong>Configura\u00e7\u00f5es do espa\u00e7o de trabalho<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Na aba <strong>Geral<\/strong>, verifique o <strong>Formato de dura\u00e7\u00e3o<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Decimal<\/li>\n\n\n\n<li>Completo<\/li>\n\n\n\n<li>Compacto<\/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\">Seu arquivo CSV deve corresponder exatamente a estes formatos; caso contr\u00e1rio, o arquivo ser\u00e1 rejeitado.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Problemas de formata\u00e7\u00e3o no Excel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea abriu ou editou seu arquivo CSV no Excel, a formata\u00e7\u00e3o pode ter sido alterada (por exemplo, datas, horas ou zeros \u00e0 esquerda removidos). Isso geralmente interrompe a importa\u00e7\u00e3o.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para evitar isso, recomendamos abrir e editar seu arquivo CSV no Planilhas Google, que mant\u00e9m a formata\u00e7\u00e3o correta.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">O arquivo n\u00e3o \u00e9 delimitado por v\u00edrgulas<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">O Clockify espera que arquivos CSV usem v\u00edrgulas como delimitadores. Se o seu arquivo usar ponto e v\u00edrgula, a importa\u00e7\u00e3o n\u00e3o funcionar\u00e1.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Como verificar se o seu arquivo \u00e9 delimitado por v\u00edrgulas:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Abra o arquivo CSV em um editor de texto simples (como o Bloco de notas).<\/li>\n\n\n\n<li>Verifique os caracteres que separam os valores:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Se os valores estiverem separados por v\u00edrgulas, o formato est\u00e1 correto&nbsp;<\/li>\n\n\n\n<li>Se vir ponto e v\u00edrgula (;), ser\u00e1 necess\u00e1rio converter os delimitadores para v\u00edrgulas&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"note wp-block-paragraph\">Voc\u00ea tamb\u00e9m pode abrir o arquivo no Planilhas Google e baix\u00e1-lo novamente como CSV. O Planilhas Google o formatar\u00e1 automaticamente e corretamente usando v\u00edrgulas como delimitadores.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Valores de campo ausentes ou incompletos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Mesmo que todos os campos obrigat\u00f3rios estejam presentes, a importa\u00e7\u00e3o ainda poder\u00e1 falhar se alguns campos forem deixados em branco no seu arquivo CSV.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Verifique as configura\u00e7\u00f5es de campos obrigat\u00f3rios do seu espa\u00e7o de trabalho:<\/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\">Selecione <strong>Configura\u00e7\u00f5es do espa\u00e7o de trabalho<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Clique em <strong>Rastreamento de tempo<\/strong> na barra lateral<\/li>\n\n\n\n<li class=\"translation-block\">Verifique se a <strong>Folha de Tempo<\/strong> <strong>visualiza\u00e7\u00e3o<\/strong> est\u00e1 habilitada. Se for, Projeto se torna um campo obrigat\u00f3rio por padr\u00e3o<\/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. Role a p\u00e1gina para baixo at\u00e9 a se\u00e7\u00e3o <strong>Campos obrigat\u00f3rios de registro de horas<\/strong> para verificar se campos adicionais (por exemplo, Descri\u00e7\u00e3o, Tarefa, Tag) est\u00e3o marcados como obrigat\u00f3rios<\/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\">Se algum desses campos obrigat\u00f3rios estiver vazio no seu CSV, a importa\u00e7\u00e3o n\u00e3o ser\u00e1 bem-sucedida.&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\">Nota<\/span><\/div><div class=\"box-content\">\n<p class=\"wp-block-paragraph\">Se o seu espa\u00e7o de trabalho exigir campos personalizados, voc\u00ea tamb\u00e9m dever\u00e1 inclu\u00ed-los no seu CSV, com dados v\u00e1lidos para cada entrada.&nbsp;<\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Para agilizar o processo de importa\u00e7\u00e3o:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Desative temporariamente todos os campos obrigat\u00f3rios nas configura\u00e7\u00f5es do seu espa\u00e7o de trabalho&nbsp;<\/li>\n\n\n\n<li>Importe apenas os dados essenciais de entrada de tempo<\/li>\n\n\n\n<li>Ap\u00f3s a importa\u00e7\u00e3o, reative os campos obrigat\u00f3rios<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Essa abordagem economiza tempo e evita a necessidade de preencher todos os campos antecipadamente.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A importa\u00e7\u00e3o fica travada em uma determinada porcentagem e n\u00e3o avan\u00e7a nem pode ser cancelada<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se a importa\u00e7\u00e3o do arquivo CSV ficar travada e a interface deixar de responder, tente fazer uma atualiza\u00e7\u00e3o for\u00e7ada da p\u00e1gina ou saia da sua conta e entre novamente. <\/p>\n\n\n\n<p class=\"translation-block wp-block-paragraph\">Verifique o hist\u00f3rico de importa\u00e7\u00f5es para ver se algum dado foi importado parcialmente. Voc\u00ea pode clicar em <strong>Reverter<\/strong> para desfazer a importa\u00e7\u00e3o e tentar novamente.<\/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\">Ainda com problemas? A equipe de suporte do Clockify ter\u00e1 prazer em analisar e ajudar voc\u00ea. Entre em contato conosco pelo e-mail <a href=\"mailto:support@clockify.me\">support@clockify.me<\/a> e nos forne\u00e7a as seguintes informa\u00e7\u00f5es:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Uma c\u00f3pia do arquivo CSV que voc\u00ea est\u00e1 tentando importar.<\/li>\n\n\n\n<li>Uma captura de tela de qualquer mensagem de erro que voc\u00ea esteja recebendo ao importar o arquivo.<\/li>\n<\/ol>","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\/pt\/author\/millenaclockify-me"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/23670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/comments?post=23670"}],"version-history":[{"count":30,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/23670\/revisions"}],"predecessor-version":[{"id":35558,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/23670\/revisions\/35558"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/media?parent=23670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/categories?post=23670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/tags?post=23670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}