How to open .VCF files?

 

Below are the steps to open a VCF file in Excel.

 

Click on the File tab at the top left corner and then click Open.

file open

Click the drop-down menu at the bottom, right corner of the window and then click All File. Select all the VCard file that you want to import into Excel and then double-click the file.

sample vcf file

Note: All of the files are already displayed in MS Excel 2013 and higher.

Click Delimited at the top of the window and then click Next.

delimited

Click on the Tab option in the Delimiter at the top of the window and then click Next.

click next

Click General option in the Column Data Format section and then click Finish.

click finish

Further reading: 
How to import xlam?
Top 25 MS EXCEL Interview questions you must know
How to Create Your Own Function?