Import Subscribers to a List

This feature requires Manager user level or higher.

Every new MailChimp list starts out empty, but not for long. Our List Import Builder can help you quickly upload and organize an email marketing audience.

If you already have a MailChimp list with subscribers, that’s great too. Our auto-update import feature can help you add new people to your list and update the information of current subscribers at the same time.

In this article, you’ll learn how to import subscribers to your MailChimp list.

Before You Start

Here’s what you’ll need to add contacts to MailChimp.

  • The names and email addresses of people who have opted in to receive your email marketing.

  • A MailChimp list.

  • A blank sheet in a spreadsheet program like Microsoft Excel or Google Sheets, saved or exported as a comma separated value (CSV) file.

How to Import Subscribers

A list import has a couple of steps. First, you’ll prepare your spreadsheet file of contacts outside of MailChimp, and save it as a CSV file. Next, you’ll use our handy List Import Builder to add your contacts to MailChimp.

Prepare for Import

To prepare your file for import, follow these steps.

  1. In a spreadsheet program like Excel or Sheets, open your blank worksheet.

  2. Create and label a column for email address.

  3. Next to your Email Address column, create and label additional columns for First Name, and Last Name.

    Email Address is the only field that we require, but you can repeat this step for any other subscriber data fields you want to include in MailChimp, like phone number, birthday, language, address, or country.

  4. Paste your contacts’ information into the relevant fields in the spreadsheet.  

  5. Save the file in CSV format. This option can usually be accessed from the File menu in your spreadsheet program, labeled as “Export as .CSV” or “Download as .CSV”.  Different spreadsheet programs will vary a little bit. If you use another file type, we won’t be able to process the file.

Now that you’ve completed these steps, you’re ready to import the CSV file to your MailChimp list.

Import to MailChimp

You’ve got your file set up correctly, so now you’ll log in to your MailChimp account and use our List Import Builder to upload your file.

To upload your contacts to MailChimp, follow these steps.

  1. Navigate to the Lists page.

  2. Click the drop-down menu next to the list you want to work with, and choose Import.

  3. Choose CSV or tab-delimited text file.

    If your last import was a CSV with the same columns, you can click Use settings from last import, which will allow you to skip steps 7-11.

  4. Click Next.

  5. Click Browse and choose the file from your computer.

  6. Check the box next to I understand that my billing plan may be automatically upgraded. Your account will only be upgraded if your list import causes your subscriber count to exceed your current billing plan.

  7. Click Next to go to the Import Subscribers step and match the columns in your import file to the fields in your MailChimp list.

  8. Click Save for the Email Address column. We automatically match the column in your import file that contains email addresses to the required Email Address field in your list.

  9. On the second column, check that the column name and field type are correct, and click Save. Or click the drop-down menu to select a different field type. To create a new column in your list, choose New Column Name.


    The editing pane for each column includes the current column name, field type, and example data from your list, for your reference. To exclude a column from the final import, click Skip.

  10. Repeat Step 9 for all unmatched columns. You must match or skip all columns to complete your import. After you’re finished matching, we’ll display a success message.

  11. Click Next to review your final import settings.

  12. On the You're all set to import! screen, review the settings for your import. Be sure to keep the Subscribed option selected.  

  13. After you've reviewed your settings, click Import.

After the import is finished, we’ll send your Primary Account Contact an email notification. Be sure to check out the Lists page in your account to see all your new subscribers.  

How to Auto-Update a List

After you’ve had some subscribers in your list for a while, their data might change. Luckily, our auto-update import feature helps you update the information of multiple subscribers at once.

Auto-update replaces the list field information with information from your import file, so you can quickly update information from your CRM or other database. Like a regular import, you’ll gather your contacts, prepare your spreadsheet, and add them to MailChimp with our List Import Builder.

On the final step of the import, you’ll check the box next to Auto-update my existing list, and click Import. That’s it! We’ll handle the rest by scanning your list and updating subscriber information.

Be careful when you auto-update. You’ll need to verify that your import column names match your MailChimp list field names and that no fields are blank. Blank fields overwrite existing subscriber data with blanks, erasing your old information.

Troubleshooting

Need some help with list imports? Learn how to troubleshoot.

Troubleshoot a List Import

 

Want to reverse a list import? Read on.

Undo a List Import

 

Don’t need that list anymore?

Delete a List

Other Resources

Learn more about lists!

View Your List Import Results

Import Subscribers into Groups

Format Guidelines for Your Import File

Requirements and Best Practices for Lists

 

Learn about ways to grow your list.

Getting Started with Lists

Import Contacts from Other Services

Signup Form Options

Manage Subscribers with the API

 

Was this article helpful?
What can we do to improve articles like this?

Technical Support