Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I export contacts to .csv format from my Mac?

I am trying to export my contacts in .csv and open in another program. but contacts only allows you to export a Vcard or an .ABBU file


Doug

iMac (27-inch, Late 2012), Mac OS X (10.7.5)

Posted on Mar 18, 2014 5:15 AM

Reply
Question marked as Best reply

Posted on Dec 16, 2014 4:09 PM

The workaround I use goes like this:

Export from Mac Contacts as Vcard.

Import Vcard into Gmail Contacts.

Export from Gmail as .csv which will open with Numbers of NeoOffice.

30 replies

Nov 29, 2015 2:30 PM in response to TinPigeon

Tin Pigeon you are MY HERO. I've been trying to figure this out for years in connection with sending out my holiday cards (including going to the Apple store 3 years ago). Their workaround was for me to create a new USER on my computer and generate a list from there that I could print labels from (because I was not mailing to all of my contacts, just a subset, so I needed a new user for that!) but I still could not get a csv file. Plus had to return to the old desktop where this user lives every holiday season. What a PITA. FINALLY! Your gmail thing worked for me. THANKS!!!

May 18, 2016 2:08 AM in response to Kalsta

"If a contact doesn't have an image, each field appears in the wrong column—basically everything is offset one column to the left of where it should be. So it gets particularly messy if some of your contacts have an image and some don't."


Hi Kalsta,


What result do you get if you sort the table on the leftmost column? I'm hoping that the result is that all the image containing records are grouped together, as are all the records not containing images. If so, it's then easy to select all the records that are too far to the left, drag them one column to the right, and drop them into the correct position.


Regards,

Barry

How do I export contacts to .csv format from my Mac?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.