Skip to content
Free · Runs in your browser

VCF to CSV converter

Turn a contacts file from your phone, Google Contacts or Outlook into a CSV, one row per contact. Your contacts never leave your browser.

Works with
VCFCSV
Opens inExcelGoogle Sheets

Drop a VCF file here

A .vcf or .vcard file from your phone, Google Contacts or Outlook, up to 100 MB. It stays on your computer.

No file to hand?

  • No sign-up
  • No contacts uploaded
  • Every phone and email kept
  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo
What you get

A contact list you can sort and filter.

  • Your contacts stay on your computer

    The file is read and the CSV is written in your browser. Your contacts are never sent to Mammoth or anyone else.

  • A column for each kind of phone

    Mobile, home and work numbers each get their own column, so you can sort by any of them.

  • Reads every phone's export

    iPhone, Android, Google Contacts and Outlook files all work, including accented names in older Android files.

How it works

How to convert VCF to CSV

Each contact becomes a row. Its name, phones, emails and addresses each go into their own columns.

  1. 1

    Add your VCF file

    Drop a .vcf file on the box, or choose one you exported from your phone or contacts app.

  2. 2

    Check the rows

    A preview shows one row per contact, with a column for each phone, email and address.

  3. 3

    Download

    Save the .csv file, or pick a different separator first. The Excel button saves a spreadsheet instead.

Your options

Other ways to do it

Python's vobject library can read a .vcf file too. The difference is the older files that Android phones and Outlook write.

  • Python with vobject

    A script you run yourself

    • Reads Android and Outlook filesNo
    • A column for each kind of phonePartly
    • Contacts stay on your computerYes
    • No code to writeNo
  • This page

    This converter

    A CSV in one step

    • Reads Android and Outlook filesYes
    • A column for each kind of phoneYes
    • Contacts stay on your computerYes
    • No code to writeYes
Other ways

How to convert VCF to CSV in Python

The vobject library reads a .vcf file, and the csv module writes the rows. Here is the whole script.

Want a spreadsheet instead? The VCF to Excel converter makes an .xlsx file. Going the other way? Use the CSV to VCF converter.

Python with vobject
import csv
import vobject

with open("contacts.vcf") as f:
    cards = list(vobject.readComponents(f.read()))

with open("contacts.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow(["Name", "Phone", "Email"])
    for card in cards:
        name = card.fn.value if hasattr(card, "fn") else ""
        phones = [t.value for t in card.contents.get("tel", [])]
        emails = [e.value for e in card.contents.get("email", [])]
        writer.writerow([name, "; ".join(phones), "; ".join(emails)])

Every phone number goes in one cell. Files from older Android phones and Outlook stop the script with a ParseError, because their long values carry on over several lines.

Your file stays private

The converter runs inside this page. Your contacts file is read and turned into a CSV on your computer, and its contents are never sent to Mammoth. We record only what kind of data it was, such as a contact list, and its common column names, never a name, number or address.

How we handle your data

Once the page has loaded, it works with your internet switched off.

Every month

Getting new contact lists every month?

Mammoth can take it from there. Put each month's list in a folder as CSV and Mammoth adds it to one table, with the duplicates removed.

Try Mammoth free

Contact lists

Septembercontacts-sep.csv
Octobercontacts-oct.csv
Novembercontacts-nov.csv
DriveDropboxOneDriveSFTP
All contactsUp to date
+351 912…Ana CostaLisboa
07700 900…Ben EllisLeeds
+33 6 12…Chloé MartinParis
+91 98765…Dev PatelPune
555-0100Blue Door CoffeeAustin

Illustration. Every new file in the folder is added to the same table.

Questions

VCF to CSV questions

Are my contacts uploaded anywhere?
No. The page reads the file and writes the CSV inside your browser. Your contacts are never sent to Mammoth or anyone else, and once the page has loaded it works with your internet switched off.
Which phones and apps does it read?
Any .vcf file: exports from iPhone, Android, Google Contacts, Outlook and Mac Contacts, in vCard 2.1, 3.0 or 4.0. Names with accents in older Android files are decoded, so Chloé stays Chloé.
What columns does the CSV have?
Name, company and job title, then a column for each kind of phone (Mobile, Home phone, Work phone, Fax), each email, and each address split into street, city, region, postal code and country. A column no contact uses is left out.
What if a contact has two mobile numbers?
The second goes in a Mobile 2 column. The same goes for a second email, a second address and a second website.
What happens to contact photos?
They are left out, because a CSV cell cannot hold a picture. Everything else on the contact is kept.
Can I turn the CSV back into a VCF?
Yes. The CSV to VCF converter reads these column names, so a file goes there and back unchanged.
Is it free?
Yes, with no account and no email. Files can be up to 100 MB.