Difference between revisions of "Create vCard(.VCF) File from Spreadsheet"

From Open Educational Resources
Jump to navigation Jump to search
Line 12: Line 12:
 
# Copy vcf file to the phone.
 
# Copy vcf file to the phone.
 
# Import vcf file to the contacts
 
# Import vcf file to the contacts
 +
 +
=== In Windows ===

Revision as of 12:39, 2 July 2020

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