VCF (vCard) to Excel / CSV Converter
Contacts from phones and address books to spreadsheets, and back.
Your vCard files
Output
Contacts
Add a .vcf file or paste vCard text to see your contacts here.
Your contact sheet
Columns
Open a file or paste cells to choose what each column holds.
| Your column | Example | Maps to |
|---|
vCard file
About the VCF (vCard) to Excel / CSV Converter
A VCF (vCard) file is how phones and address books export contacts — one file can hold thousands of them. This converter turns those files into a spreadsheet: CSV or Excel (.xlsx), one row per contact, with every phone number, e-mail address and postal address in its own column and its type (mobile, home, work…) beside it. It reads vCard 2.1, 3.0 and 4.0, the quoted-printable names Android phones write (accents, Devanagari, Arabic, Chinese…), Apple’s custom labels and embedded photos, which you can keep or leave out.
It also works the other way: open a CSV or Excel sheet of contacts, check which column is the name, the mobile number or the e-mail (the column names of Outlook’s CSV template and of a Google Contacts CSV export are recognised for you), and download a VCF for your iPhone, Android phone, Google Contacts or any vCard 4.0 app — as one file, or one file per contact. Your contacts are processed in your browser and never uploaded.
How to use it
- To turn contacts into a spreadsheet, keep vCard → CSV / Excel selected and drop one or more .vcf files on the box (or paste vCard text). The count of contacts, numbers and e-mails appears at once, with a preview.
- Choose CSV or Excel (.xlsx) and the columns: All fields gives every value its own column; Outlook CSV template uses the columns of Microsoft’s template for importing contacts into Outlook. Choose whether to keep photos.
- Press Download. To convert between vCard versions instead — for example an Android 2.1 file for an iPhone — choose vCard as the output, pick the version, and optionally split the file into one .vcf per contact (a ZIP).
- To make a VCF from a sheet, choose CSV / Excel → vCard, open the file (or paste the cells), and check the Maps to column for each of your columns. Pick the target (iPhone, Android, Google Contacts or vCard 4.0) and press Download .vcf.
Examples
N;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:=E0=A4=B6=E0=A4=B0=E0=A5=8D=E0=A4=AE=E0=A4=BE;=E0=A4=85=E0=A4=AE=E0=A4=BF=E0=A4=A4;;; TEL;CELL;PREF:+91 98765 43210 TEL;HOME:020 2345 6789
Full name: अमित शर्मा · First name: अमित · Last name: शर्मा Phone 1 - Type: Mobile (preferred) · Phone 1 - Number: +91 98765 43210 Phone 2 - Type: Home · Phone 2 - Number: 020 2345 6789
Name, Mobile No, Email ID, Company, City, PIN Code Priya Nair, 98470 12345, priya@example.in, Nair Textiles, Kochi, 682001
BEGIN:VCARD VERSION:3.0 N:Nair;Priya;;; FN:Priya Nair ORG:Nair Textiles TEL;TYPE=CELL:98470 12345 EMAIL;TYPE=INTERNET:priya@example.in ADR:;;;Kochi;;682001; END:VCARD
Name, Mobile No, Email ID, Company, City and PIN Code are recognised automatically; a column you would map differently is changed in the Maps to list.
Common uses
- Opening a phone’s contact backup (.vcf) in Excel or Google Sheets to clean, sort or deduplicate it.
- Moving contacts from an Android phone to an iPhone, or from an old feature phone, by converting the vCard version.
- Turning a customer, member or staff list kept in Excel into contacts that a phone can import in one go.
- Getting contacts into Outlook, which imports them from a CSV file in the columns of its own template.
Which vCard version to choose
- iPhone, iPad & Mac — vCard 3.0 (RFC 2426): UTF-8 text, with custom labels such as “WhatsApp” or “Office reception” written the way Apple Contacts writes them.
- Android — vCard 2.1: the version Android’s Contacts app exports. Accented and non-Latin text is written as quoted-printable UTF-8, so older phones read it as well.
- Google Contacts — vCard 3.0: the version Google Contacts exports.
- vCard 4.0 (RFC 6350): the current standard, for apps and servers that ask for it.
Every version gets the name, phones, e-mails, addresses, organisation, job title, websites, birthday, notes and (if you keep them) photos. Groups (categories) and nicknames are not part of vCard 2.1, so the Android preset leaves them out.
Columns in the spreadsheet
All fields has the name parts (prefix, first, middle, last, suffix), nickname, organization, department and job title, then Phone 1 - Type, Phone 1 - Number, Phone 2 - … for as many numbers as the contact with the most, the same for e-mails and addresses (street, city, region, postal code, country, PO box), websites, messaging, birthday, anniversary, notes, groups and any other fields. Columns that are empty for every contact are left out.
Outlook CSV template has exactly the 92 columns, in the order, of the sample file Microsoft provides for importing contacts into Outlook. Outlook has fixed places — one mobile, two business and two home numbers, three e-mails, one home, one business and one other address — so anything beyond them is reported as missing.
Phone numbers in Excel
Excel changes numbers when it opens a CSV file: +91 98765 43210 can turn into 9.19877E+11, and a leading 0 disappears. The Excel (.xlsx) download stores every cell as text, so numbers stay exactly as they were; use it to look at contacts in Excel, and the CSV to import them into another program. Cells that a spreadsheet would run as a formula — beginning with = or @, or with + or − that does not start a phone number or a number — get a leading apostrophe in the CSV; phone numbers such as +91 98765 43210 stay exactly as they are.
Limitations
- Files up to 100 MB each. Very large photo-heavy files take a few seconds to read.
- Photos stored as web links stay links: nothing is downloaded from the internet. In Excel, a photo larger than a cell can hold (32,767 characters) is left out; the CSV keeps it.
- Properties without a column of their own (keys, sounds, custom X- fields) are kept as text in the “Other fields” column, but they are not written back to a VCF.
- Duplicates are not merged. To find them, download Excel and use the Remove Duplicate Rows tool.
Privacy
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I open a VCF file in Excel?
Drop the .vcf file here, choose Excel (.xlsx) and press Download. You get one row per contact with every phone, e-mail and address in its own column, ready to sort and filter. Opening a .vcf file directly in Excel does not work: it shows the raw vCard lines instead of a table.
Why do some names look like =E0=A4=85 in other converters?
That is quoted-printable: Android phones write non-ASCII letters this way in vCard 2.1 files. This converter decodes it in the character set the file names (UTF-8 by default), so names in Hindi, Tamil, Arabic, Chinese or with accents come out correctly.
How do I import an Excel contact list into my phone?
Choose CSV / Excel → vCard, open your sheet, check the Maps to column (Name, Mobile, Email… are recognised), pick iPhone or Android and download the .vcf. Then open that file on the phone (for example from e-mail or a file manager) and choose to import the contacts; on Google Contacts and iCloud.com use their Import button.
Can I import the CSV into Outlook?
Yes: choose the Outlook CSV template columns. Microsoft’s instructions for Outlook import contacts from a CSV file, and its column headings must be in the language Outlook uses — the template here is the English one.
Can I split one big VCF into separate files, or merge several?
Yes. Drop several .vcf files at once to merge them; choose vCard as the output and tick One file per contact (ZIP) to split them, each named after the contact.
Are my contacts uploaded?
No. Files and pasted text are read by this page in your browser, and the downloads are made there too. Nothing about your contacts is sent anywhere.