Import Subscribers to a List

This feature requires Manager user level or higher.

MailChimp offers several ways to add subscribers to your list. You can import subscribers from a CSV, TXT or Excel file to a new list or an existing one, or import new subscriber data to update an existing list. 

In this article, you'll learn how to import subscribers from a CSV, TXT, or Excel file, and how to match and format fields in your list.

Before You Start

Here are some things to know before you begin this process.

Import From a CSV, TXT, or Excel File

To upload your contacts from a CSV, tab-delimited text, or Excel file, 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.
    List drop-down menu with cursor over the import option.
  3. Choose  CSV or tab-delimited text file to import from a file , or choose Copy/Paste from file to use Excel.  
    CSV or TXT option selected for import method.
    If you've previously imported to your list, you'll see an option to Use settings from last import.
  4. Click Next.
  5. To upload a CSV or TXT file, click Browse and choose the file from your computer. To import from Excel, copy and paste your contacts into the field provided.
    Example of CSV file chosen for import.
  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 move on to the Import Subscribers step and match the columns in your list import to the columns in your MailChimp list.
    Next button to move onto next step of import process.
    If you chose to use settings from a previous import, we'll automatically match and skip columns based on your last import. Review your columns and make any desired changes, then click Next and skip to Step 12 to review your import.
  8. Click Save for the Email Address column. We automatically match the column in your import that contains email addresses to the required Email Address field in your list.
    Save button on Email Address column to match your import to your MailChimp list.
  9. On the second column, click Save, or click the drop-down menu to select a different field. To create a new column in your list, choose New Column Name.
    Example of Phone column as a new column added during matching your import to your MailChimp list.
    The editing pane for each column includes the current column name, field type, and example data from your list, for reference. You can click Skip to move over a column and exclude it from the final import. This will not remove a column that already exists in your list.
  10. Repeat step 9 for all unmatched columns. You must match or skip all columns to complete your import. We'll display a success message when you've either matched or skipped all your columns.
    Success message to show you've matched all your columns.
  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. We'll display the method you chose for your import and the number of columns you matched. You can click Details to view which columns you matched to fields in your list, or Edit to make changes.
    Checklist to review your import settings before you finalize.
    If you want to use your import to update information for existing subscribers, click the Auto-update my existing list checkbox.
  13. After you've reviewed your settings, click Import.

After you finish your import, you'll be taken to the View subscribers page for your list. We'll display a status message to show you the progress of your import.
Status displayed on View Subscribers page to show the progress of your import.

You can navigate away from your list and work on something else while you wait. We'll email you when your list import is complete, and display a success notification on the View subscribers page.

About the Auto-Update Option

Use the Auto-update my existing list option to update existing subscriber information in your MailChimp list with new data in your import file.
Auto-update my existing list checkbox, as it appears on the final step of the list import process.

Auto-update replaces the column data in your list with the column data in your list import, so you can quickly update information from your CRM or other database. But keep in mind that if any fields are blank in your import file, you'll overwrite the column data in your list with blanks and lose the old information.

For Auto-update to work properly, verify your subscriber data is up-to-date on your import, and that the column names in your import match the column names in your MailChimp list.

After You Import

After you’ve completed your list import, it’s a good idea to review your field formatting to make sure everything imported correctly before you send to your list.

To view the List fields and *|MERGE|* tags page for your list, 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 Settings.
  3. Click List fields and *|MERGE|* tags.
  4. Review your list fields and make any desired changes to your field settings and default merge tags.

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