VCF to CSV for Gmail/Google Contacts (2026): Merge Multiple vCards + Keep Phone Fields Clean

VCF (vCard) is the universal contact format, but bulk editing and importing to Gmail/Google Contacts is easier with CSV. Converting VCF to CSV allows you to clean data in Excel, merge duplicate contacts, and mass-import without losing phone numbers, addresses, or email fields.

What is a VCF/vCard File?

VCF (Virtual Contact File) stores contact information in vCard format—an open standard supported by:

✅ Gmail / Google Contacts
✅ Outlook / Exchange
✅ Apple Contacts (macOS/iOS)
✅ Android address books
✅ Thunderbird

A typical vCard looks like:

BEGIN:VCARD
VERSION:3.0
FN:John Doe
N:Doe;John;;;
TEL;TYPE=CELL:+1-555-123-4567
TEL;TYPE=WORK:+1-555-987-6543
EMAIL;TYPE=WORK:john.doe@company.com
ORG:ACME Corporation
TITLE:Software Engineer
END:VCARD

Why Convert VCF to CSV?

Use Cases

Bulk editing: Fix phone formats, add missing fields (Excel)
Merge duplicates: Combine contacts from multiple sources
CRM import: Salesforce, HubSpot require CSV
Backup and migration: Move iPhone → Android, Outlook → Gmail
Data cleaning: Remove old contacts, standardize formats

VCF to CSV for Gmail/Google Contacts

Google Contacts CSV Format

Google Contacts expects specific column names. Required columns:

Column Name	vCard Field	Example
Name	`FN`	John Doe
Given Name	`N` (first)	John
Family Name	`N` (last)	Doe
E-mail 1 - Value	`EMAIL`	john@example.com
Phone 1 - Value	`TEL`	555-123-4567
Organization 1 - Name	`ORG`	ACME Corp

Multiple phone numbers: Use Phone 1 - Value, Phone 2 - Value, etc.

Multiple emails: E-mail 1 - Value, E-mail 2 - Value, etc.

Import Steps (after conversion)

Open Google Contacts
Left sidebar → Import
Choose your CSV file
Click Import

⚠️ Important: Use UTF-8 encoding when saving CSV (Excel default is sometimes Windows-1252, which breaks special characters).

Handling Multiple vCard Files

Scenario: 100 Separate .vcf Files

Your phone exports each contact as a separate file:

John_Doe.vcf
Jane_Smith.vcf
Bob_Johnson.vcf
...

Solution 1: Merge First, Then Convert

macOS/Linux:

cat *.vcf > all_contacts.vcf

Windows (PowerShell):

Get-Content *.vcf | Set-Content all_contacts.vcf

Solution 2: Batch Convert

Use our VCF to CSV Converter with drag-and-drop for multiple files—automatically merges into one CSV.

Common VCF to CSV Issues & Fixes

Issue 1: Phone Numbers Lose Formatting

Problem: +1-555-123-4567 becomes 15551234567 (Excel strips formatting)

✅ Fix: In Excel, format phone column as Text (not Number) before import:

Select phone columns
Format Cells → Text
Or prefix with single quote: '555-123-4567

Issue 2: Special Characters Break (ñ, é, ü, etc.)

Problem: "José García" becomes "JosÃ© GarcÃa"

✅ Fix: Save/export CSV as UTF-8:

Excel: Save As → CSV UTF-8 (not regular CSV)
Google Sheets: File → Download → CSV (automatically UTF-8)
Text editor: Set encoding to UTF-8

Issue 3: Multiple Phone Numbers Overwrite Each Other

Problem: Contact has 3 phone numbers, CSV only shows 1

✅ Fix: Create separate columns:

Name,Phone 1 - Type,Phone 1 - Value,Phone 2 - Type,Phone 2 - Value
John Doe,Mobile,555-123-4567,Work,555-987-6543

Issue 4: Line Breaks in Address Field

VCF:

ADR;TYPE=HOME:;;123 Main St;Seattle;WA;98101;USA

CSV export: Wrap multi-line values in double quotes:

"123 Main St
Seattle, WA 98101
USA"

Issue 5: Duplicate Contacts After Import

Cause: Same contact in multiple VCF files

✅ Fix: Before converting:

Import VCF to Google Contacts first
Use Google's built-in "Merge & fix" tool
Then export clean CSV

Or in Excel after conversion:

Remove duplicates based on Email column
Data → Remove Duplicates

Advanced: vCard Field Mapping

Name Fields (N vs FN)

FN (Formatted Name): "John Michael Doe Jr."
N (Structured): Doe;John;Michael;Jr.;
- Family Name (last)
- Given Name (first)
- Middle Name
- Prefix (Mr., Dr.)
- Suffix (Jr., III)

Phone Type Indicators

TEL;TYPE=CELL:555-123-4567    → Mobile
TEL;TYPE=WORK:555-987-6543    → Work
TEL;TYPE=HOME:555-111-2222    → Home
TEL;TYPE=FAX:555-333-4444     → Fax

Email Categories

EMAIL;TYPE=WORK:john@company.com  → Work email
EMAIL;TYPE=HOME:john@gmail.com    → Personal email

Address Structure (ADR)

ADR;TYPE=WORK:;Suite 100;123 Business Ave;Seattle;WA;98101;USA
             └─┬──┘  └───┬────┘ └──────┬───────┘ └──┬──┘└┬┘└──┬─┘└─┬─┘
               │         │             │            │   │   │    │
           P.O. Box  Extended     Street        City State Zip Country

Excel Cleaning Tips

1. Standardize Phone Formats

Remove all non-digits, then reformat:

=TEXT(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),"(",""),")","")),"(###) ###-####")

2. Split Full Name into First/Last

First Name: =LEFT(A2, FIND(" ", A2)-1)
Last Name: =RIGHT(A2, LEN(A2)-FIND(" ", A2))

3. Remove Empty Rows

Select all data
Data → Filter
Filter Name column → Uncheck (Blanks)

4. Merge Duplicate Contacts

Sort by email, then manually merge or use Excel add-ins like Remove Duplicates.

Reverse: CSV to VCF

After editing in Excel, convert back to VCF for import to iPhone/Android:

Use our CSV to VCF Converter
Map columns (Name → FN, Phone 1 → TEL, etc.)
Download VCF file
Import to phone or email yourself the VCF

Platform-Specific Import Notes

Outlook (Desktop)

File → Open & Export → Import/Export
Choose "Import from another program or file"
Select Comma Separated Values
Map columns if prompted

Apple Contacts (macOS)

File → Import → select CSV
Map fields (First Name, Last Name, etc.)
Click OK

Note: Apple Contacts prefers VCF—consider direct VCF import instead.

Salesforce

Setup → Data Import Wizard
Choose Contacts
Upload CSV
Map "Name" → "FirstName" and "LastName" (must split!)

FAQ: VCF to CSV Conversion

Can I convert multiple VCF files at once?

Yes—merge them into a single VCF first (cat *.vcf > all.vcf), then convert. Or use our multi-file converter.

Why do some contacts have missing fields?

Source VCF may not have included those fields. In CSV, they'll be blank—you can fill them in manually or with Excel formulas.

How do I handle contacts with photos?

vCard supports embedded photos (PHOTO field, Base64-encoded). Most CSV conversions skip photos—reimport as VCF to preserve them, or extract photos separately.

What's the maximum number of contacts Gmail supports?

Google Contacts has a 25,000 contact limit (as of 2026). For larger datasets, split your CSV into multiple files.

ICS to CSV (2026): Convert Calendar Events to Excel - Similar structured personal data conversion
SQL to JSON (2026): Database to API Format - Transform structured data for modern apps
HAR to CSV (2026): Network Log Analysis - Another practical CSV export guide

Can I convert VCF to Excel directly?

Yes—convert to CSV first, then open in Excel. Or use Excel's "Get Data" → "From Text/CSV" for better encoding control.

Related Converters

CSV to VCF — Reverse conversion
ICS to CSV — Convert calendar events
JSON to CSV — Other data formats

Conclusion

Converting VCF to CSV unlocks powerful contact management capabilities in Excel and Google Sheets, enabling bulk editing, duplicate merging, and easy CRM imports. The key challenges—preserving phone number formatting, handling special characters with UTF-8, and mapping multiple phone/email fields—are all solvable with proper conversion tools and CSV formatting. Use our VCF to CSV Converter for instant conversion with automatic multi-file merging, proper field mapping for Gmail/Google Contacts, and UTF-8 encoding for international characters. Whether migrating contacts between platforms, cleaning up your address book, or importing to CRM systems, VCF to CSV conversion is the essential first step.