Update: this does not work for iOS 4 and up, due to iTunes encrypting the backed up files. There is an easy fix for all of those with jailbroken devices, however. Stay tuned for that update!
Lately I wanted to backup some of my text messages from my iPhone 3GS onto my desktop, but couldn’t figure out how to do that. After some quick research and some poking around, I was able to figure out how to view them quickly and easily.
I am not responsible if you screw something up on your computer. It’s not my problem if something breaks. Do this at your own risk (which should be pretty low, unless you’re one of those people that shouldn’t be allowed near a computer).
What you’ll need
- SQLite Database Browser (available at http://sourceforge.net/projects/sqlitebrowser/files/)
Let’s Get Started
In a nutshell, the SMS system on the iPhone is just a carefully hidden SQLite database. All we have to do is find the file and open it up in the SQLite Browser.
- First, we need to locate the file that contains the SMS messages, which will be either:
This will be in one of the following locations:
- Windows Vista/7: C:\Users\[Your User Name]\AppData\Roaming\Apple Computer\MobileSync\Backup\[iPhone ID]\
- Windows XP or lower: C:\Documents and Settings\[Your User Name\Application Data\Roaming\Apple Computer\MobileSync\Backup\[iPhone ID]\
- Mac OS X: User > Library > Application Support > MobileSync > Backup >[iPhone ID]
- Copy this file to a new location to protect the file in case you accidentally screw something up (your Desktop, for example).
- Open up the new copy of the file in SQlite Browser, then select the “Browse Data” tab. Finally, select the “message” table from the “Table:” dropdown box
And that’s all it takes! From here, you can export this as a CSV via File -> Export -> Table as CSV so you can import it into Excel, or manipulate it however else you wish. If I get the time, I’m going to write a quick tool to nicely export the messages to PDF so that they look good instead of being in a table. But, it’s a nice fix for wanting to go through them on a computer, or do fulltext searches with the content.