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 Writer A former freelance contributor who has reviewed hundreds of email programs and services since 1997. our editorial process Heinz Tschabitscher Updated on July 21, 2020 reviewed by Ryan Perian Lifewire Tech Review Board Member 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. our review board Article reviewed on Nov 16, 2020 Ryan Perian Email Yahoo! Mail Gmail Tweet Share Email 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 lots of different 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. 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. Information in this article applies to Macs with macOS Catalina (10.15) through OS X Snow Leopard (10.6). 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, you can instead 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 have to first create the vCard file. Open the Contacts application from the Dock or the Applications folder. Pick 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. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Please try again. Thank you for signing up. Tell us why! Other Not enough details Hard to understand Submit