Want to convert Excel (xlsx) to VCF (vCard) file? Then you’re on the right page. On PC, storing the contacts and other information in MS Excel is the easiest way. That’s why most of the people and companies stored the contact information in Excel files. Because it is easy to manage, organize, and format the information or data in spreadsheets. You can calculate and manipulate the data with formulas. Moreover, some people get or buy contact information in xlsx files from many sources for business purposes.

Microsoft Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format. Used as the basis for XLS files it is a persistence format that supports authoring and manipulating content in workbooks and workbook templates.

However, business softwares and bulk SMS services support the Excel file to import the data/contacts from spreadsheets. But, still, to import contacts in mobile phones, cloud services, and email services, you need a vCard file. So, if you have an xlsx file and want to import the contacts from that file, you may need to convert it to the VCF file.

Contents

  • 1 3 Ways to Convert Excel to vCard (xlsx to vcf file)
    • 1.2 Method 2. Convert Excel to vCard With Software

3 Ways to Convert Excel to vCard (xlsx to vcf file)

Converting the xlsx to vcf file is seriously a lengthy process for most of the people. Because, there is no option available in Excel itself for this. However, you can convert or save the spreadsheet in CSV (comma-separated values) file. After that, you can easily create the vcf file from that.

Well, numerous paid softwares, programs, and online tools are available to convert the files. However, most people don’t prefer online tools because of privacy.

When you will trying to find the converter software, you’ll see most of the tools and software are paid. Also, the trial version doesn’t do the proper job. Trail versions always come with limitations.

Don’t worry, free software is also available without limitations to convert xlsx to vcf. Moreover, you can also do that without any software or tool. But, it is a little bit lengthy process.

So, there are three methods available – With Software,Without Software, and online tools. It’s your choice whether you want to use software or not.

Method 1. Convert xlsx to vcf Without Software

However, this a long process (not too long), but you don’t need to download any software on your PC. You can do this in three simple steps.

At first, you will need to save your Excel spreadsheet in CSV format. You can do that with MS Excel or any other spreadsheet creator software. After that, the Contacts app helps to convert the file. If you are a Windows user, you may know about the inbuilt Contacts application (program). This inbuilt tool support CSV and VCF files. So, using inbuilt software, you can easily convert the files.

The step by step guide is given below.

Step 1. Convert Excel File to CSV

You can convert your Excel spreadsheet file to CSV using Microsoft Office, Google sheets, and other softwares.

Free Excel To Vcard Converter

At first, Open file using MS Excel.

If you have Excel for Microsoft 365, Excel 2019, Excel 2016, 2013, or Excel 2010, then click on the File » Save As » Computer and select the folder.

Now you’ll see the Save as windows or dialog box. Select the folder and click on the Save as the type to select the format. After that you’ll see the list of formats. Click and select “CSV (Comma delimited)” option. After that, click on the Save button.

If you have Excel 2007, click on the click on the Office icon from the top left and select the Save as option. Select the “CSV (Comma delimited) (*.csv)” option from the Save as type drop-down list. Click on the Save button to convert and save the file.

When you click on the Save button, you may see the two warning popup messages. The first messages displayed “The selected file type does not support workbooks that contain multiple sheets”. Click on the OK button to continue. After that, again popup message displayed “*.csv may contain features that are not compatible with CSV (comma delimited). Do you want to keep the workbook in this format?”. Click on the Yes button to proceed.

Now, the file will be converted into CSV format.

If you don’t have Office software, you can use Google sheets online. Upload and open your file in Google Sheets, and go to the File » Download » Comma-separated values to save the file.

Step 2. Import CSV file in Contacts

Now open Contacts on your Windows PC. For this Type Contacts in the Cortana search. Otherwise Press “Windows key + S” to open Windows search.

Click on the Contacts from the search, After that the contacts windows will be open. Click on the Import option from the top.

Import to Windows Contacts popup will be open. Click on the CSV (Comma-separated values) option, and hit on the Import button.

Now browse and select the file where you saved the CSV file. After that, click on the Next button.

Map the field, you want to import. Click on the checkbox to change the mapping. Select the desired fields for all. Click on the Finish button.

Now you will see the all contacts.

Excel to vcard converter free download

Step 3. Export/convert CSV contacts in vCards VCF Files

Now select all contacts from the Contacts window. Press Ctrl + A, and click on the Export option from the top.

Select the vCards option from the popup window and click on the Export button. Select the folder and click on the Ok button.

That’s all.

Open the folder and you’ll see the vcf files.

Pros:

  • Lengthy Process.
  • You don’t need the internet because it works offline.

Cons:

  • Each contact converted into a separate vcf file.

Method 2. Convert Excel to vCard With Software

Software and tools make the whole process easier. Without software, all contacts are saved into a separate file. So, it is difficult to handle multiple files. Even if you have 100 contacts, you’ll see 100 files in the folder after converting.

Usb security 2.20 serial key. USB Security 2.20 Lock, encrypt, password protect USB flash drive, thumb drive, pen drive, memory stick and all other portable storage devices. Password Protect USB flash drive, pen drive, memory card, thumb drive etc. Safeguard your USB drive in 3 simple steps. Protect your files automatically after the USB. Usb Security 2.20 License Key Driver USB Disk Security Serial Key will work automatically in the background not disturb work. Whenever you connect any exterior drive to your computer, it will Automatically scan it and locate all malicious documents. By single mouse click USB, It. Usb security 2.20 serial numbers, cracks and keygens are presented here. No registration is needed. Just download and enjoy. Download cracked version Kaka USB Security 2.20. IMyFone LockWiper Crack With License Key 2020 Helps you bypass the iPhone passcode in case you forgot it and the device became unusable or you have to wait for a long time before attempting to unlock it again.

So, some software available to overcome this problem. Freeware “CSV TO VCARD” and “Systools Excel to vCard converter” are the most popular software. However, Systools converter isn’t free, but it comes with some advanced features. Its trail version gives an option to convert up to 25 entries.

Using Freeware CSV to vCard Converter

This is a free and lightweight tool i.e. less than 500KB. Also, it supports auto-mapping for common and important fields like Name, Phone Number, Email, Job, and Web Page, etc. So, you don’t need to manually select the fields for the map. However, there is an option to change the fields manually.

This is the CSV to VCF converter, so you need to save Excel file in CSV format to use it.

At first, download and install the CSV to vCard converter software. The link is given below to download it.

Download CSV to vCard Converter

The steps are given below to use this software.

  1. Open Excel xlsx file in MS Excel or Google sheets to save it as CSV format. Click on the File » Save as » Select the CSV from the to save as type an save the file. In Google sheets you need to go to File » Download » Comma-separated values.
  2. Open CSV to vCard software and click on the Browse from the CSV file option. Select and open the file.
  3. Now you have to options – Save all contacts in one VCF file and Each contact creates a VCF file. By default the first option is selected to save all contacts in one file. Click on the Save as a button to select the folder or location.
  4. Check the CSV Field and vCard properties. If the software failed to automap, select the field manually.
  5. Click on the Convert button and you will see the message – File conversion has been successfully completed.

That’s it.

Pros:

  • Easy to use.
  • Save all contacts in one VCF file.
  • Lightweight and free software.
  • Offers auto map feature.
  • Don’t need the internet.

Cons:

  • Needs to convert Xlsx file to CSV.

Using Systools Excel to vCard Converter

This softwares comes with advanced features, and you don’t need to convert your Xlsx file into CSV format. This software automatically does the entire job.

However, the tool is paid, but it converts up to 25 entries for free from the Excel file.

At first, download and install Systools Excel to vCard converter software on your PC. Below is the link.

Download Systools Excel to vCard Converter

The steps are given below to use this software.

  1. Open Systool Excel to vCard converter and import the Xlsx file. For this, click on the browse button and select the file.
  2. Now the tool shows the preview of the file. Click on the Next button.
  3. From the map column, Select the Excel fields and vCard fields. Click on the Next button.
  4. Select the vCard version and Saving location. After that, click on the convert button.

Open the folder and see the results.

Features of Systools Excel to VCF converter:

  • Load and Preview Xlsx files.
  • Offers to export files in 3 vCard versions.
  • Import empty email addresses.
  • Default saving location.

Free Excel To Vcard Converter Online

Pros:

  • Don’t need to save the file in CSV.
  • Direct converting.
  • It offers additional features.

Cons:

  • The free version allows to convert only 25 entries.

Method 3. Using Online Excel Xlsx to vCard VCF converter tools

Online tools are very handy, and you don’t need to install any tool locally on your PC. Numerous online converter tools are available. You just need to upload the Excel file and these tools returned the vcf file.

You need to arrange your spreadsheet data before uploading it. Otherwise, the tools show an error.

Moreover, in some online converters, you need to specify the first and last row & column, and what data contained by columns. So, it may difficult and time-consuming process for some users.

Popular Online Converters are

https://www.thewebvendor.com/excel-to-vcf-vcard-online-converter.html

https://pdfmall.com/excel-to-vcf

Pros:

  • Don’t need to install software on PC.
  • Free to use.

Cons:

  • Need an Internet connection.
  • Privacy risk. Your data may be leaked.
  • Difficult to map the data.

What is a VCF (vCard) file?

VCF (vCard) file format stands for virtual card format. It is an electronic business card. This format is used to store the contact information like Name, Phone/Mobile Number, Address, Email Address, Photo, Web Address, etc. It also supports custom fields, so you can add a new filed easily as your requirement.

Moreover, with vCard, you can share and send contact information over the internet. Almost all email services can read the vCards. Also, Operating systems have inbuilt programs to create and read vCards. All PC and Mobile operating systems like Windows, macOS, Android, and iOS come with an inbuilt contacts app/program that supports vCards.

Also, import and export the contacts in VCF file facility offered by all major OS.

In vCards (VCF File), the information stored in text. So, you can easily read the information by opening the file in Notepad/TextEdit or any other text editor.

Example of vCard (VCF) file data:

BEGIN:VCARD
VERSION:3.0
FN:oTechWorld,
TEL;TYPE=VOICE,WORK;VALUE=text:+123548568,
EMAIL;TYPE=HOME,INTERNET,pref:conta[email protected]
END:VCARD

What is Excel (xlsx and xls) file?

Xlsx file is an MS Excel spreadsheet file created by Microsoft Excel. The file is also be created by other programs like OpenOffice, Google Sheets, LibreOffice, and Apple Numbers. It uses tables (i.e rows and columns) to store the data or other information.

Because of the tables, you can easily organize the data. Also, you can apply formulas for calculations and make the changes. Moreover, you can represent the data in the charts. That’s why most of the businesses use excel spreadsheets.

xlsx vs xls files

However, both file formats are created by Excel software, but there is a difference between these two formats. XLS format uses the proprietary binary format and XLSX format uses Open XML. Microsoft Excel 2007 and later versions use Xlsx format and all previous versions use XLS format.

Conclusion

Now you know how to convert Excel to vCard (xlsx to vcf file). You can do that with or without software. Moreover, online tools available for free. Without software you can create a separate file for every contact. Well, it is difficult to manage the multiple files.

But, the software is best to use because you can easily convert the files. Moreover, you can save all contacts in one vCard file and you can easily use one file to import the contacts in any phone, email service, or cloud service.

Popular on OTW Right Now!


Excel to vCard Converter Software helps users to extract the data from Excel file and Convert Excel to vCard file with keeps data integrity. It allows Export Excel contacts to vCard with mapping filtering
Vartika Excel to vCard Converter Software is one of the famous & professional tool to convert Excel to vCard file.
Excel to VCF Converter Software let users convert selective or complete items of Excel along with mapping option into vCard file and the software supports all Excel file versions includes- 2019, 2016, 2013, 2010 & below versions. Converted Emails can be directly import into MS outlook profile, Samsung, Nokia, Gmail etc.
Making conversion from Excel to vCard file is become very easy with Vartika Excel to vCard Converter Software.
This is the tool which having easy steps for conversion no matter you have technical knowledge or not. Vartika Excel to vCard Conversion Software easily scans all Excel file & scanned its data for making conversion them into new created vCard format.
Excel to vCard Converter Software gives users facility to create single and separate vCard file for restoring the Excel file.
Excel to VCF Converter Software generate live preview of conversion by which you will satisfied from conversion process. And the converted vCard file mails can be directly import into WhatsApp, MS Outlook profile, nokia, gmail, android phones Samsung, blackberry, and iphone etc.
During convert Excel to vCard file, you can get option of mapping where you can map your Excel file to vCard files according to need.
Excel to vCard Conversion Tool let users convert selective single and multiple contacts from Excel file to vCard file. It supports all Excel file versions included- 2019, 2016, 2013, 2010, 2010 & below versions and all vCard file versions.
Through XLSX to vCard Converter Software you can successfully or completely export excel contacts to vCard file with maintains all data without changes.

You can firstly try demo version of Excel to vCard Contacts Converter Software that will let you view complete preview of tools and save only limited emails if you want to restore the complete data then you have to purchase full version of the software.

Version 1.0: Excel to vCard Converter Software helps users to extract the data from Excel file and Convert Excel to vCard file with keeps data integrity

⇐ ⇐ Game Resolution Changer
⇒ ⇒ Travelmate P253 Drivers