How to convert vCard to Excel

vCard format is typically used to store contact details. You can easily convert vCard .vcf files to Excel .xlsx or .xls files with Easy Data Transform:

• Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
• Start Easy Data Transform. Make sure the Auto Run button is pressed in.

• Drag the vCard file you wish to convert onto Easy Data Transform. A pink input item will be added.
• With the pink input item selected, note in the Right pane that one row has been added per contact.
• Ensuring the pink input item is selected, click the To File button in the Left pane (scroll to the bottom of the Left pane).

• A window will appear. Set the new file name and location. Select Excel file (*.xlsx) or Excel file (*.xls) as the file type.

• A green output item is added and selected.

• The Excel file is created immediately at the chosen location, no need to ‘run’ anything.

Example vCard input:

BEGIN:VCARD
VERSION:3.0
N:Gump;Forrest;;Mr.;
FN:Forrest Gump
ORG:Bubba Gump Shrimp Co.
TEL;TYPE=WORK,VOICE:(111) 555-1212
ADR;TYPE=WORK,PREF:100 Waters Edge;Baytown;LA;30314;United States of America
END:VCARD

Example Excel output:

Use the Rename Cols transform before output if you want to rename any of the columns.

If you have multiple vCard files, you can use a Stack transform to combine them before outputting.

If you have a large number of files to convert you can do it using the batch processing feature.

As well as changing file format, Easy Data Transform also allows you to combine 59 transforms (such as filter, de-dupe and join) to quickly and easily create complex data transformations.