Importing contact lists from Mailchimp manually

This guide explains how you can import your contacts from Mailchimp to Shopify manually.

Export contact lists from Mailchimp

Before you can import your contacts to Shopify, you first need to export them from Mailchimp.

Clean up the file

After you've exported your contacts from Mailchimp, you'll have a ZIP file saved to your computer. This ZIP file contains a CSV file with subscribed members list. If there were any unsubscribed members in your contacts, then you'll have another CSV file with unsubscribed members list. You need to unzip the ZIP file, and then clean up each CSV file to make it ready for import.


  1. Upload the CSV file to Google Sheets.
  2. In your spreadsheet, keep only the following column headers, and delete the others.
    • Email Address
    • First Name
    • Last Name
    • Phone Number
    • Company
  3. Rename the following column headers:
    • From Email Address to Email
    • From Phone Number to Phone
  4. Add a new column header named Accepts Marketing, and enter values for each customer according to the following:
    • If your file name begins with subscribed_members, then enter yes for the Accepts Marketing column.
    • If your file name begins with nonsubscribed_members, then enter no for the Accepts Marketing column.
  5. Export the file to your computer in CSV format.

Import the file into Shopify

After you have cleaned up your CSV files, you need to import each of these files to your Shopify store to complete your import.

Troubleshoot errors

Error found in CSV header

If you encounter the error Error found in CSV header when you import your CSV file to Shopify, then that means that the column header names don't match. Verify whether the column header names in your CSV file match the required names.

Ready to start selling with Shopify?

Try it free