How to Export Apple Contacts to Excel on Mac

Apple’s Contacts app is great for storing contact info, but it has one glaring omission: there’s no way to export directly to a spreadsheet. You can export to vCard (.vcf) format and… that’s it.

If you need your contacts in Excel for mail merges, CRM imports, mailing lists, or just a backup you can actually read, here’s how to get there.

The Problem

Apple Contacts exports only to vCard (.vcf) format. This is an industry standard for contact exchange, but it’s not a spreadsheet. You can’t open it in Excel, sort by company, filter by city, or do any of the things you’d want a contact list for.

vCards are structured text files that look something like this:

BEGIN:VCARD
VERSION:3.0
FN:John Smith
EMAIL:[email protected]
TEL:+1-555-0123
END:VCARD

Useful for syncing between phone apps. Useless for data analysis.

Method 1: Using a Mac App (Recommended)

Contacts Exporter reads your Apple Contacts database directly and exports to Excel, CSV, or Numbers:

1. Open the app - it automatically reads your Apple Contacts
2. Choose which fields to include (name, email, phone, address, company, birthday, notes, etc.)
3. Select output format - Excel (.xlsx), CSV, or Numbers
4. Export - done

The app pulls data straight from the Contacts framework, so it handles groups, multiple phone numbers per contact, and all the edge cases that make manual conversion messy.

Method 2: Export vCard + Convert (Free)

If you prefer not to install an app:

Step 1: Export from Apple Contacts

1. Open Contacts app
2. Select the contacts you want (Cmd+A for all)
3. Go to File > Export > Export vCard
4. Save the .vcf file

Step 2: Convert vCard to CSV

You can use a free online converter like vCard to CSV Converter or do it with a Python script:

import re, csv

with open('contacts.vcf', 'r') as f:
    data = f.read()

contacts = data.split('BEGIN:VCARD')
with open('contacts.csv', 'w', newline='') as out:
    writer = csv.writer(out)
    writer.writerow(['Name', 'Email', 'Phone'])
    for card in contacts:
        if not card.strip():
            continue
        name = re.search(r'FN:(.*)', card)
        email = re.search(r'EMAIL[^:]*:(.*)', card)
        phone = re.search(r'TEL[^:]*:(.*)', card)
        writer.writerow([
            name.group(1).strip() if name else '',
            email.group(1).strip() if email else '',
            phone.group(1).strip() if phone else '',
        ])

This basic script handles simple vCards but struggles with:

• Multiple emails/phones per contact (only grabs the first)
• Encoded characters (non-ASCII names)
• Multi-line values (addresses that span several lines)
• Quoted-printable encoding (special characters in names)

Method 3: iCloud.com Export

If your contacts sync to iCloud:

1. Go to icloud.com/contacts
2. Select all (Cmd+A)
3. Click the gear icon > Export vCard
4. Convert the downloaded .vcf file using Method 2

Same limitation: you get a vCard, not a spreadsheet.

Common Use Cases

Mail merge (Word/Pages): Export to CSV, then use as a data source in your word processor’s mail merge feature. Make sure to include name, address, and any personalization fields.

CRM import (Salesforce, HubSpot): Most CRMs accept CSV imports with mapped fields. Export with all available fields, then map columns during import.

Mailing list backup: Export periodically to have an offline copy of your contact list. Store the CSV alongside the vCard export for redundancy.

Event planning: Export attendee contacts to a spreadsheet for seating charts, RSVP tracking, or name badges.

Moving to Android: Export to CSV, then import into Google Contacts via contacts.google.com > Import.

Tips

Export regularly. If you rely on iCloud for contacts, keep a local CSV backup. Cloud services can lose data in sync conflicts.

Check field mapping. Before importing a CSV into another system, open it in Excel first and verify the columns are correct. Phone number formatting varies between countries and apps.

Watch for duplicates. If you export from both Apple Contacts and iCloud separately, you’ll likely get duplicates. Deduplicate in Excel using the Remove Duplicates feature (Data > Remove Duplicates).

Group exports. If you only need contacts from a specific group (Work, Family, etc.), select that group first in Apple Contacts before exporting. This avoids having to filter a massive spreadsheet later.