VCF to Excel converter
Turn a contacts file from your phone, Google Contacts or Outlook into an Excel spreadsheet, one row per contact. Your contacts never leave your browser.
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
- Phone numbers kept as written
A contact list you can sort and filter.
Your contacts stay on your computer
The file is read and the spreadsheet is built 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, written as text so Excel keeps the + and the leading 0.
Reads every phone's export
iPhone, Android, Google Contacts and Outlook files all work, including accented names in older Android files.
How to convert VCF to Excel
Each contact becomes a row. Its name, phones, emails and addresses each go into their own columns.
- 1
Add your VCF file
Drop a .vcf file on the box, or choose one you exported from your phone or contacts app.
- 2
Check the rows
A preview shows one row per contact, with a column for each phone, email and address.
- 3
Download
Save the .xlsx file and open it in Excel, Google Sheets or Numbers.
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 and pandas
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 spreadsheet in one step
- Reads Android and Outlook filesYes
- A column for each kind of phoneYes
- Contacts stay on your computerYes
- No code to writeYes
How to convert VCF to Excel in Python
The vobject library reads a .vcf file, and pandas writes the spreadsheet. Here is the whole script.
Need a CSV instead? The VCF to CSV converter lets you pick the separator. Going the other way? Use the CSV to VCF converter.
import pandas as pd
import vobject
with open("contacts.vcf") as f:
cards = list(vobject.readComponents(f.read()))
rows = [
{
"Name": card.fn.value if hasattr(card, "fn") else "",
"Phone": "; ".join(t.value for t in card.contents.get("tel", [])),
"Email": "; ".join(e.value for e in card.contents.get("email", [])),
}
for card in cards
]
pd.DataFrame(rows).to_excel("contacts.xlsx", index=False)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 spreadsheet 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.
Once the page has loaded, it works with your internet switched off.
Getting new contact lists every month?
Mammoth can take it from there. Put each month's spreadsheet in a folder and Mammoth adds it to one table, with the duplicates removed.
Contact lists
| September | +351 912… | Ana Costa | Lisboa | |
| September | 07700 900… | Ben Ellis | Leeds | |
| October | +33 6 12… | Chloé Martin | Paris | |
| November | +91 98765… | Dev Patel | Pune | |
| November | 555-0100 | Blue Door Coffee | Austin |
Illustration. Every new file in the folder is added to the same table.