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

From Open Educational Resources
Jump to navigation Jump to search
Line 14: Line 14:
  
 
=== In Windows ===
 
=== In Windows ===
 +
# Open Excel file in Microsoft Office.
 +
# Arrange the data if not already arranged.
 +
[[File:Arranging the contact in xlxs.png|center|frame]]
 +
# Click ''''''File'''''' and click ''''''Save As''''''.
 +
# Click ''''''Browse'''''' and select the location where you want to store the file.
 +
# Select ''''''CSV(Comma delimited)(*.csv)'''''' in Save as type.
 +
# Head over to www.csvtovcard.com and download their software. (Size <1MB)
 +
# Install it on your computer and open it.
 +
# Select ''''''CSV file'''''' you just exported. Select the ''''''format'''''' you want to export it in. (Single file or Separate file for each row)
 +
# If attributes/vCard property is not identified automatically then specify it manually.
 +
# Click ''''''Convert''''''. Your file will be converted in seconds.
 +
[[File:V Business card.png|center|frame]]

Revision as of 12:44, 2 July 2020

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

In Ubuntu

  1. 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.
  2. 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}'
  1. Copy vcf file to the phone.
  2. Import vcf file to the contacts

In Windows

  1. Open Excel file in Microsoft Office.
  2. Arrange the data if not already arranged.
Arranging the contact in xlxs.png
  1. Click 'File' and click 'Save As'.
  2. Click 'Browse' and select the location where you want to store the file.
  3. Select 'CSV(Comma delimited)(*.csv)' in Save as type.
  4. Head over to www.csvtovcard.com and download their software. (Size <1MB)
  5. Install it on your computer and open it.
  6. Select 'CSV file' you just exported. Select the 'format' you want to export it in. (Single file or Separate file for each row)
  7. If attributes/vCard property is not identified automatically then specify it manually.
  8. Click 'Convert'. Your file will be converted in seconds.
V Business card.png
Retrieved from "https://teacher-network.in/OER/index.php?title=Create_vCard(.VCF)_File_from_Spreadsheet&oldid=10654"