How to Export Mac Contacts to CSV and Excel (macOS Mojave Included)

We often want to export Mac Contacts to CSV or Excel for easier contacts management or backup. Then what would be the best way to export address book data to CSV or Excel? As we know, Mac Contacts app itself doesn't support exporting contacts to CSV, It supports vCard though. However, common spreadsheets or databases can't deal with vCard. As a result, you are unable to get your contacts into Excel, Numbers or SQLite for further editing or processing. In this guide, you will find the best way to export your Mac contacts to CSV, along with step-by-step instructions.

Check out the Video Guide

How to Export Mac Contacts to CSV and Excel with The Professional Tool

Cisdem ContactsMate, is awarded as the best Apple Contacts Alternative, as well as one of the best contacts address book to manage contacts. This app supports OS X 10.11 El Capitan, macOS 10.12 Sierra and macOS 10.13 High Sierra, macOS 10.14 Mojave. Cisdem ContactsMate can be used to

• Keep all contacts up-to-date and organized. You can create and edit contacts with much of labels and notes( Phone, Address, Department, URL, Note, Company, Suffix, Job Title, Email, Birthday, etc.).
• Create contact group to easily and quickly send mails or messages.
• Scan, report and fix those duplicate contacts, errors, incomplete information.
• Sync with iCloud and any other service OS X Contacts supports (e.g. Google Contacts), as It utilizes the Mac OS X built-in contact database. And what anything entered into ContactsMate will also sync in Apple Contacts. 
• Export Mac contacts to CSV, vCard, TXT, DOCX, HTML, Excel, Numbers, and Pages formats for further usage.

Cisdem ContactsMate is a wonderful contact manager software. It offers free trial version to every Mac user for performance test. Now follow the steps below on how to export Mac contacts to CSV and Excel.

Download this contacts manager software's free version on Mac

Step 1. Sync with Mac Contacts

While you run Cisdem ContactMate for the first time, it will ask you whether allowing it to sync with your contacts or not, you just need to click "OK", then a interconnection will be built between Cisdem ContactManager and your Address Book.

Meanwhile, you can 

 

Step 2. Export Mac Contacts to CSV or Excel

1. Click the button "Export", it would lead you to an output window. Choose to "Save to CSV" or "Save to Excel" from pull-down menu which includes lots of output formats for choice, like vCard, TXT, DOCX, HTML, Excel, Numbers, and Pages.

2. Create a new folder to save this CSV/Excel. Name prefix name for this file.

3. Click "Save" button, your contacts are exported to CSV or Excel right away on your Mac.

Actually, Cisdem ContactsMate is far more powerful than you can imagine. With this application, there will be no more duplicates, missing address or syncing problem in your contacts. More details, you can read the related article “How to Clean Contacts on Mac”.

 

How to Export Mac Contacts to CSV and Excel with Free Tool

There is another way to export Mac contacts to CSV, which is, however, a bit complicated though. If you have no claims for high performance, or you only use it less than a few times. This way might be adoptable.

Step 1, Export the contacts to vCard.

Open your Contacts (Application > Contacts). Select the contacts you want to export and click File > Export > Export vCard. Then contacts will be exported as vCard file and saved automatically on your Mac.

Step 2, Convert vCard to CSV

Use a third-party tool to convert vCard to CSV.  Here I used an online vCard to LDIF/CSV Converter. Click “Choose File” to upload the vCard file and choose the output format as CSV, then click “Convert” button. After the conversion is done, You'll find the converted file in the "Downloads" folder on your Mac. You can open the file with Excel for further usage.
*Please notice this online tool has a strict volume limit of no more than 8 MB.

I found It’s not so easy to find a free and easy-to-use vCard to CSV converter. There are too many limitations for the free one. If you have many contacts need to manage or you are a business man with expectation of managing the contacts well and efficiently. I recommend you make a try of the Cisdem ContactsMate. Comparing with the convenience and efficiency it can bring to you, the cost is nothing at all. And you can make a trial of free version to verify if it is deserving or not.

Benefit of Exporting Mac Contacts to CSV

CSVs look like a garden-variety spreadsheet but with a .csv extension (Traditionally they take the form of a text file containing information separated by commas, hence the name). CSV files can be used with any spreadsheet program, such as Microsoft Excel, Open Office Calc, or Google Spreadsheets. What is the advantage when we export our Mac/Apple contacts to CSV?

CSV as a general and relatively simple file format is widely used in business and science field because that large number of programs all support CSV variant. It has been a widely-used text file formats. After exporting your contacts in this format, you can easily import them into lots of other programs or services. For example, by doing so, you are able to batch edit your contacts in Excel, which is super effective.