Microsoft Excel is known as the most popular information management tool in the world. It is developed by Microsoft Corporation. It provides users with an intelligent network interface to organize and manage a large amount of data and information with ease. Excel stores all its data in a document, which is called a workbook.
Many professionals use MS Excel spreadsheets to keep track of their highly crucial and confidential data in table form. In the past, people used the Excel workbook to store their contact information. The idea of saving contacts in Excel files was quite reliable as all data and information was stored in an organized way. Due to a change in the way of communication, people have become more serious about their contact information. As storing contacts in Excel files has become an old trend, the vCard is becoming a popular file format among computer users.
The vCard file format is commonly used for storing contacts and transferring business card data. It is very popular with computer users and is widely compatible with many devices, programs, and platforms. For flexible communication, broader contact accessibility is really very important. This is the reason why users need to convert the contacts from their Excel files to the vCard format.
There is an easy and simple manual hack that you can import all contacts from Excel files to vCard files. The hack does not require any third party tools during manual operation. Just follow the steps below:
Convert from Excel to CSV
-
Open the Excel file (XLS or XLSX) on your system.
-
Click the Office button> Save TOs> ORother formats. You can also press F12 for instant action.
-
Define a location to save this new file. Also, give it a name. Now click on the drop down arrow next to Save As type option.
-
Select CSV (Comma Delimited) (* .csv) and click the Save button.
-
Click OK to save only the active sheet.
-
Click Yes to keep the workbook in CSV format.
The selected Excel file has been successfully converted to CSV format in the defined location.
Import contacts from CSV file
-
Click Start on the taskbar> type Contacts in the search box. The results will be displayed. Click Contact in the list of programs.
-
The Contacts window will open. Click the Import tab.
-
Tea Import to Windows Contacts The window will appear. You need to select CSV (Comma Separated Values) and then click the Import button.
-
Click the Browse button to locate the FileName.csv file.
-
Browse to the location of the file and select it. Confirm your selection by clicking Open.
-
Your FileName.csv file will appear in the edit box. To continue the process, click Next.
-
In this step, you need to map the fields that you want to import, that is, the text field and the contact field.
-
Once the mapping is done, click the Finish button.
All the contacts in the CSV file have been successfully imported into your system.
Export contacts to VCF file
-
In the Contacts window, select all the contacts you want to export to vCard.
-
Now click on the Export tab at the top.
-
The Export Windows Contacts window appears. You need to select vCards (.vcf files folder) and click the Export button.
-
You must define a location where you want to save the vCard files. You can save the vCard files to a new folder at any location. Once the location is defined, click OK.
-
In a fraction of a second, your contacts will be successfully exported to the vCard format.
The above manual trick is considered an easy, safe and efficient way to import contacts from Excel files to vCard format. But sometimes, it becomes a time-consuming task if you have numerous contacts in your Excel files. You can try an advanced conversion tool that can quickly convert the contacts from your Excel files to the vCard format with ease.