Import Contacts to Mailchimp

Our import tool helps you add or update contacts in Mailchimp. Import from a connected app, upload a comma-separated value file (CSV), copy and paste contacts from a spreadsheet like Microsoft Excel or Google Sheets, or type info directly into the import table. You can also auto-update multiple existing contacts at once.

In this article, you'll learn how to use our import tool to add and update contacts in Mailchimp.

Before you start

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

• Free plans include up to 500 contacts and 1,000 sends per month, with a daily send limit of 500. To learn more, check out our pricing page. To change your plan type, visit the plans page in your account.
• To get started with a file import, 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.
• Certain fields, like birthday and date, must be formatted in a specific way. Make sure you're familiar with our format guidelines before importing your file.
• In Mailchimp, you can categorize your contacts based on their email marketing status, such as subscribed or unsubscribed. You can only import to one status at a time.
• If you’d like to send postcards to your contacts, check out our article on how to import mailing addresses.
• If your import brings your total contact count above the limit of your Marketing plan tier, you'll be subject to an additional contact charge.

Import from another service

To save time and effort, Mailchimp lets you connect six of the most commonly used integrations and will import contacts for you. Here’s the list of currently supported apps:

• Zapier
• Salesforce
• WooCommerce
• QuickBooks Online
• Squarespace Commerce
• Shopify

To connect another app and import contacts to Mailchimp, follow these steps.

1. Click Audience.
   
2. Click Audience dashboard.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Manage Audience drop-down and choose Import contacts.
5. Choose Import from another service.
   
6. Click Continue.
7. Click ADD on one of the available integration tiles to begin connecting your app. Previously connected integrations will have a checkmark instead of the add button.
   
8. Click Done after you’ve connected the app.

That’s it! You’ve now connected your app and Mailchimp will import contacts.

Import new contacts from a file

The file import process has two parts: First, you'll prepare your spreadsheet of contacts outside of Mailchimp and save it as a CSV file. Next, you'll use our import tool to upload your file and add your contacts to your Mailchimp audience.

Prepare for import

To prepare your file for import, follow these steps.

1. In a spreadsheet program like Microsoft Excel or Google Sheets, open your blank worksheet.
2. Create and label a column for Email Address. This is the only field we require.
   

3. Next to your Email Address column, create and label additional columns for First Name, Last Name, and any other information you want to import to Mailchimp.
   
   To learn how to format phone numbers, birthdays, mailing addresses, and other types of data, check out Format Guidelines for Your Import File.

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 may vary.

Nice job! Now that you've prepared your CSV file, you're ready to import.

Import your file into Mailchimp

To import your contacts to Mailchimp, follow these steps.

1. Click Audience.
   
2. Click Audience dashboard.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Manage Audience drop-down and choose Import contacts.
5. Choose Upload a file.
   
6. Click Continue to upload.
7. Click Browse and choose the CSV file from your computer.
   
8. Click Continue to Organize.
9. Use the Select an audience drop-down to confirm the audience you want to import to.

10. Use the Select a status drop-down to choose the status of the contacts you're about to import.
    
    The available statuses for contacts are:

    • Subscribed
    • Unsubscribed
    • Non-subscribed
    • Cleaned

    If you import subscribed contacts, be sure that you have permission to send them marketing.

11. If your audience has groups, you can import your contacts directly into the group of your choice. Navigate to the Select groups section and check the box next to each group that applies.
    
    You'll only see this option if you have groups in your audience.
12. If you want to update contacts that are already in your audience, check the box next to Update any existing contacts.
    
13. Click Continue to Tag.
14. If you want to assign tags to all of the contacts in your import, click the drop-down menu and choose or create tags as needed. You can also choose from popular tags.
    
15. When you're ready, click Continue To Match.
16. Match the columns in your import file to the fields in your Mailchimp audience. We'll automatically match some columns for you. For example, the column that contains email addresses will match the required Email Address field.
    
17. Click the column header to choose a different field type for the column or to create a new field. Repeat for all unmatched columns that you want to import. Any unmatched columns will not be imported.
    
18. Click Finalize Import to review your import settings.
19. If everything looks good, click Complete Import.

That's it! After the import is finished, we'll send a notification to the email address associated with your username.

Copy and paste contacts

You can directly paste new contacts from a spreadsheet or list.

To paste your contacts, follow these steps.

1. Click Audience.
   
2. Click Audience dashboard.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Manage Audience drop-down and choose Import contacts.
5. Choose Copy and paste.
   
6. Click Continue.
7. Paste your contact information in the field.
   
8. Click Continue to Organize.
9. Use the Select an audience drop-down to confirm the audience you want to import to.

10. Use the Select a status drop-down to choose the status of the contacts you're about to import.
    
    The available statuses for contacts are:

    • Subscribed
    • Unsubscribed
    • Non-subscribed
    • Cleaned

    If you import subscribed contacts, be sure that you have permission to send them marketing.

11. If your audience has groups, you can import your contacts directly into the group of your choice. Navigate to the Select groups section and check the box next to each group that applies.
    
    You'll only see this option if you have groups in your audience.
12. If you want to update contacts that are already in your audience, check the box next to Update any existing contacts.
    
13. Click Continue to Tag.
14. If you want to assign tags to all of the contacts in your import, click the drop-down menu and choose or create tags as needed. You can also choose from popular tags.
    
15. When you're ready, click Continue To Match.
16. Match the columns in your import file to the fields in your Mailchimp audience. We'll automatically match some columns for you. For example, the column that contains email addresses will match the required Email Address field.
    
17. Click the column header to choose a different field type for the column or to create a new field. Repeat for all unmatched columns that you want to import. Any unmatched columns will not be imported.
    
18. Click Finalize Import to review your import settings.
19. If everything looks good, click Complete Import.

That's it! After the import is finished, we'll send a notification to the email address associated with your username.

Update existing contacts

You may need to update your contacts’ data if they’ve been in your audience for a while. Use our import tool to quickly update multiple contacts at once.

This option replaces existing audience field information with new information from your import file. You’ll follow the same process to import new contacts, but there are a few extra things to consider.

• When you prepare your spreadsheet, verify that the column names in your import file match the fields in your Mailchimp audience, and that no columns are left blank. Blank fields overwrite and erase existing contact data.
• You can only update subscribed or non-subscribed contacts with this method.
• Imports won’t update the email marketing status of contacts already in your Mailchimp account.

Proceed with a file import, and follow the steps to upload your file and match your columns. On the Organize step of the import, check the box next to Update any existing contacts.

That's it! When you import, we'll handle the rest by scanning your contacts and updating their information.

Troubleshooting

Need some help with contact imports?
Troubleshooting Contact Imports

Want to reverse a contact import? Undo a Contact Import

Don't need that audience anymore?
Delete an Audience

Next steps

Now that you know how to import contacts, here are some other things you can do to manage and grow your audience.

Getting Started with Your Audience
Manage important information about your audience. Use Mailchimp’s powerful marketing tools to help understand how contacts interact with your online store and send segmented emails.

View Your Contact Import Results
See how many contacts were added or updated, and whether there were any addresses with syntax errors.

About Signup Form Options
Grow your audience by attracting new subscribers. Use signup forms to extend your marketing reach and help expand your business.