Can You Upload Xl Spreadsheet to Mailchimp

Import Contacts to Mailchimp

This folio 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 blazon info straight into the import table. Yous can also car-update multiple existing contacts at once.

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

Earlier you beginning

Here are some things to know before y'all begin this process.

• To become started, y'all'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 y'all're familiar with our format guidelines earlier you import your file.
• In Mailchimp, you can categorize your contacts based on their electronic mail marketing condition, like subscribed or unsubscribed. You can only import to one status at a time.
• If yous'd similar 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 pricing tier, you'll be subject field to an additional contact accuse.

Import new contacts

The file import process has ii parts: Showtime, you'll set 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 ready your file for import, follow these steps.

1. In a spreadsheet program like 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. Adjacent to your E-mail Address cavalcade, create and label additional columns for First Name, Last Name, and whatsoever other information y'all desire to import to Mailchimp.
   
   To learn how to format telephone 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. Salvage the file in CSV format. This pick can usually be accessed from the File carte du jour in your spreadsheet programme, labeled every bit "Consign as .CSV" or "Download as .CSV". Different spreadsheet programs will vary a picayune bit.

Prissy job! Now that yous've prepared your CSV file, you lot're gear up to import.

Note

Demand some assistance saving your spreadsheet file in CSV format before you lot 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 Audition dashboard.
   
3. If y'all have more one audience, click the Current audience drop-downwards and choose the ane you desire to piece of work with.
4. Click the Manage Audience drop-down and choose Import contacts.
5. Choose Upload File.
   
6. Click Continue to Upload.
   
7. Click Browse and choose the CSV file from your computer.
   
8. Click Continue to Organize.
   
9. Utilise the Select an audience drop-down to confirm the audience you desire to import to.
10. Utilise the Select a status drop-down card to cull the condition of the contacts y'all're about to import.
    
    The available statuses for contacts are:
    • Subscribed
    • Unsubscribed
    • Non-subscribed
    • Cleaned
      If you import subscribed contacts, exist 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 adjacent to each grouping that applies.
    
    You'll only see this option if you have groups in your audience.
12. If you lot want to update contacts that are already in your audience, bank check the box next to Update any existing contacts.
    
13. Click Proceed to Tag.
    
14. If you desire to assign tags to all of the contacts in your import, click the drib-downwards menu and choose or create tags every bit needed. You can likewise choose from pop tags.
    
15. When you're ready, click Continue to Friction 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 E-mail Accost field.
    
17. Click the column header to cull a unlike field type for the column or to create a new field. Repeat for all unmatched columns that you want to import. Whatsoever unmatched columns will not be imported.
    
18. Click Finalize Import to review your import settings.
    
19. If everything looks proficient, click Complete Import.
    

That'due south it! Later on the import is finished, we'll send a notification to the email address associated with your username.

Note

• Imported subscribers don't go through the signup process, so you'll need to verify that yous take permission to electronic mail them.
• When you import contacts to an existing audition, we won't include any indistinguishable, bounced, or unsubscribed addresses that are already stored in the audience.
• Considering all audiences in Mailchimp are independent of each other, we can't detect duplicates, bounces, or unsubscribes across multiple audiences. If you have duplicate contacts in different audiences, you lot may find it helpful to combine your audiences into a primary audience that uses groups or tags.

Update existing contacts

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

This choice replaces existing audience field data with new information from your import file. You'll follow the same procedure to import new contacts, simply in that location 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 information.
• Yous can but 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 adjacent to Update whatsoever 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? Learn how to troubleshoot.
Troubleshoot a Contact Import

Want to reverse a contact import? Read on.
Undo a Contact Import

Don't demand that audience anymore?
Delete an Audience

Adjacent steps

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

Getting Started with Your Audience
Manage important information about your audition. Use Mailchimp'southward powerful marketing tools to help empathise how contacts interact with your online store and transport targeted campaigns.

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

Near Signup Form Options
Abound your audience by attracting new subscribers. Use signup forms to extend your marketing reach and help aggrandize your business.

boelkeofat1938.blogspot.com

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

Share this post