Changes

=== In Ubuntu ===

=== 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'''.

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'''.

# Convert csv to vcard by running below commands on terminal.

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>'''                 

# Copy vcf file to the phone.

3 Copy vcf file to the phone. <br>

# Import vcf file to the contacts

4 Import vcf file to the contacts

=== In Windows ===

=== In Windows ===

1.Open Excel file in Microsoft Office.<br>

1 Open Excel file in Microsoft Office.<br>

2.Arrange the data if not already arranged.

2 Arrange the data if not already arranged.  

[[File:Arranging the contact in xlxs.png|center|frame]]

[[File:Arranging the contact in xlxs.png|center|frame]]

3.Click <nowiki/>''''File<nowiki/>'''' and click <nowiki/>''''Save As''''.<br>

3 Click <nowiki/>'<nowiki/>'''''File''<nowiki/>'<nowiki/>''' and click <nowiki/>'<nowiki/>'''''Save As''<nowiki/>'<nowiki/>'''.<br>

4.Click <nowiki/>''''Browse'''' and select the location where you want to store the file.<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)'''' in Save as type.<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>

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>

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>

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>

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>

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>

11 Click '<nowiki/>'''''Convert''''''. Your file will be converted in seconds.<br>

[[File:V Business card.png|center|frame]]

[[File:V Business card.png|center|frame]]

12.Import/Copy the .vcf file to the phone.<br>

12 Copy vcf file to the phone. <br>

13.Opening that .vcf file will add the contacts to the phone.<br>

13 Import vcf file to the contacts