{"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\/fr\/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 columns for Full name and Email address. Place the subscriber’s name and email address into separate rows. (If the subscriber did not provide full name, just input their email) Save the file as .xls or .csv for Google Docs. Once done, this will be the list you can upload in<\/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,122,125,142,286,287,288],"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-list","ht_kb_tag-upload","ht_kb_tag-contacts","ht_kb_tag-file","ht_kb_tag-xls","ht_kb_tag-csv"],"acf":[],"_links":{"self":[{"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/ht-kb\/18697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/comments?post=18697"}],"version-history":[{"count":0,"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/ht-kb\/18697\/revisions"}],"wp:attachment":[{"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/media?parent=18697"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/ht-kb-category?post=18697"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/partners.extu.com\/fr\/wp-json\/wp\/v2\/ht-kb-tag?post=18697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}