How to Export Contacts to CSV on MacOS

I spent some time trying to figure out how to export contacts to comma separated values (CSV) on my Mac. This was in preparation for sending out Christmas cards.

On the Export menu, it only mentions you can export to vCard, PDF, or to an Archive file. I looked around for a programmatic way to do it, and found some possibilities, but everything seemed too complicated.

After some experimentation, I figured it out. All you have to do is:

  1. Select a bunch of contacts in the left column. (Hold shift while clicking to select multiple contacts.)
  2. Copy them to the clipboard
  3. Paste into new Numbers spreadsheet
  4. File > Export to CSV

Easy!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s