How to Export and Convert vCard Contacts to Excel


vCard (.vcf) is the universal format for sharing contacts. This guide shows how to export contacts from popular apps and convert them into a spreadsheet.


Why convert contacts to a spreadsheet?


Spreadsheets let you sort, filter, deduplicate, and bulk-edit contacts. This is useful for CRM imports, mailing list preparation, contact cleanup, and migration between platforms.


Exporting from Google Contacts


  • Go to contacts.google.com.
  • Select the contacts you want to export, or choose "All contacts."
  • Click the gear icon or "Export" in the left sidebar.
  • Choose "vCard (for iOS Contacts)" and click Export.
  • A .vcf file will download to your computer.

    • Exporting from Apple Contacts (macOS)


  • Open the Contacts app.
  • Select the contacts you want. Use Cmd+A to select all.
  • Go to File > Export > Export vCard.
  • Save the .vcf file.

    • Exporting from Outlook


  • Open the People section in Outlook.
  • Select the contacts to export.
  • Use the export function and choose vCard format.

    • Understanding vCard fields


    The converter extracts these fields: Full Name, First Name, Last Name, Organization, Title, Email, Phone, Address, URL, and Note. If a contact has multiple phones or emails, they are joined with semicolons in a single cell.


    Tips


  • After converting, use Excel's "Remove Duplicates" feature to clean up your list.
  • Sort by Organization to group colleagues together.
  • Use "Text to Columns" if you need to split combined phone numbers into separate columns.
    • Back to vCard / VCF converter