{"id":27039,"date":"2026-01-07T11:45:37","date_gmt":"2026-01-07T13:45:37","guid":{"rendered":"https:\/\/king.host\/wiki\/?post_type=article&#038;p=27039"},"modified":"2026-01-07T11:45:40","modified_gmt":"2026-01-07T13:45:40","slug":"email-marketing-importacao-de-contatos-via-planilha","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/email-marketing-importacao-de-contatos-via-planilha\/","title":{"rendered":"Email Marketing \u2013 Importa\u00e7\u00e3o de Contatos via Planilha"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Objetivo\"><\/span>Objetivo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Permitir a importa\u00e7\u00e3o de uma planilha com contatos provenientes de fontes externas \u00e0 plataforma, de maneira simples e clara, diretamente pela \u00e1rea de\u00a0<strong>Gest\u00e3o de Contatos > Gest\u00e3o de Listas<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Como_importar_uma_planilha\"><\/span><strong>Como importar uma planilha?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>1 \u2013\u00a0<\/strong>Navegue at\u00e9 o menu lateral esquerdo da plataforma e clique em \u201c<strong>Gest\u00e3o de listas<\/strong>\u201d e em\u00a0<strong>IMPORTAR LISTA DE CONTATOS<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake1-960x422.png\" alt=\"\" class=\"wp-image-27040\"\/><\/figure><\/div>\n\n\n<p><strong>2 \u2013\u00a0<\/strong>Clique em\u00a0<strong>\u201cClique aqui\u201d<\/strong>\u00a0para baixar o modelo de planilha recomendado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"538\" height=\"502\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2.png\" alt=\"\" class=\"wp-image-27041 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2.png 538w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2-300x280.png 300w\" data-sizes=\"(max-width: 538px) 100vw, 538px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 538px; --smush-placeholder-aspect-ratio: 538\/502;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"538\" height=\"502\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2.png\" alt=\"\" class=\"wp-image-27041\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2.png 538w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake2-300x280.png 300w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/noscript><\/figure><\/div>\n\n\n<p class=\"has-background\" style=\"background-color:#ffaebc\"><strong>IMPORTANTE:\u00a0<\/strong>siga rigorosamente o modelo para evitar falhas na importa\u00e7\u00e3o. Caso n\u00e3o deseje subir algum campo, mantenha a coluna no arquivo e deixe apenas as c\u00e9lulas em branco. N\u00e3o remova colunas do modelo original.<br><strong>O separador do csv deve ser ; (ponto-e-v\u00edrgula). Outros separadores, como , (v\u00edrgula) podem gerar erros na importa\u00e7\u00e3o.<\/strong><\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Especificacoes_da_planilha\"><\/span><strong>Especifica\u00e7\u00f5es da planilha<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Campo<\/strong><\/td><td><strong>Regras de Preenchimento<\/strong><\/td><\/tr><tr><td>firstname<\/td><td>Nome do contato. Apenas letras. Pode estar vazio. Caracteres especiais aparecer\u00e3o nas campanhas como inseridos.<\/td><\/tr><tr><td>lastname<\/td><td>Sobrenome do contato. Apenas letras. Pode estar vazio. Caracteres especiais ser\u00e3o exibidos nas campanhas.<\/td><\/tr><tr><td>email<\/td><td>E-mail v\u00e1lido (ex: nome@dominio.com). N\u00e3o pode estar vazio. E-mails inv\u00e1lidos impedem a importa\u00e7\u00e3o.<\/td><\/tr><tr><td>cpf<\/td><td>Apenas n\u00fameros, sem pontos ou tra\u00e7os. Pode estar vazio.<\/td><\/tr><tr><td>phone<\/td><td>Apenas n\u00fameros. Pode estar vazio. Para uso com WhatsApp, \u00e9 necess\u00e1rio conter DDD. N\u00fameros sem DDD s\u00e3o considerados inv\u00e1lidos.<\/td><\/tr><tr><td>gender<\/td><td>Apenas letras (ex: M ou F). Pode estar vazio.<\/td><\/tr><tr><td>birthDay<\/td><td>Data de nascimento no formato YYYY-MM-DD (ex: 1991-12-10). Pode estar vazio.<\/td><\/tr><tr><td>emailOptOut<\/td><td>Indica se o contato optou por n\u00e3o receber e-mails. Use 1 para opt-out (n\u00e3o quer receber), 0 caso contr\u00e1rio.<\/td><\/tr><tr><td>emailOptOutAt<\/td><td>Data em que o opt-out de e-mail foi registrado (formato YYYY-MM-DD). Pode estar vazio.<\/td><\/tr><tr><td>whatsappOptOut<\/td><td>Indica se o contato optou por n\u00e3o receber WhatsApp. Use 1 para opt-out, 0 caso contr\u00e1rio.<\/td><\/tr><tr><td>whatsappOptOutAt<\/td><td>Data do opt-out de WhatsApp (formato YYYY-MM-DD). Pode estar vazio.<\/td><\/tr><tr><td>smsOptOut<\/td><td>Indica se o contato optou por n\u00e3o receber SMS. Use 1 para opt-out, 0 caso contr\u00e1rio.<\/td><\/tr><tr><td>smsOptOutAt<\/td><td>Data do opt-out de SMS (formato YYYY-MM-DD). Pode estar vazio.<\/td><\/tr><tr><td>lastInteraction<\/td><td>Data da \u00faltima intera\u00e7\u00e3o do contato (formato YYYY-MM-DD). Pode estar vazio.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"74\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-960x74.png\" alt=\"\" class=\"wp-image-27042 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-960x74.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-300x23.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-768x59.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3.png 1204w\" data-sizes=\"(max-width: 960px) 100vw, 960px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 960px; --smush-placeholder-aspect-ratio: 960\/74;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"74\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-960x74.png\" alt=\"\" class=\"wp-image-27042\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-960x74.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-300x23.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3-768x59.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake3.png 1204w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><\/figure><\/div>\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>3 \u2013<\/strong>\u00a0Com o arquivo preenchido corretamente, arraste-o para o campo \u201cClique e arraste sua lista de contatos\u201d ou clique para selecionar o arquivo<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"538\" height=\"583\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4.png\" alt=\"\" class=\"wp-image-27043 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4.png 538w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4-277x300.png 277w\" data-sizes=\"(max-width: 538px) 100vw, 538px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 538px; --smush-placeholder-aspect-ratio: 538\/583;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"538\" height=\"583\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4.png\" alt=\"\" class=\"wp-image-27043\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4.png 538w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake4-277x300.png 277w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/noscript><\/figure><\/div>\n\n\n<p class=\"has-background\" style=\"background-color:#ffaebc\"><strong>IMPORTANTE:<\/strong>\u00a0Tamanho m\u00e1ximo suportado: 7 MB<\/p>\n\n\n\n<p>Assim que um arquivo v\u00e1lido for inserido, o bot\u00e3o\u00a0<strong>\u201cIMPORTAR CONTATOS\u201d<\/strong>\u00a0ficar\u00e1 habilitado.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"583\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5.png\" alt=\"\" class=\"wp-image-27044 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5.png 535w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5-275x300.png 275w\" data-sizes=\"(max-width: 535px) 100vw, 535px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 535px; --smush-placeholder-aspect-ratio: 535\/583;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"583\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5.png\" alt=\"\" class=\"wp-image-27044\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5.png 535w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake5-275x300.png 275w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/noscript><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mensagens_de_retorno\"><\/span><strong>Mensagens de retorno<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li>Importa\u00e7\u00e3o com sucesso:<br>Exibe confirma\u00e7\u00e3o visual de sucesso no carregamento da planilha.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"906\" height=\"736\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6.png\" alt=\"\" class=\"wp-image-27046 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6.png 906w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6-300x244.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6-768x624.png 768w\" data-sizes=\"(max-width: 906px) 100vw, 906px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 906px; --smush-placeholder-aspect-ratio: 906\/736;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"906\" height=\"736\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6.png\" alt=\"\" class=\"wp-image-27046\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6.png 906w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6-300x244.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake6-768x624.png 768w\" sizes=\"(max-width: 906px) 100vw, 906px\" \/><\/noscript><\/figure><\/div>\n\n\n<ul>\n<li>Erro na importa\u00e7\u00e3o:<br>Exibe mensagem de erro com destaque.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"909\" height=\"748\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7.png\" alt=\"\" class=\"wp-image-27047 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7.png 909w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7-300x247.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7-768x632.png 768w\" data-sizes=\"(max-width: 909px) 100vw, 909px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 909px; --smush-placeholder-aspect-ratio: 909\/748;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"909\" height=\"748\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7.png\" alt=\"\" class=\"wp-image-27047\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7.png 909w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7-300x247.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2026\/01\/wake7-768x632.png 768w\" sizes=\"(max-width: 909px) 100vw, 909px\" \/><\/noscript><\/figure><\/div>\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Em_caso_de_erro_verifique\"><\/span>Em caso de erro, verifique:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li>Se o cabe\u00e7alho segue o padr\u00e3o do modelo.<\/li>\n\n\n\n<li>Se os campos est\u00e3o respeitando os crit\u00e9rios (letras\/n\u00fameros).<\/li>\n\n\n\n<li>Aus\u00eancia de caracteres inv\u00e1lidos como pontos, tra\u00e7os ou crases.<\/li>\n\n\n\n<li>Se o separador do csv est\u00e1 com o formato de \u201c ; \u201d<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Observacoes\"><\/span>Observa\u00e7\u00f5es<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li>N\u00e3o considerar e-mails de marketplace.<\/li>\n\n\n\n<li>A contagem exibida na aba de lista de contatos considera apenas pessoas com e-mail v\u00e1lido.<\/li>\n<\/ul>\n","protected":false},"author":695,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[133,285],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/27039"}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/695"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=27039"}],"version-history":[{"count":1,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/27039\/revisions"}],"predecessor-version":[{"id":27048,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/27039\/revisions\/27048"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=27039"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=27039"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=27039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}