How to convert VCF to CSV
A VCF file, also called a vCard, stores contacts as text. Every contact sits between BEGIN:VCARD and END:VCARD, with one line for the name, one for each phone number, one for each email and so on. To convert vcf to csv, the tool reads every block, decodes it and writes one CSV row per contact, so the contacts open as a table in Excel.
Phone books are private. The file is read in your browser and nothing is uploaded, as the Privacy Policy explains.
VCF to CSV with correct accents (UTF-8)
Names such as Müller or José break when a CSV is opened with the wrong encoding. This tool writes UTF-8 and, by default, adds a byte order mark at the start of the file. That marker is what makes Excel on Windows open the file as UTF-8, so vcf to csv utf-8 output shows accents, Cyrillic, Arabic and Chinese correctly when you double-click it. Turn the BOM off for programs that dislike it.
One more safeguard is on by default. A contact name or note that begins with =, +, -, @ or a tab can run as a formula when the CSV is opened in Excel. Protect formulas puts a ' in front of such text, and the notes count the cells. Phone numbers that start with + are left as they are.
Old Android exports use vCard 2.1 and write non-ASCII letters as quoted-printable, such as M=C3=BCller. The tool decodes those, honours a CHARSET setting and joins the soft line breaks that split long values, so the text comes out readable. The notes tell you how many fields were decoded.
Column presets: All fields, Google Contacts and Outlook
- All fields: Full Name, First, Middle, Last, Prefix, Suffix, Nickname, Organization, Department, Job Title, Birthday, Notes, then Phone 1, Phone 2 and so on with a Type column each, the same for emails and addresses, and Websites. Nothing is dropped, up to ten of each.
- Google Contacts: column names such as First Name, E-mail 1 - Value and Phone 1 - Label, which is the layout of a Google Contacts CSV export.
- Outlook: column names such as Mobile Phone, Business Phone, E-mail Address and Home Street. Phones go to the slot for their type, and only three emails and one address per kind fit.
When a preset has no room for a value, the notes say how many values did not fit, and choosing All fields keeps them. Try a few rows in the target program first, because programs change their import columns over time.
A worked example
This vCard has two phones of different types, an escaped comma and a company with a department:
BEGIN:VCARD
VERSION:3.0
N:GarcĂa;Ana;;;
FN:Ana GarcĂa
ORG:Café Nord;Kitchen
TEL;TYPE=CELL:+49 171 2345678
TEL;TYPE=HOME:+49 30 5550 0101
EMAIL;TYPE=INTERNET,WORK:ana@example.com
ADR;TYPE=HOME:;;Hauptstr. 1\, Apt 2;Berlin;;10115;Germany
END:VCARDWith All fields this becomes one row. The escaped comma is plain text again, and the types become labels:
Full Name,First Name,Last Name,Organization,Department,Phone 1 Type,Phone 1,Phone 2 Type,Phone 2,Email 1 Type,Email 1,Address 1 Type,Address 1 Street,Address 1 City,Address 1 Postal Code,Address 1 Country
Ana GarcĂa,Ana,GarcĂa,CafĂ© Nord,Kitchen,Mobile,+49 171 2345678,Home,+49 30 5550 0101,Work,ana@example.com,Home,"Hauptstr. 1, Apt 2",Berlin,10115,GermanyThe real output has the empty columns too, such as Middle Name and Prefix, so every contact has the same columns.
Duplicates, photos and fields with no column
Contacts that share a phone number or an email with an earlier contact are listed under Possible duplicates. The comparison ignores spaces, dashes and a leading 00 or + on numbers, and the case of emails. Every contact stays in the CSV. The tool only points them out, because deciding which one to keep is your job.
Photos and logos cannot go into a CSV, so they are skipped and counted. Fields that have no CSV column, such as custom labels and social profiles, are named in the notes so you know what the file leaves out. A contact with only a full name is split at its last space so the first and last name columns are filled, and the notes count those.
Where to get a VCF file and what to do with the CSV
On Android, the Contacts app exports a .vcf under Export. On an iPhone, iCloud lets you export vCard from icloud.com. Outlook and Google Contacts offer the same. Once you have the CSV, edit it in Excel, import it into another service, or load it into a CRM or mailing list tool.
To go back, CSV to VCF rebuilds a vCard file from a CSV. If you have several CSV files to combine first, Merge CSV Files does that, and CSV to Markdown shows a CSV as a table for documents.