Create vCard(.VCF) File from Spreadsheet

From Open Educational Resources
Revision as of 12:24, 2 July 2020 by Rakesh (talk | contribs)

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