Difference between revisions of "Create vCard(.VCF) File from Spreadsheet"
Jump to navigation
Jump to search
m (→In Windows) |
|||
| Line 17: | Line 17: | ||
# Arrange the data if not already arranged. | # 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]] | ||
| − | # Click ''''''File'''''' and click ''''''Save As''''''. | + | # Click '<nowiki/>'''''File'<nowiki/>''''' and click '<nowiki/>'''''Save As''''''. |
| − | # Click ''''''Browse'''''' and select the location where you want to store the file. | + | # Click '<nowiki/>'''''Browse'''''' and select the location where you want to store the file. |
| − | # Select ''''''CSV(Comma delimited)(*.csv)'''''' in Save as type. | + | # Select '<nowiki/>'''''CSV(Comma delimited)(*.csv)'''''' in Save as type. |
| − | # Head over to www.csvtovcard.com and download their software. (Size <1MB) | + | # Head over to [http://www.csvtovcard.com/ www.csvtovcard.com] and download their software. (Size <1MB) |
# Install it on your computer and open it. | # 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) | + | # 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) |
# If attributes/vCard property is not identified automatically then specify it manually. | # If attributes/vCard property is not identified automatically then specify it manually. | ||
| − | # Click ''''''Convert''''''. Your file will be converted in seconds. | + | # Click '<nowiki/>'''''Convert''''''. Your file will be converted in seconds. |
[[File:V Business card.png|center|frame]] | [[File:V Business card.png|center|frame]] | ||
Revision as of 12:46, 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
- 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.
git clone https://github.com/mridah/csv2vcf.git
cd csv2vcf
python csv2vcf.py ~/Desktop/contacts.csv -s '{"name":1, "tel":2}'
- Copy vcf file to the phone.
- Import vcf file to the contacts
In Windows
- Open Excel file in Microsoft Office.
- Arrange the data if not already arranged.
- 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.
