How To Convert VCF to Excel?
To convert vCard to Excel, download the VCF to Excel converter in this page & follow the instruction.
How To Convert VCF to ExcelVisual Basic123451. Open the VCF to Excel converter Excel App.2. Enable macros if requested.3. Type input VCF file name with path.4. Press "Convert .vcf to Excel" button.5. Contacts in your vCard file will be converted to xls & imported to the Excel app.
Now, all your contacts are in Excel spreadsheet. It will be easy to do maintenance activities on the contacts list imported from vCard to Excel.
The download link is given just below the Excel macro code to read & convert vCard to xls.
Convert vCard to Excel – Complete Guide
This article explains how to open VCF file in Excel using the following tricks.
- How to open .vcf file in Excel using Excel VBA App.
- vCard to Excel using Microsoft Outlook.
- Contacts to Excel using Mobile Apps.
It is assumed that you have the contact files already exported to vCard format & transferred to PC using a usb connector, Bluetooth or wifi etc., Only then, we will be able to do a conversion on it.
1. How To open .vcf file in Excel?
Create a new excel sheet and press Alt + F11 to view the VB Editor. Copy paste the below code in VBE. Change the path for the VCF file in the field ‘VCF_File_Path’. Execute the code by pressing F5. (How to Run Macro in Excel – If you are beginner)How To Open a VCF file in Excel?Visual Basic123456789101112131415161718192021222324252627282930313233343536373839404142'Code Downloaded From Officetricks.com'External Properties & Functions DeclarationPrivate Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal Operation As String, ByVal Filename As String, Optional ByVal Parameters As String, Optional ByVal Directory As String, Optional ByVal WindowStyle As Long = vbMinimizedFocus) As LongPrivate Sub VCF_To_Excel()'.vcf File to Excel Conversion code'Assign the Path of the VCF file hereVCF_File_Path = ThisWorkbook.Path & "\Vcf_to_Excel.VCF"'Open .vcf File in Excel (read mode)intfilenum1 = FreeFileOpen VCF_File_Path For Input As intfilenum1icol = 0irow = 1'Read .vcf File line by line till End Of FileWhile Not VBA.EOF(intfilenum1)Line Input #intfilenum1, filetext'If VCF file has Profile Photo Information, Skip/Enable as per your needIf VBA.InStr(1, filetext, "PHOTO;", vbTextCompare) > 0 Or VBA.Mid(filetext, 1, 1) = " " Then GoTo Read_Next_Line:'Identify beginning of vCard Contact InformationIf VBA.Trim(VBA.UCase(filetext)) = VBA.Trim("BEGIN:VCARD") Thenirow = irow + 1icol = 0End If'Write Contact Information to Excel Sheeticol = icol + 1ThisWorkbook.Sheets(1).Cells(irow, icol).SelectThisWorkbook.Sheets(1).Cells(irow, icol) = filetextRead_Next_Line:WendMsgBox "Thanks For Visiting. Subscribe Your Email with Us to get Free Latest updates"ShellExecute 0, "Open", "http://officetricks.com/email-subscription-page/"Close intfilenum1End_Process:MsgBox "Converting VCF to Excel Completed"End Sub
Download limited version of VCF to Excel Converter Tool Downloaded 18,504 Times
1.a Output & Customization of VCF to Xls Converter VBA code
After execution of the code is completed, refer to first sheet in the workbook. It will have the vCard contacts imported. As said earlier, it does not give a completely customized tool to strip the vCard format tags and display only the plain contact information that our eyes would love to see.
The code can be modified to omit the tags like BEGIN: or VERSION: as how I have removed the tag PHOTO: to get a complete VCF file to Excel automated tool.
Note: As a caution, please take a back up of the vCard file & save the excel file before executing the code.
What if there are multiple VCF files: How to Merge if there are multiple VCF Files?
2. VCF To Excel Converter with Microsoft Outlook
To convert VCARD to Excel, double click on .vcf file and open it with Microsoft Outlook application. It will update all the contacts to Outlook contacts. To export contacts from Outlook to Excel use the below steps.
Export Outlook Contacts to Excel:
- Choose ‘Contacts’ from outlook app.
- Click File Menu & choose ‘Import and Export’ option. (Shortcut ‘Alt + F + T).
- Select “Export to File” & click next.
- Choose “Microsoft Excel 97-2003”, Click next.
- Choose Contacts to be converted to Excel.
- Type Output file name & path.
- Click next and then “Finish”.
Now Outlook will convert your contacts from .vcf file to Excel with this indirect method. The Excel file with contacts will be generated in the path that you have mentioned during export option.
3. VCF Converter – Mobile Contacts to Excel
To convert your mobiles vCard to Excel, if you are looking for a direct solution, then follow mobile specific recommendations as given below.
Android: “Contacts Backup – Excel & Email” by Eastros Pvt Ltd for Android has comparatively a large number of download and good rating when compared to other available apps.
iPhone: Click here CopyTrans Contacts to know more about this iPhone iOS product that will serve the purpose.
There are few other products available to export mobile contacts to Excel in the Google Play Store & iPhone App Store. But the above apps would be suffice for our purpose.
Using VCF to Excel converter as Android Contact Manager
The Excel macro just uses the VB File read operations which is nothing different from reading a plain text file. But still it handles minimal VCF format tags and imports vCard as one contact per row in excel.
The code reads contacts in VCF file one by one and its Tags. It parses the detail from each tag and writes into Excel. Once all the contacts are imported in Excel, the file can be saved to a CSV format. This is how we can convert VCF to Excel/CSV format.
The imported contact will be comparatively good for the user’s eyes to refer than opening and manually reading the vCard File. This option works fine for a Vcard file exported from an Android Mobile and we can manage the contacts in this way.
VCF Converter & Contact Management in Android
At top of the page under “also read” section, there is a article reference which explains how to convert a (CSV) Excel to VCF. By combining the codes in this article and the one in the reference, a vCard file can be imported to excel from Android device, processed and then again exported to Android contacts. Help is setting up a 2 way communication.
By using this, we can remove unwanted or unused old contacts from Android and also bulk upload a big list of contacts from an Excel of CSV to VCF and then import it into Contacts of Android.
What Else Can we Import to Excel
Previous Post: Add Sheets Dynamically to Excel
Next Post: Quick Guide – Export Outlook Emails To Excel – 2,000+ Downloads
VCF To Excel Converter 1.1 – Convert vCard To Excel – 18,000+ Downloads