Browse Code ▾
This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail Contacts), Apple IOS, Samsung Android devices and other platforms. If this doesn't work for you, please email me the VCF file and I'll modify the code to support your specific VCF format.
To use, simply download and open the Excel file (xlsm), Enable Macros if prompted, and then select the VCF file you wish to import. Once complete, Excel will create and save new file titled VCFExport.csv that can also be saved in Excel format.
Features
- Supports Mac (Apple) computers running Excel 2011 (later versions of Excel not supported on Apple)
- Support for Spouse, Assistant, Children, Preferred Email, Preferred Phone, and Preferred Address Fields
- Completely free! All I ask is that you review the program here if it works for you, or let me know via email if it does not so I can improve the compatibility for other users.
- Automatically deletes duplicate contacts that have email address only (generally created by Gmail)
- Support for fields > 255 characters long (e.g. large notes / body field)
- Support for VCF Files exported by Samsung Phones and Samsung Tablets
- Converts Bulk VCF Files to CSV files (VCF files that have more than one contact)
- Supports multiple contacts in a single VCF file
- Supports multiple phone numbers, email addresses, and address per contact and assigns categories (e.g. Home, Work)
- Fast & Free Support- if this does not work for your VCF, email the VCF file and I'll update the code as needed to support your file within 24 to 48 hours.
- Support for VCF Files with ENCODING=QUOTED-PRINTABLE (MIME encoding to ASCII printable characters)
- Published as Excel file, simply download and open the Excel .xlsm file and select the VCF file you wish to import when prompted.
- Developed and tested to support import of Google VCF files from Gmail Contacts
- Tested support for Apple IOS Exports (IOS 5 and IOS 6)
- CSV File created with Column Headers that perfectly match Outlook import template
- Supports extremely large VCF files, tested with file containing 20,000+ contacts
- With Excel Save As, can also save as XLS file instead of CSV if desired
- Support for VCF 2,1, 3.0 and 4.0 Formats
- Allows importing of bulk VCF files into Outlook or other programs
- DOES NOT currently show progress during import, may take 2 to 5 minutes to run (be patient)
- New versions developed as needed to support user submitted files; each new version tested across diverse set of VCF formats to ensure maximum compatibility
- Support for COBook contacts export and fields unique to COBook
Project Samples
License
GNU General Public License version 2.0 (GPLv2)Follow Free VCF file to CSV or Excel converter
Other Useful Business Software
Take away the pain and hassle associated with applicant recruitment, hiring, and onboarding with ApplicantStack. Designed for HR professionals and recruiters, ApplicantStack helps streamline the recruiting and onboarding processes to improve productivity and reduce costs. ApplicantStack provides a complete toolkit that includes tools for posting, launching, and advertising jobs, assessing and managing candidates, collaborating with teams, centralizing information for quick hiring and onboarding, and more.
Rate This Project
Login To Rate This Project
User Reviews
-
I had a 2500 record vcf. I didn't trust any cloud providers not to harvest that data .... this worked. It tool nearly 15 minutes to convert, but it was worth it.
-
Most of us don't have a need to do this conversion process very often, so we hesitate about buying software (which is hard to find and won't do the job any better than this excellent VBA script). Also we don't want to use an online converter who could record and sell our contact lists. So here we are, hoping this freeware will do the job. Well, my only problem was disabling the Microsoft security settings, which by default prevent VBA scripts from running automatically. For this, you'll need to follow Microsoft instructions i.e. close the file, right click it, and enable the script to run automatically via properties. Aside from this, I offer a double thankyou to ghadlock. He's done an amazing job with this VBA Script. It works like magic!
-
Works very well, quite easy. Thanks.
-
Tried many different converters online, followed several "tutorials" and nothing worked. This converter did the job in about two seconds and the output was PERFECT. Thank you!
-
Worked 100%, fields all matched up correctly.