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

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.

Doug,

I just aquired and Iphone 6s and needed to import my contacts from a Windows C900 phone (10 years old).

1. I exported my contacts from the phone as a CSV file using the Windows online system.

2. I then created a Gmail account and imported the CSV into the contacts.

3. This enabled me to export them as a VSF file.

4. I imported the VSF file into the Icloud.

5. On the IPhone I logged into the Icloud and presto contacts imported to IPhone 6s.

From Contacts select all (Cmd+A).

File/Export/Export vCard. Save to desktop. That's everyone in a vCard format

Open the webmail application and import contacts. Select the file and import.

I had to select mail then go back to contacts in the web mail app. There are all my contacts.

To my knowledge, you cannot. The export formats are a function of the contacts application.

Barry

Hi Doug,

contacts only allows you to export a Vcard or an .ABBU file

Actually, it's easy to get information in .csv format out of Contacts. Instead of using File > Export, you can do this.

If you have Numbers 2.3:

Select multiple contacts in Contacts (you can drag all contacts into a new group and select them all from that group) and drag them to the Numbers 2.3 canvas. Then File > Export > CSV...

If you have Numbers 3:

Select multiple contacts in Contacts, command-c to copy, click once in a cell of an existing table, and command-v to paste. Then in Numbers 3 File > Export to > CSV...

Note that the above is for the comma-separated flavor of CSV (character-separated-values). If you want tab-separated, instead of File > Export to > CSV from Numbers, simply select the cells with the data, command-c to copy, and in an open document in a text editor, command-v to paste. Then save with the desired file suffix.

There are also AppleScript solutions that extract directly from Contacts to a .csv file. But going through Numbers (because you posted to this forum I assume you already have it) is probably the easiest.

SG

select the contacts you want (in the application Contacts), then copy

switch to Number, paste

If this does not work you may need to allow Numbers to access the contact information by opening System Preference > Privacy & Security

now click the "Privacy" segment then select "Contacts" on the left. Now click the "+" to add Numbers as an application allowed to access contact information

repeat the previous steps

now export using the menu item "File > Export To > CSV..."

If you have access to a PC then

download & install the iCloud Control Panel for Windows from Apple’s Website

iCloud for Windows

and it will sync outlook to all your icloud / iphone contacts

Then you can export from outlook

see both these

http://davidvielmetter.com/tricks/importing-icloud-contacts-to-outlook/

http://www.wikihow.com/Export-Contacts-from-Outlook

This might work if the OP was on Windows...but he's on a Mac. Mac users try to stay out of the Windows ecosystem as much as possible. Thank you though for your tip.

Thanks for the tip. Many of us work with both Mac and Windows, and often Windows on the Mac. I'm personally happy to use whichever ecosystem allows me to get the job done.

SG

Yes this works. I created a Group of just the records I needed in Mac Contacts first and just exported that group. Gmail matched the name of the group and the fields perfectly. Thanks

I was excited to discover that you can drag and drop directly from the Contacts app into Numbers! Less excited to see how buggy it is in practice. I'm on Yosemite 10.10.1 and using Numbers 3.5. 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.

If the first contact has an image then I think the headers and data line up ok.

To report the bug, in your menu go Numbers > Provide Numbers Feedback.

SG

If the first contact has an image then I think the headers and data line up ok.

Nope, doesn't make any difference for me whether the first contact has an image or not. The bug still affects all subsequent contacts without an image.

To report the bug, in your menu go Numbers > Provide Numbers Feedback.

Done. Not sure if the bug lies with the Contacts app (OS X 10.10.1) or Numbers (3.5.2), so I've submitted via both feedback forms.

Doug,

I was having the same issue and found a link to http://labs.brotherli.ch/vcfconvert/

This is a vCard to LDIF/SV convertor.

Quick and simple.

If you are looking forward to convert contacts from CSV to vCard for Mac then you can go for a third party CSV to vCard converter software. Once the contacts gets exported into a vCard file it can be easily taken to Mac platform for easy accessibility.