9

How to convert vcard (.vcf files) to an Excel Worksheet? There are several vcards . How to import all of them to Excel at once?

1
6

After downloading the vcard2xls combine all the contacts into 1 file by following the steps below.

Step 1. First Copy all your .vcf files into one directory.

Step 2. Open Windows command prompt and navigate to the folder destination

You can type the CD **YOUR PATH** command to reach to your destination

Step 3. Enter the following DOS command: copy *.vcf all.vcf

The all.vcf file will be created

Step 4. Open the vcard2xls and open this all.vcf file. It will be converted into xls format and then save it.

Finally you will get a .xls file with all the contacts in one file.

3
  • 2
    alternately, depending on what format you need, you can perform steps 1-3 and then import it into your mail program and then export it out as .csv with the correct headers for your contacts. Dec 23 '13 at 16:39
  • 1
    If exporting from OSX Address Book to get a big .vcf file, change its VCF preferences to vCard Format 2.1.
    – brasofilo
    Apr 29 '15 at 15:48
  • 1
    I would like to add that vcard2xls didn't work for me, it didn't import all contacts (156/714). I used VCF Import v3.xlsm and it imported all contacts. Other tools didn't helped.
    – Davidenko
    Jul 7 '15 at 5:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.