Excel to VCF Converter

About Excel to VCF Converter

Excel to VCF converts a contact list kept in an Excel workbook into a .vcf file that iPhone, iCloud, Android and Google Contacts import in one step. Many people keep customers, members, staff or family contacts in a spreadsheet, and phones cannot open a spreadsheet as an address book. Load the .xlsx file directly, there is no need to save it as CSV first, and the tool reads every sheet with data; a workbook with one sheet per team or per region becomes one source per sheet. Each column is shown with sample values so you can confirm which one holds the mobile number and which one the office line. Reading .xlsx directly avoids the most common Excel problem: when a sheet is saved as CSV, long phone numbers become 3.81641E+11 and leading zeros vanish, while the workbook still holds the full number. Birthdays stored as Excel dates are converted to real dates. Before you download, the first five contacts are shown as they will appear on the phone, with warnings for any number or email address that looks wrong. Old .xls files from Excel 97 to 2003 need to be saved as .xlsx first. If the data is in JSON instead, JSON to CSV Converter turns it into a table you can load here.

A few habits make a contact import go smoothly. Keep the name in separate First name and Last name columns if you can, because phones sort and search by last name; if your list has only one Name column, the split option turns "Ana Petrović" into first name Ana and last name Petrović, and "Petrović, Ana" is understood too. Store phone numbers as text in Excel, not as numbers, otherwise leading zeros disappear and long numbers lose digits; a number that arrives as 641234567 instead of 0641234567 still imports, but calls may fail. Use the international format with a plus sign whenever contacts are used in more than one country. One column can hold several values when they are separated the way Google does it, with " ::: ", and several columns can point to the same field, for example two mobile numbers or a work and a private email, which all end up on the same contact. Columns you do not need, such as internal IDs or lead scores, can simply be set to Do not import. If the preview shows strange characters like é instead of é, the file was saved in an older encoding: choose Windows-1252 for Western European text, Windows-1250 for Central European or Windows-1251 for Cyrillic in the encoding menu. On iPhone, opening a .vcf that holds many contacts offers Add All Contacts in one tap. Outlook desktop imports only the first contact of a multi-contact file, so for Outlook choose one .vcf per contact. Google Contacts and iCloud accept the combined file. To clean a list of emails or numbers before converting, Duplicate Line Remover removes repeated lines, and an Email Signature Generator is handy once your new address book is set up.

How to use Excel to VCF Converter

  1. Drop one or more CSV or Excel contact files
  2. Match each column to a contact field and check the preview and warnings
  3. Download the .vcf and import it on iPhone, iCloud, Android or Google

Frequently Asked Questions

How do I convert Excel contacts to VCF?
Drop the .xlsx file on the tool, check that each column is matched to the right contact field and look at the preview. Then click Download vCard. Every row with a name, company, phone or email becomes a contact in one .vcf file.
Do I need to save the Excel file as CSV first?
No, and it is better not to. The .xlsx is read directly, which keeps long phone numbers and leading zeros intact. Saving as CSV is where Excel usually turns phone numbers into scientific notation and drops digits.
My workbook has several sheets. Which one is used?
All sheets that contain data. Each sheet is listed as its own source, so you can remove the ones you do not want. Sheets with the same columns share one mapping.
Does it work with old .xls files?
Not directly. Open the .xls file in Excel, LibreOffice or Google Sheets and save it as .xlsx or .csv, then load it here. The newer format is required because the old binary format cannot be read safely in the browser.
How do I import the VCF on Android?
Copy the .vcf to the phone, open the Contacts app, go to Fix and manage or Settings, choose Import from file and select it. You can also import it on contacts.google.com, and it syncs to the phone through your Google account.

Related Tools

Also Available As