How to Edit VCF File in Excel (with Easy Steps)

This article shows a step-by-step guide on how to edit VCF file in Excel, as well as in Notepad.

We have used the Microsoft 365 version of Excel here, but the steps are also applicable to other versions.


What Is a VCF File?

VCF stands for Virtual Contact File (vCard), the common file format in Windows and other operating systems for sharing and archiving contact information including name, phone number, contact image, email, and address.


How to Open and Edit VCF File in Excel

Step 1 – Open the VCF File

  • Open a blank workbook in Excel.
  • Click the File tab in the top-left corner.

Open the VCF File

  • Click Open.
  • Select the Browse option.

Browse for file

  • Select the All Files option.
  • Select the VCF file to be opened (here, Contacts.vcf).
  • Click Open.

Choosing vcf file

The Text Import wizard opens.


Step 2 – Import and Edit the VCF File

  • In the Text Import Wizard, select the Delimited option.
  • Click the Next button.

Import and Edit the VCF File

  • Check the Tab and Semicolon delimiters.
  • Check the Other field, and insert a Colon in the adjacent box.
  • Click Next.

Selecting delimiters

  • Click Finish to conclude the importing process.

Finishing import

The file is imported into Excel, and looks like this:

how to edit vcf file in excel

  • Edit the Excel file as required. In this case, we’ve edited the Contact number and Email address.

Editing imported vcf file in excel

After applying some formatting, the output should look like the image below.

Applying formatting


Step 3 – Save as an Excel File

  • Click the File tab.
  • Click Export.
  • Click Change File Type.
  • Under Workbook File Types, double-click Workbook (*.xlsx).

Save the VCF File

  • Enter a file name, for instance, Editing VCF File.xlsx.
  • Click Save.

how to edit vcf file in excel saving as excel file


How to Edit VCF File in Notepad

It’s sometimes quicker and more convenient to use the Notepad application instead of Excel to open and quickly edit a VCF file.

Steps:

  • Press the WINDOWS button on your keyboard.
  • Select the Notepad application.

How to Edit VCF File in Notepad

  • Click on File.
  • Click Open.

Opening VCF file

  • Select the All Files option.
  • Browse to and select the VCF file to be opened, for example Contacts.vcf.
  • Click Open.

The VCF file opens in Notepad.

how to edit vcf file in notepad

  • Edit the text values as required. As above, here we’ve edited the Contact number and Email address.

Editing the vcf file in Notepad

  • When you’re done editing, click File.
  • Select Save to save the updated VCF file.

saving the edited vcf file in notepad


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself.

Practice Section for how to edit vcf file in excel


Download Practice Workbook


Related Articles

<< Go Back to Import vCard to Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo