How to convert Excel or CSV to VCF
- Choose your contact list: Excel, CSV, or a Google Sheet downloaded as either.
- Check what each column holds. Most are matched by their names; change any that are wrong.
- Look over the first contacts as they'll appear on the phone.
- Download the .vcf file and import it on your phone or contacts account.
How to import contacts from Excel to iPhone or Android
iPhone: send the file to yourself by email or message, then tap the .vcf attachment, as in Apple's Import contacts on iPhone.
iCloud.com (on a computer): in Contacts, select the add button, choose Import Contact, and pick the file. Apple says that when a vCard holds more than one person, each contact becomes a separate entry, and they sync to your iPhone.
Android with the Google Contacts app: tap Organize (shown as Fix & manage in some versions), then Import from file, pick the account, and choose the .vcf (Google's steps).
Google Contacts on the web: click Import, then Select file, choose the .vcf and click Import (Google's steps). Google notes that importing more than 3,000 contacts at a time can cause problems, so split bigger lists; the tool offers files of 3,000 when a list is that long.
Getting the spreadsheet ready
- Put one contact on each row, with column names in the first row.
- Names can be in First Name and Last Name columns, or in one Name column. A single name is split at the last space, and “Lopez, Carla” style names at the comma.
- Give phone columns a clear name (Mobile, Work Phone, Home Phone, Fax) and the number is saved with that label on the phone. A plain “Phone” column becomes an other number.
- A Google Contacts CSV works as it is: its paired “Phone 1 - Label” and “Phone 1 - Value” columns are read together, and several numbers in one cell are split apart.
- Rows with no name, company, phone or email are skipped and counted, so blank rows don't become empty contacts.
ZIP codes that lost their leading zero in Excel, such as 5401 for 05401, get it back. To combine lists first, use merge Excel files, and to drop repeats, remove duplicates.
A worked example
The sample customer list has four rows: three people and a business with no contact name. The first row, Ben Hartley with a mobile number, a work number, an email, an address and a note, becomes this card in the .vcf file:
BEGIN:VCARD
VERSION:3.0
N:Hartley;Ben;;;
FN:Ben Hartley
ORG:Hartley Hardware
TEL;TYPE=CELL:(614) 555-0171
TEL;TYPE=WORK,VOICE:(614) 555-0199
EMAIL;TYPE=INTERNET:ben@example.com
ADR:;;61 Spring St;Columbus;OH;43215;
NOTE:Orders paint monthly
END:VCARDThe mobile number is saved as a cell number and the work number as a work number. The business row is named after the company, so it shows up as Lakeside Dental on the phone. Open Try a sample list to see it.
Outlook and other apps
Microsoft's instructions for the new Outlook and Outlook.com import contacts from a CSV file saved as UTF-8, so for Outlook you may not need a .vcf at all: import the CSV directly. To go the other way, from a phone's .vcf export to a spreadsheet, use the VCF to CSV converter.
Why the file stays on your computer
A customer or member list holds other people's phone numbers and addresses. This converter reads it in your browser and writes the .vcf there, so the list never leaves your computer and nothing is kept after you close the tab. The how we test page explains how to check.