Q: I ran an online event using Eventzilla recently, and want to import the contacts from that event into MailChimp. How do I do this?
This is a great question, and makes absolute sense. Organising a successful online event is hard work – why would you put those new leads to waste?!
Let’s assume you have an Excel spreadsheet with three columns of information i.e. Column A labelled Email address, Column B labelled First name, and Column C labelled Last name (You only really need email address for an import, but if you like to personalise your emails – you should – then having the First Name on there is crucial).
Save the file in CSV format.
Navigate to the Lists page on MailChimp.
Click the drop-down menu next to the list you want to work with, and choose Import.
Choose CSV and hit “Next.”
Choose the file from your computer.
Check the box next to “I understand that my billing plan may be automatically upgraded.” Your account will only be upgraded if your import causes your subscriber count to exceed your current plan.
Click “Next” to start matching the columns in your CSV file to the fields in your Mailchimp list.
Click “Save” for the Email Address column. On the second column, check that the column name and field type are correct, and click “Save” (or click the drop-down menu to select a different field type). And then you will do the same for the third column. All columns need to be matched to move on to the next step.
Click “Next” to review your final import settings.
After you’ve reviewed your settings, click “Import.”
Note: When you import new subscribers to an existing list, MailChimp removes any duplicate, bounced, or unsubscribed addresses that are already stored in that list. Bear in mind though, lists in MailChimp are independent of each other, so if you’re worried about duplicate subscribers across different lists, you probably want to consider combining your individual lists into a master list and using groups as a means of segmenting your list.