Skip to content

VCF to CSV and Excel converter

Convert a VCF (vCard) contacts file from iPhone, Android, iCloud or Google Contacts to Excel or CSV: one row per contact, with a column for every phone number, email and address. Download Excel or CSV. Your contacts are read in your browser and never uploaded.

Contacts converter

Not uploaded.

Drop your contacts file (.vcf)

A .vcf file exported from iPhone, Android, Google Contacts or Outlook. It becomes an Excel or CSV file. Or open a spreadsheet to go the other way.

How to convert VCF to CSV or Excel

  1. Export your contacts as a .vcf file (steps for each phone below).
  2. Choose the file, or drop it on the box above. Several .vcf files can go in together.
  3. Check the preview: one row per contact, a column for each phone type, email and address part.
  4. Download Excel, or CSV for Google Sheets, Outlook or a mailing tool.

Export iPhone, iCloud and Android contacts to Excel

iPhone: to export iPhone contacts to Excel, first save them as a .vcf file. In the Contacts app, tap Lists, touch and hold a list (such as All Contacts), tap Export, choose the fields to include, then tap Done and save or send the file. Apple describes this in Export contacts on iPhone.

iCloud.com (on a computer), to export all your iCloud contacts at once: open Contacts, choose Select All Contacts from the actions menu, then Share and Export vCard. Apple says that when several contacts are selected, they're exported as a single vCard containing all of them.

Android with the Google Contacts app: tap Fix & manage, then Export to file, choose the accounts, and tap Export to .VCF file (Google's steps).

Google Contacts on the web: select the contacts, then More actions and Export. Google offers CSV or vCard (Google's steps); if you already have the CSV, you may not need to convert at all.

VCF to Excel: what the spreadsheet looks like

Each contact is one row. Names are split into Full Name, First Name, Last Name and so on; each kind of phone number gets its own column (Mobile Phone, Business Phone, Home Phone, Business Fax), and so does each email and each part of an address (street, city, state, postal code). A contact with two mobile numbers gets a second Mobile Phone column. Columns nobody in the file filled in are left out.

The column names follow the ones Outlook uses, such as E-mail Address and Business Street, so the CSV is easy to match up when you import it somewhere else.

A worked example

The sample file has four contacts from different sources: an iPhone card with a custom “Mobile” label, an older Android card with accented letters, a clinic contact with a fax and two emails, and a business with only a main number:

sample contacts contacts.xlsx

RowABCDE
1Full NameCompanyMobile PhoneBusiness PhoneE-mail Address
2Maria DelgadoDelgado Landscaping(919) 555-0123(919) 555-0124maria@example.com
3José Peña+1 512-555-0142jose.pena@example.com
4Dr. Grace A. OkaforNorthside Family Clinic(614) 555-0187billing@example.com
5Hartley HardwareHartley Hardware
Part of the result. Each phone type lands in its own column, and the accents survive.

Open Try a sample .vcf to see all of it, including the addresses, birthday and notes.

Older phones, accents and long notes

Older Android phones save contacts in vCard 2.1, where names with accents are written in an encoded form such as “Jos=C3=A9”. The converter decodes them, so the spreadsheet shows José. It also joins long notes that the file split across lines, reads the custom labels iPhone and iCloud use, and saves the CSV as UTF-8 so Excel shows accented names correctly.

Using the list

With the contacts in a spreadsheet you can print them on address labels, remove duplicate contacts, or merge lists from several phones. To go the other way, from a spreadsheet to a file your phone can import, use the CSV to VCF converter.

Why the file stays on your computer

An address book holds other people's phone numbers, emails and home addresses. Many online converters upload the file to their server to convert it. This one reads it in your browser and builds the spreadsheet there, so the contacts never leave your computer. You can check that with your browser's Network tab; the how we test page explains how.

Questions

How do I open a VCF file in Excel?

Excel doesn't read a vCard file as a table, so the contacts come out as lines of code. Open the .vcf here instead and download the Excel file: one row per contact, with columns for name, company, each phone type, email and address.

How do I export iPhone contacts to Excel?

Export them from the Contacts app as a contact card file (open Lists, touch and hold a list, then tap Export), or export your iCloud contacts on iCloud.com with Export vCard. Save the .vcf file, open it here and download Excel or CSV.

Is this VCF to CSV converter free?

Yes. It's free to use online with no sign-up and no limit on the number of contacts, unlike trial converters that stop at 25 or 50.

Does it work on a Mac?

Yes. It runs in Safari, Chrome or Firefox on a Mac, a Windows PC or a Chromebook, so there's nothing to install. Choose the .vcf file and download the spreadsheet.

Can I convert several VCF files at once?

Yes. Choose them together and their contacts are combined into one list. Some phones save one file per contact, so this turns a folder of single cards into one spreadsheet.

Are contact photos included?

No. A spreadsheet can't hold photos, so they're left out and the tool tells you how many contacts had one. Every other field on the card is kept.

Is there a limit on how many contacts it can convert?

There's no set limit. The file is read in your browser, so the practical limit is your computer's memory; files up to 200 MB are accepted, which is far more than a phone's address book.

Are my contacts uploaded anywhere?

No. Your browser reads the file on your own computer and builds the spreadsheet there. Nothing is sent to a server, and nothing is kept after you close the tab.

Last updated by Muhammad Yahya. How the tools are tested.