How to Bulk Import Excel Contacts to Mailchimp? Best Ways
Fact-checked and reviewed in accordance with our Editorial Policy
What is Necessity to Import Excel Contacts to Mailchimp?
- Businesses can easily maintain customer lists in Mailchimp.
- Effortlessly segment customer information.
- Start email marketing immediately once Excel contacts are imported into Mailchimp.
- Once imported Excel information is easily used to create more personalized email campaigns.
- No need to copy information manually; maintain structured contact information inside Mailchimp.
Pre-Import Checklist
- Column with valid email addresses of every contact.
- Add separate column if you have first & last names information.
- Add phone numbers, company names, birthdays, addresses, etc. in another column if you want to import.
- Remove blank rows, unwanted columns, notes, & formatting.
- Delete duplicate & mistyped email addresses.
- Use clear column headings such as Email Address, First Name, Phone Number, etc.
- Choose CSV as file format. Mailchimp doesn’t support XLSX or XLS format directly.
How to Directly Import Excel Contacts to Mailchimp?
If your contacts are saved in multiple XLS files or you want to save them as CSV format, then you can download or BitRecover Excel to CSV Converter. This application helps users to create single CSV file from multiple Excel contact spreadsheets. It is very easy to use this software because you can complete this process in just 5-6 steps without any technical knowledge. This software also provides free demo version in which you can convert some data from Excel to CSV. The free trial lets you understand complete feature information without paying single dime. Now let us know the process of this software step by step.
Phase 1: Convert Excel XLS Contacts to CSV
- Download software on your computer.
- Start application & select Excel files or folders.
- Preview Excel sheets in software panel.
- Choose destination path to save converted CSV file.
- Click “Create Single CSV files from All Sheets” to help you make single CSV from multiple XLS sheets.
- In last step, click “Convert” icon to begin conversion process
Phase 2: Import Converted CSV Contacts to Mailchimp
- Log in to your Mailchimp account & select Audience Dashboard from Audience.
- Click Add Your Contacts option to import contacts.
- Select CSV or tab-delimited text file option to upload file & press Continue.
- Click Browse button to choose contact file from your pc.
- Select converted contact file and select the Open button to continue.
- Thereafter, choose Continue to Organize option.
- Select Status as Subscribed.
- Enable Update my existing contacts’ information & choose Continue to Tag.
- Create Tag according to your choice and click Continue to Match.
- If you are seeing a warning message, then edit to column name to resolve error. Click on the orange-colored field to continue.
- Select field for this column as shown in the respective screenshot.
- Choose Create a new field option from the drop-down.
- Enter specific name of the field & hit Confirm button.
- Click the Right Arrow to fix all the errors.
- Click Finalize Import after confirming your import settings.
- Complete import process by clicking Complete Import button.
- See message: We’re importing contacts from Excel to Mailchimp dashboard.
- Check email notification after the import process is done.
- Login to your Mailchimp audience dashboard and view imported contacts.
Now that your Excel contacts are successfully imported to Mailchimp, you can start marketing your content or product without worries.
Common Problems When Importing Excel Contacts to Mailchimp
- Mailchimp Didn’t Know My Columns: If Mailchimp doesn’t match existing Mailchimp field, then you need to rename column in source file. You can also manually assign it during step.
- Mailchimp Rejects My File: If you choose another file format, then Mailchimp reject import file process. Users convert Excel contacts in TXT or CSV format to process easily.
- Duplicate Contacts Are Not Updated: Mailchimp automatically removes duplicate contacts. If users already upload same contact then Mailchimp doesn’t process same contacts again.
- Existing Contacts Are Not Updated: If you want to refresh contacts, then update existing contacts in Organized step. Mailchimp treats import as new-contacts-only. It leaves existing records untouched.
- Contact Information Is Missing: Sometimes, blank cell overwrite existing data. If some fields are disappearing after import you need to check source file for blank cells in columns.
- Email Addresses Have Errors: Mailchimp automatically scan block common domain typos. Fix typo in source file & re-import them. If you have international addresses, note Mailchimp can’t process UTF-8 encoded characters before @ symbol.
- CSV File Uses Wrong Delimiter: European version of Excel export CSV with semicolon not in commas as delimiter. Mailchimp can’t read semicolons correctly. Users need to open file in text editor & replace semicolons with commas. Check Excel regional settings before exporting.
Commonly Asked Questions
Can I Import Excel Contact List into Mailchimp Directly?
XLSX can’t be imported directly into Mailchimp. Users first need to convert XLS to CSV, then move converted CSV file into Mailchimp.
What Format Mailchimp Support?
Mailchimp supports CSV or TXT format. It requires Email Address column, plus any optional columns like First Name, Last Name, phone, custom fields, etc., you want imported.
How to Update Existing Mailchimp Contacts?
Firstly, create file with column headers matching Mailchimp fields. Check update existing contacts on Organize step. Mailchimp matches contacts by email address & overwrite stored data.
How to Add Tags When Importing Excel Contacts to Mailchimp?
On “tag your contacts” screen during import. Users need to choose existing tags or create new one. These tags easily apply to every contact in that import batch.
In Essence,
The advent of email marketing has completely changed the brand marketing landscape (except advertising). The current times have seen the advent of many email marketing tools to help companies, content creators and business owners connect with their audiences. And Mailchimp is one of them, with an all-in-one platform supporting the core components of digital marketing.
In this blog, users get to know simple method to bulk import Excel Contacts to Mailchimp. Before beginning conversion Excel contacts to CSV, conversion is needed because Mailchimp doesn’t support XLS format. Choose safe solution to convert Excel contacts because they carry crucial information that cannot be taken risked by online solution. Once converted, import them via above-mentioned steps. I hope this blog properly helps you when you are trying to upload Excel contacts list to Mailchimp.
About the Author
