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

From Open Educational Resources
Jump to navigation Jump to search
 
Line 1: Line 1:
 
[[Category:Explore an application]]
 
[[Category:Explore an application]]
 +
By exporting your contacts from excel sheet to .VCF format will help you to import contacts from spreadsheet to your smartphones.
 +
 +
=== In Ubuntu ===
 +
# 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'''.
 +
# Convert csv to vcard by running below commands on terminal.
 +
                '''<code>git clone <nowiki>https://github.com/mridah/csv2vcf.git</nowiki></code>'''
 +
 +
                  '''<code>cd csv2vcf</code>'''
 +
 +
                  '''<code>python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'</code>'''               
 +
# Copy vcf file to the phone.
 +
# Import vcf file to the contacts

Revision as of 06:54, 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
Retrieved from "https://teacher-network.in/OER/index.php?title=Create_vCard(.VCF)_File_from_Spreadsheet&oldid=10650"