{"id":18697,"date":"2022-02-08T16:56:01","date_gmt":"2022-02-08T16:56:01","guid":{"rendered":"http:\/\/partners.oneaffiniti.com\/?post_type=ht_kb&p=18697"},"modified":"2022-02-15T16:30:12","modified_gmt":"2022-02-15T16:30:12","slug":"how-do-i-import-csv-or-xls-file-to-campaign-monitor","status":"publish","type":"ht_kb","link":"https:\/\/partners.extu.com\/th\/knowledge-base\/how-do-i-import-csv-or-xls-file-to-campaign-monitor\/","title":{"rendered":"How do I import .csv or .xls file to Campaign Monitor?"},"content":{"rendered":"

To prepare your file<\/u>:<\/h4>\n
    \n
  1. Create a new spreadsheet.<\/li>\n

    \"\"<\/p>\n

  2. Make two columns for Full name and Email address.<\/li>\n

    \"\"<\/p>\n

  3. Place the subscriber’s name and email address into separate rows. (If the subscriber did not provide full name, just input their email)<\/li>\n

    \"\"<\/p>\n

  4. Save the file as .xls or .csv for Google Docs. Once done, this will be the list you can upload in Campaign Monitor.<\/li>\n

    \"\"
    \n<\/ br>
    \n<\/ br><\/p>\n

    To upload your list<\/u>:<\/h4>\n
      \n
    1. Login to your Campaign Monitor account.<\/li>\n

      \"\"<\/p>\n

    2. Go to Lists & subscribers.<\/li>\n

      \"\"<\/p>\n

    3. Click ‘Create a list’.<\/li>\n

      \"\"<\/p>\n

    4. Name your list and ‘Continue to import’.<\/li>\n

      \"\"<\/p>\n

    5. To upload your list, you can either ‘drag and drop’ the file or tap on ‘upload a file’. Acceptable file types are csv<\/i>, txt<\/i>, and xls<\/i>.<\/li>\n

      \"\"<\/p>\n

    6. After the upload is complete, the successfully added subscribers will show up in Active like this:<\/li>\n

      \"\"\n<\/ol>\n

      <\/ br>
      \nIf you are uploading a file with multiple email addresses and some of them did not show up to your list, you may refer to this article: Why didn\u2019t all my contacts import to Campaign Monitor?<\/u><\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

      To prepare your file: Create a new spreadsheet. Make two col<\/p>\n

      <\/div>\n

      Read more<\/a><\/p>\n","protected":false},"author":45,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"footnotes":""},"ht-kb-category":[121],"ht-kb-tag":[111,142,288,286,122,125,287],"class_list":["post-18697","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-list-management","ht_kb_tag-campaign-monitor","ht_kb_tag-contacts","ht_kb_tag-csv","ht_kb_tag-file","ht_kb_tag-list","ht_kb_tag-upload","ht_kb_tag-xls"],"acf":[],"_links":{"self":[{"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/ht-kb\/18697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/comments?post=18697"}],"version-history":[{"count":0,"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/ht-kb\/18697\/revisions"}],"wp:attachment":[{"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/media?parent=18697"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/ht-kb-category?post=18697"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/partners.extu.com\/th\/wp-json\/wp\/v2\/ht-kb-tag?post=18697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}