Guide · Office and email
Excel to VCF: turn a contact list in Excel or Google Sheets into one .vcf file for iPhone, Android or Outlook, free
By Blink Brief · Published · Updated · How pages are made
Copy the contact list’s cells in Excel or Google Sheets, header row included, and paste them into the converter below, or open the list saved as CSV. Check the preview, then press Download .vcf: one vCard file holds every contact. Import it on an iPhone (iCloud.com › Import vCard), an Android phone (Contacts › Organize › Import from file) or in Outlook. It’s free, and the list is read in this browser tab, never uploaded.
Turn your contact list into one .vcf file
The list is read in this tab and never uploaded.
One contact per row. Headers are read in English, German, Spanish, French, Italian and Japanese. An Excel workbook (.xlsx) can’t be read: copy its cells and paste them, or save it as CSV.
What each column holds
This converter needs JavaScript. Without it, Google Contacts makes the .vcf for you, on a computer:
- Save the sheet as a CSV with Google’s headers in the first row, such as First Name, Last Name, Phone 1 - Value and Email 1 - Value.
- At contacts.google.com, click Import, then Select file, choose the CSV and click Import.
- To get a .vcf, select the contacts, click More actions, then Export, choose vCard and click Export.
Paste the list or open the CSV
- From Excel or Google Sheets: select the cells with the header row, copy, and paste them into the box. The preview appears as you paste.
- A CSV file: press Choose a .csv file. Commas or semicolons both work (Excel in Germany, France, Italy or Spain saves with semicolons), and a value in quotes may hold a comma. The file is read as UTF-8, or as Excel’s Windows encoding if it isn’t UTF-8. From a Japanese Excel, save it as CSV UTF-8.
- An .xlsx workbook: the converter doesn’t read it. Copy the cells, or save the sheet as CSV first (in Excel, File › Save As › CSV UTF-8).
Lines above the header row, such as a title, are skipped: the converter looks for the first row that names a name or a company column. A list with no header row is read too; the converter then guesses each column from the first row (an @ makes an email, digits a phone, the first text column the name), and says so.
The columns it reads (and the header words in six languages)
| In the .vcf | Header words it reads |
|---|---|
| Full name | Name, Full name, Nombre completo, Nom complet, Nome completo, 氏名, 名前 |
| First name | First name, Given name, Vorname, Nombre, Prénom, Nome, 名 |
| Last name | Last name, Family name, Surname, Nachname, Apellidos, Nom, Cognome, 姓 |
| Mobile (TEL;TYPE=CELL) | Mobile, Cell, Handy, Mobiltelefon, Móvil, Portable, Cellulare, 携帯 |
| Home and work phone | Home phone, Telefon privat; Work phone, Business phone, Telefon geschäftlich, Teléfono trabajo, Téléphone bureau, Telefono ufficio |
| Phone | Phone, Telefon, Teléfono, Téléphone, Telefono, 電話 |
| Email, E-Mail, Correo, Courriel, メール | |
| Company | Company, Organization, Firma, Empresa, Société, Azienda, 会社 |
| Address | Address, Street, City, Postal code, Country; Adresse, Straße, PLZ, Ort; Dirección, Indirizzo, 住所 |
| Notes | Notes, Notizen, Notas, Note, メモ |
Each column gets a list under What each column holds, so a wrong guess takes one change. Two columns can hold the same thing: Email 1 and Email 2 both go into the card. The address columns of a row (street, city, postal code) are joined in one address line. Columns it doesn’t know, such as a birthday or a job title, are left out; set one to Notes to keep it in the card.
Google Contacts’ and Outlook’s own CSV exports read as they are: First Name, Last Name, Organization Name, Phone 1 - Value (with its Phone 1 - Label, such as Mobile), E-mail 1 - Value; or Outlook’s Mobile Phone, Business Phone, Home Phone and E-mail Address.
Check the preview, then Download .vcf
The heading counts the contacts and the line under it gives the first five names. Check two things there: that the names are the people in your list, and, for a list with first and last names in separate columns, that they come out in the right order. A row with neither a name nor a company is skipped, and the count says how many.
Download .vcf writes one vCard 3.0 file (RFC 2426) with a card per contact: the name (N and FN), the company (ORG), each phone as TEL with its type (CELL, HOME, WORK, or VOICE for a column that only says Phone), each email, the address (ADR) and the notes (NOTE). Commas, semicolons and line breaks inside a value are escaped as the standard asks (a phone or email cell with two lines gives two phones or emails), lines longer than 75 octets are folded, and the text is UTF-8, so accented and Japanese names stay as they are. A contact with only a company gets the company as its name.
Open it in the VCF viewer leads to the VCF viewer: choose the downloaded file there to see every card with its fields before you import it. Not done here: photos, contact groups, merging duplicates, birthdays, and vCard 2.1 or 4.0 files.
Tested here: lists with headers in each of the six languages, Google Contacts and Outlook CSV files, Japanese and accented names, a comma inside quotes and an empty row, pasted and opened as files in Chromium and WebKit at 375 and 1280 px; each .vcf opened in the VCF viewer with the same contacts. Not tested: the imports below, as no iPhone, Android phone or Apple, Google or Microsoft account was signed in.
Import it: iPhone, Android, Google, Outlook
iPhone
On a computer, go to icloud.com/contacts, sign in, select the Add button on the right and choose Import vCard, then select the file. Apple: “If the vCard contains contact information for more than one person, each contact becomes a separate entry.” The contacts reach the iPhone through iCloud. On the iPhone itself, Apple’s iOS 27 guide gives one step: “Tap a .vcf attachment in an email or message”, so mail the file to yourself and tap it.
Android
Google’s steps: open the Contacts app, tap Organize at the bottom, then Import from file. Pick the account to save the contacts to if the phone has several, then select the .vcf file.
Google Contacts on a computer
At contacts.google.com, click Import on the left, then Select file, choose the .vcf and click Import. The contacts then reach every phone signed in to that Google account.
Outlook
Outlook on a PC takes a file of many contacts as a CSV, not a .vcf: Microsoft says a vCard file has to be converted to a .csv first. So import your list’s CSV directly, as the last section says. Import a .vcf file into Outlook has every version, Outlook for Mac included, which saves each contact of a .vcf you double-click.
Only one contact came in
Open the .vcf in the VCF viewer and compare its count with the converter’s. If both say many, the route you used adds one card at a time: on an iPhone, use iCloud.com’s Import vCard instead; on Android, Google Contacts’ Import from file. If the converter counted fewer than your list, look at the skipped rows it reports (no name, no company) and at the column lists: a name column set to Skip leaves its contacts without a name.
More on the phones’ side: import a .vcf file on an iPhone or Android.
From Google Contacts or Outlook on Windows and the web (they import a CSV themselves)
If the contacts are going into Google Contacts or Outlook, you don’t need a .vcf. Google Contacts imports a CSV at contacts.google.com (Import › Select file), and publishes a template whose headers it reads. Outlook imports a CSV too: classic Outlook through File › Open & Export › Import/Export › Import from another program or file › Comma Separated Values; new Outlook through People › Import contacts; Outlook.com through People › Manage contacts › Import contacts. Microsoft recommends UTF-8 for the file.
The .vcf is for the places that want one: an iPhone or iCloud.com, an Android phone’s Contacts app, Outlook for Mac, or a person you send the contacts to. Going the other way, from a phone to a spreadsheet: export iPhone contacts to Excel.
Privacy: the list you paste or the file you open is read in this browser tab and never uploaded; close the tab and it’s gone. The .vcf is made in the tab and goes straight to your downloads.
Questions
How do I create a VCF file with multiple contacts?
Put the contacts in a sheet, one row each, with a header row (Name, Phone, Email, for example). Copy the cells, paste them into the converter on this page, check the preview and press Download .vcf: the file holds one vCard per row. A .vcf file with many contacts is one vCard after another, each from BEGIN:VCARD to END:VCARD.
How do I convert Excel to VCF for free?
Select the cells in Excel with the header row, copy them, and paste them into the converter on this page; or save the sheet as CSV and press Choose a .csv file. Check the column guesses and the first names in the preview, then press Download .vcf. It’s free and runs in the browser tab: the list is never uploaded.
Can I convert Excel to VCF on Android?
Yes, in the phone’s browser: open the CSV from the phone with Choose a .csv file, or paste cells copied from the Google Sheets app, then press Download .vcf. We tested the converter at phone size in Chromium and WebKit, not on an Android phone. Google’s steps to add the file: Contacts app › Organize › Import from file.
Do I need a .vcf for Google Contacts or Outlook?
No, except Outlook for Mac. Google Contacts and classic Outlook, new Outlook and Outlook.com import a CSV themselves (Google at contacts.google.com › Import; Outlook through its CSV import). Outlook for Mac can’t import a CSV, so give it the .vcf: double-click it and every contact is saved. A .vcf is also for an iPhone, iCloud.com, an Android phone’s Contacts app, or anyone you send the contacts to.
Sources
- RFC 2426: vCard MIME Directory Profile (vCard 3.0): FN, N and VERSION required; \, \; and \n escapes. Read on 10 November 2026.
- RFC 6350: vCard Format Specification (vCard 4.0): lines folded at 75 octets. Read on 10 November 2026.
- Apple: Import, export, or print contacts on iCloud.com: Import vCard; each contact becomes a separate entry. Read on 10 November 2026.
- Apple: Import contacts on iPhone (iOS 27): tap a .vcf attachment in an email or message. Read on 10 November 2026.
- Google Contacts Help: Import your contacts (Android): Organize › Import from file. Read on 10 November 2026.
- Google Contacts Help: Import your contacts (computer): Import › Select file; a CSV or a vCard; the template's headers. Read on 10 November 2026.
- Google Contacts Help: Export, back up, or restore contacts: More actions › Export, as a CSV or vCard file. Read on 10 November 2026.
- Microsoft: Import or export contacts in Outlook using a .csv file. Read on 10 November 2026.