January 30, 2011

Merging Many .VCF Files In One File & Convert To CSV

Phonebook or a contact information is the most important part of every mobile user. Most of us have forgotten to keep a written backup of any mobile number and when we do not have our mobile along, we are helpless. This is also true when you want to change mobile phone or want to transfer complete mobile contact information or phone book. 
These are the days of faster upgrade of mobile devices and we are changing mobile handsets more frequently. now when you want to transfer your contact numbers from old mobile to new one, there are many problems we come across, like different mobile manufacturing companies use different file formats, different type of backups and various computer sync software. 
Most of the mobiles do have an option to backup your mobile phonebook but they all save the backup file in a proprietary format. Eg. Nokia saves a backup file in .nbf format. You can use that backup file only for other Nokia mobile. (Read How to extract and Read Nokia Backup File like .nbf and .noki) But if you have changed the handset manufacturer this phonebook backup does not come to your help and you have to transfer all these addresses manually.
The other way is to save all your phone-book as a vcf file. All the phones have this function but the problem is each and every entry is saved as a separate file. So if you have say 500 contacts, there will be 500 .vcf files. 

VCF

This is the most commonly used contact format. It's called "Visiting Card File / format". You will find this type of contact files when you try to backup your entire contacts from your mobile to memory card. Your mobile will save every contact in one .vcf file. If you want to transfer all your contact from mobile to any other software you have to manually transfer each and every file. So What is the solution to transfer all these contacts at once?
Yes - you need to concatenate or merge all the VCFs into a single file 

1. If you're using windows: 

GOTO Command prompt. (Windows_Key + R)

Run: cmd

2. Change to the directory where all your VCFs are stored
            d:
     cd   \my_vcfs

3. Run this command
                  
copy   /B   *.vcf   all_in_one.vcf

all-vcf-one-file

Then just upload the "all_in_one.vcf" file to your software and it will grab all your contacts in one go

CSV

CSC is the most commonly used data management format. Its Comma Separated Value file. You can use simple office excel to edit the file.

Convert .vcf File into .CSV file easily.
Just go here LINK

Once you have converted the VCF in to CSV, you can Edit the converted .CSV file as you want with this "CSVEd" software which is Free or you can also use MS Excel to do this.

Download CSVEd

If you do not like the CSVEd, you can use more easily and excellent utility which is just 100KB. 
Author : Pravin
TopTrix, Updated at: 1/30/2011 09:58:00 PM

42 comments :

  1. Thank you for the instruction. After the conversion, the .csv file recognised the phone numbers as numbers and omitted all the + signs for the country code. Anyway that can be corrected without having to enter the + sign?

    ReplyDelete
    Replies
    1. Yes, you can remove plus sign. You can also set the bulk rule to add + sign in all phone numbers with the CSV edit software.

      Delete
  2. Hi dost esa kuchh hai jese me apne sare contek net pe bhej du or mera dost jise pure con.lena chahe to le sakta hai plz tell

    ReplyDelete
    Replies
    1. You mean, you want to send a contact file to your friend? You can easily send even a single contact or a whole phonebook containing 1000's of contacts.
      Just tell me, what type of contact file you want to send? Do you want to send complete phonebook of your mobile? If you want to send a complete mobile address book, tell me which mobile model you have and where or by what means you want to send it to your friend like via email or via a shared file.

      mai tumhari poori help karunga. par tum mujhe details batao. there are many such tools. just give details.

      Delete
    2. hey genius !!
      i'm just a step away from success using your method, please help me converting my 984 VCF files to CVS, as i followed your method all_in_one.vcf and imported it into outlook, it just imported one contact detail and without name, i want to import all my vcf to outlook but not one by one.. so need your kind help..

      Delete
  3. Hi dost esa kuchh hai jese me apne sare contek net pe bhej du or mera dost jise pure con.lena chahe to le sakta hai plz tell

    ReplyDelete
  4. hi,,
    vry much thanks for this useful info
    it worked just the way i wanted ...
    thanku soo vry much ...

    ReplyDelete
  5. God bless you.

    What a pitty that I didn't find this page before few hours ago. You save my nerves and my keyboard too.

    Thank you

    ReplyDelete
  6. God bless you.

    What a pitty that I didn't find this page before few hours ago. You save my nerves and my keyboard too.

    Thank you

    ReplyDelete
  7. Awesome. Thank you, thank you thank you. I forgot how easy everything was before !@#$%^&* Windows. I spent an hour trying to download a tool from a web site to do my christmas mail merge and gave up right before finding your post. Thanks for the simple solution. Did I say thanks? Well, thank you.

    ReplyDelete
  8. Awesome buddy this worked, what i did is copied all my contact cards from Outlook into my machine, used your technique to convert into one file, sent it to my gmail id, opened the file in my Iphone and BANG all my contacts got downloaded...! Cool... Thanks
    Jerry

    ReplyDelete
  9. Hi

    having one major problem with the conversion of multiple vcf into one..
    the names appear "blank" in all columns

    please help

    ReplyDelete
  10. seems workable but I have one major issue while converting the multiple VCFs to a single VCF

    The name field appears blank in all the contacts

    whats the solution??

    ReplyDelete
  11. can u tell how to discombine combine VcF Files in seperate vcf files???

    ReplyDelete
  12. Thanks a lot. Great tip. Saved me a lot of headache in importing so mny vcf's into my new phone!

    ReplyDelete
  13. great help man
    I just copy and paste your cmd and got my phone book in exell

    ReplyDelete
  14. GREAT THANKS A LOT
    I JUST COPY N PASTE YOUR CMD N GOT WORK DONE!

    ReplyDelete
  15. hello sir am having lumia 620so i want to upload my .vcf contacts into it. as i hav done ur mentioned process of "all_in_one.vcf" and now am not able to do any further steps iam uploading via hotmail and it needs .csv file one by one. so please help me in uploading my contacts or converting it in to .csv file.

    ReplyDelete
    Replies
    1. Hi Vivek, actually, the tutorial already discussed the way to convert VCF file in to .CSV file. You can also use the csv edit application software to do it.

      Delete
  16. hello sir as am using lumia 620 it imports contacts through hotmail which is .csv file supporter. i have done ur above mentioned step"all_in_one.vcf" now how i convert this into .csv file. while iam doing through hotmail mail it is taking one by one file. so please help me out in uploading my contacts or converting them in bulk in .csv file.

    ReplyDelete
  17. Hello, at the beginning I had the many VCFs contact files (about 300). So, I used the command "copy /B *.vcf all_in_one.vcf" described above. Then I imported this all_in_one.vcf into the Google account as a new contacts. Then you have to export them to Outlook CSV format file - all_in_one.csv. And finally, you need to import it to your LIVE account. So, at the end you will have all these contacts imported in your actual live.com account.
    You can synchronized them in your Nokia Lumia phone.

    ReplyDelete
    Replies
    1. Hi Enigmatique, thanks for the easier way and your help.

      Delete
  18. Only half of my contacts out of 800 are converted into single vcf. What to do about the rest??

    ReplyDelete
  19. Only about half of my contacts out of 800 were converted to single vcf. What about the rest?
    Plz advise help.

    ReplyDelete
  20. Very useful article.thanks for the help.

    ReplyDelete
  21. Thank you! You saved me a lot of time and energy! :)) Very kind of you to share :)

    ReplyDelete
  22. Thank you! You saved me time, energy and a possible frustration :)) Very kind of you to share, thanks :)

    ReplyDelete
  23. Dear
    Kudos to the information you have shared.. excellent !! my hundred +1 for you.. :)

    ReplyDelete
  24. THANK YOU SO MUCH!

    Every website I went to told me to do the Command Prompt thing and stopped there. However, Google only grabbed the first contact of the entire compiled file. Tried compiling it by typing ".csv" instead of ".vcf" but that didn't garner good results. The online converter is a life saver!

    Thanks again!

    ReplyDelete
  25. thank u very much friend, ur trick just save my contacts

    ReplyDelete
  26. i need to convert .csv file into .vsf file for android mobile...
    can any one help me?
    Thanks in advance...

    ReplyDelete
  27. Thank you... You are GENIUS....Saved my day

    ReplyDelete
  28. Works brilliantly in windows 7 thanks

    ReplyDelete