News We Recently Launched AD Migrator and AD Reporter.

How to Convert Excel Contacts to vCard?

Convert Your Excel File Contacts to vCard File Format Using This stepwise Guide

Pre-Requisites:

STEP 1

Go to Start menu » Programs » SysTools Excel to vCard Converter » SysTools Excel to vCard Converter

excel-to-vcard

STEP 2

Click on the Browse button to select an MS Excel file. Then, the software will display the following screen. Select the desired MS Excel file and click on the Open button.

browse-excel-contacts

Note: To browse files other than (XLSX, XLS, CSV, XLA, XLAM, XLSB, XLSM ), type the 'first letter' of the file.
For example: If the file name is book-spreadsheet.xlt ,then type 'B' & select file from dropdown as shown below :

browse-excel-contacts

STEP 3

After that, the software will let you preview the whole content of the selected XLSX / XLS/ CSV / XLA / XLAM / XLSB / XLSM file, as shown below:

Note: Software immediately converts approximately 40,000 contacts at a time from excel to vCard format (TESTED).

preview-of-contacts

STEP 4

After this, click on the Next button to continue the conversion process:

progress-details

STEP 5

To match the Excel fields with vCard Fields, follow the given steps:

Choose Excel Fields from the left side of the screen.

excel-contacts-attributes

STEP 6

Then choose any of the vCard Fields from the right side panel of the software.

Match the fields:

vCard-contacts-attributes

STEP 7

Then after matching the fields, click on the Add button. The tool will now display the list of matched attributes. After this click on the Next button.

mapping-of-attributes

STEP 8

Now, apply the settings.

If you want to allow empty email address to be imported, then tick the checkbox.

You can choose to merge all Excel contacts into one single vCard file. By default, the software creates individual VCF files for each contact.

This Excel to vCard Converter tool supports all versions of vCards i.e., v2.1, v3.0 & v4.0.

Note: To import vCard into iCloud please select vCard version 3.0 or 4.0

convert-contacts-with-empty-email-address

STEP 9

Next, provide a location to save the resultant file. Click on Change.

conversion-process

Choose the folder or create a new folder to save the vCard files. Click on OK.

change location

After this, click on the Convert button to start the conversion process.

create folder

STEP 10

The Excel files will convert into vCard contacts.

conversion-process

Files have been converted successfully, click on Yes to view them.

completion-of-conversion-process

STEP 11

Software has successfully created vCard files:

converted-contacts

Open vCard with Windows Contact or import them into any desired application.

converted-contacts

Videos : How to Import Excel Contacts into Android & iPhone

Free Download Excel to vCard Download Now