Conversion program csv2vcf V.17.01      

Today, there are cheap mobile phones that do not have Android operating system, but still they are able to carry out operations that were previously not possible. I needed to transfer contacts that I got in the Excel table to such a phone. There were 20 contacts and only 15 of them had also a phone number. I was reluctant to transcribe it manually onto the phone especially considering the threat a typo in a phone number.

Therefore, I propose a program that might be useful to everyone.

Follow these procedures:

• it is necessary to determine whether the mobile phone supports export and import contacts
• first we export one contact to obtain the correctly formatted .vcf file
• this format may be significantly different so we use that as a template
• in the case that there are other contacts in the obtained VCF file, you need to erase the rest
• this file should be renamed to master.vcf and will serve as a template
• verify in your .xls file that there is a contact name and telephone number
• it is important to note the order of columns, eg. Name=1, Phone=4
• afterwards, modify the file keywords.txt
• at last, modify the template file master.vcf
• after starting the program csv2vcf.exe, it will create a file export.vcf
• which should be copied into the mobile phone
• such a file can also be send to Gmail or elsewhere

Mobile phone must have a storage place where its software creates a file with extension .VCF. This output file we transfer via USB cable to the PC. If this is possible, we won, considering that is would be possible to do a reverse process as to import contacts from PC back to the mobile phone.

We create such file later on PC and via a USB cable transfer back to the phone. On my cheap cellphones for 19.10 Euro, it was enough to mark this file and the cellphone asked whether to import the contacts. Do not read any further if this is not possible, my program will not help you.

This is the input file in the .xls shape from which to export data to a CSV file for the program.

This is the result in the form VCF. Darina Palková there are missing because they have not a phone number in the table.

The program is freeware. The author reserves the right to decide where the program will be available for download. If you intend to save the program on a different server, please inform the author.

The program was made to suit author’s needs. If you have ideas how it can be improved, email me please. I myself already thought of an upgrade that may be available in January 2017.

Mailto:Ing. Branislav Štofko

Download

Content of .ZIP file