Import Subscribers to a List

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

If your MailChimp list already has subscribed contacts, 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 are some things to know before you begin this process.

  • These instructions are for adding subscribed contacts to your list. Make sure you have the names and email addresses of people who have opted in to receive your email marketing.
  • Make sure you've set up your MailChimp list.
  • You'll need 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 subscribed 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.
    click import
  3. Choose CSV or tab-delimited text file. click csv or text fileIf 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. If you want to assign tags to your imported contacts, click the Plus (+) icon in the Organize imported contacts section.
  13. After you've reviewed your settings, click Import.

After the import is finished, we'll send a notification to the email address associated with your username. Be sure to check out the Lists page in your account to see all your new subscribers.

Update Existing Contacts

After you've had some contacts in your list for a while, their data might change. You can use your import file to update existing information for multiple contacts at once.

This option replaces the list field information with information from your import file, so you can quickly update contact information. Like a regular import, you'll gather your contacts, prepare your spreadsheet, and add them to MailChimp with our Import Builder.

On the final step of the import, check the box next to Update existing contacts, and click Import. That's it! We'll handle the rest by scanning your list and updating subscriber information.

checkbox-import-updateexisting

Be careful when you update with this method. 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

About Signup Form Options

Manage Subscribers with the API

Was this article helpful?
Anything else we can do to improve our site?

Technical Support