How to Export Mac Contacts to CSV and Excel with 1 Click

Rosa Reyes
time June 10, 2021 Preview 36.2K
share it facebook share it Twitter

This article mainly talks about how to export Mac contacts to CSV or Excel easily. Mac contacts are stored in the Contacts app, previously known as Address Book. Mac’s Contacts app supports three export formats: vCard, PDF and ABBU (as an archive file).

But what if you need to export contacts from Mac Contacts to a comma-separated values file? There are two easy methods. And one of them enables you to do the export directly without having to converting contacts.

Method 1. How to Export Mac Contacts to CSV or Excel Directly With Ease

You can effortlessly export contacts from Mac’s Contacts app (and various other sources) to CSV with Cisdem ContactsMate, the best contact manager for Mac.

Advantages:

  1. It is easy to use and user-friendly
  2. Export Mac contacts to CSV or Excel Only with simple steps
  3. Support exporting all Mac contacts, or selective contacts to CSV or Excel
  4. Enable to define the contacts fields to be exported
  5. Export Mac contacts to CSV or Excel with good layouts
  6. Export Mac contacts to other formats like vCard, Html, Docx, Pages, Numbers

Disadvantages:

  1. Not applicable for the Windows system

Steps to export Mac contacts to CSV or Excel directly

  1. Download ContactsMate and install it.

Free Download

  1. When you open it for the first time, click OK to permit access to your contacts on Mac.click OK
  2. Right-click On My Mac in the left sidebar and choose Export.
    click export
  3. To export Mac contacts to CSV, select CSV from the Format drop-down list. To export Mac contacts to Excel Spredsheet, select Excel from the Format drop-down list.
    click csv or excel
  4. Select a location on your Mac to store the exported comma-separated values.
  5. Click Save.

Tips

  • The method allows you to control the fields to be exported. You can export Mac contacts with valid fields, all fields or custom fields. Things are easily customizable.custom fields
  • By following the 6 steps above, you can straightforwardly export all Mac contacts to CSV. If you only need to export selected contacts, choose On My Mac in the sidebar, select the specific contacts in it, control-click and choose Export.
    export selected contacts
  • The (Apple) Contacts app is also available for iOS. In addition, Apple provides a cloud-based contact management service known as iCloud Contacts. If you want to export contacts from these places, the same method can also help. Here are the instructions to export iCloud contacts to CSV and export iPhone contacts to CSV.

Method 2. How to Export Mac Contacts to CSV Through Conversion

With the first method, you can directly export Apple contacts to CSV from Mac (and iCloud and iPhone). This one is different. It involves conversion.

As mentioned above, Mac's Contacts app can export contacts to vCard. Also known as VCF, it's the primary export format of Apple contacts. You can export contacts to a vCard file first and then convert it to a comma-separated values file.

Advantages:

  1. The online converter is easy to access and use.
  2. No need to install a software.
  3. Export complete information of Mac contacts.

Disadvantages:

  1. The conversion may take quite a while if the vCard file is relatively large.

Steps to export Mac contacts to CSV through conversion

  1. Open the Contacts app on Mac.
  2. In the left sidebar, select All on My Mac (or a sub-group under it).
  3. From the top menu bar, choose File > Export > Export vCard.Export vCard
  4. Choose a location to keep the file you are going to export. Click Save.
  5. Open your web browser and visit vCard to LDIF/CSV Converter, an online tool.
  6. Click Choose File. Select the exported vCard file. Click Open.Choose File
  7. Click the Format dropdown list and choose CSV.
  8. Select the option Comma as CSV (comma-separated values) files are generally separated by commas.
  9. Make sure you select the box before Add header line.
  10. Click Convert. Once the process is done, the CSV file will be automatically saved to your computer.

Compared to the first method, this one is a little bit complex. The online tool used here is easy to access and use. But there are a few limits. You need to upload your Mac contacts to the tool’s server. Also, there is a file size limit. In addition, the conversion may take quite a while if the vCard file is relatively large.

Bonus tip: How to prepare a CSV containing contacts for use

One of the common reasons to export Mac contacts to CSV file is to use the contacts in services that don't support vCard. For example, Shutterfly is one of the services.

Before you can properly import your Mac contacts (now in a CSV) into Shutterfly address book, you need to get the CSV file ready for import. To help you out, Shutterfly provides a CSV template. There are two options. You can make sure that the column headers in your CSV match those in the template. Or, you can copy contact information from your CSV into the columns in the template. Below are the column headers in the template.

  • First Name
  • Last Name
  • Display/Household Name
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Postal Code
  • Country
  • Email

With other services, if such a template is not available, you can manually create one.

Benefit of exporting Mac contacts to CSV

vCard is a file format standard for storing contact information, but it's much less widely supported compared 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 format. CSV files can be used with many services and apps such as Microsoft Excel, NeoOffice, LibreOffice and Intuit Quicken, etc. If you want to use your Mac contacts in such an app or service, CSV is the format you need. Also, by doing so, you are able to batch edit your contacts in Excel, which is super efficient.

Conclusion

If you are looking for an easy, straightforward way to export Mac contacts to CSV file, I hope this article will help. To export Apple contacts to CSV, you can choose to do it directly with Cisdem ContactsMate or by converting using a converter. If you have many contacts to export, organize and manage, it’s a good idea to get a powerful contact manager as the one used in the first method.

avatar
Rosa Reyes
share it facebook share it Twitter

Rosa has worked in Mac software industry for more than eight years. She believes that the purpose of software is to make life better and work more productively. In addition to writing, Rosa is also an avid runner.

share it facebook share it Twitter
Comments (6) Leave a Reply

Name *

Comment *

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

    5 years ago Reply

    Name *

    Comment *

  • fiverr crorkservice

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

    6 years ago Reply

    Name *

    Comment *

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

    6 years ago Reply

    Name *

    Comment *

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

    6 years ago Reply

    Name *

    Comment *

  • Hugh Appelgren

    Im obliged for the blog article. Cool.

    6 years ago Reply

    Name *

    Comment *

  • Insurancewhisper.com

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

    6 years ago Reply

    Name *

    Comment *

Hot Articles

Password Protect Apps on Mac: Lock iMessage and Others 6 Best Visio Viewer for Mac in 2020 (Online & Offline) Top 8 Best Duplicate Photo Finder for Mac: Delete Duplicate Photos in Minutes
Home > How to Export Mac Contacts to CSV and Excel with 1 Click