196
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − # 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.+ + Line 10:
Line 11: − # Copy vcf file to the phone.+ − # Import vcf file to the contacts+ + + + + + + + + + + + + + + + +
Create vCard(.VCF) File from Spreadsheet (view source)
Revision as of 14:40, 2 July 2020
, 14:40, 2 July 2020→In Windows
=== In Ubuntu ===
=== In Ubuntu ===
1 Put contacts on a spreadsheet with a common '''First name''' and '''Phone number''' in two columns and save as a CSV file on the Desktop as '''contacts.csv'''.
* Give Common First Name (Program name as part of the contact name). For example "RIE.XYZ." next column "Mobile number" <br>
2 Convert csv to vcard by running below commands on terminal.
'''<code>git clone <nowiki>https://github.com/mridah/csv2vcf.git</nowiki></code>'''
'''<code>git clone <nowiki>https://github.com/mridah/csv2vcf.git</nowiki></code>'''
'''<code>python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'</code>'''
'''<code>python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'</code>'''
3 Copy vcf file to the phone. <br>
4 Import vcf file to the contacts
=== In Windows ===
=== In Windows ===
1 Open Excel file in Microsoft Office.<br>
2 Arrange the data if not already arranged.
* Give Common First Name (Program name as part of the contact name). For example "RIE.XYZ." next column "Mobile number" <br>
[[File:Arranging the contact in xlxs.png|center|frame]]
3 Click <nowiki/>'<nowiki/>'''''File''<nowiki/>'<nowiki/>''' and click <nowiki/>'<nowiki/>'''''Save As''<nowiki/>'<nowiki/>'''.<br>
4 Click <nowiki/>'<nowiki/>'''''Browse''<nowiki/>'<nowiki/>''' and select the location where you want to store the file.<br>
5 Select '<nowiki/>''''CSV(Comma delimited)(*.csv)''<nowiki/>'<nowiki/>'''' in Save as type.<br>
6 Check if the encoding is set to '''UTF-8''' or any similar Unicode encoding format.<br>
7 Head over to [http://www.csvtovcard.com/ www.csvtovcard.com] and download their software. (Size <1MB)<br>
8 Install it on your computer and open it.<br>
9 <nowiki/>'''''<nowiki/>'''''<nowiki/>Select '<nowiki/>'''''CSV file'<nowiki/>''''' you just exported. Select the '<nowiki/>'''''format'''''' you want to export it in. (Single file or Separate file for each row)<br>
10 If attri<nowiki/>butes/vCa'''''<nowiki/>'''''rd property is not identified au<nowiki/>tomatically then specify it manually.<br>
11 Click '<nowiki/>'''''Convert''''''. Your file will be converted in seconds.<br>
[[File:V Business card.png|center|frame]]
12 Copy vcf file to the phone. <br>
13 Import vcf file to the contacts