Convert a spreadsheet of contacts to a VCF file

Turn a CSV list of names, phone numbers and emails into a .vcf file that an iPhone, Android phone, Gmail or Outlook can import. Runs in your browser.

From a spreadsheet to your phone's address book, without uploading the list

A list of contacts usually starts in a spreadsheet: a sign-up sheet, a customer export, a wedding guest list. Phones and email services do not import spreadsheets. They import .vcf files, and this writes one from your CSV.

Open the CSV or paste it in, with the column names in the first row. Each row becomes a contact. The columns are matched by their headings, so a column called Phone, Mobile or Tel becomes a phone number, Email or Work email becomes an email address, and Company or Organisation becomes the company. First name and last name columns are joined into the display name when there is no full name column. Every phone and email column is kept, so a contact with a mobile and an office number gets both.

What the result line tells you

It says how many contacts were written and how many rows were skipped because they had nothing to save. It also names every column it did not recognise, so a heading like “Cell #2” that was missed is visible and can be renamed before you import hundreds of contacts with a field missing.

Getting the contacts onto a phone

The file follows vCard 3.0 as RFC 2426 defines it, with commas, semicolons and line breaks inside a value escaped as the standard asks, so a company called “Acme; Ltd” stays one company. Open the downloaded file on the phone, from its files or from an email to yourself, and its contacts app offers to add the contacts. Address books in webmail and on computers have an import option that takes the same file.

Names are written as they are in the sheet, in any language, and phone numbers keep their plus sign and spaces. To go the other way, VCF to CSV turns a phone’s export into a spreadsheet. If your list is an Excel workbook, save it as CSV first or use Excel to CSV.

Nothing here is uploaded. The list is read and the file is written in your browser, which matters when the spreadsheet holds other people’s numbers.

How to convert CSV contacts to VCF

  1. 1

    Open the CSV or paste it

  2. 2

    Check which columns were recognised

  3. 3

    Download the VCF and import it on your phone

Everything you need

Columns found by name

Phone, Mobile, Work email, Company and the other usual headings are matched automatically, and anything unmatched is listed.

Standard vCard 3.0

Each contact is written to the vCard 3.0 standard, RFC 2426, with names in any language kept as written and special characters escaped.

Private by design

A contact list is other people's data. It is converted in your browser and never uploaded.

Nothing is uploaded, and you can verify it

Processing runs on this device. Open the browser’s Network panel while the tool works and you will see no file upload request to FileGizmo. Temporary previews use local browser URLs, and closing or resetting the page releases them instead of leaving a server copy behind.

No daily limits, no watermarks

Use the tool without a daily task counter, account wall or watermark. Nothing is uploaded, so your device’s memory sets the practical size. Free limits a few repeat-work features, such as 20 images per background batch.

Works on any device, and offline after first load

Use a current browser on desktop, Android, iPhone, or iPad without installing an app. Once this tool and its required assets load, the cached workflow works without a connection. Large jobs are usually more comfortable on a desktop with additional memory.

Frequently asked questions

Which columns does it recognise?

Name or full name, first and last name, phone, mobile or tel, email, company or organisation, job title, address, birthday, notes and website. Several phone or email columns are all kept. Columns it does not recognise are named in the result line.

How do I get the contacts onto my phone?

Open the downloaded .vcf on the phone, from its files or from an email to yourself, and the contacts app offers to add them. Address books on computers and in webmail have an import option that takes a .vcf as well.

What happens to rows with no name?

A row with no name but a company, phone or email is named after the first of those. A row with nothing usable is skipped and counted, so you know how many were left out.

Is my list uploaded?

No. The spreadsheet is read and the VCF is written in this browser tab, so the names and numbers never reach a server.

Sources

Related guides

Move contacts between a phone and a spreadsheetHow contacts are stored in a .vcf file, why names turn into codes in some converters, and how to go from phone to spreadsheet and back without losing numbers.