In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting to Vcard does not work...only exports a small handful of vcards out of over 4,000 and data is not usable in Numbers, Excel, or Outlook/Windows Live Mail. Please help!
1
-
1See this related question: apple.stackexchange.com/questions/70281/…– PierzCommented Jun 25, 2015 at 15:02
Add a comment
|
2 Answers
Really simple:
- In Contacts select all contacts you want to export or press CMD-A.
- Press CMD-C (copy to clipboard).
- Open a new, empty Numbers document.
- Delete any existing table in that document.
- Press CMD-V to paste your clipboard.
This gives you a nice spreadsheet with all your selected contacts and proper rows and columns.
-
Works for me although I doesn't put everything in the right columns if a field is missing. Commented Jun 25, 2015 at 14:25
-
What do you mean by "if a field is missing"? If there's no entry of some sort in one of the contacts, while other contacts do have this entry?– awadoCommented Jun 27, 2015 at 10:40
-
Correct. For example if one contact has an image and another does not the row on the one that does not gets shifted so that the each cell is under the wrong column. Commented Jun 27, 2015 at 15:25
-
1Sadly, this is true. As soon as you start using images, columns get shifted, even when there are no more images.– awadoCommented Jun 28, 2015 at 12:47
In Contacts select all then Export as vCard file.
Use this online conversion tool to get CVS file.
vCard to LDIF/CSV Converter
You can also download the script and run in directly on your computer for increased privacy.
-
If your files re < 8mb else it won't work– user115795Commented Feb 23, 2015 at 3:35
-
Could you cite some reference as to why this might be the case?– TetsujinCommented Feb 23, 2015 at 6:52