Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Import CSV contacts into Android 4 phone

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.)?

like image 621
rubo77 Avatar asked Jul 02 '12 19:07

rubo77


People also ask

How do I transfer contacts from CSV to phone?

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.

Why won't Google Contacts import my CSV file?

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.


2 Answers

Here's the Windows-only version of rubo77's solution:

  1. Import the csv-list into the Windows 7 Contacts. (remember you can only use the Windows contacts fields once per csv field)

  2. Export the Windows Contacts into single VCF-Cards.

  3. Glue them all together into one large vcf file:

    type *.vcf>..\all_adresses.vcf

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

  5. Import them into android Phone (in Contacts there is an option to import from SD-Card)

like image 147
Jon Avatar answered Oct 02 '22 14:10

Jon


I tried a lot and finnally i found a solution that works without google!

  1. I imported my csv-list into the Windows 7 Contacts. (it's easy if you adjust the first line with the correct fieldnames)

  2. then I exported them from there into single VCF-Cards.

  3. I glued them all together into one large vcf file:

    cat *.vcf>../all_adresses.vcf

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

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

like image 43
rubo77 Avatar answered Oct 02 '22 15:10

rubo77