How to Import Excel Contacts to Mailchimp? – Use Free Solution

Rollins Duke
Published: October 26th, 2023 • 7 Min Read

If you are looking for ways to import Excel contacts to Mailchimp Audience Dashboard for marketing purposes, your search ends here! This blog post shows 2 ways to import contacts from Excel to Mailchimp.

With the advent of email marketing, companies have said goodbye to old marketing methods (except advertising) to attract new customers. The current times have seen the advent of many email marketing tools to help companies, content creators and business owners connect with their audiences. You can have your audience list with all the contact details on an Excel sheet. But if you want to import that list to your Mailchimp, then this article is for you, in this, you will be told the process to import Excel contacts to Mailchimp.

But before getting to the main point, let’s introduce you to Mailchimp!

Mailchimp is an email marketing platform helping small businesses and content creators with an all-in-one platform supporting the main components of digital marketing. Launched in 2001, it’s the top email marketing tool, with more than 20 million users and many features that are easy to understand.

Let’s move further and discuss the solutions to import Excel contacts to Mailchimp.

Phase 1: Best Ways To Import Excel Contacts to Mailchimp

The main thing here is – you cannot import contacts from Excel to Mailchimp Audience dashboard directly as Mailchimp only accepts CSV and TXT files to import contacts. All you need to do is convert the Excel sheet into either of the two formats and upload that new sheet to your Mailchimp account.

Here we will describe two methods to create CSV files, with the help of which you will complete this task. The first method is manual in which you have to convert each sheet one by one. If you have Excel files in bulk then manual solutions for the same will become very hectic and even when you upload the files in Mailchimp, you will have to do them one by one due to which your time will also be very consuming. To avoid all these problems, we have also mentioned an automatic tool. Let us now know both methods with complete information.

Method 1: Generate CSV Files from Excel Files Using Manually

Open the Excel Sheet having your contacts.
Click File and then Save As.
In the Save As Type menu, select CSV as the file format and the destination folder for the resultant file.
Click Save and save the Excel sheet (XLSX or XLS) in CSV format.
Get contacts in CSV format from selected locations.

Note: If you have multiple Excel files, repeat this process again. Or if you have it in bulk then you can also use our second solution. which we have mentioned below.

Method 2: Create CSV Files from Source Files Using Automatic Tool

The best automatic tool to generate csv files in bulk is BitRecover Excel to CSV Converter. With the help of this tool, you can create a single file from multiple Excel files. After which you will not need to upload multiple files in Mailchimp, your work will be done with a single file only. It is very easy to use this software because you will complete this process in just 5-6 steps without any technical knowledge. This software also provides you with a demo version in which you can convert some data from your Excel so that you can understand this software. Now let us know the process of this software step by step.

Download Now

Steps for How to Use Software With Screenshots

Download and launch the software on your Windows system by clicking the download button.
Now, add the Excel files after clicking the Add Excel Files or Add Folder Having Excel Files.
Thereafter, you can see all the Excel files listed on the Software panel.
Now, choose the Destination path for the resultant files by clicking the 3-dot icon.
If you create a single CSV file then click the Create Single CSV files from All Sheets option.
Finally, tap the Convert button to start the process, you can see the live process on the Software panel.

Note: Now that the Excel sheet is converted to the Mailchimp-accepted CSV format, follow these steps to import Excel contacts to Mailchimp dashboard:

Phase 2: Import Resultant CSV to Mailchimp

Log in to your Mailchimp account and select Audience Dashboard from Audience.
Click the Add Your Contacts option to import contacts.
Select the CSV or tab-delimited text file option to upload a file and press Continue.
Click the Browse button to choose a contact file from your pc.
Select converted contact file and select the Open button to continue.
Thereafter, choose the Continue to Organize option.
Select a Status as Subscribed.
Enable Update my existing contacts’ information and choose Continue to Tag.
Create a 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 Color field to continue.
Select a field for this column as shown in the respective screenshot.
Choose Create a new field option from the drop-down.
Enter the specific name of the field and hit the Confirm button.
Click the Right Arrow to fix all the errors.
Click Finalize Import after confirming your import settings.
Review and complete your import and click the Complete Import button.
See the message We’re importing contacts from Excel to Mailchimp dashboard.
You will receive an 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.

FAQs to Import Excel Contacts to Mailchimp

Ques 1: How to import contacts to Mailchimp from Excel Workbook?

Ans: Above we have mentioned complete details to import contacts from Excel to Mailchimp. Please follow above mentioned steps to resolve your query.

Ques 2: Can I complete the process to import Excel contacts to Mailchimp without using the software?

Ans: Yes, this task can be completed manually without using any software. If you need to complete the first phase by software then you can use our mentioned software.

Ques 3: Does the explained method work with all Mailchimp subscription plans?

Ans: Yes, you can follow the above-mentioned steps to import Excel contacts to Mailchimp having any subscription plan.

Conclusion

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.

The solution to import Excel contacts to Mailchimp was discussed in this blog. The only solution is that you have to first convert your source file into CSV for which we have mentioned two solutions in this article. You can select any of these solutions as per your needs. And then the converted file has to be imported into Mailchimp, the process of which we have also mentioned in the article with complete information. The steps mentioned above are perfect for the file-import process.