OpenWithout

Convert CSV or Excel to VCF – Contact List to vCard, Free

By Tam Vu · Updated

Have your contacts in a spreadsheet and need them on a phone? Drop the .csv or .xlsx file below. We match your columns to contact fields, show you what each contact will look like, and give you one contacts.vcf with everyone in it. The file is read in this browser tab — it never leaves your device.

No file handy?

How it works

  1. Columns are matched for you. "First Name", "Mobile", "E-mail", "Company", "Birthday" and many other common names — including the column names Outlook and Google Contacts use in their own exports — go to the right field automatically. Change any of them with the drop-down.
  2. Nothing is thrown away quietly. A column that doesn't fit a contact field, like Status or Customer ID, is added to the contact's note with its label — Status: Active — unless you choose Don't include.
  3. Check the preview, then download. You see the contacts as a phone will show them before you save anything.

Phone numbers that turned into 4.15555E+10

When a long phone number is typed into Excel as a number, Excel shows it as 4.15555E+10. If the sheet is then saved as CSV, that short form is what gets saved — the last digits are gone for good, and no converter can bring them back. We spot these numbers, list them with the row and the person's name, and let you type the right number in before you download. Numbers you leave alone are kept in the note, so you can still find them; Skip all leaves them out.

To stop it happening next time, format the phone column as Text before typing numbers, or type them with a leading + and spaces (+1 415 555 0132). An .xlsx file is safer than CSV here: Excel keeps the full number inside the workbook even when it shows the short form, and we read the full number.

Outlook needs a CSV, not a .vcf

Classic Outlook opens a .vcf one contact at a time, so a file with 200 contacts doesn't import in one go. Microsoft's own advice is to import contacts from a CSV file. Choose contacts-outlook.csv in step 3: it uses the column names Outlook itself writes (First Name, Mobile Phone, E-mail Address…), is saved as UTF-8 so accents survive, and puts extra numbers and labels into Notes.

Good to know

  • Google Sheets: File → Download → Comma-separated values (.csv), then drop that file here.
  • Several sheets in one workbook: pick the sheet with your contacts from the list next to the file name.
  • Only one "Name" column? The whole name is kept as you typed it, in the first-name field. We don't guess which word is the surname, so "Nguyen Van Linh" and "Linh Nguyen" both show exactly as written.
  • Birthdays like 4/17/1992 are read month-first, as Excel writes them in the US. If any date in the column can only be day-first (17/04/1992), the whole column is read day-first.
  • Old .xls files (Excel 97–2003) aren't supported yet. Open the file in Excel and save it as .xlsx or CSV first.
  • The .vcf uses vCard 3.0, which the contacts apps on iPhone, Android, Mac and Google Contacts read.