Create vCard(.VCF) File from Spreadsheet - Revision history

Bharath: /* In Windows */

2020-07-02T09:10:44Z

In Windows

Bharath: /* In Windows */

2020-07-02T09:09:54Z

In Windows

Bharath: /* In Ubuntu */

2020-07-02T09:06:54Z

In Ubuntu

Bharath: /* In Ubuntu */

2020-07-02T09:06:38Z

In Ubuntu

Bharath at 09:05, 2 July 2020

2020-07-02T09:05:14Z

Bharath: /* In Windows */

2020-07-02T09:04:30Z

In Windows

Bharath: /* In Windows */

2020-07-02T09:03:50Z

In Windows

Bharath: /* In Ubuntu */

2020-07-02T07:57:53Z

In Ubuntu

Bharath: /* In Ubuntu */

2020-07-02T07:57:27Z

In Ubuntu

Bharath: /* In Windows */

2020-07-02T07:56:52Z

In Windows

@@ Line 21: / Line 21: @@
 Click <nowiki/>'<nowiki/>'''''File''<nowiki/>'<nowiki/>''' and click <nowiki/>'<nowiki/>'''''Save As''<nowiki/>'<nowiki/>'''.<br>
 Click <nowiki/>'<nowiki/>'''''Browse''<nowiki/>'<nowiki/>''' and select the location where you want to store the file.<br>
-Select <nowiki/>'<nowiki/>'''''CSV(Comma	delimited)(*.csv)''<nowiki/>'<nowiki/>''' in Save as type.<br>
+Select '<nowiki/>''''CSV(Comma delimited)(*.csv)''<nowiki/>'<nowiki/>'''' in Save as type.<br>
 Check if the encoding is set to '''UTF-8''' or any similar Unicode encoding format.<br>
 Head	over to [http://www.csvtovcard.com/ www.csvtovcard.com] and download their software. (Size <1MB)<br>

@@ Line 15: / Line 15: @@
 === In Windows ===
-.Open	Excel file in Microsoft Office.<br>
+Open	Excel file in Microsoft Office.<br>
-.Arrange the data if not already arranged.
+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]]
-.Click <nowiki/>'<nowiki/>'''''File''<nowiki/>'<nowiki/>''' and click <nowiki/>'<nowiki/>'''''Save As''<nowiki/>'<nowiki/>'''.<br>
+Click <nowiki/>'<nowiki/>'''''File''<nowiki/>'<nowiki/>''' and click <nowiki/>'<nowiki/>'''''Save As''<nowiki/>'<nowiki/>'''.<br>
-.Click <nowiki/>'<nowiki/>'''''Browse''<nowiki/>'<nowiki/>''' and select the location where you want to store the file.<br>
+Click <nowiki/>'<nowiki/>'''''Browse''<nowiki/>'<nowiki/>''' and select the location where you want to store the file.<br>
-.Select <nowiki/>'<nowiki/>'''''CSV(Comma	delimited)(*.csv)''<nowiki/>'<nowiki/>''' in Save as type.<br>
+Select <nowiki/>'<nowiki/>'''''CSV(Comma	delimited)(*.csv)''<nowiki/>'<nowiki/>''' in Save as type.<br>
-.Check if the encoding is set to '''UTF-8''' or any similar Unicode encoding format.<br>
+Check if the encoding is set to '''UTF-8''' or any similar Unicode encoding format.<br>
-.Head	over to [http://www.csvtovcard.com/ www.csvtovcard.com] and download their software. (Size <1MB)<br>
+Head	over to [http://www.csvtovcard.com/ www.csvtovcard.com] and download their software. (Size <1MB)<br>
-.Install it on your computer and open it.<br>
+Install it on your computer and open it.<br>
-.<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>
+<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>
-.If	attri<nowiki/>butes/vCa'''''<nowiki/>'''''rd property is not identified au<nowiki/>tomatically then	specify it manually.<br>
+If	attri<nowiki/>butes/vCa'''''<nowiki/>'''''rd property is not identified au<nowiki/>tomatically then	specify it manually.<br>
-.Click '<nowiki/>'''''Convert''''''.	Your file will be converted in seconds.<br>
+Click '<nowiki/>'''''Convert''''''.	Your file will be converted in seconds.<br>
 [[File:V Business card.png|center|frame]]
-.Import/Copy the .vcf file to the phone.<br>
+Copy vcf file to the phone. <br>
-.Opening that .vcf file will add the contacts to the phone.<br>
+Import vcf file to the contacts

@@ Line 11: / Line 11: @@
                    '''<code>python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'</code>'''
-Copy vcf file to the phone.
+Copy vcf file to the phone. <br>
 Import vcf file to the contacts

@@ Line 3: / Line 3: @@
 === In Ubuntu ===
-# 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'''.
+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>
-# Convert csv to vcard by running below commands on terminal.
+Convert csv to vcard by running below commands on terminal.
                   '''<code>git clone <nowiki>https://github.com/mridah/csv2vcf.git</nowiki></code>'''
@@ Line 11: / Line 11: @@
                    '''<code>python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'</code>'''
-# 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 ===

@@ Line 3: / Line 3: @@
 === In Ubuntu ===
-# 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'''.
+# 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'''.
 # Convert csv to vcard by running below commands on terminal.
                   '''<code>git clone <nowiki>https://github.com/mridah/csv2vcf.git</nowiki></code>'''