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

Revision as of 12:24, 2 July 2020

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

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.

                git clone https://github.com/mridah/csv2vcf.git

                 cd csv2vcf

                 python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'

@@ Line 1: / Line 1: @@
 [[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