VCF to CSV conversion

According to the site below, multiple VCF files can be easily merged into single VCF file.

http://www.file-extensions.org/article/open-split-merge-convert-vcf-contact-file s

However the command "cat ..." may have trouble in your case because of too many files.

So, try the command below instead.

find . -type f -name \*.vcf \! -name merged.vcf -exec cat \{\} \; > merged.vcf

Hope this can be your help.

This is what probably happened when the MS developers got round a table and decided on the design of Outlook for Mac.

…Ok team how can we make Outlook for Mac really, really annoying for users. What important feature that Outlook for Windows has can we remove this time.

As it happens in this case Apple will come to your rescue.

A .vcf file is a vcard file, one can hope the Microsoft have not added some horrible proprietaryness to it. As such Apple's own Contacts application should be able to import .vcf files and I believe important them all in one go.

Once you have all the contacts in Apple's Contacts application you can then use this tool to convert them to a csv file.

See http://contactssyncer.com/wordpress/?page_id=48

Another approach to consider is that apparently you can import vCards in to Google Mail and you can also export as a csv file from Google Mail. However 9000 contacts is a large amount so it may also struggle.

Beyond the above I suspect we are now moving in to the territory of needing to buy a commercial solution although still a cheap one.

One final approach to consider is to import say 2000 in to contacts, convert that 2000 to a csv, then delete that 2000 from Contacts, import then next batch, and repeat.

Once you have converted all the batches to several separate csv files it will be easy enough to import them all in to a single Excel file or to use a text editor to combine them in to a single file.