Export Mac Mail Address Book Contacts to CSV File GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Email, Messaging, & Video Calls > Email

Export Mac Mail Address Book Contacts to CSV File

You aren't limited to the VCF file format

By Heinz Tschabitscher Heinz Tschabitscher Writer University of Vienna A former freelance contributor who has reviewed hundreds of email programs and services since 1997. lifewire's editorial guidelines Updated on May 20, 2021 Reviewed by Ryan Perian Reviewed by Ryan Perian Western Governors University Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12+ years' experience working in the IT industry support and management positions. lifewire's editorial guidelines Tweet Share Email Tweet Share Email Email Yahoo! Mail Gmail

What to Know

Download AB2CSV. Select Mode > CSV, then go to AB2CSV > Preferences > OK > CSV. Choose categories and select File > Export. Convert VCF to CSV: Open Contacts. Select a list to convert and choose Contacts > File > Export > Export vCard. Name and save the file. There are two ways to get your contacts into the CSV file format. You can either use a dedicated tool that exports a CSV file from the start, or you can export the contacts into the VCF format first and then convert the VCF file to CSV. We show you how to do both using any Mac with OS X Snow Leopard (10.6) or later.

Export Contacts Directly to CSV Format

Exporting information contained in the Contacts application requires a helper application. Some paid helper apps, such as AB2CSV and Address Book to CSV, are available in the Mac App Store. Others are available from third-party vendors. This example uses the application AB2CSV, which saves your contacts to a CSV file without having to create a VCF file first. Download AB2CSV from the Mac App Store—the price is $0.99—and launch it. Select Mode in the AB2CSV menu bar and click CSV in the drop-down menu. To configure which fields to export, go to AB2CSV in the menu bar and select Preferences in the drop-down menu. Click OK in the pop-up window that asks you to grant the app access to your contacts. Select the CSV tab. Select the fields you want to export by checking the boxes in front of the categories. Click File on the menu bar followed by Export. Pick a location for the CSV file. It will have a .csv extension.

Convert the VCF File to CSV

If you'd rather not install an application or pay for an app to make a CSV file, export the Contacts application's VCF file and then use an online utility to format the VCF file as a CSV file. To do that, you first have to create the vCard file. Open the Contacts application from the Dock or the Applications folder. Choose the list in the left pane that you want to export, such as All Contacts. From the Contacts menu bar, select the File > Export > Export vCard. Name the exported list of contacts and choose a location for the file. Click Save. Now that the contacts are in the VCF format, use an online VCF to CSV converter such as ACConvert to make the CSV file. Upload your VCF file to the website and select CSV as the output format. Click the Convert Now button when you're done to make the CSV file.

Why Export Contacts to CSV

By default, the Contacts or Address Book program on a Mac exports entries to the vCard file format with a VCF file extension. However, CSV is a more common format that works with many email clients, so having an Apple Contacts list in CSV format makes it easier to import it into other email clients or view them in a spreadsheet program like Microsoft Excel. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Export Contacts From iPhone How to Use macOS Contacts With Outlook CSV File (What It Is & How to Open One) How to Export Contacts in Mozilla Thunderbird How to Import Outlook Contacts Into Apple Mail How to Import Addresses Into Gmail From Other Email Services What Is a VFC File? How to Export Your AOL Mail Contacts How to Restore or Import a Mac OS X Mail Address Book How to Create a vCard in Microsoft Outlook How to Export Your Yahoo Mail Address Book How to Export Your Gmail Contacts How to Export Emails From Outlook How to Back Up Your iCloud Contacts and Calendar Data How to Export Your Outlook Contacts to a CSV File How to Export Contacts and Email Addresses From Hotmail Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies