{"id":14205,"date":"2023-01-03T11:52:23","date_gmt":"2023-01-03T14:52:23","guid":{"rendered":"https:\/\/ajuda.locaweb.com.br\/?post_type=ht_kb&#038;p=14205"},"modified":"2023-02-14T09:46:20","modified_gmt":"2023-02-14T12:46:20","slug":"como-converter-csv-em-excel-email-marketing","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/como-converter-csv-em-excel-email-marketing\/","title":{"rendered":"Como converter CSV em Excel &#8211; Email Marketing"},"content":{"rendered":"    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Informa\u00e7\u00e3o!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tVeja neste artigo como realizar a convers\u00e3o do CSV em Excel para seu Email Marketing.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<ul>\n<li>Muitos sistemas acabam exportando os arquivos em formato CSV e muitas vezes em uma mesma linha a caracteres n\u00e3o aceitos pela plataforma de Email Marketing.<\/li>\n<\/ul>\n<h6>Transformando os dados em CSV<\/h6>\n<ul>\n<li>Abra um arquivo Excel em branco e clique em <strong>Dados<\/strong>;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14474\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01.jpg\" alt=\"\" width=\"641\" height=\"169\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01.jpg 641w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01-300x79.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01-50x13.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01-60x16.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-01-100x26.jpg 100w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/p>\n<ul>\n<li>Clique em <strong>De Text\/CSV<\/strong>;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14475\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02.jpg\" alt=\"\" width=\"356\" height=\"194\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02.jpg 356w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02-300x163.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02-50x27.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02-60x33.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-02-100x54.jpg 100w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/p>\n<ul>\n<li>Selecione o arquivo em formato<strong> CSV<\/strong> que deseja transformar em excel;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14476\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03.jpg\" alt=\"\" width=\"833\" height=\"459\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03.jpg 833w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03-300x165.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03-768x423.jpg 768w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03-50x28.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03-60x33.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-03-100x55.jpg 100w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><\/p>\n<ul>\n<li>Defina a op\u00e7\u00e3o <strong>V\u00edrgula<\/strong>\u00a0e clique em <strong>Carregar<\/strong>;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14477\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04.jpg\" alt=\"\" width=\"877\" height=\"660\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04.jpg 877w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04-300x226.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04-768x578.jpg 768w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04-50x38.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04-60x45.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-04-100x75.jpg 100w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/p>\n<ul>\n<li>Assim que os dados forem carregados, a planilha ser\u00e1 gerada. Tornando mais f\u00e1cil a edi\u00e7\u00e3o dos dados.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14478\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05.jpg\" alt=\"\" width=\"1312\" height=\"392\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05.jpg 1312w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-300x90.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-768x229.jpg 768w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-1024x306.jpg 1024w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-50x15.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-60x18.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2019\/05\/Converter-CSV-em-Excel-Email-Marketing-05-100x30.jpg 100w\" sizes=\"auto, (max-width: 1312px) 100vw, 1312px\" \/><\/p>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Conhe\u00e7a!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAgora que voc\u00ea aprendeu a converter um arquivo em CSV em Excel, confira nosso servi\u00e7o de <a href=\"https:\/\/www.locaweb.com.br\/hospedagem-de-sites-com-dominio-gratis\/\" target=\"_blank\" rel=\"noopener noreferrer\">Hospedagem de Sites<\/a>!    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n","protected":false},"excerpt":{"rendered":"<p>Muitos sistemas acabam exportando os arquivos em formato CSV e muitas vezes em uma mesma linha a caracteres n\u00e3o aceitos pela plataforma de Email Marketing. Transformando os dados em CSV Abra um arquivo Excel em branco e clique em Dados; Clique em De Text\/CSV; Selecione o arquivo em formato CSV&#8230;<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[128],"ht-kb-tag":[376],"class_list":["post-14205","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-email-marketing","ht_kb_tag-categoriaemail-marketing"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/14205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=14205"}],"version-history":[{"count":11,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/14205\/revisions"}],"predecessor-version":[{"id":30052,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/14205\/revisions\/30052"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=14205"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=14205"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=14205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}