dauntexlabs

VCF to CSV Converter

Convert vCard (.vcf) contacts to CSV for Excel, Google Contacts or Outlook — runs in your browser.

Runs on your deviceFreeNo sign-up
Runs in your browser
Loading tool…

Designed to run in your browser. See the privacy policy.

About VCF to CSV Converter

A .vcf file (also called a vCard) is the standard way phones and email apps export contacts. iPhone, Android, iCloud, Outlook and most address books can save your contacts as one .vcf file holding every card. Spreadsheets and many import screens, though, want a CSV file with one contact per row. This tool converts a VCF file to CSV so you can open your contacts in Excel or Google Sheets, clean them up, or move them to another service.

It reads vCard versions 2.1, 3.0 and 4.0, including files with many contacts, long lines that are wrapped across several lines, and older Android exports where names with accents are stored as quoted-printable text. Names, email addresses, phone numbers with their type, company, job title, postal addresses, birthday, website and notes are kept. Photos are left out.

Contact lists are personal data, so the conversion runs in your browser: the file is processed on your device rather than on a server.

How to use

  1. Drop your .vcf file onto the box, or click it to choose the file. You can also paste vCard text into the box below it.
  2. Pick a column layout: Generic for spreadsheets, Google Contacts for importing into Gmail, or Outlook for importing into Outlook.
  3. Check the preview of the first 20 contacts and the count of contacts read and skipped.
  4. Click Download CSV and open the file in Excel or Google Sheets, or import it into your contacts app.

FAQ

How do I convert a VCF file to Excel?+
Convert it to CSV here with the Generic layout, then open the downloaded CSV in Excel. Each contact becomes one row, with separate columns for each email address, phone number and address. The file is saved as UTF-8 with a byte order mark so Excel shows accented names correctly.
How do I import VCF contacts into Gmail or Google Contacts?+
Google Contacts can import a .vcf file directly. If you want to review or edit the contacts first, choose the Google Contacts layout, download the CSV, edit it in a spreadsheet, and then use Import in Google Contacts. The columns use the names Google expects, such as Given Name, E-mail 1 - Value and Phone 1 - Value.
What does the Outlook layout do with extra phone numbers?+
Outlook has fixed columns: three email addresses, one number per kind (mobile, home, business, fax, pager, other) and one home and one business address. Anything that does not fit in those columns is added to the Notes column so it is not lost.
Why were some contacts skipped?+
A card is skipped when it is cut off (it has no END:VCARD line) or has no name, email, phone or company at all. The tool tells you how many were skipped so you can check the original file.
Does it work with an iPhone or Android contacts export?+
Yes. iPhone and iCloud exports use vCard 3.0, and Android exports often use vCard 2.1 with quoted-printable names. Both are read, along with vCard 4.0 files that store phone numbers as tel: links.

More in Data Tools

Data Tools

Base64 Encode / Decode

Encode and decode Base64 strings with built-in validation.

Data Tools

URL Encode / Decode

Percent-encode URLs and untangle query parameters.

Data Tools

JWT / JWS Token Tool

Decode, verify and sign JWT / JWS with HS256, HS384 and HS512.

Data Tools

File Viewer & Previewer

Preview Markdown, HTML, JSON, XML, CSV and YAML in real time.

Data Tools

Encryption & Decryption

AES, PGP/RSA, HMAC, SHA, ROT13 and Caesar — all client-side.

Data Tools

Base58 & Base32 Encoder

Encode and decode text with Base58 and Base32.