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
Go to Start menu » Programs » SysTools Excel to vCard Converter » SysTools Excel to vCard Converter
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.
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 :
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).
After this, click on the Next button to continue the conversion process:
To match the Excel fields with vCard Fields, follow the given steps:
Choose Excel Fields from the left side of the screen.
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
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.
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
Next, provide a location to save the resultant file. Click on Change.
Choose the folder or create a new folder to save the vCard files. Click on OK.
After this, click on the Convert button to start the conversion process.
The Excel files will convert into vCard contacts.
Files have been converted successfully, click on Yes to view them.
Software has successfully created vCard files:
Open vCard with Windows Contact or import them into any desired application.