Converting contact files VCF

[Gabbi]

Good morning,

I have several contacts set up in Excel that need to be saved as VCF file.When I google how to do this I keep getting the message that there is no solution to importing contacts from an Excel file to another program or application because Excel file is not supported by all these platforms. To transfer Excel contacts into other platforms, I need to use a converter. Users need to convert Excel files to vCard VCF format. Is there any other way to make Excel formatted contacts into VCF files? Thanks

 

[CountTepes]

This might help you.

How to Convert Excel xlsx to Vcard vcf File

After a long time, we are here with a completely different tutorial. When you export data, especially contacts, they are sometimes exported in xls or xlsx

www.techrrival.com

 

[RoryA]

Typically, I think you would save the Excel file as a CSV file, then use that in your converter.

This thread will also likely be bombarded with spam, given its nature, so will be carefully monitored!

 

[Gabbi]

Thank you, I was hoping to find a solution that didn’t require using a converter.

 

[RoryA]

I don't know what the format for a VCF file is, so I can't help, I'm afraid. If you can find that out, it may be possible to code something.

 

[CountTepes]

VCard info here

vCard - Wikipedia

en.wikipedia.org

 

[daverunt]

VCF Specification has various versions.

Wiki gives you the format and examples of the different versions.

vCard - Wikipedia

en.wikipedia.org

Outlook as of 2013 still uses 2.1.

You can mail yourself and example from the Outlook Address book
Right-click on contact and select Properties.
Select Forward as Internet format vCard

As far as I remember only the Begin, Version and End are compulsory tags so the content depends on what is in the Excel file.
A lot of the tags will be superfluous for most uses.

Here's basic content you can add to a text file and save as a .vcf file, then double-click to view as Outlook contact

BEGIN:VCARD
VERSION:2.1
FN:Fred Bloggs
TEL;HOME;VOICE:+44 (0) 1234 123456
TEL;WORK;VOICE:+44 (0) 1314 123456
EMAIL;PREF;X-INTERNET:fred.Bloggs@gmail.com
END:VCARD

If you work out the fields you need you could write the text file(s) with a macro.