How to open a VCF contacts file in Excel

You exported your contacts and got a .vcf file. Now you want them in a spreadsheet: to clean up duplicates, send a list to a colleague, print a phone list, or import them into another tool. Excel looks like the obvious choice, but it does not understand VCF files. This guide shows the fastest way around that, explains what you get, and covers the problems people run into most.

What is a VCF file, and why won’t Excel open it?

A VCF file is a contacts file in the vCard format. Phones, email apps and address books use it to export and share contacts. One file can hold one contact or thousands.

A vCard stores each contact as a block of text lines. Each line holds one detail:

BEGIN:VCARD
VERSION:3.0
N:Rivera;Sam;;;
FN:Sam Rivera
TEL;TYPE=CELL:+1 555 0100
EMAIL;TYPE=HOME:sam@example.com
END:VCARD

A spreadsheet needs the opposite shape: one contact per row and one detail per column. Excel has no vCard import. If you open a VCF file in Excel anyway, it is treated as plain text: every line lands in its own row, so each contact is spread over many rows.

So the file has to be converted first. Here is how the formats compare:

	VCF (vCard)	CSV	Excel (.xlsx)
Shape	One block of lines per contact	One row per contact, comma-separated	One row per contact, in a real worksheet
Opens in Excel	No	Yes	Yes
Several phone numbers per contact	Yes, with labels	Yes, as numbered columns	Yes, as numbered columns
Contact photos	Yes, stored inside the file	No	No
Keeps + and leading zeros reliably	Yes	Not always (Excel may reformat them)	Yes, when cells are stored as text
Best for	Moving contacts between phones and apps	Importing into other apps and CRMs	Reading and editing in Excel

For a deeper look at the format itself, see What is a VCF file?

How do I convert a VCF file to Excel?

The quickest route is the free VCF to CSV Converter. It runs in your browser, so your contacts stay on your device. It takes about a minute.

1. 1

   Open the converter

   Open the free VCF to CSV Converter on ToolkitHere in any modern browser, on a phone or a computer.

2. 2

   Add your VCF file

   Drop your .vcf file onto the upload box, or tap Choose files. You can add several files at once, and they are combined into one table.

3. 3

   Check the preview

   Scroll through the preview table. Every contact is one row, and every detail (name, phone, email, address) has its own column.

4. 4

   Pick your columns

   Open Choose columns and keep only the details you need. Recommended picks the most useful columns, and Clear starts from nothing.

5. 5

   Download and open in Excel

   Tap Download Excel to get an .xlsx file, or Download CSV for other apps. Open the downloaded file in Excel.

A few details that help:

• Several files become one table. If your contacts are split across many .vcf files (some phones export one file per contact), add them all at once. You can also add more later with Add files.
• The file name is kept. If you convert one file called contacts-2026.vcf, the download is called contacts-2026.xlsx. Several files download as contacts.xlsx.
• The preview handles big files. Tens of thousands of contacts scroll smoothly, because only the rows on screen are drawn.

Should I download Excel (.xlsx) or CSV?

Both downloads contain the same contacts and the same columns. The difference is how other apps read them.

If you want to…	Choose	Why
Open and edit the list in Excel	Excel (.xlsx)	Every value is stored as text, so phone numbers keep their + and leading zeros
Import contacts into a CRM, newsletter tool or another app	CSV	Almost every app accepts CSV
Open the list in Google Sheets or Numbers	Either	Both formats open; Excel format avoids number reformatting
Keep a simple backup you can read anywhere	CSV	It is plain text and opens in any editor

The converter writes CSV files as UTF-8 with a byte-order mark. That small marker tells Excel the file uses UTF-8, so names like José, Zoë or 王小明 display correctly instead of as garbled symbols.

The Excel file has a few extra comforts. The header row is bold and stays visible while you scroll. Column widths are set roughly to fit the content. The worksheet is named Contacts.

What will my contacts look like in Excel?

You get one row per contact and one column per detail. When people have several phone numbers, emails or addresses, the converter adds numbered columns, each with a label column next to it:

Name	Phone 1	Phone 1 label	Phone 2	Phone 2 label	Email 1
Sam Rivera	+1 555 0100	Mobile	(555) 010-0199	Work	sam@example.com
Chidi Okafor	+234 1 555 0102	Home fax			chidi@example.net

The full list of available columns:

• Name: full name, first name, middle name, last name, prefix, suffix and nickname
• Phones and emails: up to 10 of each per contact, each with its label (Mobile, Home, Work and so on)
• Addresses: as one line, or split into street, city, state or region, postal code and country
• Work: company, department, job title and role
• Other: birthday, anniversary, websites, notes and groups

Open Choose columns to keep only what you need. The preview and both downloads follow your choice. Notes keep their line breaks in the download.

Contact photos are left out, because a spreadsheet cell cannot hold an image. The converter tells you how many photos it skipped.

How do I get a VCF file from my phone or email account?

If you don’t have the file yet, export it from wherever your contacts live. Menu names can change between app versions.

1. iPhone: open the Contacts app, tap Lists, touch and hold a list such as All Contacts, and tap Export. Pick the details to include, tap Done, then save the file to Files.
2. iCloud on a computer: sign in at icloud.com/contacts, choose Actions, then Select All Contacts, then the Share button and Export vCard.
3. Android: in the Google Contacts app, tap Fix & manage, then Export to file, pick the accounts, and tap Export to .VCF file. Other contacts apps, such as Samsung’s, have a similar export option under different names.
4. Google Contacts on a computer: open contacts.google.com, select the contacts, open More actions, choose Export, and pick the vCard format.
5. Outlook: Outlook exports contacts only as CSV, which is already a spreadsheet. Open it in Excel directly.

The converter page keeps these steps up to date for each source.

How do I open a CSV in Excel without breaking phone numbers?

If you picked CSV and Excel mangles your numbers, it is because Excel guesses each column’s type when it opens a CSV. It can drop leading zeros, show long numbers in scientific notation such as 4.47E+11, and treat a value that starts with + as a number, dropping the +.

The simplest fix is to download the Excel version instead. If you need to stay with CSV, import it and set the phone columns to text:

1. Open a blank workbook in Excel for Windows.
2. Go to Data, then From Text/CSV, and pick your file.
3. In the preview window, choose Transform Data.
4. Select the phone columns. On the Home tab, set Data Type to Text, and choose Replace current if asked.
5. Choose Close & Load to put the data in the sheet.

Phone numbers then stay exactly as they appear in the CSV.

Can I open a VCF file in Excel without converting it?

Technically yes, but it is slow and error-prone. You would open the VCF in a text editor, paste it into Excel, and then build formulas or use Power Query to turn each block of lines into one row. That breaks easily on real files, because vCards come in three versions (2.1, 3.0 and 4.0), fold long lines across several lines, and often encode accented names in “quoted-printable” form such as J=C3=B6rg.

The converter handles all of that for you. It reads vCard 2.1, 3.0 and 4.0, unfolds long lines, decodes quoted-printable text, and repairs common garbled characters from older phones.

Can I use Google Sheets or Numbers instead of Excel?

Yes. Neither app opens VCF files directly either, so convert first.

• Google Sheets: create a sheet, then use File, Import, Upload and choose the CSV or Excel file. For a CSV, untick Convert text to numbers, dates, and formulas so phone numbers keep their + and leading zeros.
• Numbers on a Mac: open the CSV or Excel file directly from Finder.

What if something goes wrong?

Problem	Likely cause	Fix
“This doesn’t look like a contacts file”	The file isn’t a vCard, or it’s a CSV already	Check the file ends in .vcf. A .csv file already opens in Excel
“This is a zip file”	The export was zipped	Unzip it first, then add the .vcf file inside
Names show as é, =C3=A9 or question marks	Text encoding problems from an older phone	The converter repairs most cases and says how many it fixed. If some remain, export the file again
Phone numbers look like 4.47E+11 in Excel	Excel reformatted a CSV	Download the Excel version, or import the CSV with phone columns set to Text
Only some contacts appear	Contacts are spread across several files	Add every .vcf file at once; they are combined into one table
Nothing happens when choosing a file on iPhone	The file is stored in iCloud Drive and hasn’t downloaded yet	Open it once in the Files app so it downloads, then try again

Is it safe to convert my contacts online?

It depends on the tool. Some online converters upload your file to their server, which means a stranger’s computer holds your address book, at least for a while. Others work in the browser. Check the site’s privacy page before you add a file.

ToolkitHere works differently. Nothing is uploaded. Your browser reads the file and builds the spreadsheet on your device. The part of the page that reads your file is blocked from making any network request. You can check this yourself: open the tool, add one file, switch on airplane mode, and add another. It still works, because nothing needs the internet. How it works explains the details.

Key takeaways

• Excel can’t open VCF files, so convert the VCF to Excel (.xlsx) or CSV first.
• Choose Excel to keep phone numbers exactly as they are; choose CSV to import into other apps.
• You get one row per contact, with numbered columns for extra phones, emails and addresses.
• Photos are left out; everything else can be kept.
• The VCF to CSV Converter is free, needs no sign-up, and runs in your browser, so your contacts stay on your device.