How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

Solution 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.