Don’t Know How to Import CSV File to MailChimp? Read This
A properly created and managed subscribers list is the key to success in email marketing. In this mini-tutorial, we will show you how to manage and import CSV to MailChimp for better management of your customers’ contact details.
MailChimp is the best subscriber management tool that keeps one’s web followers updated constantly using beautiful email templates. It comprises so many amazing automation functionalities and differentiated integrations, which makes it a firing email marketing tool in the current marketplace. It also allows professionals to create ads for Instagram, Facebook, and Google even without leaving the platform.
As we all know creating a list of nurturing contacts is the very first thing that needs to be done before initiating email marketing. And…MailChimp allows to import subscribers’ list also. But, the thing is your subscribers list must be in CSV file format. So, if you have a list of all your subscribers in any CSV file, then is you can import it into MailChimp simply.
How to Import CSV File to MailChimp?
In this section, we will show you the simple steps to import CSV in MailChimp. It is recommended to follow the guidelines sequentially to avoid any kind of conflict.
Step 1. First, log in to your MailChimp account and click on Lists tab
Step 2. Click on Add Contacts and choose Import Contacts option from the opened menu list
Step 3. Select the radio button corresponding to CSV or tab-delimited text file from ‘Where do you want to import contacts from’ the page. Click Next
Step 4. Hit the Browse button from the next screen and navigate to the location where your contacts CSV is saved. Add the file to import CSV file to MailChimp and hit the Next button
Step 5. Select Show Skipped Columns and Skip all unmatched columns options from the Import Contacts page. Click Next >> Import
Step 6. Let the import CSV into MailChimp process gets completed and once it’s done, ‘Your import is complete’ prompt will occur
All the imported CSV contacts will start displaying in your MailChimp subscribers list and now you can start email marketing without any hassle.
Are You Unable to Import CSV to MailChimp?
There are times when MailChimp refuses to import CSV into MailChimp or creates issues like mismatched contact columns after importing CSV to MailChimp. This happens only if the added CSV is not compatible with MailChimp or not formatted properly.
ell, if this is happening with you also, then don’t worry. We have other solutions also. From the below section, choose your case and respective solution:
Case 1. You are trying to import a file without having .csv extension
As we can see above that MailChimp only allows to import CSV or TXT files. So, it is very necessary to browse these files only. If you don’t know how to convert your Excel file into CSV then, follow the step given below:
Open your Excel file in MS Excel and click on File >> Save As >> CSV (Comma Separated Values) >> Save
After this, you can simply add and import CSV to MailChimp account.
Case 2. If you are facing columns mismatch issue
This happens when the CSV file you are trying to import is created or exported from some other platform and is not compatible with MailChimp. So, the only option we have left now is to convert this CSV to TXT format (which is supported by MailChimp). Below is how this can be done on Mac OS X:
Download CSV to TXT Converter and launch it
Download Now Purchase Now
Spoiler Alert: This software is cheaper, powerful and intuitive. It can convert unlimited CSV contacts to TXT in a single go.
Step 1. Add the CSV file that you are unable to import in MailChimp and click Next
Step 2. Choose TXT as an export option and map all CSV fields with TXT (manually or automatically)
Step 3. Once the mapping is done, hit the Export button
All the CSV contacts will get converted into TXT file format within a few moments only.
After conversion, you can simply import the resultant TXT to your MailChimp account.
And that is all for now
So, this is how you can import CSV to MailChimp account without any technical expertise.
Frequently Asked Questions
Q. What file types can be uploaded to Mailchimp?
A. MailChimp allows to import CSV, TXT, XLS, and XLSX files. You can also copy and paste contacts from Excel XLS and XLSX files to MailChimp.
Q. Does Mailchimp delete duplicates?
A. No, MailChimp does not delete duplicate contacts automatically. However, it does not allow to keep duplicates in the same list.
Q. How do you import contacts from Excel to Mailchimp?
A. Open MailChimp and click on Lists. Select Add Contacts option and choose CSV / TXT or XLS / XLSX format and import Excel contacts to MailChimp easily.
Q. How many contacts can I have in MailChimp?
A. The free plan of MailChimp allows to store 2,000 contacts or subscribers in your account, and you can send up to 12,000 emails per month.