Featured post

Office 2013 Activator (KMSpico 10.1.5)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with thi...

How to Convert Excel Contacts into vCard (.vcf)?



Convert .xls file to .vcf



Exporting and Importing Contacts of your Smartphone is not a big deal. You can easily do this from the Settings option of your Contact App. But you will get it really challenging when you've to convert a simple excel file into vCard (.vcf) format and import them as your phone contacts. 


If you don't have any third party tool or if you don't know the tricks then you may require few hours to save contacts on your smartphone one by one. 


Just few hours ago I faced the same challenge and hopefully you will be glad to know that I've done the job! Of course it costs me nearly 2 hours to discover the trick. But you don't need to wait that long. If you face the same need, you can do this within few minutes. Let's see how . . .


Convert Excel Contacts into vCard Format | 3 Steps
  1. Convert the Excel file (.xls/ .xlsx) into CSV (.csv) 
  2. Import the CSV file using Contacts - It's a default Windows Application in the previous versions of Windows. But in Windows 10, Contacts is considered as a folder. 
  3. Export the contacts as vCards (.vcf) using Contacts. 


Convert the Excel file into CSV - Step 1
  • Open the Excel file where your contacts are stored that you wanna convert. 
  • Now Save the file as - CSV (Comma delimited) (*.csv)


Save file as csv

  • Now you will get a message like this. 

CSV Saving Warning Message


  • Simply hit the yes button and step 1 is done!



Import CSV File using Contacts | Step 2
  • Press the Start button and type Contacts. Choose the Contacts app from the search result as shown in the image below.

Windows OS Contacts Application


  • Now you will see the Contacts folder in the screen. Hit on the Import button as shown in the image below

Contacts folder Import Option



  • Choose CSV format as shown below and hit on the Import button.

Import CSV file to Windows Contacts



Choose files to import



  • Hit on the browse button, locate your CSV file and select it.



Importing CSV to Windows Contact



  • After selecting, hit on the Next button. 



Import CSV to Windows



CSV Import Mapping



  • Now you've to mark the fields which you wanna include. Choose the field type as shown in the image below. 



Change Field Type while importing



  • After mapping the fields properly, hit on the finish button. And Close the dialogue box. 



Fields to import



After pressing the Finish button, all of your contacts will be stored in your Contacts folder. To see these contacts, again press Start button > Type Contacts and then you will see the Contacts window as shown in the following image - 



Windows Contacts sample



Here you can see that all contacts are stored with .contact extension. This format is quite useful for your Windows PC. But if you wanna get these contacts on your Smartphone, then they should be converted into vCard format. I mean Step 3 is unlocked. We've to get there now . . .



Export the Contacts as VCF  | Step 3


Make sure you're in Contacts folder or Press Start > Type Contacts > Go to the Export option > 



Windows Contacts export option



  • Now choose vCards option and hit on the Export button. 



Export contacts as VCF



  • You must choose a separate folder for exporting. Or you can choose your Contacts folder. Never choose desktop cause your desktop will be full with these contacts files.



Choosing a location to export

  • Press OK after choosing the export folder. 




Converting contacts to vCards




  • Within few moments your contacts will be exported and you will see the following message. 



Exporting process finished



Contacts with contact and vcf extension


That's it. Now you can see both type of contacts side by side. If you need to import these contacts on your Smartphone, then simply select the .vcf files and copy them in a separate folder. Then copy this folder to your phone memory or SD card. 
  • Then go to your Phone Contact application
  • Find the Import option from Settings
  • Choose your Import location i.e. Phone Memory or SD Card
Finish! 



Hope this will be of great use if you are in trouble to copy your excel contacts to your Phone. 



Stay with Marks PC Solution to get more interesting IT topics!



No comments:

Post a Comment