ExcelTool.io

Excel to vCard Converter

Turn a contact spreadsheet into a .vcf file you can import into iPhone, Google Contacts, or Outlook - without your contacts ever leaving your device.

Drop your file here or click to upload

Supports .xlsx, .xls, .csv · up to 50MB · or paste a file from your clipboard

How to Convert Excel Contacts to vCard

  1. Upload your spreadsheet - .xlsx, .xls or .csv exported from any CRM, mail client or address book. It is read in the browser and never uploaded.
  2. Check the column mapping - columns are guessed from your header row; every field can be re-pointed or cleared.
  3. Read the count - the panel shows how many cards will be written and how many rows were skipped.
  4. Download the .vcf - one file containing every card, ready to import into iPhone, Google Contacts, Outlook or Android.

What Each Row Becomes

One spreadsheet row becomes one vCard 3.0 card, and all the cards are concatenated into a single contacts.vcf. This is what a fully mapped row produces:

Your columnvCard propertyNotes
Full nameFNRequired by the spec. Falls back to first + last, then company, then email
First / last nameNWritten as last;first;;; - no middle name, prefix or suffix
Mobile phoneTEL;TYPE=CELL,VOICEThe number is written exactly as the cell reads
Work phoneTEL;TYPE=WORK,VOICEThe second and last phone slot
EmailEMAIL;TYPE=INTERNETOne address per contact
Company / job titleORG / TITLEORG is a single value; no department splitting
AddressADR;TYPE=HOMEThe whole cell goes in the street component, unsplit
Website / noteURL / NOTEFree text, escaped for the format

How Your Headers Are Matched

The guess is a case-insensitive match on the header text: name or contact for the full name, first or given, last or surname or family, mobile or cell (then phone or tel) for the mobile number, work phone or office for the work number, email, company or organisation or employer or org, title or position or role, address or street, url or website or homepage, and note or comment or remark. Each column is claimed at most once. Two habits of real spreadsheets are worth watching: a column literally called "Title" that holds Mr or Dr is mapped to the job title, and a sheet with no header row needs the "First row contains headers" box unticked so the columns become Column 1, Column 2 and can be mapped by hand.

Edge Cases and Limits

  • Numbers keep their cell text - a phone column formatted as a number loses its leading zero in Excel long before it gets here. Format the column as text in the spreadsheet if that matters.
  • Photos are never written, so cards import without avatars.
  • No deduplication - two rows for the same person produce two cards. Clean the sheet first with Remove Duplicates.
  • Groups and categories are not exported; organise contacts after importing.
  • Multiple sheets - select the sheet you want and the mapping is re-guessed from its headers.
  • CSV input gets delimiter and encoding detection, so a semicolon-separated or UTF-16 export from Outlook loads correctly.

When to Use a Different Tool

To join separate street, city and postcode columns into the single address cell this tool expects, use Combine Columns first. For dated entries rather than people, Excel to Calendar writes .ics events from the same kind of sheet. If you only need the list somewhere else rather than in an address book, Excel to CSV or Excel to JSON keep the rows as data.

Frequently Asked Questions

Related Tools