Home » Blogs » How to » How to Convert XLS Contacts to VCF Format? Explained

How to Convert XLS Contacts to VCF Format? Explained

author
Published By Deepmala Pandey
Published On December 22nd, 2022
Reading Time 5 Minutes Reading
Category How to

Summary: In this article, we have discussed the techniques that can be used to convert XLS contacts to VCF without losing any data. There are two methods that we have explained here to execute this process.

Brief Introduction of Excel and vCard File

There are several users who use MS Excel for multiple purposes. They used to save their data but generally, users save data like contacts in Excel as it becomes easier to share with others. However, if a user wants to import all the contacts saved in an MS Excel file to Outlook(PST), Mobile Phones, and other different platforms. For that, the user would need to convert XLS  file to VCF format.

XLS is a file format used to save data in Excel, apart from this users can also have options to save excel files in CSV and XLS. While VCF (vCard File) is the file format used to save data like contacts. Moreover, vCard provides the facility to generate and exchange contact data using the internet, such as in email and instant messaging.

Furthermore, it includes name, phone number, address, photos, email address, URLs, logos, and other data. vCard format is almost supported by all devices, email clients, email services and cloud services

Why Do Users Want to Convert XLS Contacts to VCF?

The only way to move and access Excel (XLS) files to other platforms is to move XLS contacts to VCF. As there is no other way to access Excel data (Contacts) in other applications. So, by converting the XLS file into vCard format, users can view or access contact data easily in Outlook, mobile phones, or other platforms.

So, to make it easier for users, we will discuss some convenient yet quick methods which can help users to convert excel contacts to vCard file easily.

Manual Solution to Export Excel XLS File to VCF Format

In this section, we will explain the manual solution to execute the process of converting excel files into VCF format. Here we have the entire process into three stages.

1. Excel to CSV Conversion
2. Import contacts from CSV Format
3. Exporting Contacts to VCF File

Stage 1: Convert MS Excel (XLS file) to CSV

  • Initially, open the MS Excel XLS/XLSX file in the system.
  • Press the file option, then press Save As an option or if the file was saved earlier then press the Save a Copy option, then press Other Formats.
  • Select the CSV format and set the location path to save the CSV file.
  • A message will appear. Click the Yes button to keep the workbook in the same format and click the Yes option.

Stage 2: Moving Contacts from a CSV File

  • Press the Windows + R or Windows Search button and enter the Contacts into the search box.
  • From the Contacts pane, press the Import tab.
  • Hit on the CSV and press the Import in the Import to Windows Contacts dialogue.
  • Now browse to search the.csv file you made in the previous stage.
  • Hit on the.csv file. And select the Next button.
  • Finally, hit the Finish button after it completes the mapping of the contact fields.

Stage 3: Contacts Export to vCard

  • Go back to Contacts Window and choose all contacts you desire to convert to vCard format. Now press the Export button.
  • Press vCard in the Export Windows Contacts wizard.
  • Finally, press the Export option. Set the location to save the output (.vcf file) and press the Ok button.

Smart Solution to Bulk Convert XLS Contacts to VCF File

Every user wants to complete the entire process in a few clicks which means that they want to extract the excel contacts into vCard format in a simple way. So, by using the Excel Converter Software, not only VCF but users can easily convert XLS contacts files into PST, PDF and other file formats.

Steps by Step Guide to Convert Multiple Excel File Contacts to VCF

  • Initially, on the local system download the software and launch it
  • Then, press the browse tab, find, and choose the excel file which needs to convert into VCF format

Browse Excel file

  • The tool will scan the file, after that in the settings tab, choose vCard as the export option and select the vCard version as per the requirements    

Choose vCard Version

  • Now, hit on the Change Tab to set the target location to save the resultant output file (vCard file)

destination

Note – User can mark the empty mail address to be imported to allow empty email ids to import

  • Next, In the mapping tab, choose the excel fields & export file fields, for mapping excel file fields. Then hit on the Add button. Here, the user can choose the Auto Map option to map automatically

Select Auto mapping

  • Finally, after completing the mapping task, hit on the Export Button to initiate the process.

Convert Excel file

By following a few steps user will be able to accomplish the task to export contacts from MS Excel to VCF format in less time without losing any data.

Conclusion

In this informative post, we have explained the solution to convert XLS contacts to VCF without any hassle. Moreover, here we have explained two different methods for converting contacts from excel to vCard format. Using the manual and a professional method which makes the process easier.  

We are the global leader in End-to-End IT Managed Services, Server Management & Security, and Datacenter Services discipline.

© 2024 MSOutlookTools All Rights Reserved