Friday 14 November 2014

Export The Contacts From The Nokia 6120 To An Excel File

Getting information off of a Nokia cell phone is simple, with the utilities Nokia provides.


Nokia's 6120 phone (and several more recent models) can store more information in the phone's memory than it can write reliably to the SIM card. Getting your contacts off of the phone is the purview of a specialized piece of software called Nokia PC Suite, a free download from Nokia. This software can also export the contacts into several formats, some of which you can open within Excel. Once in Excel, it's fairly easy to sort them and trim away unwanted contacts or contacts that are no longer valid.


Instructions


Getting Contacts Off the Phone


1. Download Nokia's PC Suite from the company's website (see Resources). Be sure to enter the model number (6120) into the search function to get the version that supports your model of phone.


2. Click on the "Install" button.


3. Plug in your Nokia phone to the computer with the mini USB charging cable.


4. Launch Nokia PC Suite and click on the "Synchronize" button. This will download all of your phone's contacts to the PC program.


5. Click on the "File" menu item within Nokia PC Suite and select "Export." Choose "CSV" as the exported file format; this exports the contacts as comma-separated values. Save the file someplace where you can find it easily.


Converting Contacts to Excel


6. Open Excel.


7. Click on the "Office" button (Excel 2007) or the "File" menu item (Office 2003 and earlier) and select "Open."


8. Select the file you saved from Nokia PC Suite. Excel will open it, with each contact on its own row and each piece of information about the contact in its own column.


9. Click on the "Office" button (Excel 2007) or the "File" menu item (Excel 2003 and earlier) and select "Save As." Choose "Native Excel" as the file format, and your contacts will be in an Excel spreadsheet.

Tags: Nokia Suite, File menu, File menu item, menu item, 2003 earlier, 2003 earlier select, 2007 File