How to Convert VCF to CSV
In short: To convert VCF to CSV, import the .vcf into Google Contacts, then export it as a CSV, since a VCF will not open in Excel on its own. Windows Contacts can also import a vCard and export CSV. For many files, older vCard versions or a full-field copy, a vCard converter does it in one step.
Why a VCF will not open in Excel
A VCF file, also called a vCard, stores contact details such as name, phone, email, company and address. The trouble is that it is built for address books, not spreadsheets. Double-click one and Windows tries to add it to Contacts, while Excel cannot read it as a table. To get your contacts into a spreadsheet, a CRM or a mail merge, you first need CSV, a plain-text format that Excel, Google Sheets, Outlook and most tools open. The methods below take you there, from a quick free route for a few contacts to a bulk tool for hundreds.
Technical Executive and Staff Writer, Corbett Software
“The mistake people make is trying to open a VCF straight in Excel, which never works. The clean free way is to run it through Google Contacts, which exports a proper CSV. Copying fields by hand loses phone numbers and photos. Older vCards with accented names can also arrive garbled, so for a real address book I use a converter that reads every version.”
Convert VCF to CSV with Google Contacts
This is the cleanest free method. It works from any browser.
- Go to contacts.google.com and sign in.
- On the left, click Import, choose Select file, pick your .vcf file, then Import.
- Select the imported contacts, click Export, choose a CSV type, then download.
Google offers three CSV formats. Pick Google CSV to import into another Google account, Outlook CSV for Excel and Outlook or a Yahoo-friendly CSV for Yahoo Mail. If you do not want the contacts left in your Google account, delete them there after the export.
Convert VCF to CSV with Windows Contacts
Windows has a built-in address book that does the job without a browser.
- Press Windows + R, type shell:contacts and press Enter to open the Contacts folder.
- Click Import, choose vCard (VCF), pick your file and import it. A vCard with several contacts shows one confirmation each, so keep clicking through.
- Click Export, choose CSV, tick the fields you want to keep and Save.
Convert VCF to CSV in bulk
The free routes handle a few contacts well, but they get slow with a large file, several .vcf files or older vCard versions. For those, a dedicated converter reads the vCards and writes a clean CSV in one pass.
The Corbett vCard Converter opens single or multiple VCF files, previews every contact and exports them to CSV, with all fields kept. It reads vCard 2.0, 2.1, 3.0 and 4.0, splits a large file or merges many into one, lets you search and select specific contacts, then offers a free demo edition on every edition of Windows.
- Install and open the tool, then choose Choose Files or Choose Folders and add your VCF files.
- Preview the contacts in the panel to check the details.
- Click Export, pick CSV, choose a location and Save.
Keep every field and fix garbled names
Two things catch people out with the manual routes. First, copying a vCard into a spreadsheet by hand often keeps the name and email but drops phone numbers, addresses, job titles and photos, so use a method that maps every field, such as the Google Contacts export or a converter. Second, older vCards saved with quoted-printable or MIME encoding can turn accented names into garbled characters in a plain export. A converter that understands every vCard version reads those correctly. If your contacts are spread across several files, first combine the VCF files into one, then convert the single file.
Move phone contacts to a spreadsheet
A common reason to do this is getting contacts off a phone and into a spreadsheet. On an iPhone, contacts sync to iCloud, where you can export them as a vCard and then convert that to CSV. On Android, they sync to Google Contacts, so you can export CSV directly. Once you have the CSV, it drops straight into Excel or imports into Outlook and Google. Our guide on how to export iPhone contacts to CSV walks through the phone side in detail.
Frequently asked questions
How do I convert a VCF file to CSV for free?
Import the .vcf into Google Contacts, then export the contacts as a CSV. Windows Contacts does the same offline: open shell:contacts, import the vCard and export CSV. Both are free.
Why will my VCF file not open in Excel?
A VCF is a contact file for address books, not a spreadsheet, so Excel cannot read it as a table. Convert it to CSV first, then open the CSV in Excel.
How do I convert multiple VCF files to CSV at once?
Combine the files into one vCard first and convert that. You can also use a converter that takes a folder of VCF files and exports them all to CSV in one pass.
Why are the names in my converted CSV garbled?
Older vCards use quoted-printable or MIME encoding for accented characters, which a plain conversion can misread. Use a converter that reads every vCard version, from 2.0 to 4.0, to keep the names correct.
Which CSV format should I choose?
Google CSV suits importing into another Google account, Outlook CSV suits Excel and Outlook, while a Yahoo CSV suits Yahoo Mail. For a plain spreadsheet, Outlook CSV is the safe pick.
Will converting keep phone numbers and photos?
A field-mapped export like Google Contacts CSV or a converter keeps phone numbers, addresses and job titles. Contact photos are often dropped by simple text conversions, so use a full converter if photos matter.