Work in progress

This site is currently undergoing an update. If you spot any problems on this page, please let me know.

Convert VCF to CSV

I spent ages looking for a way to convert a VCF file (output from Evolution) to a simple CSV (to mail merge). I found a fantastic solution which you can either use online, or for the security conscious (or paranoid) you can also download an run on your own server. VCF-Convert from brotherli.ch (new window).

Update: To go the other way, I used this page with great success. It’s all javascript, so seems quite secure.

Posted on: December 29, 2006
Previous post: The Voyage to Koh Pha Ngan
Next post: Tom Leaves Us

Categories

Comments

joost at 2007-01-28 21:00:03

I am delighted with your program, but… Online it works fine. On my computer I get the error: '.$GLOBALS['error_msg']."\n"; ?> Instead the converted testfile it gives a index.php file. I use Apple G4, OsX10.4.8, Firefox 1.5.0.9 Probably it must run on a server.

Callum at 2007-01-29 00:59:37

Hi Joost, the program is not mine, I simply linked to it. I uploaded my file and it worked fine. Good luck - Callum.

Macsico at 2007-02-09 23:03:14

The page states below th online convert form: "You can also download the script and run it locally. All you need is a shell with PHP installed." Shell means Terminal and PHP means PHP environment. Maybe an additional local MAMP installation could help here if the information is too confident.

fime at 2007-03-01 23:47:45

thanks for the link. very useful.

Mexy at 2007-06-22 00:53:32

WOWWWWWWWWWWW ..... great! Thanx!! Also spent ages looking for a way ... was even trying to so it manually (hit head against wall!!!!) Cheers

spidersddd at 2007-06-29 03:26:36

Thanks for the link. It worked great for me. SPIDERSDDD

Kim Connors at 2007-08-02 19:18:33

You saved my bacon! and a lot of tedious work. Script works very well. Thanks Much! Kim

cubny at 2007-09-10 11:37:46

thank you very much

Luiz Bonetti at 2008-03-20 12:05:21

Thanks!

Ralf Engels at 2007-11-06 22:38:15

Nice but not perfect. E.g. it will swallow postbox and extended address. It will also not extract uncommon tags like TITLE or GEO. My own page (http://www.tomota.de) should do a better job in converting. If you are just interested in learning more about parsing vcards I propose to have a look at the evolution-server source code.

Nick at 2008-01-08 04:42:23

where can i get shell and php

James Jones at 2008-02-05 14:11:17

Thank you for the help converting my iPod contacts file to my Outlook Express address book. I searched for quite some time to make it happen, to no avail. That is until I tried your converter. I had to figure out what format to convert it to, but that took a whole 3 minutes. Then, poof...it worked great. Thanks again.

Callum at 2008-01-08 10:21:31

@<a href="#comment-22890" rel="nofollow">Nick</a>: If you don't know where to get a shell with PHP, I'd suggest you upload your file and let their site do the conversion for you.

j harake at 2008-03-27 20:29:42

I am very grateful

Callum at 2008-02-11 07:31:51

Glad it worked for you. Just to be clear, the script is not mine, it's a provided by <a href="http://brotherli.ch" target="_blank" rel="nofollow">brotherli.ch</a>.

Charles at 2008-11-11 14:12:47

I can't believe people are happily putting all of their private data into a webpage with no thought of the risks involved. Anyone know of an easy to use application that can be downloaded?

odiyya at 2008-10-30 09:58:17

you can also use this site by simply uploading your vcf file and choosing your desired output. two step process and works great. http://labs.brotherli.ch/vcfconvert/

eli at 2008-12-16 07:15:00

Hey- This is great! Thanks. For those of you that had privacy concerns and questions about running this script locally, here is a quick solution (for Windows users... directions can be adapted slightly for Mac and Linux users)... Download the XAMPP server for your operating system ( from http://www.apachefriends.org/en/xampp.html ). This is a lightweight webserver that supports PHP &amp; mysql that will run locally from your computer. So when it is installed and active, if you go to http://localhost/ in your web browser, it will take you to the default webpage for the XAMPP server. *Note: the installation is pretty unobtrusive, but, in case you have concerns, there is a "Lite" version available that will run from a USB stick without installing any files into your system. Next... unzip the files from the vcfconvert-0.8.2.tar.gz (tar.gz is a type of file that is just like a .zip file. If you need software to open it... try the free, open source 7zip from www.7zip.com). Unzip the folder in the archive to your htdocs document root folder... If you did the default XAMPP installation this folder will be c:\xampp\htdocs\ ... Now, assuming the XAMPP server is active and you unzipped the files to the right place, you should be able to open your web browser to something like http://localhost/vcfconvert-0.8.2/ ... and walla! you've got your own private, secure way to run the script that's on this page.

steg at 2008-09-25 15:02:02

If you have to go back the other way vcf ( vcard ) to csv for like gmail or something use this site which has both. http://www.vcf2csv.com/ Also the javascript converter at the bottom is the only one I've found to accept multiple record vcf files which is what OS X's Address Book creates. Outlook can't handle this format even though it conforms to vcard standards, so you'd have to import an address book db as a collated csv actually.

Chrille at 2009-09-16 06:05:14

Just the thing I was looking for, thanks!

Arun Christopher at 2009-12-31 01:55:27

Works great... Thanks a lot...

Callum at 2008-09-25 15:48:17

Thanks for the feedback steg.

Carrie at 2009-07-15 09:35:46

THANK YOU! You saved me hours of frustration and typing!

Mr. Reddy at 2009-05-21 00:13:28

Hi friends, Please help me in this regard. i had a mobile sony ericsson w580i, now i have gone for Nokia 5130c. how can i copy all my contacts from Sony ericsson w580i to Nokia 5130c. Please guide me in this regards... Please.......

Pro Backup - online backup at 2011-02-09 17:57:01

It's a pitty that this brotherli Vcf to Csv script only converts up to 2 e-mail addresses per card, and the script doesn't know what to do with the extended properties like item1.X-ABLabel.

Callum at 2009-05-25 18:30:17

@<a href="http://www.callum-macdonald.com/2006/12/29/convert-vcf-to-csv/comment-page-1/#comment-35965" rel="nofollow">Mr. Reddy</a>: I'm not familiar with those phones. Best of luck.

francisco at 2009-07-10 18:21:00

How can I convert a vcf to nbu?

Patrick at 2009-05-26 07:36:16

God send! thankyou!

Violet at 2009-06-09 18:18:08

THANK YOU!!! You just saved me ages of manual typing!!!

Tracy at 2009-05-11 13:33:48

I consulted with Mac tech support and salesforce.com tech support, and with other techie people here in Silicon Valley (I am not a techical person) and they all told me that converting a vcf file to csv for upload into salesforce.com was virtually impossible. I am so thrilled that this application worked for me, in just seconds after a few attempts. Thanks a million.

Carol at 2009-10-27 02:08:54

I am trying to export my windows mail contacts and emails to Thunderbird. I am working on my contacts. I have them in a folder on the desktop and they are VCF. I don't understand how to get them to CSV--one at a time? I did one here online and it just went into an excel file. OK, I have it out of Windows Mail, but how do I get it into Thunderbird? I don't understand.

Callum at 2009-10-27 02:29:08

I'm not very familiar with any of the programs you're using. I posted this link to a VCF to CSV conversion service. I don't host the service or know much about it. I haven't used it since I posted that link back in 2006. Good luck with your migration.

Mayur at 2012-03-16 11:30:00

http://labs.brotherli.ch/vcfconvert/ try this link, it works for me.,

Carol at 2009-10-27 02:55:17

Thanks for you prompt answer. My issue was to convert from VCF to CSV. I decided it was a good time to clean out my email address book. I pretty much have it done. This conversion tool looked like the right way to go but it didn't make sense how to do it. No matter now I guess. Have a good one.

Callum at 2009-07-13 14:38:10

I don't know.

John from Melbourne at 2009-05-16 21:48:47

Many thanks, worked nicely. Cheers, John

Callum at 2010-11-10 15:06:41

I didn't write the tool, I've only linked to it. I'm not aware of any tools that convert .csv to vcard, but I'd guess they exist.

Wendy at 2009-07-16 22:48:08

Thanks Callum - finding the right tool for the job is half the work, you've made my boss' (and consequently my) day :)

Eddie Huang at 2010-06-15 20:34:41

Callum, many thanks for sharing to us this link. This program works great!! I was looking for convert my contact from old phone to my windows mobile and It works great!!!

Huibert at 2010-03-22 09:35:57

What a great relief...! Thank you.

Andre Jaunin at 2009-09-17 08:26:02

This one helped me to convert CSV -&gt; VCF !! http://homepage.mac.com/phrogz/CSV2vCard_v2.html

Rachel at 2010-10-28 10:23:55

Hello, this tool works for single VCards but i have so many to convert into a CSV file i need to do them all in one go. is there a way of doing this?

shhh at 2010-01-25 22:46:03

hey many thanx for the program .... ol the best

Davina at 2010-05-18 11:21:49

Awesome! Worked in seconds.....

Ben at 2009-11-04 02:17:30

Thank you thank you thank you! Why don't they just CSV in the first place :S

Carl at 2010-08-04 18:28:19

Thank you so much... saved me days of work!

Google Contacts - Android Forums at 2010-05-30 17:18:17

[...] you tried this: Google Sync for your phone ? Or tried converting the file? Convert VCF to CSV It&#39;s not the most elegant solution, but the point is to get it on there and be done with it. Even [...]

draupadi at 2010-04-19 05:37:25

Hi, maybe you are interested in my litte c-prog to convert vcf to csv or html: http://vcf2csv.sourceforge.net/ The intention is *not* to merge multiple vcf files, but using a text-editor it should be easy to merge them. The download package contains binaries for linux and windows. It is completely free (GLP, no license, no serial ...). CU, draupadi

Sebastian at 2010-07-16 09:21:47

thank you! Great Job! thank you from Argentina!

sijo thomas at 2010-10-29 12:34:21

Excellent work..I really facinated. This is a perfect application for the conversion of .vcf file to other formats Here i like to share my little knoweldge for merging number of &gt;vcf file to one in Linux(unix command) Go to your terminal change directory to your Directory command: &gt;&gt;&gt;cd &gt;&gt;&gt;fmt -sp *.vcf &gt; addresses.vcf or &gt;&gt;&gt; cat *.vcf &gt;&gt; allinone Thanks and regards sijo thomas maparayil

Gowri Shankar at 2010-01-25 08:16:23

Thanks a ton!!!

Jaro Kiliman at 2010-02-27 07:22:16

There's another site that will convert entire zip files of vcards into a single csv file - http://www.inter-help.com/toolbox/vcardtocsv Its worked for me! All you need to do is put all those files into a zip folder and upload it.

Mona Metzger at 2010-11-07 18:51:50

Thanks for this handy tool. I use it all the time! Any chance you have a script that'll convert the .csv to a vcard?

Saptak at 2010-10-23 08:43:31

Fantastic. I currently lost my cell. But was able to restore the contacts... The problem was if I am having only bck file, I can only import it into sony phone. Now with this solution, the problem is solved and can import it in any other hone. Free to buy phone other than soy. :)

Callum at 2010-08-14 10:22:24

I don't know what a VSF or a CSF file is.

Callum at 2010-10-29 14:04:05

sijo thomas posted something that might help, at least if you're on linux. Otherwise, you can probably just combine all the VCard files into one on any other platform (Windows / Mac / etc) and then convert them. I'm really not sure, I used this script once in 2006 and haven't needed it since. :-)

Callum at 2010-01-23 12:22:46

No idea. I didn't write the software, I just published a link to it. Try <a href="http://www.scroogle.org/cgi-bin/nbbw.cgi?Gw=combine+multiple+vcf+files" target="_blank" rel="nofollow">searching</a> and see how you get on.

Andrew Dickens at 2010-01-23 12:12:29

When I downloaded my contacts from my phone, I got a CSV file for each contact, but that site will only let me convert one at a time. Is there a way round it?

Andrew Dickens at 2010-01-23 12:12:53

Sorry, correction, I got a VCF file for each contact.

ankur at 2010-10-17 17:09:46

the above link is not opening [http://www.inter-help.com/toolbox/vcardtocsv]... getting the error in address Pls correct it .. thnx

Callum at 2010-05-07 17:49:59

I had no problems with it. I might have downloaded it an run it locally though, I'm fairly privacy careful like that... :-)

Raja Manickam at 2010-05-10 06:56:07

Thanks friend.. It worked perfectly for me... Raj

Anonymous at 2010-05-07 17:31:05

Has anyone (or people in thier vcf file) been spammed after using the recommended website (http://labs.brotherli.ch/)? Has anyone that actually downloaded the script looked to see if it might save the file data on the remote server. I am sure that two different copies of the script could be in play here... It looks like no one has complained of privacy violations since the original post over 3 years ago so maybe it is safe...

Jonathan Gaby at 2010-04-12 10:24:45

Callum, thanks for posting this man. Great tool!

Callum at 2010-10-18 02:41:16

I didn't post that link, I'm not sure what the correct link is. If you find it, please feel free to post it back here.

MAYUR SINDHAV at 2010-08-13 10:03:12

How to VSF FILE TO CSF FILE CONVERT

eremus77 at 2010-08-28 08:31:56

Another way: On Ubuntu 10.04 save your evolution contacts in vcf file. Then install from your repository a tiny application: pycocuma. Run "pycocuma" in your terminal, import vcf file and export as .csv Then open addressbook in Thunderbird &gt;tools&gt;import&gt;addressbook&gt;comma separated&gt;your .csv file. Then adjust which fields you want and which correspond to which value on the right column. Then OK and it is done.

Luca Pioltelli at 2012-04-05 22:17:11

Hi Carolyn, I just read your comment ...I am starting a Mail chimp account as well and can not find a way to select more than one vcf card at a time... I saw that you did 170 in seconds.... How did you do that ? ( I put all the contacts from my address book in to one folder on the desktop and when I select that I can only pick one card at a time.. : ( Any help would be greatly appreciated... !

Mona Metzger at 2010-11-12 23:07:35

Thank you for the follow up. I'll keep looking around.

V Lee at 2010-11-24 18:54:11

I came across this which may work... http://homepage.mac.com/phrogz/CSV2vCard_v2.html

Gerrit at 2010-12-31 04:46:34

That's great! I had a social network contact list that would allow me to export only vcf, and another software only importing csv. No idea how to do that. Googled it, found your post with the link, tried it - and was done in less than 3 minutes. Thanks a lot for sharing and all the best for the New Year! Gerrit P.S. Any idea if I can also export my Facebook friends and fans?

juan at 2011-06-30 23:15:58

Are you going from cvf to csv? if so, how did you add them in the terminal and what folder do you put it in so that it works??? thank you, i'm just really new to terminal. oh, and will it work if you have a lot of vcf's???

Robin at 2011-01-10 16:17:24

Thanks for the link, very helpful!!

Roberto at 2011-01-11 09:22:14

Great!

art teo at 2012-02-24 06:17:50

Hi Carolyn, i just read about your sucess with the convertor.. i want to convert a contacts (.vcf) from my old "palm" palm machine.. everytime i export it only manage to send the first record... even using the "brotherli" convertor it also achieves one record.. can you send me a email and help me with simple instruction.. please...? my email... art_teo@pacific.net.sg

Carlos Lizcano at 2011-03-23 14:41:30

Excelente herramienta! muchas gracias por tu aporte. Éxitos!

peter at 2011-02-25 07:16:10

I found an easier manner Just zip the folder with all your vfc files in it. Then import the zipped folder into your mail program (universal) then export contacts to csv format for uploading to Iphone

Callum at 2011-07-27 17:52:06

I'm really not sure, I only linked to the software, I didn't produce it, and I wrote this post in 2006, I haven't used it since then.

balasubramanya at 2011-07-27 07:46:37

How can I use ur software in Windows 7 Ultimate??? I dont understand the Read me File too.... Please help... I use Google Chrome Browser...

Anil Achary at 2011-04-21 16:20:56

Try this link. It worked wonderfully for me. http://homepage.mac.com/phrogz/CSV2vCard_v2.html

carolyn at 2011-09-28 20:14:28

I'm starting a mail chimp account and didn't realise that the v cards were so incompatible with everything else. So thank you so much for this file converter link! This took literally seconds for a list of 170 contacts and thankfully cost nothing!

William at 2011-11-10 21:25:55

This is awesome! Many thanks for this much-needed software.

Bob at 2011-06-18 19:59:09

Thanx a lot. Exactly what i was looking for!

Anriëtte Combrink at 2012-05-03 06:00:36

Thank you so much, that really helped me a lot.

Callum at 2012-07-05 22:32:45

I only linked to the service, and some 6 years ago, I'm not sure what your issue is or how to resolve it.

beth farinas at 2012-07-05 18:01:23

Hi Callum, I came across this site while trying to look for ways on how to troubleshoot my situation. I have sony mini experia phone which shuts down with a reason i dont know yet. And as i search my sd card I was able to save a vcf file. my problem now is I want to transfer my phone contact through vcf file to my currently used phone which is sony experia x10? can you help me. Or if I will use a nokia x2 how can i transfer my phone contacts hope you can help me.

Woomie at 2013-01-01 08:08:24

I needed to get a .vcf file (exported from Mail.com) into Mail Chimp. I found the easiest way was to import the .vcf file into MS Outlook and export it as a .csv file from there. Thanks for everyone's input. :)