Mashhura Jahan
If you are looking for a way to convert an Excel file to VCF without using any software, this article will be helpful for you. The focus of this article is to explain how to convert Excel to VCF without software.
Download Practice Workbook
Here, I have provided the practice workbook. You can download it from here.
What Is VCF File?
VCF (Virtual Contact File) is used to store virtual contact information. These files can be used as virtual business cards. VCF files can be shared easily. You can attach these files to emails. These files can be sent via MMS also. VCF files are also accepted universally.
Step by Step Procedures to Convert Excel to VCF Without Software
To explain this article, I have taken the following Excel sheet. It contains the Employee Name and Contact Number. Here, I will convert this Excel sheet to VCF without software. Let’s see the steps.
Step-01: Save Excel File in CSV Format
In this first step, I will convert the Excel file to CSV format.
- Firstly, open the Excel file that you want to convert to VCF.
- Secondly, go to the File tab from the Ribbon.
- Thirdly, select Save As.
- After that, click on the drop-down button for the file type.
- Then, select CSV (Comma delimited)(*.csv).
- Next, select Save, and your file will be saved as a CSV file.
- In the following picture, you can see how my Excel file looks after converting it to CSV.
Read More: How to Convert CSV File to VCF Using Excel (with Easy Steps)
Step-02: Import Contacts from CSV File
Now, I will import contacts from the CSV file that I got from the Excel file.
- In the beginning, click on the Start button for windows.
- Then, write contacts.
- After that, the Contacts folder will appear.
- Select the Contacts folder.
- Next, the Contacts folder will open.
- Select Import.
- Afterward, the Import to Windows Contacts dialog box will appear.
- Select CSV (Comma Separated Values).
- Then, select Import.
- Now, the CSV Import dialog box will appear.
- Select Browse.
- After that, select the CSV file that you converted from Excel.
- Next, select Open.
- Then, you will see that the file is selected as Choose a file to import.
- Afterward, select Next.
- Further, check the field you want.
- Then, another dialog box named Change Mapping will appear.
- Select the Contact field. Here, I selected the Name because this column contains names.
- After that, check the Import this field option.
- Then, select OK.
- Next, select the other column.
- Consequently, the Change Mapping dialog box will appear again.
- Select the Contact field. Here, I selected the Business Phone because this column contains the Contact Number.
- Next, check the Import this field option.
- After that, select OK.
- Then, select Finish.
- Afterward, select Close on the Import to Windows Contacts dialog box.
- Finally, you will see that you have imported the contacts from the CSV file as Contact File.
Read More: How to Create VCF File from Excel (2 Simple Methods)
Step-03: Export Contacts to Convert to VCF
Here, I will export these contacts to VCF and then I will get my desired file format.
- First, select Export in the Contacts folder.
- Then, the Export Windows Contact dialog box will appear.
- Next, select vCards (folder of .vcf files).
- Afterward, select Export.
- Now, the Browse for folder dialog box will appear.
- Select the folder where you want the VCF files.
- Then, select OK.
- Next, another dialog box will appear.
- Select OK.
- After that, Close the Export Windows Contacts dialog box.
- In the end, you will see that finally you have converted the Excel file to VCF files without software.
Practice Section
Here, I provided a practice sheet for you to practice how to convert Excel to VCF without software.
Conclusion
In this article, I tried to explain how to convert Excel to VCF without software in 3 simple steps. I hope this article was clear to you. If you have any questions or suggestions, feel free to let me know in the comment section. For more articles, stay connected with ExcelDemy.
