2

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

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. – Steve Moser Jun 25 '15 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? – awado Jun 27 '15 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. – Steve Moser Jun 27 '15 at 15:25
  • 1
    Sadly, this is true. As soon as you start using images, columns get shifted, even when there are no more images. – awado Jun 28 '15 at 12:47
0

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 – user115795 Feb 23 '15 at 3:35
  • Could you cite some reference as to why this might be the case? – Tetsujin Feb 23 '15 at 6:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .