Wednesday, March 30, 2016

How to Import Excel Contacts to vCard Manually?

Posted by datarecoveryblogger
Are you still using Excel spreadsheet for storing your contacts and their information? Haven't you heard about the new standard VCF format? Storing contacts in Excel sheets was popular in past, but now it's an old trend which is not that much popular among computer and mobile users. The Excel sheet is now replaced by vCard format for storing contact information of a person or business. A VCF aka vCard file contains a name, address, phone number, e-mail address, and other contact information. Also, it supports custom fields, images, and other types of media. A single VCF file stores only one contact, so it's small in size as compared to Excel sheet that may contain hundreds and thousands of contacts. Unlike Excel sheet, VCF files are supported by all the latest devices as well as most of the email clients.

Another common use of VCF files is to import and export contacts from Windows address book. Also, VCF files can be attached with email messages with ease. If you are still using Excel sheets for storing contacts, I would recommend you to switch to this new standard format, known as vCard.

If you have important contacts in your Excel sheets and you want to save them into VCF format, you would need to import excel contacts to vCard files. There are two ways to do that, either you can use a professional tool or can simply follow an easy trick. Professional software would be a paid solution whereas manual trick doesn't require any third-party software. If you want to use the manual trick for importing Excel contacts to VCF files, it will take a lot of time if you're having hundreds and thousands of contacts. There are three different processes needed to perform: converting Excel sheet into CSV format, importing contacts to your system from CSV files, and last importing contacts to VCF files. Let's find out below how to do that: 

Convert Excel to CSV 



Step 1: Open the Excel sheet containing the contacts. 

Step 2: On the menu bar, click File tab and select Save As. Or, simply click F12 button to go to the Save As dialog window. 

Step 3: Now go the saving options there. Rename the file. Also, define CSV (Comma delimited) (*.csv) in the options of Save as type. Click Save

Step 4: You will receive a couple of on-screen messages. Click OK and take exit from Microsoft Excel. 

The Excel sheet is successfully converted into CSV format. You can check this new file at the location you defined earlier. 

Import CSV Contacts to System 



Step 1: Go to Windows Start, and type contacts on search bar. Under Programs, you can see Contacts entry. Click it to go to the Contacts window. 

Step 2: On the Contacts window, click Import tab on the header section. 

Step 3: On the Import to Windows Contacts window, select CSV (Comma Separated Values) in the options and click Import

Step 4: Now choose the CSV file to import contacts from. Click Browse and select the file. Click Next

Step 5: Map the text field and contacts field accordingly. Click Finish

All the contacts from CSV file are successfully imported to your system, you can check them. 

Export Contacts to VCF Files 



Step 1: Select all the contacts which you want to export to vCard format. 

Step 2: On the header section, click Export tab. 

Step 3: On the Export Windows Contacts window, select vCards (folder of .vcf files). Click Export

Step 4: Now browse a location where you want to save new vCard files. Click OK to start the process of exporting contacts to vCard files. 

This might be a time-consuming task if there are thousands of contacts need to be exported to VCF files. In such situation, a professional Excel to vCard Converter tool is extremely helpful for users. It can easily export thousands of contacts from Excel sheet to multiple VCF or vCard files at a time. Users can download free demo version of this tool before purchasing its licensed version. Demo version helps users evaluate the software.