Friday, March 16, 2012

Android: How to Export all SMS from GO SMS Pro as Microsoft Excel format

Follow Step by Step guide.

  1. Open GO SMS Pro application in your Phone
  2. Click Application key (Normally Left bottom side of phone"
  3. Select "Services" from popup.
  4. Select "SMS B&R"
  5. Check All Options
  6. Select Settings Icon.
  7. Choose "Readable Mode"
  8. Choose "All Messages"
  9. Save.
  10. Press "Backup" to start backup process.
  11. You can email yourself the backup files. Choose your option if asked for email.
There are two ways to retrive backup files from phone to PC
  1. Download the file from Email, which was generated by GO Sms application.
  2. Copy File from Phone USB storage. You will need following two files
    1. smsbackup_yyyy-MM-dd.xml (Here yyy MM and dd is the date format)
    2.  gommssms.db (Located in Private folder of same path)
If you have private sms box, you will need to restore it separately. Lets restore common sms folder first

Restore Common SMS Folder in Excel.
  1. Open Microsoft Excel
  2. Click File > Open
  3. Select the XML file that we discovered above.
  4. Select "Open as Read only Workbook" when prompted.
  5. These are your SMS. Save a copy as xls file and enjoy ;)
Restore Private Box
  1. This is not pretty simple. But you can do it by following these instructions. You will need a good Database Reader software that understand the SQLite database. I choosed SQL Database Browser that can be free download from here
  2. Extract the downloaded zip in a separate folder in your PC.
  3. Double click to Execute "SQLite Database Browser.exe"
  4. Click File > Open Database
  5. Choose gommssms.db file that we discovered above.
  6. Now you will see some contents read by SQLite Browser. This is database file contains all your sms.
  7. Click again File > Export > Table to Csv File
  8. Select "SMS" table from the list
  9.  Click Export
  10.  Type the name with .csv extension and save.
  11.  Open File in Excel and save a copy as excel workbook.
You have exported two different excel files. One for common sms folder and the 2nd one is private box. You can combine both in one sheet later.
Enjoy... ;)