Import Mailchimp Contacts via CSV

From MoHA Wiki


Purpose:

Add, update, and tag contacts in Mailchimp by importing CSV lists.

Steps:

  1. In Mailchimp, go to the Master Audience list.
    Master Audience list.png Mailchimp.png
  2. Click Add Contacts > Upload a file.
    • Note: You can copy and paste if you don’t want to go through the import process. Using copy and paste is best for quick, simple imports without a variety of fields.
  3. Select your CSV file. You can use Browse or drag-and-drop.
    • “Subscribed” is the default.
  4. Add contacts to any Groups.
    • Groups are additive. For example, if a person is already subscribed to “Shows and Events,” and you select only “Volunteering” they will be subscribed to both.
  5. Checkmark “Update any existing contacts.”
  6. Click Continue to Match.
    • “Continue to Match” refers to matching column labels to contact fields.
    • Because of the amount of tags, it is not recommended to add tags to your contacts on this screen. You can still add tags through the CSV, but this will apply a tag to ALL the contacts you import here.
    Tag your contacts Mailchimp.png
    • If there is an error at this step it will appear like this:
    Match column labels Mailchimp.png
    • If you click the Orange box (Container Header), you can select the associated field. Mailchimp will guess which field it should be. Once you match, it changes to match the others.
  7. In the CSV file, if you have multiple tags, put a comma “,” in between each and the system will recognize you are adding multiple tags to that subscriber.
    Match column tags Mailchimp.png
  8. Uncheck the boxes of any columns/fields you do not wish to import.
    • Above the “Finalize Import” button, you can check how many columns are being imported.
    Finalize Import review Mailchimp.png
  9. Click Finalize Import.
    • A summary of what is being imported displays.
    Review and complete Mailchimp.png
  10. Click Complete Import.
    • The Master Audience List is sorted by recently changed, so any added and updated contacts will be at the top for you to review.
    • You can also review by going to Import History > Manage contacts > Import History > the most recent CSV.

Related links