I have a CSV-file with all my contacts (exported from Thunderbird).
On my Phone I have Android 4 ice cream sandwich installed.
How can I import the contacts from the CSV-File into my Android cellphone (sony ericson Xperia Ray) without using any "spyware" (google, facebook, outlook, etc.)?
Navigate to the Google CSV file that you made in Excel. Double-click the file to select it and then click Open in the lower-right corner. Click Import. This imports all the contacts from the CSV file into your Google account.
The issue is often that the . CSV you are uploading is formatted incorrectly and Google rejects the data in the file. One way to solve the problems of importing files into Google Contacts is to make sure that you are using the correct CSV file format that Google Contacts will accept.
Here's the Windows-only version of rubo77's solution:
Import the csv-list into the Windows 7 Contacts. (remember you can only use the Windows contacts fields once per csv field)
Export the Windows Contacts into single VCF-Cards.
Glue them all together into one large vcf file:
type *.vcf>..\all_adresses.vcf
Convert all_adresses.vcf to UTF-8 so the special characters are correct:
Open all_adresses.vcf in Notepad++, click Encoding > Encode in UTF-8. Save.
Import them into android Phone (in Contacts there is an option to import from SD-Card)
I tried a lot and finnally i found a solution that works without google!
I imported my csv-list into the Windows 7 Contacts. (it's easy if you adjust the first line with the correct fieldnames)
then I exported them from there into single VCF-Cards.
I glued them all together into one large vcf file:
cat *.vcf>../all_adresses.vcf
convert them to UTF-8 so the special characters are correct:
iconv --from-code=ISO-8859-1 --to-code=UTF-8 all_adresses.vcf > all_adresses_correct.vcf
finally I imported them in my android Phone (in Contacts there is an option to import from SD-Card)
if you delete them from your windows contacts after you are done, I think no traces of your addresses are left on the computer.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With