January 17, 2012

Take Nokia Phone Contacts (Phonebook) backup in Excel Spreadsheet or .csv file by using OVI PC Connectivity

Hi friends,

Today I have come up with phonebook backup in Nokia. I previously used very old nokia model which doesn't contain the Nokia PC/Ovi Suite connectivity. So, I used to take backup of my contacts in excel sheet by doing data entry. But now most of phones does have the facility to connect to Nokia Ovi/PC Suite to take the backup and maintain their data in Computer(PC).

Here, I have taken backup of my contacts in PC and converted that to Excel sheet to quick access of my contacts.

  1. Make sure that, your phone does support Mobile to PC connectivity via Nokia Ovi/PC Suite
  2. Download and install Nokia Ovi/PC Suite
  3. Make sure that, you have the PC connectivity cable to the corresponding mobile
  4. Make sure that, all your contacts are on device(mobile) memory instead of SIM
    • Note: Copy all the SIM contacts to device(mobile)
  • Connect your mobile to PC
  • Select "Nokia Ovi PC Suite" connection from your mobile
  • After successful connection, you will get the similar screen like below
  • Select "Contacts" from the image icons on top of the window
  • Now, all your contacts will be displayed on the 2nd pane(column) in the Window as shown below
  • Select all the contacts (Note: First select any one of contact and do the any one of the below)
    • Option 1: Use Keyboard shortcut Control + A
    • Option 2: Right click on the contact and choose "Select All" option
    • Option 3: Select "Edit" menu and choose "Select All" option
  • Now, you can "Drag and Drop" the selected contacts to PC contacts  
    • Hint: Drag and drop the content to "Contacts" (Red Circle)
By now, you have successfully taken the backup of your contacts to PC

View/Save the contacts in Spreadsheet/.csv file
  • Download the file GrabMyContacts from this link 
  • Install it in any folder
  • Run the "grabmycontacts.exe", you will get the following screen

  • Default "Step 1 - Search for your contacts file" tab will be selected
  • Click the "Search for it" button, it will automatically searches your Nokia Ovi contacts database file as shown below
    • Click on "Yes"
  • Now, choose the "Step 2 - Choose and display your data" tab
    • Click on "Push this button to display your contacts"
    • Now, it will display all your contacts in the sheet
  • Finally, Choose "Step 3 - Export to Excel" tab
    • Click on "Finished ! Now Export to Excel !" button
    • It will show, your file named "myovicontacts.xml" has been saved on desktop
    • Click on "Yes"
    • Then, it will ask you to open the file Excel, as shown in the below screen
    • Click on "Yes"
  • If the default program for the xml is not Excel then it will open with the default program. 
  • Open the XML file in Excel:
  • To see your contacts in excel, open the new Excel workbook and "Drag and Drop" the "myovicontacts.xml" in it
  • Remove the unnecessary columns and save your contacts as "Excel Workbook"/".csv" file format
Post a Comment

Featured Post

Java Introdcution

Please send your review and feedback to psrdotcom@gmail.com