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 Open button.

browse-excel-contacts

Note: To browse files other than (XLSX, XLS, CSV ), Type 'first letter' of file.
For example: If file name is Book18-Excel-97-Template.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 selected XLSX / XLS/ CSV 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 Next button to continue the conversion process. Then software will display the following screen:

progress-details
STEP 5

To match the Excel fields with Outlook attributes follow the given steps:

Choose Excel fields from the left side of the screen.

excel-contacts-attributes
STEP 6

Then choose any of the Outlook Attributes from the right side panel of the software.

Match the fields like this way :

  • FirstName -->> FirstName or FullName
  • Last Name -->> LastName
  • Email -->> EmailAddress
vCard-contacts-attributes
STEP 7

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

mapping-of-attributes
STEP 8

Now, check the options you want the software to handle during the conversion process. Checking this option will allow software to convert contacts with empty email address fields. It can create a single vCard file for all contacts and create individual .vcf for each contact present in the selected Excel sheet.

This Excel to vCard Converter tool supports all versions of vCards i.e. v 2.1, 3.0 & 4.0

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

convert-contacts-with-empty-email-address


STEP 9

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

During the conversion, software shows a number of empty email addresses and number of contacts added into vCards.

conversion-process

You can change the location of exported vcard files as per you Choice. To do this, Click on Change

change location

Select the desired location on your system, Create New Folder & Click on OK button

create folder


STEP 10

The, Click on Convert button to begin the process to Convert Excel to vcard

conversion-process

Then after the completion of the conversion process, software will display a confirmation screen as follows:

completion-of-conversion-process


STEP 11

Software will create separate vCard files for each contact and save them at the location selected during conversion process as shown below:

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