asked on

Importing New Subscribers to a MailChimp List

I have an xlsx file with 40,000 emails in column A that I want to import into a new Mailchimp list. In Mailchimp I've checked "Copy and past contacts from .xls or .xlsx file. Then I copied the A column to the clipboard in xlxs and pasted it to the "Paste subscriber" box in MailChimp. The data goes in but when I click Next I get the error "You must have an email address column to import a list."

So I inserted a row at the top of column A in xlsx and wrote "Email Address" there. Copied again to clipboard and pasted into MailChimp. Get same error as above.

Tried next copying the A column and pasting into Notepad++. Wrote "Email Address" above the first email, and copied from Notepad++ copied to clipboard. Selected "Import contacts from .csv or .txt file" in Mailchimp and pasted again. Still get the same error: "You must have an email address column to import a list."

So what is MailChimp looking for?

Thanks for any help

Milind Koyande

Can you please try to copy first 50 or hundred email address and see if the problem persists?

steva

ASKER

The first 50 also fail. The problem was some mal-formed email addresses in the list. MailChimp found it. And it had nothing to do with the "You must have an email address column to import a list" error that MailChimp was throwing.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.