How to Convert Excel Contacts to vCard?

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

Export Excel Spreadsheet Contacts to vCard VCF Format

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:

  • FirstName -->> FirstName or FullName
  • Last Name -->> LastName
  • Email -->> EmailAddress
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

Card image
Card image

Free Download Excel to vCard Download Now