How to Convert VCF Files to CSV: A Simple Step-by-Step Guide
The fastest way to convert VCF to CSV is to upload your vCard file to a free online VCF to CSV converter, click convert, and download the CSV. The whole thing takes under a minute, and the result opens directly in Excel, Google Sheets, or any CRM import screen. If you'd rather not use a web tool, Outlook, Google Contacts, and a little manual editing in a spreadsheet will also get you there.
This guide walks through each option, then covers the messy parts nobody mentions: files with hundreds of contacts, missing phone numbers, and the checks you should run before importing anything.
A VCF file is a vCard, the standard format phones and email apps use to store and share contacts. Each entry holds a person's name, phone numbers, email addresses, company, job title, physical address, website, and sometimes a photo or notes.
When you export contacts from an iPhone, Android device, Gmail, Outlook, or iCloud, you usually get a .vcf file. One file can hold a single contact or your entire address book stacked together.
The catch is that VCF is built for contact apps, not for people. Open one in a text editor and you'll see lines like FN:Sara Ahmed and TEL;TYPE=CELL: 92300..., which is fine for software but hard to sort, filter, or edit in bulk.
A CSV file (comma-separated values) is a plain-text table. Each line is one record, and commas separate the columns. Convert a VCF contact file to CSV and you get one row per contact with columns for name, phone, email, company, and so on.
Because it's so simple, almost everything reads it. Excel, Google Sheets, Numbers, Mailchimp, HubSpot, Salesforce, Gmail, and Outlook all import CSV contact lists without any special setup. That's why CSV is the go-to format when you need to move contacts between systems or clean them up in bulk.
You convert vCard to CSV whenever you need to work with contacts as data rather than as individual cards. The most common reasons:
Managing large contact lists. Scrolling through 800 contacts on a phone is painful. In a spreadsheet you can sort by company, search by city, and spot duplicates in seconds.
Opening contacts in Excel or Google Sheets. VCF won't open as a table. CSV will, which is why many people search for "VCF to Excel" and end up here.
Cleaning and organizing data. Fix inconsistent phone formats, merge duplicate entries, fill in missing emails, and delete old contacts in one pass.
Importing into other systems. Most CRMs, email marketing tools, and helpdesks accept CSV but not VCF. Converting first is often the only way to get your contacts in.
Backing up or sharing. A CSV backup is readable on any device, and you can hand a filtered list to a colleague without exposing your whole address book.
An online VCF to CSV converter is the quickest route if you don't want to install anything. OCRNest's free VCF to CSV converter runs in your browser, needs no account, and handles files up to 50 MB.
Here's how to use it:
Open the tool. Go to ocrnest.com/vcf-to-csv in any browser, on desktop or mobile.
Add your VCF file. Drag the .vcf file into the upload box, click Browse to pick it from your device, or paste the vCard text directly. You can add up to 5 files at once.
Click Convert. The tool reads every contact in the file and maps each field to its own CSV column: name, phone, email, company, job title, address, website, and notes.
Download the CSV. Click the download button and save the file. It opens straight away in Excel, Google Sheets, or your CRM's import screen.
A few things worth knowing before you upload:
Bulk files are fine. A VCF with hundreds of contacts becomes one CSV with one row per contact, so you don't need to split anything first.
It works with any common export. Contacts saved as VCF from iPhone, Android, Gmail, Outlook, or iCloud all convert the same way.
Missing details become empty cells. If a contact has no email, that cell stays blank rather than breaking the row, which makes gaps easy to spot later.
Need Excel instead? The same site has a VCF to Excel converter that produces a native .xlsx file.
On privacy: files are processed within your browser session, and OCRNest's privacy policy explains how uploads are handled. That said, it's sensible to think twice before uploading a highly sensitive client list to any online service. For those cases, the offline methods below keep everything on your own machine.
If you prefer to stay offline, or you already use a contact app that can do the job, these methods work too. They take a bit longer but need no third-party tools.
Open contacts.google.com and click Import in the left menu.
Select your .vcf file and import it. Google reads multi-contact files without complaint.
Click Export, choose Google CSV or Outlook CSV, and download.
This is a solid option for large files. The downside is that your contacts land in your Google account along the way, so you may want to delete them afterwards if they don't belong there.
Double-click the .vcf file to open it in Outlook, then click Save & Close to add it to your contacts. Repeat for each contact if the file holds several.
Go to File → Open & Export → Import/Export.
Choose Export to a file, then Comma Separated Values, select your Contacts folder, and save.
Outlook's import handles one vCard at a time, which is fine for a handful of contacts and tedious for a full address book.
For a very small file, you can skip conversion tools entirely. Open the .vcf in Notepad or TextEdit, copy the lines, and paste them into a spreadsheet. Then use Text to Columns (Excel) or Split text to columns (Sheets) with the colon as the separator.
You'll still need to rearrange the data so each contact sits on one row, so this only makes sense for five or ten contacts. Anything larger and an online VCF file converter saves real time.
Most exported VCF files hold more than one contact. Inside the file, each contact sits between its own BEGIN:VCARD and END:VCARD lines, one after the other. A good converter reads those boundaries and writes one CSV row per contact, so a 500-contact file becomes a 500-row spreadsheet.
If your converted CSV shows only one contact, the tool you used probably stopped at the first card. Try a converter that explicitly supports bulk contacts, or import through Google Contacts, which handles multi-contact files reliably.
The opposite problem also happens: some phones export one .vcf per contact, leaving you with dozens of files. OCRNest accepts up to 5 files per batch, which helps, but for a large pile of single-contact files the simplest fix is to merge them first. On Windows, open Command Prompt in that folder and run copy *.vcf all.vcf; on Mac or Linux, run cat *.vcf > all.vcf in Terminal. Then convert the one combined file.
A clean conversion still reflects whatever was in the original file. Here's how to handle the common problems once the CSV is open in a spreadsheet.
Blank name cells. Some contacts are saved with only a phone number or an email. Filter the Name column for empty cells, then fill in names from the email address or delete entries you no longer need.
Phone numbers that lost their leading zero or plus sign. Excel treats numbers as numbers, so 92 300 1234567 can turn into 923001234567 or even 9.23E 11. To avoid this, import the CSV through Data → From Text/CSV and set the phone column to Text, or open it in Google Sheets, which is gentler with phone formats.
Several numbers for one contact. A vCard can hold mobile, work, and home numbers. A good converter splits these into separate columns; a basic one may stuff them into a single cell separated by semicolons. If that happens, use Text to Columns on that cell range.
Garbled characters in names. If names with accents or non-Latin scripts show as é or question marks, the file was opened with the wrong encoding. Re-import it and choose UTF-8 when prompted.
Duplicate contacts. Sort by phone number or email, then use Remove Duplicates in Excel or the "Merge & fix" feature in Google Contacts after import.
Take two minutes to review the file before you push it into a CRM or email tool. Fixing problems in a spreadsheet is far easier than fixing them after import.
Row count matches. If your phone said 412 contacts, the CSV should have 412 rows plus a header. A big gap means some contacts were skipped.
Headers match the destination. Most systems expect specific column names such as First Name, Last Name, Email, Phone. Rename yours to match, or use the import tool's field mapping screen.
One contact per row. Scan for rows where a second person's details have spilled into the notes or address columns.
Phone numbers kept their format. Spot-check a few international numbers for a missing or leading zero.
No stray commas or line breaks in fields. Addresses and notes often contain commas. They should be wrapped in quotes in the CSV; if a row looks shifted, that's usually why.
File is saved as UTF-8 CSV. In Excel, choose CSV UTF-8 (Comma delimited) rather than plain CSV to keep accented names intact.
Run a test import with the first 10 rows if the destination allows it. If those look right, import the rest.
Yes. OCRNest's VCF to CSV converter is free and doesn't ask you to create an account. Google Contacts and Outlook also do it at no cost if you already use them.
Yes. Export your contacts as a .vcf file from the Contacts app (iPhone: iCloud.com → Contacts → Export vCard; Android: Contacts → Settings → Export), then upload that file to the converter from your phone's browser.
A CSV opens in Excel, so for most people that's enough. If you want a native .xlsx file with proper column formatting, use a dedicated VCF to Excel converter instead.
Yes. CSV is text-only, so embedded photos are dropped during conversion. Everything else, including notes and multiple phone numbers, carries over.
Yes. Google Contacts, Outlook, and several online tools can import a CSV and export it as vCard. Keep your original .vcf file as a backup anyway until you've confirmed the import worked.