Why Wont Csv File Upload to Mailchimp

Import Contacts to Mailchimp

This folio is now available in other languages.

Our import tool helps you add together 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 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 y'all start

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

• To get started, you'll need a bare canvass in a spreadsheet programme like Microsoft Excel or Google Sheets, saved or exported as a comma separated value (CSV) file.
• Sure fields, similar birthday and date, must exist formatted in a specific manner. Brand sure you're familiar with our format guidelines earlier you import your file.
• In Mailchimp, you can categorize your contacts based on their email marketing status, similar subscribed or unsubscribed. You tin can only import to one status at a fourth dimension.
• If y'all'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 pricing tier, you'll be field of study to an additional contact charge.

Import new contacts

The file import process has two parts: Outset, you'll set up your spreadsheet of contacts exterior of Mailchimp and salvage it as a CSV file. Next, you lot'll use our import tool to upload your file and add together your contacts to your Mailchimp audience.

Set up for Import

To set up your file for import, follow these steps.

1. In a spreadsheet program similar 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 Accost cavalcade, create and label additional columns for First Name, Last Name, and any other information y'all want to import to Mailchimp.
   
   To learn how to format telephone numbers, birthdays, mailing addresses, and other types of data, cheque 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 every bit .CSV" or "Download equally .CSV". Different spreadsheet programs will vary a little bit.

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

Note

Need some aid saving your spreadsheet file in CSV format before you import? Bank check out these CSV tips from Excel and Google Sheets. Or, download our sample CSV import file and replace the sample emails with your ain data.

Import to 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 audition drop-down and cull the ane yous want to work with.
4. Click the Manage Audience drib-down and cull Import contacts.
5. Choose Upload File.
   
6. Click Go along to Upload.
   
7. Click Browse and cull the CSV file from your computer.
   
8. Click Continue to Organize.
   
9. Use the Select an audience drib-downwards to confirm the audience yous want to import to.
10. Utilise the Select a status driblet-down menu to choose the status of the contacts you're nigh 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 audition 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 choice if you accept groups in your audience.
12. If yous 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 y'all desire to assign tags to all of the contacts in your import, click the drop-downward menu and choose or create tags as needed. Y'all can also choose from popular tags.
    
15. When you're ready, click Continue to Lucifer.
    
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 E-mail Address field.
    
17. Click the column header to cull 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 volition non be imported.
    
18. Click Finalize Import to review your import settings.
    
19. If everything looks skilful, click Complete Import.
    

That'due south it! Afterwards the import is finished, we'll send a notification to the electronic mail address associated with your username.

Note

• Imported subscribers don't get through the signup procedure, so yous'll need to verify that you take permission to e-mail them.
• When you import contacts to an existing audience, we won't include any duplicate, bounced, or unsubscribed addresses that are already stored in the audience.
• Because all audiences in Mailchimp are contained of each other, we can't detect duplicates, bounces, or unsubscribes across multiple audiences. If you lot have duplicate contacts in different audiences, y'all may detect information technology helpful to combine your audiences into a master audience that uses groups or tags.

Update existing contacts

You may need to update your contacts' information if they've been in your audition for a while. Use our import tool to quickly update multiple contacts at one time.

This selection replaces existing audition field data with new data from your import file. You'll follow the same process to import new contacts, merely in that location are a few extra things to consider.

• When you fix your spreadsheet, verify that your column names in your import file match the fields in your Mailchimp audience, and that no columns are left blank. Bare fields overwrite and erase existing contact information.
• You can but update subscribed or non-subscribed contacts with this method.
• Imports won't update the e-mail 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 pace of the import, bank check the box adjacent to Update any existing contacts.

That's it! When yous import, we'll handle the balance by scanning your contacts and updating their data.

Troubleshooting

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

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

Don't need that audience anymore?
Delete an Audience

Side by side steps

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

Getting Started with Your Audience
Manage important data about your audience. Use Mailchimp'south powerful marketing tools to help sympathise 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.

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

holmanconven.blogspot.com

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

Share this post