Excel to vCard Format – Import Excel Contacts to VCF

Need for Excel to vCard Conversion

It’s always better to save contacts in a unified format supported by a wide range of devices and programs. And vCard is the most popular and highly supported format. It has replaced the Excel file, which was commonly used for storing contacts.

To export all the contacts from an Excel file to vCard format, you can try two different solutions:

• Either an easy manual trick
• Or a third-party Excel to vCard Converter tool

I always recommend the manual tricks before using any 3rd party tool. Sometimes the manual tricks resolve our issues without requiring any other tool. Though a manual trick is considered the most inexpensive way, but it may sometimes require higher human efforts and enough time while execution. If any sort of mistake or error takes place while performing any manual trick, this may lead to loss of crucial data and information.

To perform the manual trick, you need to convert Excel to CSV (Comma Separated Values) format first. It’s very simple.

Convert Excel to CSV in just four steps:

Step 1: First of all, open Microsoft Excel on your system. Now open the Excel spreadsheet containing your contacts information. 

Click Office button (on the top) > Save As > Other Formats. Or, you may simply press F12 button.

Step 2: Select a new location where you want to save the file. You may also give a new name to this file.

Now select Save as type: CSV (Comma delimited) (*.csv). Click Save.

Step 3: You’ll see an error message on your screen saying the selected workbook contains multiple sheets.

To save only the active sheet, click OK.

Step 4: Now finally click Yes to keep the selected workbook in the same format.

This will convert Excel file into CSV format without causing any changes or damage to contacts information because it keeps the original file intact while conversion. Now you need to import all the contacts from this new CSV file to your system. And then, you can export the contacts to VCF files.

Import contacts to your system

Step 1: Click Start button > type Contacts on the search bar.

Click Contacts under Programs.

Step 2: On the Contacts window, click Import tab.

Step 3: On the Import to Windows Contacts pop-up window, select CSV (Comma Separated Values).

Then click Import to continue the process.

Step 4: Now locate the *.csv file on your system.

Click Browse button to browse the location.

Step 5: Select the *.csv file which you want to import.

Click Open to confirm your selection.

Step 6: You can see the selected CSV file in the edit box.

Now click Next to continue the process.

Step 7: Now map the text field and contacts field.

Click the box of Name of the Employee.

Step 8: Select a Contact field for the text field: Name of the Employee.

Select Name in the options and click OK.

Step 9: Click OK to confirm your selection.

Step 10: Map all the fields you want to import.

Finally, click Finish once the mapping is done.

Step 11: Now click Close to end the import process.

Export contacts to VCF files 

Step 1: Again on the Contacts window, select all the contacts which you want to export to VCF.

Then click Export tab.

Step 2: On the Export Windows Contacts window, select vCards (folder of .vcf files) in the options.

Click Export to continue the process.

Step 3: Select the location at which you want to save these contacts.

You may create a new folder to save the contacts at any desired location. Click OK to confirm your selection.

Step 4: Within a few seconds, all your selected contacts will be exported in VCF format at your desired location.

Step 5: Now click the Close button to end the export process.