How to convert VCF to CSV or Excel
- Export your contacts as a .vcf file (steps for each phone below).
- Choose the file, or drop it on the box above. Several .vcf files can go in together.
- Check the preview: one row per contact, a column for each phone type, email and address part.
- 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
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Full Name | Company | Mobile Phone | Business Phone | E-mail Address |
| 2 | Maria Delgado | Delgado Landscaping | (919) 555-0123 | (919) 555-0124 | maria@example.com |
| 3 | José Peña | +1 512-555-0142 | jose.pena@example.com | ||
| 4 | Dr. Grace A. Okafor | Northside Family Clinic | (614) 555-0187 | billing@example.com | |
| 5 | Hartley Hardware | Hartley Hardware |
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.