In Mailchimp Only 86 Names Got Uploaded. How Do I Upload the Rest?

Import Contacts to Mailchimp

This page is now available in other languages.

Our import tool helps you lot 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 direct into the import table. You can likewise machine-update multiple existing contacts at once.

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

Earlier yous start

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

• To get started, you lot'll demand a blank sail 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 appointment, must be formatted in a specific way. Make sure y'all're familiar with our format guidelines before you import your file.
• In Mailchimp, you tin categorize your contacts based on their e-mail marketing condition, like subscribed or unsubscribed. You tin can simply import to one status at a time.
• If you'd like to send postcards to your contacts, bank 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 exist subject to an additional contact accuse.

Import new contacts

The file import procedure has ii parts: First, yous'll gear up your spreadsheet of contacts outside of Mailchimp and save it as a CSV file. Side by side, yous'll use our import tool to upload your file and add together your contacts to your Mailchimp audience.

Prepare for Import

To prepare your file for import, follow these steps.

1. In a spreadsheet program like Excel or Google Sheets, open your blank worksheet.
2. Create and characterization a column for Electronic mail Address. This is the just field we require.
   

3. Next to your Email Address column, create and characterization additional columns for First Name, Terminal Name, and any other information yous want to import to Mailchimp.
   
   To learn how to format phone 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. Salvage the file in CSV format. This option tin usually be accessed from the File menu in your spreadsheet program, labeled equally "Export as .CSV" or "Download as .CSV". Dissimilar spreadsheet programs will vary a footling bit.

Prissy chore! At present that yous've prepared your CSV file, y'all're ready to import.

Notation

Need some help saving your spreadsheet file in CSV format earlier y'all 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 ain data.

Import to Mailchimp

To import your contacts to Mailchimp, follow these steps.

1. Click Audience.
   
2. Click Audition dashboard.
   
3. If you lot accept more than one audience, click the Current audience driblet-down and choose the ane y'all want to work with.
4. Click the Manage Audience drop-down and choose Import contacts.
5. Choose Upload File.
   
6. Click Continue to Upload.
   
7. Click Scan and choose the CSV file from your computer.
   
8. Click Continue to Organize.
   
9. Apply the Select an audience drop-down to ostend the audience you lot desire to import to.
10. Apply the Select a status drop-down card to choose the status of the contacts you're about to import.
    
    The bachelor statuses for contacts are:
    • Subscribed
    • Unsubscribed
    • Non-subscribed
    • Cleaned
      If you import subscribed contacts, exist sure that yous accept permission to ship them marketing.
11. If your audience has groups, y'all can import your contacts directly into the group of your option. Navigate to the Select groups department and check the box next to each group that applies.
    
    Yous'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 side by side to Update whatsoever existing contacts.
    
13. Click Keep to Tag.
    
14. If yous desire to assign tags to all of the contacts in your import, click the drop-down carte du jour and choose or create tags as needed. You lot can as well choose from popular tags.
    
15. When you're ready, click Go on to Match.
    
16. Match the columns in your import file to the fields in your Mailchimp audience. We'll automatically lucifer 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 cavalcade or to create a new field. Repeat for all unmatched columns that y'all desire to import. Any unmatched columns will not be imported.
    
18. Click Finalize Import to review your import settings.
    
19. If everything looks expert, click Consummate Import.
    

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

Notation

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

Update existing contacts

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

This option replaces existing audition field information with new information from your import file. Y'all'll follow the aforementioned process to import new contacts, but there are a few extra things to consider.

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

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

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

Troubleshooting

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

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

Don't need that audience anymore?
Delete an Audience

Next steps

Now that you lot know how to import contacts, hither are some other things you lot can exercise to manage and grow your audition.

Getting Started with Your Audience
Manage of import information about your audience. Use Mailchimp's 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 there were whatever 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 concern.

vonwillersiblens.blogspot.com

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

Share this post