View source for Create vCard(.VCF) File from Spreadsheet

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

=== In Windows ===
1.Open	Excel file in Microsoft Office.<br>
2.Arrange the data if not already arranged.
[[File:Arranging the contact in xlxs.png|center|frame]]
3.Click <nowiki/>''''File<nowiki/>'''' and click <nowiki/>''''Save As''''.<br>
4.Click <nowiki/>''''Browse'''' and select the location where you want to store the file.<br>
5.Select <nowiki/>''''CSV(Comma	delimited)(*.csv)'''' 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.Import/Copy the .vcf file to the phone.<br>
13.Opening that .vcf file will add the contacts to the phone.<br>