How to Upload Excel List to Mailchimp

Import Contacts to Mailchimp

This page is now available in other languages.

Our import tool helps you add contacts to Mailchimp. 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 tin can also auto-update multiple existing contacts at once.

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

Before you commencement

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

• To get started, you'll need a blank sheet in a spreadsheet program similar Microsoft Excel or Google Sheets, saved or exported as a comma separated value (CSV) file.
• Sure fields, like birthday and date, must be formatted in a specific style. Make certain you're familiar with our format guidelines earlier yous import your file.
• In Mailchimp, you tin categorize your contacts based on their electronic mail marketing status, like subscribed or unsubscribed. You tin can just import to one status at a time.
• If you'd similar to send postcards to your contacts, check out our commodity on how to import mailing addresses.
• If your import brings your total contact count above the limit of your pricing tier, you'll be subject to an boosted contact accuse.

Import new contacts

The file import procedure has two parts: Beginning, you'll prepare your spreadsheet of contacts exterior of Mailchimp and relieve it as a CSV file. Next, you lot'll utilise our import tool to upload your file and add your contacts to your Mailchimp audition.

Prepare for Import

To ready your file for import, follow these steps.

1. In a spreadsheet plan similar Excel or Google Sheets, open your blank worksheet.
2. Create and label a column for Email Accost. This is the only field we crave.
   

3. Next to your Electronic mail Address column, create and characterization additional columns for Outset Name, Last Name, and any other information y'all 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 pick can normally be accessed from the File menu in your spreadsheet programme, labeled as "Consign as .CSV" or "Download as .CSV". Unlike spreadsheet programs volition vary a piffling bit.

Nice job! At present that you've prepared your CSV file, you're gear up to import.

Note

Need some help saving your spreadsheet file in CSV format before yous import? Check out these CSV tips from Excel and Google Sheets. Or, download our sample CSV import file and replace the sample emails with your own information.

Import to Mailchimp

To import your contacts to Mailchimp, follow these steps.

1. Click Audience.
   
2. Click Audience dashboard.
   
3. If yous take more than than i audience, click the Current audition drop-downward and choose the one you want to work with.
4. Click the Manage Audience drop-down and cull Import contacts.
5. Cull Upload File.
   
6. Click Continue to Upload.
   
7. Click Browse and choose the CSV file from your estimator.
   
8. Click Go along to Organize.
   
9. Apply the Select an audience drib-downward to confirm the audition you desire to import to.
10. Use the Select a status drop-down menu to cull the condition of the contacts y'all're about to import.
    
    The available statuses for contacts are:
    • Subscribed
    • Unsubscribed
    • Not-subscribed
    • Cleaned
      If you import subscribed contacts, exist sure that y'all have permission to transport them marketing.
11. If your audience has groups, you lot can import your contacts direct into the group of your choice. Navigate to the Select groups section and cheque the box next to each group that applies.
    
    Yous'll merely see this option if you have groups in your audition.
12. If you want to update contacts that are already in your audience, check the box adjacent to Update whatsoever existing contacts.
    
13. Click Continue to Tag.
    
14. If you want to assign tags to all of the contacts in your import, click the driblet-downward menu and choose or create tags as needed. You can too choose from pop tags.
    
15. When y'all'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 y'all. 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 cavalcade or to create a new field. Echo for all unmatched columns that you want to import. Any unmatched columns volition not be imported.
    
18. Click Finalize Import to review your import settings.
    
19. If everything looks good, click Consummate Import.
    

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

Notation

• Imported subscribers don't go through the signup process, then y'all'll demand to verify that you accept permission to email them.
• When you import contacts to an existing audience, we won't include whatsoever duplicate, bounced, or unsubscribed addresses that are already stored in the audition.
• Considering all audiences in Mailchimp are independent of each other, nosotros can't detect duplicates, bounces, or unsubscribes beyond multiple audiences. If you have duplicate contacts in different audiences, you may find it helpful to combine your audiences into a primary audience that uses groups or tags.

Update existing contacts

Y'all may need to update your contacts' data if they've been in your audition for a while. Apply our import tool to quickly update multiple contacts at one time.

This choice replaces existing audience field information with new information from your import file. Yous'll follow the aforementioned process to import new contacts, only at that place are a few extra things to consider.

• When you prepare your spreadsheet, verify that your column names in your import file match the fields in your Mailchimp audience, and that no columns are left bare. Bare fields overwrite and erase existing contact data.
• You tin merely update subscribed or non-subscribed contacts with this method.
• Imports won't update the e-mail marketing condition 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 pace of the import, cheque the box side by side to Update any existing contacts.

That'south information technology! When you lot import, we'll handle the rest past scanning your contacts and updating their data.

Troubleshooting

Need some help with contact imports? Larn how to troubleshoot.
Troubleshoot a Contact Import

Desire to reverse a contact import? Read on.
Disengage a Contact Import

Don't need that audience anymore?
Delete an Audience

Next steps

At present that you know how to import contacts, here are another things you can do to manage and abound your audience.

Getting Started with Your Audience
Manage important information about your audition. Use Mailchimp's powerful marketing tools to assist understand how contacts interact with your online store and send targeted campaigns.

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

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

florancetheankind.blogspot.com

Source: https://mailchimp.com/help/import-contacts-mailchimp/

Share this post