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

Project Activity

See All Activity >

License

GNU General Public License version 2.0 (GPLv2)

Follow Free VCF file to CSV or Excel converter

Free VCF file to CSV or Excel converter Web Site

Other Useful Business Software
An All-in-One EMR Exclusively for Therapy and Rehab. Icon
An All-in-One EMR Exclusively for Therapy and Rehab.

Electronic Medical Records Software

Managing your therapy and rehab practice is a time-consuming process. You spend hours on paperwork, billing, scheduling, and more. Raintree’s Therapy & Rehab EHR is here to help you manage your practice more efficiently. With our all-in-one solution, you’ll get the tools you need to streamline your therapy and rehab practice, improve patient care, and get back to doing what you love.
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
98
4
3
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

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.
  • An excellent example of a superb VBA script. My only problem was disabling Microsoft security which by default prevents VBA scripts from running automatically. You'll need to follow Microsoft instructions to enable the script to run automatically upon opening the file i.e. close the file, right click it, and enable the script to run automatically via properties. Otherwise, double thankyou to ghadlock. GOAT VBA Script!
    1 user found this review helpful.
  • 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.
Read more reviews >