How to Convert a vCard File to Excel and Keep the Columns Clean

To convert a vCard file to Excel, import the VCF into a contacts app or service, then export CSV or an Excel workbook. For a CSV, use Excel’s Data > From Text/CSV, open Transform Data, set phone, postal, and identifier columns to Text, choose Replace Current, then Close & Load.

Keep the original VCF. The conversion earns your trust when the second phone number and the leading zero survive.

See what a VCF holds

If Excel shows a stack of contact properties, you’re looking at text, not yet a useful contact table. RFC 6350’s contact structure puts each vCard 4.0 record between BEGIN:VCARD and END:VCARD, requires FN for the formatted name, and allows TEL and EMAIL properties. More than one phone or email can belong to the same person.

Here’s a fictional contact, with its literal vCard lines preserved:

BEGIN:VCARD
VERSION:4.0
FN:Juniper Vale
TEL;TYPE=cell;VALUE=uri:tel:+1-202-555-0147
EMAIL;TYPE=work:[email protected]
END:VCARD

What to look for:

• One BEGIN and END pair per person.
• A name, phone, and email that each need their own column.
• Any extra TEL or EMAIL lines, which need their own destination too.

For the broader file format question, our guide to vCard and VCF files explains the starting point.

Pick a route from VCF to CSV

Choose by where the contacts live and whether you’re willing to import them into a cloud account.

Convert on a Mac with Contacts and Numbers

Apple documents three ways to import a VCF into Contacts: double click the file, drag it into Contacts, or choose File > Import, then Add. Once the contacts are there, select the ones you need.

Apple’s export instructions let you drag selected contacts into Numbers, then export an Excel, CSV, TSV, or Numbers file. Choose Excel for a workbook you’ll review, or CSV for the text import steps below.

Export contacts from an iPhone or iCloud

On iPhone, Apple documents exporting a contact list: open Contacts, select the list, choose Export, select the fields, choose Done, then send or save the exported contact cards. Choose those fields deliberately. A worksheet can’t recover a detail you left out of the export.

Continue with that file on a computer, using the Mac route or Google Contacts if cloud import is acceptable.

For contacts already in iCloud, Apple says you can export selected or all contacts as one vCard from a computer. Importing a vCard containing several people into iCloud creates a separate contact entry for each person, so one VCF file can hold many contacts and should not mean one worksheet row.

Convert with Google Contacts

Google Contacts on a computer accepts VCF or CSV imports through Import > Select file. Import your VCF, then review the contacts you intend to export. Google warns that importing more than 3,000 contacts at once can cause problems and recommends splitting larger imports into multiple CSV files.

Select the contacts, then follow Google’s Google CSV export route: More actions > Export > Google CSV > Export. This suits someone working on a Windows computer who is comfortable putting the contacts in Google’s service.

If the starting point is Google Contacts on Android, Google documents exporting accounts to VCF: Contacts > Menu > Settings > Export, choose one or more accounts, then export. Take that VCF to the computer route above.

If cloud import isn’t acceptable and you don’t have the Mac apps, keep the VCF and get a documented contact export from the source system.

Import the CSV into Excel as Text

Microsoft’s documented text and CSV import offers Transform Data before the worksheet load. Use it instead of opening the CSV directly. Follow Microsoft’s Text column import sequence:

1. In Excel, choose Data > From Text/CSV, select the CSV file, and choose Import.
2. Inspect the delimiter and preview. Check that the header and values divide into the columns you expect.
3. Choose Transform Data to open Power Query/Query Editor. The documented older preview interface calls this Edit.
4. In the editor, select phone, postal, and other identifier columns. Choose Home > Transform > Data Type > Text.
5. Choose Replace Current to replace the current type conversion step.
6. Choose Home > Close & Load to load the result into the worksheet.

Excel can remove leading zeros, change phone or postal values, and turn long values into scientific notation when it treats text as numbers. A display format cannot restore digits already discarded, so set Text during the import.

Set up the columns

For the fictional Juniper contact, this literal CSV illustrates the intended columns. It is an illustration, not Google’s exact import template:

Full Name,Phone,Email,Postal Code
Juniper Vale,+1-202-555-0147,[email protected],00123

What to look for:

• Full Name, Phone, and Email map to FN, TEL, and EMAIL.
• The plus sign stays on the phone number.
• The Postal Code column is a separate fictional value, included only to show a leading zero that must stay Text.

If you’re building a file for Google contact import, use Google’s own template guidance instead of copying these headers. Google says to keep its header row, creates a contact for each row containing entered data, and permits extra columns for multiple phone numbers or email addresses.

Keep separate numbered or extra phone and email columns when the bridge produces them. RFC 6350 allows repeated TEL and EMAIL properties, so a second value is contact data, not clutter.

Check the worksheet against the VCF

Before saving the reviewed XLSX, compare the worksheet with the untouched VCF and the bridge export:

1. Compare the contact count.
2. Inspect a person with more than one phone or email.
3. Check notes, an accented name, a phone starting with a plus sign, and a postal value starting with zero, where those occur in your data.

For each value you check, confirm who it belongs to. Finding it somewhere in the workbook isn’t enough.

Fix lost zeros and plus signs

If 00123 has become 123, or the phone has lost its plus sign, return to the intact CSV and repeat the editor sequence with the affected columns set to Text. Microsoft explains why formatting cannot recover discarded digits.

Find a missing detail after a Google import

Google recommends checking the contact’s Notes section. Compare with the original export before deleting a column that looks empty.

Fix broken accents before an Outlook import

If your next step is an Outlook contact import and its preview shows broken accented characters, Microsoft recommends UTF 8 for the CSV. Cancel, convert the file to UTF 8, and restart.

If a heading or field is missing, Microsoft’s Outlook guidance requires headings in the first row and advises returning to the source when needed information is absent from the CSV.

Save as XLSX or CSV

Save the checked sheet as XLSX when the job is a worksheet someone will sort, review, or hand to a colleague. Keep the original VCF and the bridge export beside it so a later correction starts with intact data.

Choose CSV when the next system needs a flat contact file. Outlook’s documented CSV contact import is one such handoff. For the general flat export route, follow our vCard to CSV instructions.

For contact details you’ll keep updating after sharing, Zapped offers a digital vCard shared by link, QR code, or NFC tap, with shared destinations that can point to the latest profile after edits. Keep the reviewed XLSX for the static record and use the live card for details you’ll continue updating.