-
Excel to VCF Converter
To Convert Excel To VCard, follow these instructions:
- Download & Open Excel to vCard converter app.
- Enable macro & content editing if requested.
- Copy contacts to vCard converter spreadsheet.
- Type output Vcf file name.
- Click on ‘Convert Contacts to Vcf’ command button.
- Open & verify vCard file created in same folder.
Thats not all …
Get free Vba code to convert Excel contacts to Vcf format (or xlsx to VCard File).
If you are not that much familiar with Excel programming, then just quickly download this app & test it yourself.
Read this .. before Using Xls to VCF Converter:
- Do not leave any blank rows in between records. Code will stop conversion when it reads a empty row.
- You can find the Output File in the same folder where the Excel File is stored.
Download this to Convert Excel Contacts to VCF or Android Format
Downloaded 70,141 Times
Build your own converter app using the steps explained further:
1. Excel To vCard Converter – Step By Step
We manage contact details in Excel format mostly, because it will be in good readable format & easy to manage.
Many services like gmail, yahoo, Outlook have option to import contacts from Excel files. But not all operating system or Email client provide this feature.
To create a basic Excel to VCF creation follow these steps.
- Create a new Excel workbook with sheet1 having column headers as in below image.
- Once this is done, the free code present in this page can be used to export contact details to a VCF file.
Excel to VCF VBA – VCard Generator – Excel to vCard Converter
Download this Excel to VCF Converter - VCard or Android Format
Downloaded 70,141 Times
Also Read: Name Numerology Calculator - Lucky Number from Birthday - Excel App
2. VBA Code to Convert Excel to VCF
Open the newly created Excel workbook. Press Alt+F11 and copy paste the below code. Press F5 to execute the code.
A VCF file will be generated in the path where the Excel is saved (Ex: “D:\OutputVCF.VCF”)
Note: If You want to Insert alternate phone number for a Contact, check the syntax of VCF file and Insert the corresponding tag in the below code.
12345678910111213141516171819202122232425262728293031'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 Excel_To_VCF_Converter()'Open a File in Specific Path in Output or Append modeDim FileNum As IntegerDim iRow As DoubleiRow = 2FileNum = FreeFileOutFilePath = ThisWorkbook.Path & "\OutputVCF.VCF"Open OutFilePath For Output As FileNum'Loop through Excel Sheet each row and write it to VCF FileWhile 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 & " " & LNamePrint #FileNum, "TEL;TYPE=CELL;TYPE=PREF:" & PhNumPrint #FileNum, "END:VCARD"iRow = iRow + 1Wend'Close The FileClose #FileNumMsgBox "Contacts Converted to Saved To: " & OutFilePath & " - Join Email Subscription To Get Latest Updates"ShellExecute 0, "Open", "https://officetricks.com/email-subscription-page/"End Sub
Copy and Import to Android Contacts:
- You can view this VCF File created from this Excel to VCF converter in any text editor like notepad, because this is not an encrypted file format.
- This File can be copied to Android Phones or any other VCF supporting device or application and imported into Phone Contacts.
- From Android Device Contacts, choose Import from SD card option and select the file you just copied. Android will start to import the contacts to the device.
3. What is VCF or VCard File?
It is a file format used to store Contact Information like Name, Phone Number, Email Address, Mailing Address etc.,
In this this article you can learn – how to convert phone contact information in an Excel File to VCF file with VBA code and a trial product 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.
Related: Export VCF file to Excel
Also Read: How To Type Subscript in Excel - Superscript Options - Excel VBA Code
4. Sample File format of Excel to vCard Converter
Each contact starts with a BEGIN: tag followed by Contact fields & then terminates with END: tag. In few advanced VCF formats, there are fields available to add even the profile picture, social profile, website etc.,
BEGIN:VCARD
VERSION:3.0
N:FirstName;LastName;;;
FN:FirstName LastName
TEL;TYPE=CELL;TYPE=PREF:0123456789
END:VCARDThis converted VCF or vCard format is supported in many Email clients, Smart Phones and Operating systems to store the Contact details. For Example: Microsoft Outlook, Gmail, Android, iPhone & other smart phones.
Do not forget to read this article how to open & verify a vcf file.
The advantage of a VCF file are:
- It is not an encrypted file format.
- You can open this file using any Text file editor & modify manually.
- You can transfer the file over internet through Email or a simple file transfer through a USB Cable, Wifi or Bluetooth between devices.
SummaryDeveloper Rating3.5 based on votesSoftware NameExcel to VCF Converter ToolOperating SystemWindowsSoftware CategoryDesktopPriceUSD 5Landing PagePrevious Post: Extract Web Page with Tables – Parse HTML Table – Data Mining Tool
Next Post: Hello World Program – Google Spreadsheet Scripts- krishna
- krishna
- https://officetricks.com/ kumarapush
- Alaska Raj
- https://officetricks.com/ kumarapush
- Brijj
- https://officetricks.com/ kumarapush
- https://officetricks.com/ kumarapush
- rowdy
- https://officetricks.com/ kumarapush
- Agatha Alice
- Ed Bentall
- https://officetricks.com/ kumarapush
- Ekeke Emmanuel
- https://officetricks.com/ kumarapush
- Ekeke Emmanuel
- https://officetricks.com/ kumarapush
- venkatesh
- https://officetricks.com/ kumarapush
- Sravanthi
- https://officetricks.com/ kumarapush
- http://www.facebook.com/desktopdecor Alkama Zaif
- Layola
- Layola
- Jitendra Degama
- https://officetricks.com/ kumarapush
- sanesh
- lahratla
- https://officetricks.com/ kumarapush
- kirti sharma
- https://officetricks.com/ kumarapush
- https://officetricks.com/ kumarapush
- Leanca Radu C.
- ajtech
- https://officetricks.com/ kumarapush
- Linh Hoang Dang
- https://officetricks.com/ kumarapush
- Linh Hoang Dang
- gleb
- Yash Pradhan
- https://officetricks.com/ kumarapush
- Dalip
- https://officetricks.com/ kumarapush
- Dalip
- Sohail Abbasi
- https://officetricks.com/ kumarapush
- Sohail882
- sagar
- Martha
- Martha
- https://officetricks.com/ kumarapush
- desuja
- https://officetricks.com/ kumarapush
- Kevin
- https://officetricks.com/ kumarapush
- Bruno Zotti
- https://officetricks.com/ kumarapush
- Sanjay
- https://officetricks.com/ kumarapush
- Compliance Chennai
- Kevin
- https://officetricks.com/ kumarapush
- Arpi K
- barna
- Santhu Major
- Santhu Major
- KnapsacK
- https://officetricks.com/ kumarapush
- Indu Sudhir
- https://officetricks.com/ kumarapush
- shaheer
- https://officetricks.com/ kumarapush
- http://www.hostick.ir Masoud Avard
- https://officetricks.com/ kumarapush
- LIZZY
- https://officetricks.com/ kumarapush
- Abby B.
- https://officetricks.com/ kumarapush
Excel To VCF Converter 1.1 – Excel To Vcard – 68,000 Downloads
Post Categories
Popular Posts
Recent Posts
Similar Pages
Popular Tags
- Email Marketing Block Apps in FaceBook Task Manager print screen VCF HTML Table Import Data Candy Crush Outlook Record Macro android app development SEO Convert URL to IP HTML/ Javascript QR Code Generation VCARD Timer in Excel Countif Google+ bitcoin vba color index vba color codes Data Mining Android social media Twitter bulk email Google Adsense Tips Excel VBA Calendar in Excel Excel Macro WhatsApp Facebook mass email outlook vba Wordpress