3,098 views

Tutorial: How to import Nokia Contacts to Google / Android Phone

Filed Under (android, mobiles) by Abbas on 01-08-2011

Tagged Under : , , , , , , , ,

After following this tutorial, you will be able to transfer contacts from your Nokia phone to your android phone within a few minutes.

It’s a pain to transfer contacts from a Nokia phone to an Android or non-nokia phone – After a lot of tinkering with my Nokia’s Ovi contact’s site, I was able to transfer my contacts with a little bit of simple hacking/text-manipulation. These steps are pretty easy and you’ll have no problem following this tutorial – regardless of your computer usage skill.

Nokia makes it very easy to transfer phone contacts to another Nokia phone. But it’s a nightmare to transfer contacts from Nokia to android phone or any other phone for that matter.

Onto the tutorial now.

1- First of all, you need to register at Nokia’s Ovi site (if you haven’t registered already). The Ovi site’s contacts section will let you upload/synchronise contacts from your phone to their server. Go to http://www.ovi.com/ and follow the registration process.

2- After registration, and verifying your phone number ,  Download the Nokia Ovi suite application and install it on your PC.

3- Now connect your nokia phone with your PC and launch the Ovi suite application and sign in with the ovi account that you registered in step 2.

4- From the top menu in the ovi application, go to sync and choose the option to sync your contacts. This will upload your phone’s contacts to nokia’s servers.

5- Unfortunately, there is no easy or direct way of importing these contacts to a file so now – once again go to http://www.ovi.com/ and login with your account.

6- Go to the contacts section and you should see all phone’s contacts listed there as they were uploaded from the Ovi Suite application in step 4.

7- Make sure you set the contacts to show in ‘list’ format by clicking on the ‘list’ button at the bottom of the contacts page on OVI website’s contact page. As shown in image below

8- Now click in the very first cell at the very top – so as to select the first contact in the list (as shown in image)

9- Now press and hold the ‘Shift’ key and at the very bottom most contact in the list, click again. This way you will select all the contacts displayed on that page in the list.

10- Press ctrl+C to copy the selected contacts and open Notepad or any text editor where you’ll paste the copied contacts in raw form. In the text editor/notepad, Press ctrl+v and you’ll see all the contacts copied in the format as shown in screenshot below.

11- Copy all the contacts from the rest of the list’s pages on Ovi site. Now save this list from the text editor/notepad and name it something like ‘myContacts.txt’. Make sure that each individual contact is separated like shown in the screenshot above. Every contact must have ONLY ONE phone number (sorry but in the next steps, the import won’t work if any contact has more than one phone number listed below them – delete any secondary phone numbers from the ‘myContacts.txt’)

12- Now we just need to style and format this list in proper CSV (comma separated format) so that we can upload the CSV formatted contacts to Google Contacts (and ultimately to your android phone). We need a slightly advanced text editor for formatting the contacts in myContacts.txt into CSV format.

13- Download notepad++ from the download page on http://notepad-plus-plus.org/ and install it. Now open the ‘myContacts.txt’ file in notepad++.

14- In notepad++ , once the myContacts.txt file is opened.  Go to ‘View’ (from top menu) and from the drop down menu, click ‘Show Symbol’ and from the subsequent menu check ‘Show end of line’. (This option will now make the editor show the ‘end of line’ characters in the text , that are normally invisible). You should see the contacts like as shown in the image below.

15 – With the new-line special characters visible, we’ll now start formatting this list to CSV format. the ‘CR LF’ characters just show that the line ends here and new line begins after it, it’s only relevant for the styling we are going to do in the next step.

16 – Now for CSV format, what we want to do is to make all the contact names and numbers wrapped quotations like “Friend Johin”,”03451234567″. For this, we use some intelligent find-and-replace to replace the CRLF like symbols with quotation marks, this way, if you have hundreds of contacts in your myContacts.txt, you can format all those hundreds of records in 3,4 steps like we are going to do in the following steps

17- In notepad++, press ctrl+H to get the find-and-replace window. In that window,  ‘in FIND WHAT: write ‘/r/n/r/n’ and in the replace field, write ‘ “/r/n’ , as shown below – and press REPLACE ALL .  Now to for double assurance, in FIND WHAT field, write ‘/r/n /r/n’ (notice there is a space between the first /r/n and the the second /r/n and press REPLACE ALL again.

18- You should get something like this now, notice the ” quotations at the end of the telephone numbers for each contact.

19- Since we have to achieve formatting like “Lara Shyalot”,”03441256882″ .. i.e. both the name and number separated by a comma and each of the name and number blocks wrapped in quoation marks, we continue our find-and-replace work. Press ctrl+h again to get the find and replace screen and then in FIND WHAT field type ‘\r\n’ and in Replace WITH field, type ‘\r\n” ‘ and press replace all. – You should get something like tis, notice the new quotation marks added in front of contact names now

20- Now we want to insert a comma b/w the name and number of each contact, so we replace the CR LF (/r/n) symbols with a comma. press ctrl+h again and in FIND WHAT field, type ‘”\r\n’(notice the quotation mark right before \r\n, its important) and replace with ‘xyzxyz’. press replace-all button and you’ll get something like

20(b)- now to insert the comma b/w a name and number of each contact, replace ‘/r/n’ with a quotation mark, followed by a comma i.e. ‘ “, ‘  as shown below

21- We still have to put ending quotation mark at the end of each phone number, so now we replace the xyzxyz string with a quotation mark followed by /r/n , as shown below – and you should get something like below.

22- Notice how there is a missing quotation mark at the very start of the file and there is an extra quotation mark at the very bottom of file. (if we have such extra/missing symbols), our CSV file won’t be accepted by google, so lets fix that and also at the very top add the title of each of these two columns. The end result should look like as below

22(b)- Now open a blank sheet inside MS Excel (spreadsheet) and import this myContacts.txt -  (by clicking on Data > From TEXT ) and choosing the myContacts.txt file. Import this file (choose to use the quotation mark ” and comma , as the delimeter. once imported. If  you did all steps fine, you should see two columns in the spreadsheet (Name, Phone) – and all your contacts will be listed here.

23(c)- Now save this excel spreadsheet as .csv file (comma separated values), Name it something like myContacts.csv

 

23- That’s it!   Now lets save this file and then go to Google Contacts  http://www.google.com/contacts (login with your gmail account there) – We will now import the CSV formatted file (myContacts.csv) of our nokia contacts into Google Contacts.

24- Inside the Google Contact main-page, click the ‘import’ button on the top-right. Select the newly created csv file and click upload. – Don’t forget to add a userfriendly name for this group of contacts in your google-contacts.

25- Voila, thats it, so now you know how to import nokia contacts into android and google contacts.

Part two of this tutorial will show how you can directly download your google contacts directly into your android phone.

 

Share:
  • Digg
  • Reddit
  • del.icio.us
  • StumbleUpon
       

Leave a Reply