
You’ll then get a pop-up window detailing the number of vCards that have been imported and how long it took, usually just seconds.
Doing that will automatically load and convert the VCF to a CSV file opened in Excel. So navigate to where you have saved your VCF file, select it and click the Open button.
Enabling the Macro will launch an Open dialog prompting you to open a VCF file. In Excel 2007, click the Options button first, then select Enable this content in the pop-up window. In Excel 2010 and later, click on the Enable Content button to allow this script to run. When you open the file, you’ll get a security warning that Macros have been disabled. If it’s not associated, launch Excel first, then use the Open dialog to open the file. The workbook format should be already associated with Microsoft Excel, in which case just double-click to open it. The script is actually a Macro Enabled Microsoft Excel Workbook (*.xlsm) that will allow you to import a VCF (version 2.0, 2.1, 3.0 and 4.0) containing multiple vCards (contacts). Get this Excel VBA Script by Greg Hadlock from SourceForge. Step 2: Convert VCF to CSV using an Excel Macro