How to Convert VCF to Excel: 4 Free Ways

A .vcf file is fine for a phone and useless for everything else. You cannot sort it, filter it, de-duplicate it, or hand it to a CRM. Sooner or later you need the same contacts as a spreadsheet.

There are four working ways to do that, and they are genuinely different — not four wrappers around the same trick. This guide covers all of them, says plainly which one fits which situation, and explains the two problems that break most conversions regardless of the method you pick.

First: get the .vcf file off your phone

If you already have the file, skip ahead. If not, export it first.

iPhone. The Contacts app has no bulk export. Two options that work:

• Via iCloud (recommended): Sign in at icloud.com → Contacts → click the gear icon at the bottom left → Select All → gear again → Export vCard. You get one .vcf containing every contact.
• Via the Contacts app: Open a contact → Share Contact. This exports one card at a time, which is only practical for a handful.

Android. Contacts app → Settings (or the three-line menu) → Import/Export → Export to .vcf file. Samsung, Xiaomi and Huawei each word this slightly differently, but the option is always under Import/Export. Choose internal storage, then move the file to your computer.

A Gmail or Outlook account. If your contacts already sync to Google or Microsoft, you do not need a .vcf at all — jump to Method 2 or Method 3 and export directly to CSV.

Method 1: An online VCF to Excel converter (fastest)

Best when you want the spreadsheet in under a minute and the contact data is not something you want sitting on someone else's server.

1. Open the VCF to Excel converter.
2. Drop the .vcf file in.
3. Check the preview. Every contact is parsed into named columns — name, phone, email, organisation, address — before anything is downloaded.
4. Download the .xlsx.

The conversion runs in your browser. The file is never uploaded, which matters when the list is customer data rather than your own contacts. If you would rather have a plain text table, VCF to CSV produces the same columns in CSV form.

Limits: very large files (tens of thousands of contacts) are slower in the browser than a native tool. If yours is unwieldy, split it first with the VCF Splitter.

Method 2: Google Contacts (no software, works anywhere)

Best when you do not want to install anything and do not mind the contacts passing through a Google account. This is the method most video tutorials show.

1. Go to contacts.google.com.
2. Left menu → Import → Select file → choose your .vcf → Import.
3. The contacts now appear in your Google account. Select them (checkbox at the top selects all).
4. Left menu → Export → choose Google CSV → Export.
5. Open the downloaded CSV in Excel and save it as .xlsx.

Watch out: this genuinely adds every contact to your Google account. If you only wanted a spreadsheet, you now have to delete them again, and if that account syncs to a phone, they will land there too. Create a throwaway Google account if that is a problem.

Also note that Google CSV exports roughly 70 columns, most of them empty. You will be deleting columns.

Method 3: Microsoft Outlook (good for Windows users who already have it)

Best when Outlook is already installed and you are comfortable with its import wizard.

1. Outlook → File → Open & Export → Import/Export.
2. Choose Import a VCARD file (.vcf) → select your file.
3. Then go back to Import/Export → Export to a file → Comma Separated Values → pick the Contacts folder → save the CSV.
4. Open the CSV in Excel.

The catch that wastes everyone's afternoon: classic Outlook imports one contact per VCF file. If your .vcf holds 500 contacts, Outlook imports the first one and stops. There is no setting for this — it is how the importer is built.

Workarounds: use Method 1 or 2 instead, or split the multi-contact file into single-contact files first and import them in a batch. For anything above a handful of contacts, this method is the wrong tool.

Method 4: PowerShell (Windows, no upload, scriptable)

Best when you are on Windows, the file must not leave the machine, and you will do this more than once.

$vcf   = Get-Content "contacts.vcf" -Raw -Encoding UTF8
$cards = $vcf -split '(?=BEGIN:VCARD)' | Where-Object { $_ -match 'BEGIN:VCARD' }

$out = foreach ($card in $cards) {
    [PSCustomObject]@{
        Name  = ([regex]::Match($card, '(?m)^FN[^:]*:(.*)$').Groups[1].Value).Trim()
        Phone = ([regex]::Match($card, '(?m)^TEL[^:]*:(.*)$').Groups[1].Value).Trim()
        Email = ([regex]::Match($card, '(?m)^EMAIL[^:]*:(.*)$').Groups[1].Value).Trim()
    }
}

$out | Export-Csv "contacts.csv" -NoTypeInformation -Encoding UTF8

Open the resulting CSV in Excel.

Be honest about what this does not handle, because it will bite you on real exports:

• It takes only the first phone number and email per contact. Most real contacts have several.
• It does not unfold long lines. vCard wraps values longer than 75 characters onto continuation lines, and this script will truncate them.
• It does not decode Quoted-Printable name fields, so non-Latin names come out as =E5=BC=A0=E4=B8=89.

For a clean Latin-script address book it is fine. For a real multi-country contact list it will quietly lose data.

Which method should you use?

The two problems that break conversions

Garbled names

This is the single most common complaint, and it is not your fault. Contact exports from Huawei, Xiaomi and older Android builds encode name fields as Quoted-Printable, so the file contains:

N;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:=E5=BC=A0=E4=B8=89

Open that in Excel and you get the literal =E5=BC=A0=E4=B8=89 instead of the name. Methods 2, 3 and 4 all pass it straight through.

Method 1 decodes it automatically. If you have already produced a broken file, the VCF Encoding Fixer repairs the .vcf in place, after which any method will work.

Columns that don't line up

A vCard can carry several phone numbers, several emails, and typed fields (TEL;TYPE=CELL, TEL;TYPE=WORK). Converters differ in how they flatten that into a table: some keep only the first value, some join them with semicolons into one cell, some create Phone 1 / Phone 2 columns.

Before you rely on the output, check one contact you know has two phone numbers and confirm both survived. Doing that check takes ten seconds and saves you finding out after you have imported 3,000 rows into a CRM.

Going the other way

If what you actually need is the reverse — a spreadsheet of numbers turned into contacts you can import to a phone — that is the Excel to VCF converter, and the full workflow is covered in How to Import 10000+ Excel Contacts to iPhone/Android.

Frequently asked questions

Can you convert a VCF file to Excel? Yes. A .vcf file is plain text with a defined structure, so every field in it can be mapped to a spreadsheet column. The four methods above all do this; they differ in speed, in whether the file leaves your machine, and in how well they handle multiple values and non-Latin names.

How do I convert a .vcf file to CSV format? Any of the four methods produces CSV — Methods 2, 3 and 4 produce CSV natively, and Method 1 offers VCF to CSV directly. CSV is the better choice if the file is going into another system; .xlsx is better if a person is going to read it.

Can I export my phone contacts to Excel directly? Not in one step. Both iOS and Android export contacts as .vcf, never as a spreadsheet, so a conversion step is always required. The export instructions are at the top of this guide.

Is there an offline VCF to Excel converter? Method 4 is offline by definition. Method 1 is browser-based but performs the conversion locally — the file is not uploaded — so it also works for confidential data, though it does require the page to load once.

Why does Outlook only import one contact from my VCF file? Because classic Outlook's vCard importer handles one card per file. This is a known limitation with no setting to change it. Use Method 1, 2 or 4 for multi-contact files.