Home › Developer Tools › Excel to VCF Converter

Excel to VCF Converter

Convert a contact list from Excel into a vCard (.vcf) file you can import on an iPhone, Android phone, Google Contacts or Outlook. Columns are matched automatically, you can fix any match, and the whole conversion happens on your device.

Last updated:

Contacts stay on your device. Nothing is uploaded.
1

Check your data

2

Match columns to contact fields

3

Create the VCF

Preview of the first contacts

  
Advertisement
Advertisement

How to use the Excel to VCF Converter

  1. Drop your Excel file (or .csv) on the upload area. Pick the sheet if the workbook has more than one.
  2. Check the first rows and confirm whether the first row holds column names.
  3. Review the column matches: each contact field shows which spreadsheet column it uses. Change or clear any of them.
  4. Choose the vCard version and output: one .vcf file for importing, or a ZIP with a separate file per contact.
  5. Click Download VCF and import the file on your phone, in Google Contacts or in Outlook.

How Excel columns become vCard fields

A vCard is a plain text file made of PROPERTY:value lines between BEGIN:VCARD and END:VCARD. Each spreadsheet row becomes one of these blocks. Name and address parts are combined into structured properties whose parts are separated by semicolons, so the converter escapes any semicolons, commas and line breaks that appear inside your cells.

Typical Excel columnvCard property (3.0)Example output
First Name, Last Name, Middle, Prefix, SuffixN (Last;First;Middle;Prefix;Suffix)N:Ruiz;Ana;;;
Full Name / Display NameFNFN:Ana Ruiz
Company, DepartmentORGORG:Brightside Dental
Job TitleTITLETITLE:Office Manager
Mobile / Work / Home Phone, FaxTEL with a TYPETEL;TYPE=CELL:+1 512 555 0101
Email, Email 2EMAILEMAIL;TYPE=INTERNET,HOME:[email protected]
Street, City, State, ZIP, CountryADR (;;Street;City;State;ZIP;Country)ADR;TYPE=HOME:;;120 Elm St;Austin;TX;78701;USA
BirthdayBDAYBDAY:1988-04-12
WebsiteURLURL:https://example.com
NotesNOTENOTE:Met at the spring trade show
Groups / CategoriesCATEGORIESCATEGORIES:Clients,Austin

Tips for a clean import

  • One contact per row, one header row. Remove title rows, merged cells and totals above or below the list. Empty rows are skipped automatically.
  • Store phone numbers as text in international format (+1 512 555 0101) so leading zeros and the plus sign survive and the number dials correctly when traveling.
  • Use real Excel dates or YYYY-MM-DD for birthdays. Text like 03/04/1990 is ambiguous, so pick the matching date order in the options; dates the tool cannot read are reported and left out.
  • Import a test file first. Export two or three rows, import them on your phone and check the result before importing hundreds of contacts, because phones do not merge duplicates automatically.
  • Going the other way? The VCF to CSV converter turns a .vcf exported from a phone back into a spreadsheet.

Frequently asked questions

How do I convert an Excel contact list to VCF?

Drop the .xlsx file on this page. The columns are matched to contact fields automatically (for example First Name, Mobile Phone, Email). Check the matches, choose vCard 3.0 and click Download VCF. You get one .vcf file containing every row as a separate contact.

How do I import the VCF file on an iPhone or Android phone?

On an iPhone, email or AirDrop the .vcf to yourself and tap it, or import it at iCloud.com in Contacts with Import Contact. On Android, open the Contacts app, choose Fix and manage or Settings, then Import from file and select the .vcf. Google Contacts and Outlook also have an Import option that accepts .vcf files.

Which vCard version should I choose?

vCard 3.0 is the safest choice and is accepted by iPhone, iCloud, Google Contacts, Outlook and most Android phones. Choose 4.0 only if the target app asks for it, and 2.1 for very old phones; in 2.1 accented characters are written with quoted-printable encoding, as that version requires.

Why are the leading zeros or plus signs missing from my phone numbers?

If a phone column is stored as numbers in Excel, Excel itself drops the leading 0 or + before the file is saved. Format the column as Text in Excel and retype or re-import the numbers, or keep them as text like +1 512 555 0101. The converter copies phone numbers exactly as they are stored.

My sheet only has a Name column. Will first and last names be filled in?

Yes. With Split a full name turned on, the last word becomes the last name and the rest becomes the first name, and a name written as Last, First is split at the comma. The full name is always kept as the display name (FN).

What is the difference between one VCF file and a ZIP of VCF files?

A single .vcf containing many contacts is what phones and Google Contacts import in one step. The ZIP option creates a separate .vcf for each person, named after the contact, which is useful for attaching individual contact cards to emails or a CRM.

Is my contact list uploaded to a server?

No. The spreadsheet is read and converted entirely in your browser with JavaScript, and the VCF is created on your device. No names, numbers or emails are sent anywhere.

Are all the tools on FreeToolCabin tested for quality and accuracy?

Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.

Related tools

VCF to CSV ConverterConvert vCard (.vcf) contacts to CSV for Google or Outlook, or turn a CSV back into a VCF.Excel to CSVConvert XLSX spreadsheets to CSV.Excel to JSON ConverterConvert Excel sheets (XLSX, XLS, ODS) to JSON with header row, type and shape options.Excel Viewer (XLSX / XLS)Open XLSX, XLS and ODS spreadsheets in your browser without Excel.VCF File ViewerOpen vCard .vcf files as contact cards with photos, search and duplicate check, export CSV.JSON to Excel ConverterTurn JSON into a styled .xlsx spreadsheet; nested arrays become their own linked sheets.JSON to CSVConvert JSON data to CSV for spreadsheets.CSV to JSONConvert CSV data to JSON with live preview.CSV ViewerOpen a CSV or TSV file as a sortable, filterable table.Line Ending ConverterConvert text and files between CRLF, LF and CR line endings.Markdown to HTMLConvert Markdown to clean HTML with a live editor.XML to JSONConvert XML to JSON with validation.Text Encoding ConverterDetect and convert text file encodings like UTF-8, UTF-16 and Latin-1.JSON ViewerExplore JSON as a collapsible tree, search keys and values and copy any node's path.TTF to WOFF2 ConverterConvert TTF and OTF fonts to WOFF2 or WOFF and get a ready @font-face CSS snippet.Chmod CalculatorConvert Linux file permissions between checkboxes, octal (755) and symbolic (rwxr-xr-x) notation.JSON to TypeScriptGenerate TypeScript interfaces or types from JSON, with nested types and optional fields.Morse Code TranslatorTranslate text to Morse code and back, then play it as sound or a blinking light, or save a WAV.HTML Table GeneratorBuild HTML tables in an editable grid with styles, header rows, CSV import and live preview.Hex to Text ConverterConvert hex to text and text to hex with UTF-8 support and space, 0x, \x or comma formats.JSON to XML ConverterConvert JSON to well-formed XML with attributes, arrays and pretty print.JSON to YAML ConverterConvert JSON to clean YAML as you type, with indent, quoting and sort options.YAML to JSON ConverterConvert YAML to pretty or minified JSON, with errors pinned to the exact line.HTML to Markdown ConverterTurn HTML or pasted rich text into clean Markdown with tables and live preview.Markdown Table GeneratorBuild Markdown tables in a grid or paste from Excel/CSV, with alignment and preview.JSON ValidatorCheck JSON with the exact line and column of each error, fix tips and one-click auto-fix.Image to Base64Convert images to Base64 data URIs, CSS backgrounds and HTML img tags in your browser.Base64 to ImagePaste a Base64 string or data URI to preview, identify and download the image.JSON CompareCompare two JSON documents and see every added, removed and changed path.Hex to DecimalConvert hex to decimal instantly with steps and signed mode.Decimal to HexConvert decimal to hex instantly with steps and signed mode.Binary to DecimalConvert binary to decimal instantly with steps and signed mode.Decimal to BinaryConvert decimal to binary instantly with steps and signed mode.Two's Complement CalculatorDecimal to two's complement binary and back for 4-64 bits, with invert-and-add-1 steps.XML to CSV ConverterConvert XML to CSV: detects repeating records, flattens nested data, pick your columns.CSV to XML ConverterConvert CSV to well-formed XML with custom root and row names, escaping and pretty print.TOML to JSON ConverterConvert TOML to JSON and JSON to TOML with a full v1.0 parser and clear error lines.JSON to Go StructTurn JSON into Go structs with inferred types, nested structs and json tags.REM to PX ConverterConvert CSS rem values to pixels for any root font size, with a quick 0.25–6rem table.SQL to JSON ConverterConvert SQL INSERT statements and dumps into a JSON array of row objects, with CSV export.TSV to CSV ConverterConvert TSV to CSV and back, or between tab, comma, semicolon and pipe, with correct quoting.TypeScript to JavaScriptConvert TypeScript or TSX to clean JavaScript instantly: strip types, keep or compile JSX.XML to YAML ConverterConvert XML to clean YAML with attributes, text nodes, lists and exact error lines.YAML to XML ConverterConvert YAML to pretty, well-formed XML with custom root, attributes and array item tags.Boolean Algebra SimplifierSimplify boolean expressions or minterm lists to minimal SOP and POS with Quine-McCluskey steps.Compare Excel FilesCompare two Excel spreadsheets cell by cell, highlight changes and export a diff report.CSV CleanerClean messy CSV in one click: trim spaces, drop empty rows and columns, fix headers, dedupe.CSV VLOOKUP ToolJoin two CSV or Excel files on a key column like VLOOKUP, with left, inner and full joins.Remove Duplicates in ExcelFind and remove or highlight duplicate rows in XLSX or CSV files by the columns you choose.GeoJSON ViewerView GeoJSON on a map, inspect and edit properties, validate against RFC 7946 and export.GPX ViewerOpen GPX tracks on a map with distance, elevation profile, moving time, speed and splits.JSON Repair ToolFix broken JSON automatically: trailing commas, quotes, comments, truncated data, with a diff.Karnaugh Map SolverSolve 2–6 variable K-maps: click cells or enter minterms to get the minimal SOP or POS with groups.Merge Excel FilesCombine XLSX, XLS and CSV files into one workbook or append all rows into a single sheet.Parquet File ViewerOpen Apache Parquet files in your browser: schema, rows, filters and CSV or JSON export.Query CSV with SQLRun SQL on CSV, Excel, JSON and Parquet files in your browser with DuckDB. Join and export.Online Serial MonitorTalk to Arduino, ESP32 and USB serial devices in your browser: log, send, plot and save.Split Excel FileSplit an Excel sheet into several files by row count or by each value in a column, as ZIP.SQL Create Table GeneratorDefine columns, keys, defaults and indexes; get CREATE TABLE SQL for MySQL, Postgres and more.SQL IN Clause GeneratorTurn a pasted list into a SQL IN ('a','b') clause with quoting, dedupe and 1,000-item chunks.SQL Online CompilerRun SQL queries online on SQLite with sample databases, a result grid, CSV export and .db save.SQL to ER DiagramPaste CREATE TABLE statements and get an entity-relationship diagram with keys and links.XML to XSD GeneratorGenerate an XML Schema (XSD) from sample XML: types, occurrences, attributes and namespaces.XML ValidatorCheck if XML is well-formed, see the exact line and column of each error and pretty-print it.Wildcard Mask CalculatorConvert a subnet mask or CIDR to a wildcard mask for ACLs and OSPF, with range and binary.CSV to VCF ConverterConvert a contacts CSV into a vCard (.vcf) file, mapping columns to name, phone, email and more.CSV to YAML ConverterConvert CSV rows to a YAML list of mappings with type inference and delimiter detection.Endianness ConverterSwap byte order of 16, 32 and 64-bit hex values and see big- and little-endian integers and floats.
See all 129 Data & File Format Converters →