Map Extract
Free tool

Convert a CSV of contacts to a vCard (.vcf) file

Paste or open a contact list with a header row, check which column goes into each contact field, and download a single .vcf file holding every contact. Phones, desktop mail apps and webmail contact books can import it in one go.

Runs in your browser. Nothing you enter is uploaded.

From spreadsheet to contacts

  1. Add the CSV

    Press Choose a CSV file or paste the text. The first row must be a header.

  2. Review the column mapping

    Fifteen contact fields are listed, from full name, first and last name, company and job title to email, mobile, work phone, street, town, county, postcode, country, website and note. Common header names are matched automatically; set the rest from each drop-down or leave them as (not used).

  3. Pick the vCard version

    vCard 3.0 has the widest support and is the safe default. vCard 4.0 is newer and writes phone numbers as tel: links in international format.

  4. Check the counts

    You see how many contacts were made and which rows were skipped because nothing in them was mapped.

  5. Download or copy

    Download .vcf saves contacts.vcf. The text is also shown so you can copy it or check a card before importing.

Two trade contacts from an event list

This list came from a sign-up sheet at a trade fair. Most headers match automatically, but Office Phone is not a name the guesser recognises, so it starts as (not used). Setting Work phone to that column adds it to each card.

The blank last row is skipped and reported as row 4. Sam has no mobile, so their card simply has no mobile line rather than an empty one. Only the postcode was mapped for the address, so that is all the ADR line holds.

Input
First Name,Last Name,Company,Job Title,Email,Mobile,Office Phone,Postcode
Jo,Hartley,Kiln & Co Pottery,Owner,jo@kilnandco.example,07700 900321,01632 960410,BA11 1AA
Sam,Okafor,Marlow Print Works,Studio Manager,sam@marlowprint.example,,01632 960411,BA1 1AA
,,,,,,,
Result
Contacts: 2   Rows skipped (nothing mapped): 1 (row 4)

BEGIN:VCARD
VERSION:3.0
FN:Jo Hartley
N:Hartley;Jo;;;
ORG:Kiln & Co Pottery
TITLE:Owner
EMAIL;TYPE=INTERNET,WORK:jo@kilnandco.example
TEL;TYPE=CELL:07700 900321
TEL;TYPE=WORK,VOICE:01632 960410
ADR;TYPE=WORK:;;;;;BA11 1AA;
END:VCARD

Importing the .vcf

WhereHow
iPhoneOpen the file from Files, Mail or AirDrop and choose to add all contacts
Android with Google ContactsIn the Contacts app, use Import from file and pick the .vcf
Google Contacts on the webImport, then choose the file
Outlook desktopOpen the .vcf; some versions import only the first contact from a multi-contact file, so test with a small file first
Apple Contacts on a MacFile, Import, then choose the file

Contacts on your phone, not just in a sheet

For field sales and local trades, the useful place for a prospect's number is the phone you call from. Importing a short list of the businesses you plan to visit this week means calls show a name when they ring back, and WhatsApp and messaging apps recognise them.

Keep the import small and current rather than loading a whole lead database onto a personal phone. Contacts synced to a phone often end up in cloud backups and shared with apps that request contact access. A focused list of people you are actively dealing with is easier to justify and to delete later.

Questions people ask

How do I convert an Excel contact list to vCard?

Export the sheet from Excel as CSV, load that file here, confirm which column feeds each contact field and press Download .vcf. If you only have the .xlsx, convert it to CSV first with the Excel to CSV tool. Each row with at least one mapped value becomes one contact in the file.

Should I choose vCard 3.0 or 4.0?

Use 3.0 unless you know the destination prefers 4.0. Version 3.0 is the most widely supported by phones and mail apps. Version 4.0 writes phone numbers as international tel: links, such as tel:+447700900321, which some newer systems handle better but older ones may not read.

Why was a row skipped?

A row is skipped when none of the columns you mapped has a value in it, which usually means a blank line or a row of empty cells at the end of the sheet. The skipped row numbers are listed so you can check them in the original file.

Can I import all the contacts at once?

Yes. Every contact goes into one .vcf file, one card after another, which iPhone, Android, Google Contacts and Apple Contacts import in a single step. Some versions of Outlook open only the first card of a multi-contact file, so test with two contacts before importing hundreds.

Where your data goes

Contact details are mapped and written into the .vcf by code in your browser. The spreadsheet is not uploaded, and no contact is synced or stored anywhere by this page.

Checked against the tool on

Top