Petar Strinic and all those sorts of things…

March 27, 2009

VCF to CSV Converter

Filed under: — admin @ 12:19 pm

New version of the converter is ready for testing. It adds support of a large number of fields and conforms to the VCARD 3.0 standard.

You can find it here: http://code.google.com/p/vcf-to-csv-converter/

You can now find it here: https://github.com/pstrinic/vcf-to-csv-converter

I will leave this old version here for now, if anyone still needs it.

Param Description
h or –help displays the usage menu
-i filename input file (required parameter)
-o filename output file (require parameter)
-d [comma|tab|semicolon] delimiter to use in the output, tab is default
-q double quote the output values

python ./convertContacts.py -i vcfFile.vcf -o ~/csvFile.csv -d comma -q

  convertContacts.py (5.3 KiB, 10,338 hits)

Latest updates: http://code.google.com/p/vcf-to-csv-converter/

Latest updates: https://github.com/pstrinic/vcf-to-csv-converter

jordan 11 low georgetown cement tongue 5s low bred 11s midnight navy 5s low hornets 13s jordan 7 lola bunny jordan 5 cement tongue jordan 13 low bred low georgetown 11s jordan 11 low bred low hornets 13s low bred 13s jordan 11 low georgetown cement tongue 5s low bred 13s jordan 5 cement tongue low bred 11s jordan 13 low bred jordan 11 low georgetown low georgetown 11s
low bred 11s jordan 5 cement tongue metallic silver 5s low georgetown 11s nsk 203 set jordan 13 low bred jordan 11 low georgetown low bred 11s midnight navy 5s jordan 11 low bred jordan 11 low georgetown hare 7s low georgetown 11s jordan 5 midnight navy metallic silver 5s low georgetown 11s jordan 11 low bred low hornets 13s low georgetown 11s curing light cure lamp
michael kors outlet michael kors uk christian louboutin sale christian louboutin uk christian louboutin sale christian louboutin sale adidas Yeezys michael kors outlet adidas Yeezy christian louboutin uk michael kors outlet uk christian louboutin uk michael kors outlet uk christian louboutin uk louboutin uk michael kors outlet uk christian louboutin sale christian louboutin sale michael kors outlet adidas Yeezy 750 Boost
low georgetown 11s low hornets 13s low georgetown 11s low georgetown 11s low georgetown 11s jordan 11 low georgetown jordan 11 low georgetown jordan 13 low hornets low hornets 13s jordan 5 metallic silver jordan 5 metallic silver jordan 11 low georgetown low hornets 13s louis vuitton outlet metallic silver 5s jordan 13 low hornets jordan 11 low bred jordan 5 metallic silver low georgetown 11s jordan 5 metallic silver
jordan 11 low bred jordan 11 low georgetown jordan 5 metallic silver jordan 11 low georgetown jordan 11 low georgetown jordan 11 low bred jordan 13 low hornets jordan 11 low bred low georgetown 11s adidas yeezy boost low georgetown 11s jordan 11 low georgetown coach outlet low georgetown 11s low georgetown 11s low georgetown 11s adidas yeezy 750 boost jordan 11 low georgetown jordan 5 metallic silver low georgetown 11s
Share

36 Comments »

  1. awesomo!

    Comment by Hessy — April 9, 2009 @ 8:11 pm

  2. Dear Peter,
    I will need your help and advice. I’ve been using Sonyericsson phones for long years. I always transferred my vcf phone book directly to my new phones. But now I have a Nokia phone and I cant convert all my phone book to csv. The problem is that in my address book one person some times has 3-4 mobile numbers. When I convert this vcf it only converts some of my numbers not all. What do you think I should do? If you can write to me your advice I would be very happy. Thanks a lot.

    Comment by hakan yaman — May 1, 2009 @ 1:47 am

  3. Hello Hakan,

    Google Contacts allows you to merge multiple contacts into one. You could in theory export to CSV, import the CSV into Google Contacts/GMail and merge the multiples that way.
    Your other option is to send me a sample of the input file and perhaps I can find a way to merge multiple similar records into one in some way.

    Let me know how it all works out for you.

    Comment by admin — May 3, 2009 @ 10:47 am

  4. Hi there…can you please help me? I’m not able to convert vCards from Address Book to transfer to a Nokia 8910i phone.. I’ve tried other CSV converters but once I send the file to my phone, it says “not supported by the phone”. Are there different versions of CSV files?
    I couldn’t figure out how am I suppose to use the above thing. When I download it, Terminal opens up showing “missing required parameters”
    Thank you…

    Comment by Chirag — June 21, 2009 @ 7:36 pm

  5. Unfortunately I’m not familiar with the details of the import file required by the 8910i. There’s a possibility they require a different delimiter or something. To use my converter you would type in a command like this:

    python ./convertContacts.py -i {input file name} -i {output file name}

    Can you tell me how you are executing it?

    Comment by admin — June 23, 2009 @ 6:00 am

  6. Great; saved my bacon when I had over 100 VCF v-cards my boss wanted dumped into excel!! Notice your surname. Srbin? Pozdrav!

    Joni

    Comment by joni Mueller — June 29, 2009 @ 2:59 pm

  7. thanks

    Comment by vv — July 14, 2009 @ 9:59 am

  8. Hi how to type command python ./convertContacts.py -i {input file name} -i {output file name} ?

    the file where i put eg c:\

    Comment by dragon61 — August 4, 2009 @ 7:15 am

  9. I couldn’t figure out–it doesn’t do Address/City/State/Zip/Country, or I did something wrong?

    Comment by Alan — September 10, 2009 @ 11:59 pm

  10. tried it with nokia contacts vcf file – no good.

    Comment by bill — September 20, 2009 @ 3:00 am

  11. Bill and Alan, if you can send me a file I will try to make it work. Use the contact form please.

    Comment by admin — September 23, 2009 @ 2:07 pm

  12. Hello,

    I’m trying to convert contacts from the Motorola RAZR V6 to the LG KP202. This is what happens :

    root@marietto2009:/home/marietto/Scrivania/LG# python ./convertContacts.py -i Contacts.vcf -o contacts.csv -d -q
    converting Contacts.vcf > contacts.csv (tab delimited)
    Traceback (most recent call last):
    File “./convertContacts.py”, line 188, in
    main()
    File “./convertContacts.py”, line 184, in main
    VCFToCSVConverter( input_file, output_file, delimiter, quote )
    File “./convertContacts.py”, line 139, in __init__
    self.__parseFile()
    File “./convertContacts.py”, line 45, in __parseFile
    self.__parseLine( theLine )
    File “./convertContacts.py”, line 63, in __parseLine
    self.__processLine( theLine.split(“:”) )
    File “./convertContacts.py”, line 71, in __processLine
    self.__process_phone( pieces[0].split(“;”)[1], pieces[1] )
    IndexError: list index out of range

    Comment by Mario — September 26, 2009 @ 3:05 am

  13. hello, my name is Marsha, I have 1441 emails in Address book my vcf vcards are all in groups A B C D etc. each group belonging to different places. and I am getting ready to upload them into a bulk mail program. They use a cvs format I can change each of them individually no problem, I need some way to do this quickly, any ideas???
    hopefully my casket is finished before I am..
    marsha

    Comment by Marsha — March 30, 2010 @ 2:24 pm

  14. File does not exist :( I guess I need to cook my own script

    Comment by Tan — July 25, 2010 @ 1:22 pm

  15. Oops. Fixed.

    Comment by admin — July 25, 2010 @ 3:48 pm

  16. You should probably look at the newer version on google docs, anyways: http://code.google.com/p/vcf-to-csv-converter/

    Comment by admin — July 25, 2010 @ 3:48 pm

  17. I tried to convert about 200 vcf cards from my n900, but I get this error and no output:
    Traceback (most recent call last):
    File “./convertContacts3.py”, line 467, in
    main()
    File “./convertContacts3.py”, line 463, in main
    VcfToCsvConverter(options.input_file, options.input_path, options.output_file, delimiter, options.quote, options.trace, options.verbose)
    File “./convertContacts3.py”, line 413, in __init__
    self.__parseFile()
    File “./convertContacts3.py”, line 107, in __parseFile
    self.__parseLine(theLine)
    File “./convertContacts3.py”, line 124, in __parseLine
    self.__processLine(theLine.split(“:”))
    File “./convertContacts3.py”, line 220, in __processLine
    self.__processAddress(pre, pieces[1])
    File “./convertContacts3.py”, line 318, in __processAddress
    (a,addressTypes) = pre[1].split(“=”);
    IndexError: list index out of range

    If you need any more info please let me know.

    Comment by seagolfer — August 24, 2010 @ 5:36 am

  18. Hi,
    Will this support a conversion of Palm desktop contacts to Google (for my new Android phone)? I have not found a solution and really hope this is it!

    thank you

    Comment by Alyssa — September 16, 2010 @ 5:21 pm

  19. […] VCF to CSV Convertor Another online option CSV to VCF online Convertor Sourceforge Convertor option GNU Code option 1 GNU Code option 2 Gaz and Guy on Twitter,feedback@mymac.com, or our Skype direct number […]

    Pingback by Podcast Where have all the Guy’s gone? MyMac Podcast 313 — September 30, 2010 @ 11:48 am

  20. I’m trying to convert a Skype vcf contacts file to csv. I’m just trying to pull the Skype display names and phone numbers out. I get the same IndexError: list index out of range as SeaGolfer.

    Any suggestions would be appreciated.

    Thanks!

    Comment by Michael — October 9, 2010 @ 10:51 am

  21. As a general note, to process any random field, you should be able to add an “else if” statement to the end of the giant “if…else” statement in __processLine.

    elif pre[0] == ‘X-SKYPE-DISPLAYNAME':
    self.__processSingleValue(‘ORGANIZATION’, pre, pieces[1])

    In this case “X-SKYPE-DISPLAYNAME” is the source field, and “ORGANIZATION” is the destination field.

    Some fields that require more logic, such as phone numbers may require a bit more/different logic, such as adding this “else if”

    elif pre[0] == ‘X-SKYPE-PSTNNUMBER':
    self.__processTelephone(pre, [pieces[1]])

    Comment by admin — October 11, 2010 @ 11:40 am

  22. Hi Peter,
    Keen to use your convertor, downloaded it but can you give me some brief details on how to use it.

    Comment by Peter Briscoe — November 6, 2010 @ 1:33 am

  23. Make sure you have python installed. Then from the command line, execute something like this:

    python ./convertContacts.py -i {vcfFile.vcf} -o {csvFile.csv} -d comma -q

    of course replace {vcfFile.vcf} with the path & name of the VCF file and {csvFile.csv} with the path & name of the file you’d like to get.

    Comment by admin — November 8, 2010 @ 7:46 am

  24. A glitch in SmarterMail had it importing only ONE record from my GroupWise vcard file, so I needed something to convert the .vcf to .csv.

    This seems to have worked perfectly! Had vcard 2.1 file – v3 of your program gave a warning about the version number of the old file, but looks like it converted things fine. The earlier one worked great.

    I created a batch file so that I could run from the command line and just feed it the name of the input file, with the same name for the output file (with csv extension of course).

    ** I renamed the program (convertContacts.py) to just cc2.py **

    Here’s the contents of my batch file if anyone is interested – I just put the vcf file into the Python27 folder, and ran my batch from the command prompt in the Python folder in Windows (XP Pro x86):

    python ./cc2.py -i %1.vcf -o %1.csv -d comma -q

    And then you run it thusly: {batch-file name} {vcf-file name} [Enter]

    Other info: used Python 2.7, installed in default folder (c:\python27)

    Piece of cake to use.

    THANK YOU THANK YOU!

    Comment by PJBeee — January 4, 2011 @ 2:15 pm

  25. Try this Windows version of VCF to CSV Converter from
    http://www.softspire.com/vcf-to-csv.html

    Comment by Admin — March 26, 2011 @ 1:27 pm

  26. Can this Script be included in a symbian C++ code? will it work?

    Comment by Sandy — April 28, 2011 @ 4:28 am

  27. Yes! VCF to CSV conversion over MS Outlook is easy. Go here:

    File >> Import & Export > Export a File >> Comma Separated Values (CSV) >> Provide Display Name >> Select Contacts Folder >> and proceed further.

    Its not enough, you may also try this vCard converter tool for automate conversion process.

    Comment by T.T. Adom — September 7, 2011 @ 2:45 pm

  28. I can not find the solution for the field “Skype” in OS X 10.7.4.

    The field in the file “name_file.vcf” is:

    IMPP;X-SERVICE-TYPE=Skype;type=HOME;type=pref:skype:MyNameSky

    Do you have a solution?

    One more question, you can export multiple “URL”?

    Thanks and sorry for my GooglEnglish
    Toni

    Comment by toni — July 6, 2012 @ 3:38 pm

  29. […] VCF to CSV Convertor Another online option CSV to VCF online Convertor Sourceforge Convertor option GNU Code option 1 GNU Code option 2 This entry was posted in Podcast by MyMacPodcast. Bookmark the […]

    Pingback by Where have all the Guy’s gone? – Episode #313 | MyMac Podcast — August 13, 2012 @ 1:11 pm

  30. Is this a MAC only application? I’m a PC user and need to import 1000+ vcf’s into outlook. This file type is unrecognized by my PC. Instructions to use??? Help!?! Thanks!

    Comment by Anonymous — August 17, 2012 @ 10:01 am

  31. It can definitely work on Windows. All you need is Python (http://www.python.org/getit/windows/).

    Comment by admin — August 18, 2012 @ 6:59 pm

  32. i Have 1340 Contacts in Pc, How Can import that into Outlook,

    Comment by Satheesh — January 3, 2013 @ 4:17 am

  33. I have 2500 contacts on my pc in vcf format but my nokia 6500c cant access them and keeps telling me format not suported help urgently cant use my contacts….hassan

    Comment by hassan — May 9, 2013 @ 2:27 pm

  34. Hi Peter,

    Thanks for your program.
    My vcf file uses VARD 2.1 format, Can you please help to convert this.

    With this program, I am getting WARNING in the first column of csv as “Unexpected VCARD version: 2.1.”. And names are not getting listed, but phone numbers are shown.

    Comment by Satya — June 7, 2013 @ 8:14 pm

  35. Satya,

    I looks like the FN tags is the same for VCARD 2.1 and 3.0. It should work. Can you share a record from your file?

    Comment by admin — June 9, 2013 @ 10:04 am

  36. You can also use vCard converter: http://www.vcardconverter.in/

    Comment by devid martin — October 4, 2013 @ 3:37 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress