{"id":4041,"date":"2020-02-17T10:28:09","date_gmt":"2020-02-17T09:28:09","guid":{"rendered":"https:\/\/mndsupport.wpengine.com\/?post_type=faq&#038;p=4041\/"},"modified":"2021-06-03T08:15:09","modified_gmt":"2021-06-03T07:15:09","slug":"file-not-being-imported","status":"publish","type":"faq","link":"https:\/\/helpstaging.mynewsdesk.com\/en\/faq\/file-not-being-imported\/","title":{"rendered":"Why is my address file not being imported?"},"content":{"rendered":"<p class=\"p1\">The file to be imported may be up to 5 MB in size, and needs to be one of the following file types:<br \/>\nXLS, CSV, TSV, ODS or XLSX<\/p>\n<p class=\"p1\">If the import of a file is failing, it is mostly due to shortcomings in the file itself.<br \/>\n<span style=\"letter-spacing: 0.009em;\">Please check that your file doesn\u2019t contain:<\/span><\/p>\n<p class=\"p1\">&#8211; mis-spelled email addresses (e.g. <i>gmail,com<\/i> instead of <i>gmail.com<\/i>)<br \/>\n&#8211; fields filled with more than 180 characters<br \/>\n&#8211; data that is not organised in columns<br \/>\n&#8211; any combined cells<br \/>\n&#8211; multiple tabs<\/p>\n<p class=\"p1\">If none of the above applies, it might be some bad formatting that is causing issues. To get rid of the bad formatting, you can try to mark all names, copy, and then paste them <i>as values<\/i> into a completely new file that you create in Excel. Then save and import this new file.<\/p>\n<p class=\"p1\">Alternatively, you can use the <i>Paste<\/i> function instead, as described in the <em>Paste<\/em> section in our guide <a href=\"https:\/\/mndsupport.wpengine.com\/how-to\/import-contacts-lists\/\"><span class=\"s1\">Import contacts into your lists<\/span><\/a>.<\/p>\n<p class=\"p1\">To ensure a correct take-over of special characters and umlauts, the uploaded file with your names should be saved in <i>Unicode (UTF-8)<\/i>.<\/p>\n<p>Please also see:<\/p>\n<p class=\"p1\"><span class=\"s2\"><a href=\"https:\/\/mndsupport.wpengine.com\/how-to\/import-contacts-lists\/\">Import contacts into your lists<\/a><br \/>\n<\/span><span class=\"s1\"><a href=\"https:\/\/mndsupport.wpengine.com\/faq\/how-do-i-add-contacts\/\">How do I add contacts?<\/a><br \/>\n<a href=\"https:\/\/mndsupport.wpengine.com\/faq\/why-were-not-all-contacts-included-when-importing-my-list\/\">Why were not all contacts included when importing my list?<\/a><br \/>\n<\/span><\/p>\n<p>Or learn more about <a href=\"https:\/\/mndsupport.wpengine.com\/sv\/howto-category\/contacts\/\">Contacts<\/a> in our <a href=\"https:\/\/mndsupport.wpengine.com\/sv\/how-tos\/\">Guides<\/a><\/p>\n","protected":false},"parent":0,"template":"","faq-category":[134],"faq-tag":[],"faq-language":[],"faq-translation_id":[],"acf":[],"_links":{"self":[{"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq\/4041"}],"collection":[{"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/types\/faq"}],"wp:attachment":[{"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/media?parent=4041"}],"wp:term":[{"taxonomy":"faq-category","embeddable":true,"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq-category?post=4041"},{"taxonomy":"faq-tag","embeddable":true,"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq-tag?post=4041"},{"taxonomy":"faq-language","embeddable":true,"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq-language?post=4041"},{"taxonomy":"faq-translation_id","embeddable":true,"href":"https:\/\/helpstaging.mynewsdesk.com\/en\/wp-json\/wp\/v2\/faq-translation_id?post=4041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}