Closed Thread
Results 1 to 7 of 7

Open .vcf Files in Excel

  1. #1
    Forum Contributor
    Join Date

    Open .vcf Files in Excel

    I am downloading several 1000 ( thousand ) names, addresses, city,
    state, zip, telephone number files from a website and the names
    can only be saved as .vcf files.

    However, I would like to open all of these files in Excel so that I
    can clean up all of the information.

    I have downloaded several test names with .vcf extensions in a
    Documents/Download directory and now I am trying to find a way
    to open all of these files in Excel at the same time....not one file
    at a time.

    Is there a way to do this or is there a conversion file that would be


  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365

    Smile Re: Open .vcf Files in Excel

    Good afternoon scotfitz
    Quote Originally Posted by scotfitz View Post
    the names can only be saved as .vcf files.
    However, I would like to open all of these files in Excel
    Would you be able to post a (small) .vcf file so that we can take a look at one, and perhaps make suggestions from that basis?

    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    MS-Off Ver
    office 97 ,2007

    Re: Open .vcf Files in Excel

    try here only $15 scroll down to
    Vcardconvert 1.2
    saves all .vcf into one .slk which can be opened with excel
    Last edited by martindwilson; 02-06-2010 at 03:56 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Re: Open .vcf Files in Excel

    Hey try this link -, supports multiple formats - Excel(XLS), CSV and PST(Outlook).

    This will help you export vCard files to Excel file with all fields.YOu can easily open VCF files in Excel with this tool...

    Try it... its a worth tool

  5. #5
    Registered User
    Join Date
    Dili, Timor-Leste
    MS-Off Ver
    Excel 2010

    Red face Re: Open .vcf Files in Excel - SOLVED

    I know this is a little old but my cell phone service provider just added an extra digit to all cell numbers. What a pain to amend by hand. Bit of Google and I came across this post and thought I would give it a go.

    So, I backed up my phone's contacts (the LG KP500 is a cheap but pretty clever "smart phone") onto the micro SD card (I don't have a USB cable), removed the micro SD card and put it into my PC, created a copy of the .vcf file with a later date time file name, opened the new file with Excel 2010 (accepting the default settings for a non-native file type) and had a bit of a play.

    I did a find and replace on the line with the numbers in it (see below) and, very slowly intially, did a replace one-by-one. Eventually I found it was not coming up with any false positivies so I clicked "replace all". I also tidied up some of the contact names.

    Replacing the micro SD card in the phone, I cleared all the numbers off the handset, did a restore from the new .vcf file on the micro SD card, did a check, and all is well. 200+ contacts updated in 10 minutes rather than hours.

    For info, my excel commands were:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    (adding the new digit between the international dialing code and the first digit of the local number, so +6707123456 became +67077123456).

    Please do a few tests first and check the results to ensure you have got teh find and replace right.

    I was too scared to delete any unwanted contacts as I thought there might be some sort of algorhytm that tied them all together, but I don't think it would be a problem, espescially if you have kept the earlier .vcf file if something goes wrong!

    Enjoy, this is a really easy fix.
    Last edited by ahalin; 08-01-2012 at 03:40 AM.

  6. #6
    Registered User
    Join Date
    England & Spain
    MS-Off Ver
    Excel 2003

    Red face Re: Open .vcf Files in Excel

    Simply change the .vcf file index to .xls then you can read the file in Excel.

  7. #7
    Forum Moderator dominicb's Avatar
    Join Date
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365

    Re: Open .vcf Files in Excel

    Thread closed to prevent persistent spam.

    If you have a valid reason for opening this thread, please contact a moderator / administrator.


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06661 seconds
  • Memory Usage 8,998KB
  • Queries Executed 14 (?)
More Information
Template Usage (33):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (46):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1