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)
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)
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.
Sorry for the typo
This is a vCard to LDIF/CSV convertor.
And it's free!!!!!
Search "vcard to csv" on Google. I usually use the tool at http://labs.brotherli.ch/vcfconvert/. You can export a list as vCard, then import that file into the converter. It will give you a CSV file to download. It's pretty simple, and it's free.
Fabulous resource! Thank you so much for bringing to our attention!
Though perhaps caution is warranted if there are privacy concerns.
SG
You can download ContactsSyncer from App Store. It's free. Besides importing and exporting between vCard and CSV, it can also sync to Gmail, Yahoo and more... Hope this helps.
Thanks Wayne for posting your tip. It's a bit of a workaround, however it does work.
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!!!
There is also an App on App Store called AB Export. This has the option to export from your contacts to CSV and you can select any group of contacts that you have created to export. I use this a lot and it works great and is simple (which I need) and free.
Wow, super simple! Use comma instead of tab in the check box. Took 60 seconds. Amazing and free.
You can use Automator using this tutorial: http://www.scrubly.com/blog/how-to-mac-contacts/how-to-use-mac-automator-to-expo rt-contacts-to-excel/
very helpful thank you
"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
Have found several Vcard to CSV converters online (labs.brotherli.ch/vcfconvert/ and www.unc.edu/vtoc). Are there any issues with security in using these - such as your contacts being stored on their server, etc.? What steps can be taken to ensure security and privacy in utilizing these converters?
Thanks.
AN
There is no "+" to click. macOS 10.12.6, all updates done. Working as Standard user, but logged in to Sys Prefs as admin.
I found VCF to CSV converter tool so, you can export your all contacts in vcard format and into .csv file. https://www.softaken.com/vcf-to-csv-converter
How do I export contacts to .csv format from my Mac?