Skip to main content

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!



Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!






About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.








Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…

Office 2010 Activator (KMS) !!

Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 






Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:



YF79C-7Y4B4-PGM89-6BKGJ-46PBT

FC7HF-CF42G-MX6D7-8K9T7-BT9QT

2PWHY-KT4X6-96PYW-XQR7V-HW2W9
PYMDW-8DFY2-Y68BB-XHDGD-CT443
7XD2X-JWJ94-BCHBW-W9WXP-J2WPT
P6RW8-B8X84-FFK73-4BPWM-KRHX3


After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

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 this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 





I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 






Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

IDM 7.2 Portable Free Download!!

There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.


Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

Download GTA Vice City Cheat Codes (PDF)

Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!


Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Effect
Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

Disable Automatic Update in Windows 10

As I mentioned earlier, Windows 10 has come with some boring changes. One of the stupid changes is related to Automatic Update. In Windows 10, you're set to automatically install new updates. And you've no choice to change this settings. Because the change settings option is disable. 


Applies to: Windows 10




Disable Automatic Update (Final Edition)



When you Disable Automatic Update?

If your net bandwidth is limitedIf you don't need windows updates at allIf the updates cause activators not work in your PC
In earlier versions of Windows (Windows 7, 8 or 8.1), you can manually configure the update settings. There were four settings: Install updates automaticallyDownload updates but let me choose whether to install themCheck for updates but let me choose . . . Never check for updates
In Windows 10, you don't have any option to choose any of these settings. It's simply disabled. You can't use the drop down menu. Look at the image below:




But still you have a chance to configu…