Cisdem Learning Resource Center

How to Export Apple Contacts to CSV and Excel on macOS Sierra?

It is a pity that Apple Contacts doesn't support to export contacts to CSV, except for vCard. Common spreadsheets or databases can't handle vCard, therefore you are unable to get your contacts into Excel, Numbers or SQLite for further editing or process. Export Apple contacts to CSV will make contacts easier to back up or sync.

One compromised solution If you would like to have a try, you can drag-n-drop contacts from Apple Contacts to the desktop, it produces a vCard file, use the third-party converter tool to convert vCard to CSV (some online converter like vCard to CSV Converter, but they can offer the best conversion.), then you can open that file with Excel for further usage.

I think there must be more users who are confused about how to export Apple contacts to CSV. Don't worry, this article will recommend an effective application with step-by-step guidance.

The Best Apple Contacts Alternative: Cisdem ContactsMate

I want to recommend an professional application to resolve what Apple Contacts can't do, that's Cisdem ContactsMate. It is one of the best contacts address book to manage contacts. Let me list briefly what Cisdem ContactsMate can help you as below.

1. 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. & many sub categories to get all the details of your Contacts.)

2. Make group contacts for you easily sending mail or check.

3. Scan, report, fix those duplicate contacts, errors, incomplete information, which would be reported and displayed for you to fix , and get them correct instantly.

4. What anything entered into ContactsMate will also sync in Apple Contacts. It utilizes the Mac OS X built-in contact database, this means you can still sync with iCloud and any other service OS X Contacts supports (e.g. Google Contacts).

5. Export Apple Contacts to CSV, vCard, TXT, Docx, HTML, Excel, Numbers, and Pages formats for further usage.

How to Export Apple Contacts to CSV and Excel on Mac?

Cisdem ContactsMate is priced at $19.99. It offers free trial version for every Mac user to test its features. Now follow the steps below on how to export Apple contacts to CSV and Excel.

Download this contacts manager software's free version on Mac

Step 1. Sync with Apple Contacts

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

By the way, you can create more new contacts, or edit contacts to add more contacts labels an dproperties as you like,like Middle Name, Job Title, NickName, Address, etc.

Step 2. Export Apple Contacts to CSV

1. Click the button "Export", it would lead you to an output window, see the "Export Format", choose to "Save to CSV" or "Save to Excel" from pull-down menu which includes lots of output formats, like vCard, TXT, Docx, HTML, Excel, Numbers, and Pages.
2. Create a new folder to save this CSV/Excel. Make prefix name for this file.
3. Click "Save" button, your contacts are exported to CSV or Excel right away on your Mac.

You can also export a contacts group to CSV file. As to how to make group contacts, please refer to this useful article - How to Make a Contact Group 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”.

More Information about CSV File

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.

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.

/ Posted by to Contact Manager Mac Follow @ Rosa

Related Cisdem Recommendations

Mac App Blocker

Securely lock apps like Facebook, Twitter, games, Reddit, etc. and block distracting websites on Mac Learn More

Window Manager

Quickly and efficiently divide your Mac screen into various sizes and positions. Learn More

More Related Articles You May Like

  • How to Sync Contacts to Gmail for Backup

    Many users don’t know how to sync contacts to Gmail for backup. This article will show you how to sync your Mac, Android phone , iPad and iPhone contacts to Gmail.

  • How to Add Contacts to Gmail

    Many Gmail users are looking for answers online about how to add contacts to Gmail. In fact, adding contacts to Gmail is the same as adding contacts to Google Contacts. How to add contacts to Gmail? This guide will show you 5 ways to add contacts to Gmail or Google Contacts.

  • How to Import Contacts into Outlook?

    We can store our contacts through many channels, like iPhone, mac and some media applications. With my situation, I prefer to manage all of my contacts at one place, it will be very easy to call, message or email someone. In order to make email be convenient, this article will introduce how to import contacts into outlook.

6 Responses

  • crork fiverr

    jRExv7 Thank you for every other great post. Where else may anyone get that type of information in such a perfect method of writing? I ave a presentation next week, and I am at the look for such information.

    1 years ago REPLY
  • fiverr crorkservice

    FXUwh6 Just Browsing While I was surfing today I noticed a great article concerning

    1 years ago REPLY
  • Handynummer Orten

    If you want tab-separated, instead of File Export to CSV from Numbers, simply select the cells with the data, command-c to copy, and in an open document in a text editor, command-v to paste. Then save with the desired file suffix.

    1 years ago REPLY
  • Dyson

    If you want tab-separated, instead of File Export to CSV from Numbers, simply select the cells with the data, command-c to copy, and in an open document in a text editor, command-v to paste. Then save with the desired file suffix.

    1 years ago REPLY
  • Hugh Appelgren

    Im obliged for the blog article. Cool.

    1 years ago REPLY
  • Insurancewhisper.com

    This is one awesome article post.Really looking forward to read more. Awesome.

    1 years ago REPLY

Leave a Reply

Top Utility Articles

Get Inspired!

Sign up for Cisdem newsletters, stay informed on the latest products news, the hottest deals, and our holiday special sales.