Create vCard(.VCF) File from Spreadsheet

From Open Educational Resources
Jump to navigation Jump to search

By exporting your contacts from excel sheet to .VCF format will help you to import contacts from spreadsheet to your smartphones.

In Ubuntu

  1. Put contacts on a spreadsheet with a common last name and phone number in two columns and save as a CSV file on the Desktop as contacts.csv.
  2. Convert csv to vcard by running below commands on terminal.
                git clone https://github.com/mridah/csv2vcf.git
                 cd csv2vcf
                 python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'                
  1. Copy vcf file to the phone.
  2. Import vcf file to the contacts

In Windows