Convert Excel Contacts File to VCF Format [Easy Method]

The VCF format is supported in Microsoft Outlook, Gmail, Android Phone etc.,Though the code in this article can be used to convert Excel contacts to VCF format, it focuses mostly on generating a contact file for devices running Android.

1. What is VCF?
2. Sample VCF File
3. Sample Excel with Contact Details.
4. Code for Creating VCF from Excel.

1. What is VCard or VCF File?

It is a file format used to store Contact Information like Name, Phone Number, Email ID etc.,

This article explains – how to convert Phone Contact Information in an Excel File to VCF file with VBA code and also Product link to generate contact file on your own. After Conversion this file can be transferred to supported Mobile Phones or Email Accounts to update in Contacts.

2. Sample VFC File Format

3. Sample Excel File Containing Contact Information:

4. Code to Convert Excel to VCF:

1. Create a new excel workbook. Press Alt+F11 and copy paste the below code.
2. Press F5 to execute the code. A VCF file will be generated in the path where the Excel is saved (Ex: “D:\OutputVCF.VCF”)

Copy the below Code (Ctrl+A and Ctrl+C) and for Paste ( Ctrl+V)

Sub Create_VCF() 'Open a File in Specific Path in Output or Append mode Dim FileNum As Integer Dim iRow As Double iRow = 2 FileNum = FreeFile OutFilePath = ThisWorkbook.Path & "\OutputVCF.VCF" Open OutFilePath For Output As FileNum 'Loop through Excel Sheet each row and write it to VCF File While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) <> "" FName = VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) LName = VBA.Trim(Sheets("Sheet1").Cells(iRow, 2)) PhNum = VBA.Trim(Sheets("Sheet1").Cells(iRow, 3)) Print #FileNum, "BEGIN:VCARD" Print #FileNum, "VERSION:3.0" Print #FileNum, "N:" & FName & ";" & LName & ";;;" Print #FileNum, "FN:" & FName & " " & LName Print #FileNum, "TEL;TYPE=CELL;TYPE=PREF:" & PhNum Print #FileNum, "END:VCARD" iRow = iRow + 1 Wend 'Close the File Close #FileNum MsgBox "Contacts Converted to Saved To: " & OutFilePath End Sub

After make output.vcf copy this file into your mobile and simply import this file.

Keyword : how to convert excel file into vcf, excel contact convert in to vcf format

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email