How to Convert Excel to VCF Without Software (With Easy Steps)

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.


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.


How to Convert Excel to VCF Without Software: Step-by-Step Procedure

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.

how to convert excel to vcf without software


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.

Save Excel File in CSV Format to Convert to VCF without Software

  • 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.

Saving As CSV to Convert Excel to VCF Without Software

  • In the following picture, you can see how my Excel file looks after converting it to CSV.

Final CSV File to Convert Excel to VCF without Software


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.

Import Contacts from CSV File

  • Next, the Contacts folder will open.
  • Select Import.

Selecting Import to Convert Excel to VCF Without Software

  • 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.

CSV Import Dialog Box to Convert Excel to VCF Without Software

  • After that, select the CSV file that you converted from Excel.
  • Next, select Open.

Open Dialog Box to Convert Excel File to VCF Without Software

  • 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.

Change Mapping Dialog Box to Convert Excel to VCF without Software

  • 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.


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.

Export Contacts to Convert to VCF

  • 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.

Practice Sheet to Conver Excel to VCF Without Software


Download Practice Workbook

Here, I have provided the practice workbook. You can download it from here.


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.


Related Articles

<< Go Back to Export Excel to vCard | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo