Skip to content

CSV and Excel to VCF converter

Convert Excel to VCF: turn a contact list in Excel, CSV or Google Sheets into a .vcf file (vCard) you can import on an iPhone, an Android phone, iCloud or Google Contacts. Columns are matched by name and you can change any of them. The list is read in your browser and never uploaded.

Contacts converter

Not uploaded.

Drop your contact list

An Excel, CSV or Google Sheets file with one contact per row. It becomes a .vcf file your phone can import. Or open a .vcf to go the other way.

How to convert Excel or CSV to VCF

  1. Choose your contact list: Excel, CSV, or a Google Sheet downloaded as either.
  2. Check what each column holds. Most are matched by their names; change any that are wrong.
  3. Look over the first contacts as they'll appear on the phone.
  4. 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:VCARD

The 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.

Questions

How do I import contacts from Excel to iPhone?

Convert the spreadsheet here and download the .vcf file, which is how you transfer contacts from Excel to an iPhone. Email it to yourself or send it in a message, then tap the .vcf attachment on your iPhone, as Apple describes. You can also import it on iCloud.com, which adds every contact in the file.

How do I import contacts from Excel to Android?

Download the .vcf file here and copy it to the phone. In the Google Contacts app, use Import from file and choose the .vcf. Or import it on contacts.google.com, and the contacts sync to the phone.

What columns does my spreadsheet need?

One row per contact, with a header row. Columns are matched by name: First Name, Last Name or just Name, Company, Mobile, Work Phone, Email, Street, City, State, ZIP and more, including Google Contacts' own CSV columns. Any column it doesn't recognize, you can assign yourself.

Which vCard version does it make?

vCard 3.0, the format iPhone, Android and Google Contacts all read. Every contact goes into one .vcf file, with long lines folded the way the standard asks.

Is there a limit on how many contacts I can import?

Not here, but Google Contacts says imports of more than 3,000 contacts at once can run into problems. For bigger lists the tool also offers the .vcf in files of 3,000.

Is this CSV to VCF converter free?

Yes. It's free to use online with no sign-up and no contact limit. It runs in any browser on Windows, Mac or a Chromebook.

Are my contacts uploaded anywhere?

No. Your browser reads the spreadsheet on your own computer and writes the .vcf there. Nothing is sent to a server.

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