This tutorial will help you save all those important and juicy text messages on your iPhone to your computer for later reading.
If you followed my previous tutorial, “How To Recover Your iPhone Files, Photos, Contacts, Notes, SMS, Call History, Etc.”, you learned how to recover iPhone files from a backup on your computer to restore back to your iPhone. By now you should already downloaded and installed two free applications called DiskAid and iPhone Backup Extractor. For this tutorial, we only need DiskAid to transfer your text messages or SMS from your iPhone to your computer, but we need another one to read those messages from a database and save them in a file format that can be read and properly formatted by an application like MS Excel or any other spreadsheet. This is where we need SQLite Database Browser.
What You Need
Download and install the following:
DiskAid for Mac or Windows
SQLite Database Browser for Mac or Windows
Use DiskAid To Copy “sms.db” From iPhone To Computer
(1) Connect your iPhone to your computer.
(2) Open DiskAid
(3) Click the pull-down at the bottom of the screen where it says Media Folder and select Root Folder (click Go Ahead when a warning window pops up).
(4) Click User -> Library -> SMS -> sms.db.
(5) Click the Copy to Folder icon above and save the “sms.db” file to a folder in your computer.
(6) From your compuer, right-click on sms.db and open it with the SQLite Database Browser application you just installed.
(7) From the SQLite Database Browser, click on the menu File -> Export -> Table as CSV file.
(8) On the Table name drop-down list, select message and click Export.
(9) Save the file with a .csv extension (ex. sms.csv).
(10) Open the file with MS Excel or any other spreadsheet.
[ad#insidepost]













{ 97 comments }
← Previous Comments
Cucusoft iPhone/iTouch/iPod to Computer Transfer is an easy to use iPod/iPhone utility designed to help you back up all your files from your iPod, iPhone, or iTouch, so that you can recover any lost or missing music. With this package, you can back up and restore all of your iPod, iPhone, or iTouch content, including your favorite songs, videos, photos, play lists and more.
Free download at: http://dvd-video-soft.com/ipodconverter/ipod-it...
Full Guide: Transfer songs, videos, photos and playlists etc from iPhone to your computer
http://dvd-video-soft.com/ipodconverter/ipod-it...
How to backup iPhone SMS to computer with password protection?
http://www.backup-iphone-sms.com/how-to-backup-...
With iPhone Transfer SMS, you can backup the iPhone SMS to PC as a txt file or a ANTS file and keep them safe. In ANTS file condition, you can protect the file with a password to keep your privacy.
More infomation: http://www.backup-iphone-sms.com
20% OFF for Tansee iPhone Transfer SMS
http://www.gutensoft.com/Utilities/Tansee-iPhon...
Do remember to free download it to try :
http://www.regnow.com/softsell/visitor.cgi?affi...
It's fast and safe!!!
I got Tansee iPhone SMS Transfer from and luckily Save 20%….
http://www.gutensoft.com/Utilities/Tansee-iPhon...
All iPhone users can't backup the SMS to anywhere until the SMS box is full, then you have to delete all of them to prevent iPhone rejecting new SMS receiving. With Tansee iPhone Transfer, you can transfer the iPhone SMS to computer as a txt file or a ANTS file before the event above happens. Before the transfer, you can choose to transfer from all contacts or a single contact, further more, you can choose transfer the SMS to a TXT file or a ANTS file. In ANTS file condition, you can protect the file with a password to keep your privacy. From now on ANTS file support edit feature just the same operation process as the SMS edit on iPhone. If you want print iPhone SMS, you can choose MHT file format, then open the file by Internet Explorer, print it just like shown on iPhone! No more words, please watch how to backup iPhone SMS to computer, a step by step guide
http://gutensoft.com/Guide/How-to-Transfer-SMS-...
Free download link for you:
http://www.regnow.com/softsell/visitor.cgi?affi...
Cheers.
can i read the messages on my computer without jailbreaking my iPhone, because on DiskAid it will not allow me to view the Root folder unless it is jailbroken
Want to transfer and save your iphone music videos to Mac computer? You can use an iPhone to Mac transfer program to help. I personally use 3herosoft iPhone to Computer Transfer for Mac.
Free download at: http://dvd-video-soft.com/iphoneconverter/iphon...
It helps me to transfer my music, videos, photos, podcasts and TV Shows from iphone to my Mac directly and safely.It works well for me,you can give it a try.
http://dvd-video-soft.com/iphoneconverter/iphon...
Tansee iPhone Transfer SMS is useful SMS backup software that iPhone fans must own one.It is a one-click solution when your iPhone text box is full and keeps rejecting receiving any texts.
It can help you transfer your texts to computer in Txt file format or ANTS file format, so that you can view and manage SMS in your computer freely.For the texts stored in ANTS file, you can even protect it with a password to keep your privacy.
It supports transfering SMS of a single contact or all the contacts.
http://www.92download.com/wiki/Tansee_iPhone_Tr...
Tansee iPhone Transfer Contact is a the first software in the world that can backup contacts and contact photos in iPhone memory to computer. It can help you backup your iPhone contacts along with contact photos to computer as a file (either txt or antc). For the antc file, you protect the file with a password to keep your privacy. Before the transfer, you are free to select all contacts or a single contact.
http://www.92download.com/wiki/Tansee_iPhone_Tr...
Two of them supports iPhone, iPhone 3G, iPhone 3GS.
iMobileTool Windows Mobile Backup Suite 3.10
Requirements: Pocket PC,Windows Mobile 2005,WM5,WM6
Overview: Backup both contacts and SMS from windows mobile to computer;Backup contacts and SMS into Text file format(.txt, .csv file) or Data file format.(.cbf and .sms);Restore contacts and SMS from the backup data files(.cbf and .sms file).
http://imobiletool.com/windows-mobile-backup-su...
iMobileTool Windows Mobile Backup Suite is an all-in-one windows mobile backup solution. This suite includes two software packages, the “iMobileTool SMS Backup” and the “iMobileTool Contacts Backup”, so with this single package you can backup both contacts and sms messages from your windows mobile phone to computer directly
With SMS Backup, you can easily backup the SMS to computer as a text file or a SMS file whenever you want. You can choose whether to backup the SMS into a TXT file or a SMS file. By choosing SMS file format, you can use our pc sms manager to view and edit your SMS on computer.
With Contacts Backup, you can easily backup all contacts to computer as a text file or a .cbf backup file at your will. If you choose to backup into .cbf backup file format, you can even manage these contacts on your computer by the use of our pc contacts manager.
Key Feature:
* Backup SMS for windows mobile into txt file or .sms backup file and save onto your computer
* Backup Windows Mobile SMS to CSV file
* Support customized sms backup
* Support all SMS default folders (Inbox, Outbox, Drafts, Deleted, Send) and custom folders
* Restore SMS from the .sms backup file
* Export and backup contacts into txt file or .cbf backup file format and save onto your pc
* Backup both sim card contacts and outlook contacts
* Backup winddows mobile contacts to CSV file
* Transfer windows mobile contacts to gmail, hotmail, outlook etc on computer.
* Backup contacts'photos and ringtones
* Edit contacts info on computer directly
* Set photos and ringtones for contacts on computer
* Restore contacts from the .cbf backup file
* Import contacts from csv,excel,access etc on pc to windows mobile
* Put gmail, hotmail contacts from PC to windows mobile
* Print SMS + Contacts on computer
* Support unlimited contacts and SMS backup/restore.
* Fast backup and restore speed
* Easy to use
Read More: http://imobiletool.com/windows-mobile-backup-su...
Detailed guide for you:
How to backup iPhone SMS to Computer
http://ipod-tool.com/ipod-guide/how-to-transfer...
This works great for me.
I have been trying to get my messages off my phone and I am frustrated. I downloaded the trial of this software and it never gets past the reading data phase. Can you help?
Hello Esther, Might it will need some time to read your iPhone, at most 1 hour. That depends on your messages amount.
In your case, follow the below tips:
If you check “Encrypt iPhone backup”
Try uncheck this option:
Open your iTunes, plug your iPhone, click “summary” ,uncheck “Encrypt iPhone backup”
–By iPod-tool.com
Read details: http://ipod-tool.com/ipod-software/tansee-iphon...
Lame!! The tutorial should clearly state that the iphone must be jailbroken for this tutorial to work.
being able to work with text messages on your PC from the iPhone can be very useful. Particularly if you use SMS a lot for business.
How to backup your mobile SMS and contacts?(windows mobile &iphone)
It is commom that we get a lot of SMS and most of them are so important.Do you find it is not easy that we save so many contacts in our mobile phone?SIM or memory card has its limited storage capacity and our SMS&contacts will become more and more,what can we do with this?Someone will say we can delete them.Yes,of course we you can delete them but you know most of them are so important.I do many thigs to find the solution way,finally I find the best way is that we can save them to our computer,but our mobile phone can not provide the solution way,I have no ideas until the day I get the third part software.Actually,it show me a good way.There are so many this kind of software and which one is the right one?I find [b]3GMobile SMS + Contacts Backup[/b] and GodswMobile Windows Mobile Transfer[/b] Suite for your windows mobile phone.These software is valueble.
windows mobile backup software :
With [b]3GMobile SMS + Contacts Backup[/b], you can:
Backup SMS Messages for windows mobile into txt file or .xml backup file and save onto your computer
Restore SMS Messages from a .xml backup file
Support all SMS default folders (Inbox, Outbox, Drafts, Sent Items, Deleted Items) and custom folders.
Export your outlook contacts into txt file or .xml backup file format and save onto your pc
Edit outlook contacts info on computer directly
Restore outlook contacts from the .xml backup file
Support unlimited outlook contacts and SMS backup/restore.
Fast backup and restore speed
Fully Support Windows Mobile 5/6.0/6.1/6.5
More information:
https://www.3gmobiletool.com/
With [b]GodswMobile Windows Mobile Transfer Suite[/b], you can:
Backup and restore contacts, including sim card contacts and mobile contacts;
Backup and restore text message for windows mobile;
Support backup and restore SMS and Contacts to text file(*.txt);
Transfer SMS and Contacts from mobile to computer;
Including an application for windows pc to view,edit and print SMS and Contacts;
Support set photo and ringtone for contacts on computer directly;
Support unlimited SMS and Contacts backup/restore;
Fast backup and restore speed;
Easy to use – 3 click to finish the backup or restore job;
Fully support Microsoft Windows Mobile 5 and 6.
Fully support VGA and WVGA Screen. (Such as HTC Touch HD 2,Pro 2,Diamond 2)
More information:
http://www.converter123.com/Other-Software/Othe...
iphone backup software:
If you use iPhone I think [b]Tansee iPhone Transfer SMS[/b]&[b]Tansee iPhone Transfer Contact[/b] can help you:
With [b]Tansee iPhone Transfer SMS[/b],you can:
Backup SMS in iPhone to computer before iPhone reject receiving new SMS.
View and Manage old iPhone SMS in your computer.
View SMS in Text file format (.txt file), ANTS file format (.ants file), MHT file format (.mht file)on PC.
Password protection support (ANTS file only).
Edit SMS (ANTS file only).
Print SMS (MHT file print by IE).
More information:
http://www.converter123.com/iPhone-Software/Tan...
With [b]Tansee iPhone Transfer Contact[/b],you can:
Backup contacts on iPhone memory to a file.
Export two types of file format (Antc file, Text file).
Backup iPhone Contact’s Photos.
Export full screen of iPhone contact’s Photos.
View Contacts in Text file format (.txt) or ANTC file format (.antc) on PC.
Password protection support (ANTC file only).
More information:
http://www.converter123.com/iPhone-Software/Tan...
If you want to get more onformation,you can see:
Http://www.converter123.com
Have fun with this software,hope it can do you a favor!
[url=http://www.converter123.com/][b]dvd to avi converter[/b][/url]
dvd to avi converter
DVD Ripper Software
DVD Ripper Software
DVD Creator Software
DVD Converter Software
IPhone Tools
Ipod Tools
DVD Software for Mac
Video Software for Mac
Misc Software for Mac
MP4 Software
Audio Software
Video Software
Zune Software
Flash Software
YouTube Software
Other Tools
SMS Backup
Backup SMS
Contacts Backup
Backup Contacts
SMS transfer
transfer SMS
Used-Wheel-Loaders
Used Bulldozers
Used Cranes
Used Excavators
Used Excavators
Used Rollers
Used Motor graders
Used Forklifts
Used Concrete Mixers
Used Truck-Mounted Concrete Pumps
Used Generating Sets
Tansee iPhone Transfer SMS can provide you:
Backup SMS in iPhone to computer before iPhone reject receiving new SMS.
View and Manage old iPhone SMS in your computer.
View SMS in Text file format (.txt file), ANTS file format (.ants file), MHT file format (.mht file)on PC.
Password protection support (ANTS file only).
Edit SMS (ANTS file only).
Print SMS (MHT file print by IE).
http://www.backup-iphone-sms.com/
————————————————————————-
More infomation:
How to backup iPhone SMS to computer?
How to copy iPhone SMS to Text file?
How to transfer iPhone SMS to PC?
How to backup iPhone SMS to ANTS file?
how to backup iPhone SMS with Password protection?
How to view iPhone SMS in Text file format (.txt) or ANTS file format (.ants) on PC?
How to print iPhone SMS on computer?
—————————————————————————-
If you use this iPhone SMS to PC Backup software to backup all his text messages onto your pc before he deletes them, you can view them easily, even in .txt format.
http://ipod-tool.com/ipod-software/tansee-iphon...
- Backup SMS in iPhone to computer before iPhone reject receiving new SMS.
- View and Manage old iPhone SMS in your computer.
- View SMS in Text file format (.txt file), ANTS file format (.ants file), MHT file format (.mht file)on PC.
- Password protection support (ANTS file only).
- Edit SMS (ANTS file only).
- Print SMS (MHT file print by IE).
Helpful guide for iPhone SMS backup:
http://ipod-tool.com/ipod-guide/how-to-transfer...
Daniusoft Media Converteris a powerful DRM media converter that supports both DRM Audio and DRM Video. This all-in-one DRM media converter allows you to convert DRM media in a fast and professional way.
Daniusoft Media Converteris a powerful DRM media converter that supports both DRM Audio and DRM Video. This all-in-one DRM media converter allows you to convert DRM media in a fast and professional way.
The guide is created to help people solve the following problems.
(1)People who want to transfer their broken iPod's files back to iPod or iPhone.
(2)People who want to transfer their iPod files to another iPod or iPhone.
(3)People who want to manage their iPod as hard disk but not just syncing their files by using iTunes.
All the need is a smart transfer called [b][url=http://www.macdvdrippersoft.com/ipod-transfer-avcware.html]AVCWare iPod to iPod/Computer/iTunes Transfer[/url][/b](For Windows) and [b][url=http://www.macdvdrippersoft.com/ipod-to-mac-transfer-imacsoft.html]iMacsoft iPod to Mac Transfer[/url][/b](For Mac).
[b]For Windows:[/b]
Step 0: Download [b][url=http://www.macdvdrippersoft.com/download/ipod-transfer/avc-ipod-transfer-572666.exe]AVCWare iPod to iPod/PC/iTunes Transfer[/url][/b], install it on your computer.
Step 1: Connet your iPod to your computer with your iPod Date Cable.
[b]Note: [/b]Before you run this iPod transfer, you should run your iTunes first to recognize your iPod, Once your iTunes recognize your iPod, close your iTunes and run your AVCWare iPod Transfer, then your iPod files will appear on the left of this transfer software.
Now you can transfer your files from iPod to iTunes/Computer/iPod or from local computer to your iPod.
[b]Part 1: Transfer iPod files to Local computer.[/b]
Open the library/playlist that you want to export files, and then check the file(s) you want to export in the file list.
Click the “Backup to local” button to start exporting files.
[img]http://www.macdvdrippersoft.com/images/guide/avcware-ipod-transfer-2.jpg[/img]
[b]Part 2: Transfer iPod files to Local computer.[/b]
Open the library/playlist that you want to export files, and then check the file(s) you want to export in the file list.
Click the “Add to iTunes” button to start exporting files.
[img]http://www.macdvdrippersoft.com/images/guide/avcware-ipod-transfer-3.jpg[/img]
[b]Part 3: Transfer Local files to your iPod.[/b]
Open the library/playlist that you want to add files into.
Click the “Add files button”, and choose the Add Files to List option that the button shows, and then locate the required files to your iPod/iPhone.
[b]Tip:[/b] If you want to add a folder containing all files you want, please click the Add files drop-down button, and choose the Add Folder to List option, and then locate the folder to your iPod/iPhone.
[img]http://www.macdvdrippersoft.com/images/guide/avcware-ipod-transfer-1.jpg[/img]
[b]Part 4: Create a Playlist[/b]
When the iPod/iPhone icon appears in the AVCWare iPod to iPod/Computer/iTunes Transfer window, select a playlist below the iPod/iPhone icon. And then choose the New Playlist button to create an untitled playlist. This will appear at the bottom of the list of playlists below the selected iPod/iPhone icon.
Enter a name for your playlist. A short and descriptive name will help you organize your music and video on your iPod/iPhone.
Add audio or video files to your new playlist.
[img]http://www.macdvdrippersoft.com/images/guide/avcware-ipod-transfer-4.jpg[/img]
[b]For Mac:[/b]
Step 0: Free download [b][url=http://www.macdvdrippersoft.com/download/ipod-transfer/m-ipod-to-mac-transfer.dmg]iPod to Mac Transfer [/url] [/b], install and run it.
All information about your iPod, such as type, capacity, version, serial number, and format, will be shown on the main interface.
[b]Tip:[/b] All functions for iPod are applicable to iPhone, iPhone 3G, iPhone 3GS as well except for the photo management.
[img]http://www.macdvdrippersoft.com/images/guide/mac-1.jpg[/img]
[b]Step 1: Transfer movies to iPod[/b]
Open the library/playlist that you want to transfer.
Click the “Add files to iPod” or “Add Folder to iPod” button.
[img]http://www.macdvdrippersoft.com/images/guide/mac-2.jpg[/img]
[b]Step 2: Locate the required audio files on the pop-up dialogbox and click “Open” button to import selected files to your iPod. [/b]
[img]http://www.macdvdrippersoft.com/images/guide/mac-3.jpg[/img]
[b]Step 3: Edit iPod Playlist[/b]
To those who want to create their own personalized iPod Playlist, you can try this function.
Choose the “File -> Playlist” option to create a new list , and then choose the “New Playlist” option from the submenu.
Drag & drop to import or export files need and drag it to the local, or you can choose the file from the local and drag it to the iPod.
More useful smart tool for iPod:
[b][url=http://www.macdvdrippersoft.com/ipod-video-converter-aiprosoft.html]iPod Video Converter[/url][/b], [b][url=http://www.macdvdrippersoft.com/dvd-to-ipod-converter-for-mac-iskysoft.html]DVD to iPod Converter for Mac[/url][/b], [b][url=http://www.macdvdrippersoft.com/dvd-to-ipod-converter-aiseesoft.html]DVD to iPod Converter for Mac[/url][/b], [b][url=http://www.macdvdrippersoft.com/ipod-mate-3herosoft.html]iPod Mate[/url][/b]
iPod to iPod/Computer/iTunes Transfercan transfer your iPod files between iPod and iPod, iPod and Computer, iPod and iTunes easily and fast.
Daniusoft Media Converteris a powerful DRM media converter that supports both DRM Audio and DRM Video. This all-in-one DRM media converter allows you to convert DRM media in a fast and professional way.
It worked great. Thank you very much.
Excellent post, exactly what I was looking for. Thank you.
Great info. Thanks a million.
Thanks for the great post. I've manually pulled the SMS messages from my iPhone, but I've also tried a simple tool called Decipher TextMessage. They also have a voicemail saving tool. Five bucks for a simple piece of software to do the work for me.
Thanks again!
yes there is a way to retrieve old text
there was an incident where the police got involved one time and they showed me all the old text from my ex and me and another person involved… so yea there is a way..
retrieve text messages
hey, I tried to use SPIRITJB to jailbreak my iPhone 3gs, but it didn't work! I had the boot screen for 2 hours, so I waited for the battery to die out, and now, all I have is the apple logo… what should I do?
help please!!
***LAMEST ATTEMPT AT AN APP THAT APPLE SHOULD ALREADY HAVE – DO NOT BOTHER – THE JAILBREAK CRAP IS STUPID AND LAME***
i have more then 10,000 text in my iphone 3g 8gb version,
i am scared to loose all of them
i tried tansee iphone sms transfer but its free version allowed me to just transfer top 20 text , i need some help
i really need to save them as soon as i can
can anyone help me with this
<3
thanking everyone
Can I splice two different SMS.db files and restore it as one file to my iPhone?
…If I extract two different SMS.db files but they are both text back and forth from the same two phone numbers, can I splice them and restore it as one file to my iPhone?
I had to replace my iPhone and I have a weeks worth of text I want to “attach” to the original text thread from the old phone. Any head would be greatly appreciated!!!
TANSEE IS TUCK ON “READING DATA” – WHAT DO I DO?
For mac,if you need convert video to the formats what you need,you can use mac video converter to help you.
http://www.macvideoconverter.org/
of course,you can also look here.
http://www.macdvdconverter.com/mac-video-conver...
ok so the diskaid i downloaded doesn't even have the drop down arrow where it let's me choose the root folder..
HELP PLEASE! im desperate to have my messages on my macbook!
Caitlin, are you on Mac or PC? If Mac, you should try Decipher TextMessage (posted a few things above).
LB – if you're on a MacBook, try the Decipher tool. Much easier! :)
http://decipher-media.com/iphone-tools/
I spent the $5 on that Decipher tool and it works great. Backed up all my txts to my iMac. It's cool to finally be able to save these thing.
This is why I love it.
Hi Sarah,
I just bought the Decipher Tool for SMS and Voicemail. Each time I try and run the Decipher Tool, I get a pop up saying:
“Loading your iPhone backup data. This should only take a moment”
And then it freezes.
Any ideas?
RT
Ricky,
Have you emailed the developer? I'm fairly sure that's the best way to get your problem fixed.
Let me know if it works out.
Try a hard reset. Worked for me
Learn details about this iPhone sms backup software
http://www.gutensoft.com/Guide/How-to-Transfer-...
You can save 20% Now.
- Backup SMS in iPhone to computer.
- View and Manage old iPhone SMS in your computer.
- View SMS in Text file format (.txt file), ANTS file format (.ants file), MHT file format (.mht file)on PC.
- Password protection support (ANTS file only).
- Edit SMS (ANTS file only).
- Print SMS (MHT file print by IE).
Very vivid appearance, perfect plot, challenging game. Many of us put this game as a very important part of life. Surprise,when I browse the web ,I found these website Pretty good. adidas arenas Signature
This is where I first came to try and save my texts but this only works if your phone is jailbroken. Learned that after downloadig everything. After 2 days of searching I found iPhoneBackupExtractor.com. It sells for $25 but you can find the crack torrent for it easy enough on the web. This program works by using the backup saved from itunes. I have a 3G using 3.1.3 version firmware. Hope this saves you a bunch of time and you can spend it helping someone else fix their problem
Thank you! Thank you! Thank you! You might have saved me from going to prison. I have some texts that are extremely important for me if i go to court. Thank you! People follow what this guy said.! The other instructions on this page will just waste your time and you wont get any good results.
Here is a nice and easy PC and Mac program (Mac via Paralles or VirtualBox), I recently came across. It is named 'iTwin'. http://www.i-twin.de/en I took the latest beta-version and had no problems at all. Contacts, Text Messages, Calendar entries, Notes and more … Looks really great !
This works great! I didn’t want to pay a single dime at first, but after I tried many of the other options on this page, I was happy to spend $5 on this product. No need for jail breaks or any of that BS. Follow the link and watch the video to see how it works.
Thanks so much!
← Previous Comments
Comments on this entry are closed.
{ 1 trackback }