How to import subscribers from Apple Address Book or (Contacts application, as it’s been called since Mountain Lion) to your MailChimp Lists
If you’re using OS X 10.6.6 or later, Mail Chimp has a lovely app called Chimport to get your subscribers’ details from the Contacts (the name for Apple’s Address Book application since Mountain Lion) into your MailChimp List. Here’s MailChimp’s article showing you how. Fine……….
If it works!
I’ve just tried it and although it claimed to import the subscribers, they have not appeared in my MailChimp List. Uh Oh!
Don’t let that put you off, others have made it work. I’m on OS X 10.6.8. If you have a later operating system, it may work for you. Give it a try! Or you can try my work around below.
My workaround may seem to have many steps but it is simple and straightforward. If you can copy, paste and drag, you’ll be able to follow this tutorial.
Before you tackle this, make sure people on your list have opted in to receive marketing messages. If you’re not sure of the rules check out the law in your country. Here’s what the UK Information Commissioner’s Office has to say on the subject. Scroll down for regulations on Electronic Mail Marketing.
If you’re ready, let’s get to it.
Getting set up
1. Open a blank spreadsheet, use either Microsoft Excel or Numbers for Apple Mac.
2. Open Address Book
3. Close any other open applications.
4. Re-size the Address Book and spreadsheet windows so you can see both on the screen.
Selecting the contacts in Address Book
1. Click on Address Book. In the first column, called GROUP, select ALL CONTACTS or choose the GROUP containing the email addresses you want to export to MailChimp.
2. To select more than one GROUP, hold down the COMMAND ⌘ key and click on the GROUPs you want, one by one.
3. When you’re done, click on one of the contacts in the second column, NAME. Then select all the addresses. You can do this by holding down the COMMAND ⌘ key and clicking A or choosing SELECT ALL from the EDIT menu.
Dragging the contacts onto the spreadsheet
1. Now you’re going to drag those contacts onto the blank spreadsheet. So simply place the cursor somewhere on the selected addresses, click and hold while you move the mouse to drag the cursor to the spreadsheet.
2. As you hover over the blank spreadsheet, you’ll see a white plus sign in a green circle and a red circle with the number of contacts in it. Let go of the mouse.
3. Next, you want to select the contacts in the spreadsheet. It’s very important, you only select cells that have contact details in them. Don’t highlight the column names. To do this click in the first cell of the first column that has data in it. Then hold down the SHIFT key and click on the last cell that has data in it.
If you have problems clicking on a cell containing an email address, hold down the SHIFT key and click on the cell to the left of the last one, then still holding down SHIFT, use the right arrow on your key board to move into the last cell.
Don’t worry about the order of the data. It doesn’t matter whether your first column is LAST NAME, FIRST NAME or EMAIL ADDRESS. You can sort this out during the IMPORT process.
4. Copy the data either using ⌘C or the COPY option from the EDIT MENU.
Copying and pasting the contacts into your MailChimp List
1. Now, go into your web browser (Google Chrome or Firefox for preference) and log in to your MailChimp account.
2. Select LISTS from the left hand side.
3. On the far right of the screen is a downward pointing triangle next to a button marked STATS. Click on that downward pointing arrow for the list you want and select IMPORT.
4. Scroll down and click on COPY/ PASTE FROM EXCEL. It is the second button in the top row.
5. Place your cursor in the box below where it says PASTE YOUR LIST. And paste your contacts using ⌘V or choose the PASTE option from the EDIT MENU.
6. If you have set up groups for this list, you’ll have the option to choose a group at this stage.
7. At the bottom of the page, you’ll see the IMPORT button. Hit the button.
8. Next MAILCHIMP will ask you to match columns. In the first column you will either see MAKE A SELECTION or MAILCHIMP will suggest a column name e.g. EMAIL ADDRESS. To make a selection use the pull down menu, to find the appropriate column name, e.g. FIRST NAME. Then click OK. If MAILCHIMP has already made the correct selection, you just click OK or if you don’t want that data imported e.g. Phone numbers, then click SKIP. Then you’ll move to the next column. Check each column and click OK or SKIP. There’s a short cut if you have a large number of columns.
10. If you have brought in a large number of columns and you realise you don’t need most of them, there is a SKIP ALL option, it is above the columns, in blue text, in brackets after the text about how many unmatched columns are left. Only use this once you have hit OK for the email address column, first name and last name (if you have them).
11. Once the IMPORT is complete, check the list to make sure it has come in as you intended.
That’s it. Use the comments to let me know if this worked for you or if you tried out Chimport, I’d love to hear how you got on.