Skip to content

Latest commit

 

History

History
27 lines (23 loc) · 1.63 KB

README.md

File metadata and controls

27 lines (23 loc) · 1.63 KB

vcf_py

CSV to VCF (virtual contact file) generator

This program allows you to extract the contact information (names and numbers) of multiple people from a CSV file and compile it into a virtual contact file (VCF) which can be easily imported into many devices and platforms such as smartphones and email clients, thereby allowing for a fast and efficient transfer of numerous contacts from a spreadsheet.

Requirements

If the contacts are stored in a Microsoft Excel Spreadsheet, the file should first be opened with Excel and then saved as CSV (Comma delimited) (*.csv). It is recommended to open the generated CSV file using a text editor to ensure that it follows this format:

name1,number1
name2,number2
...
  • Ensure that the names and numbers do not contain any commas.
  • Column A should contain the names and column B should contain the corresponding numbers.
  • The rest of the columns must be empty
  • The columns must not have headings, i.e. row 1 will be assumed to be the contact for the first person.
  • The CSV file containing the contact information should be in the same folder as vcf.py

Usage

Run the vcf.py script from the Terminal/Command Prompt:

python vcf.py

Assuming the CSV file is in the same folder as vcf.py, the script would automatically detect the CSV file and attempt to read from it.

Test

A sample CSV file titled contacts.csv is given in this repository. It contains some real telephone numbers from the various offices of NUS, taken from http://www.nus.edu.sg/contact. Open it using Excel and a text editor to take a look. Try running vcf.py and ensure that contacts.vcf is generated.