How can I export SMS text messages from my iPhone?

Question

When answering this question, please note if the solution is:

For Windows and/or Mac OS X users
The price of the solution
If you have successfully—and actually—used the solution

score 51 · Accepted Answer · answered Jan 24 '11 at 23:43

51

Get /var/mobile/Library/SMS/sms.db
It is now exported.

What format do you want the export to be? The existing format is sqlite, so you can convert it to ASCII like so: sqlite3 sms.db .dump > sms.db.txt

For step one, you can jailbreak and then scp, or you can just search your backup folder for the file, no jailbreak required.

If your phone is not jailbroken, look on OS X in:

~/Library/Application Support/MobileSync/Backup/<long_hex_string>/

And, in my case, and according to various web sources, although not in all cases, is named:

3d0d7e5fb2ce288813306e4d4636395e047a3d28

To answer your other questions: Any OS, Free, Successful.

answered Jan 24 '11 at 23:43

Great solution. I'm going to have to try this when I get home. Thanks! – Ciaocibai Jan 24 '11 at 23:59
Thanks for the solution. I have a non-jail broken iPhone and was able to get what I needed. However, I'd also be interested in sans-Terminal solutions for non-technical folks if you've used any. – Matthew Rankin Jan 26 '11 at 16:30
Awesome solution. voted up – segfault Jan 18 '12 at 22:08
any idea how I can find this file in ios6? I've asked here: http://apple.stackexchange.com/questions/80875/what-is-the-iphone-sms-database-called-in-ios6 – ptim Feb 03 '13 at 09:20
The command, sqlite3 sms.db .dump > sms.db.txt is exactly what I was looking for. Thanks! – Andrew Larsson Jun 27 '13 at 15:39
The hex string was very helpful. Have another upvote. – lababidi Mar 06 '17 at 04:17
I was able to export the text messages on Mac by opening the file using sqlite3 3d0d... and then running .once my-sms.txt; followed by select * from message;. – JakeTheSnake Dec 23 '21 at 10:10
I don't have a 'MobileSync' directory in that folder. I'm on MacOS Monterrey (12.5) – Raleigh L. Aug 01 '22 at 18:45
I think the new location on macOS Monterrey is ~/Library/Messages/chat.db – Raleigh L. Aug 01 '22 at 18:51

mtlynch · Answer 2 · 2015-01-03T02:06:06.617

13

AllYourTexts - free - Windows

Full disclosure: I'm the author.

Allows you to view SMS and MMS data from your PC
Supports exporting to plaintext or HTML files.
Shows you graph visualizations of your texting behavior over time.

I was looking for a solution to this myself and I was unhappy with the 3rd party offerings. I felt like they were overpriced or poorly designed, so I wrote my own.

edited Jan 03 '15 at 02:06

answered Nov 21 '11 at 14:27

mtlynch

231

After trying out AllYourTexts, i can honestly say that this is the most simple and easy to use software for exporting text messages. I've looked around the web for days trying to find a program that will export text messages AND iMessages for the iPhone, and I finally found it. As a computer geek, I highly recommend AllYourTexts. – Aug 01 '12 at 06:22
1

This is great! View, export and see status of your texting habits! Thanks much for your efforts. – SeanDowney Jun 26 '15 at 03:51
2

Note: It's not yet compatible with iOS 10 – Simon East Dec 27 '16 at 05:22
Thanks for posting this. I looked at your Github repo and noticed the project hasn't been updated in almost a decade -- would it still work on newer iOS versions (15 and up)? Or is the project no longer active? – Raleigh L. Jul 31 '22 at 18:29

score 6 · Answer 3 · answered Apr 19 '11 at 22:49

6

I rely on PhoneView which you correctly note is a Mac OS X only paid solution.

It has always been updated very quickly by the developers each time a new iOS is released. I even received support several times for pre-release / beta versions of iOS and iTunes. Support emails are promptly answered and I have twice received custom builds from them to resolve issues using their product with pre-release iOS versions to assist me in managing the devices I use for iOS development.

I've used PhoneView to save data from a phone that iTunes said was broken and could only be erased and then restored. It's been a reliable swiss army knife for me filling in many gaps that iTunes and Xcode leave for managing iOS devices.

answered Apr 19 '11 at 22:49

bmike

235,889

1

me too, its a fantastically handy piece of software, it was one of the first apps out there when it was called iPhoneDrive. I use it most of the time to bypass iTunes when loading content/backing up in game purchases. – Stu Wilson Oct 05 '12 at 20:46
tried this but it doesn't work (macOS 11.2.1 + iOS 14.4) – Bowen Mar 15 '21 at 19:33
@Bowen thank you. I will dust off my license and see if I get the same. – bmike Mar 15 '21 at 20:55

score 5 · Answer 4 · edited Dec 25 '18 at 12:39

5

I used CopyTrans Contacts for Windows (not sure whether it also operates on Mac) to export my iPhone SMS and iMessage text messages to my PC.

Here is where I found out about the tool: How to export iPhone SMS

I do not know the price as I used their free version to export all of my 100+ messages I think you have to pay if you want to export a really large number of SMS text messages.

export iphone sms

edited Dec 25 '18 at 12:39

Glorfindel

4,057

answered Feb 07 '13 at 17:39

jDonMas

955

The link no longer is active. – Raleigh L. Jul 31 '22 at 18:31

score 4 · Answer 5 · edited Apr 20 '11 at 00:07

4

I'm on windows and I bought Decipher Text Message (Mac $7, Windows $10). It did the trick for my needs and backed up all my work sms messages from my iphone. My girlfriend uses it too however, she is on a mac. The cool thing is that the program also saved my sms images, which I hadn't even expected. Has anyone tried any of the other tools?? Curious about them.

edited Apr 20 '11 at 00:07

Jason Salaz

24,471

answered Apr 19 '11 at 21:03

Robert Clowry

41

This is a pretty powerful tool. Just checked it out, works fairly well for iOS 12.4. – Aug 11 '19 at 05:04

score 4 · Answer 6 · edited Oct 05 '12 at 20:41

4

A windows software solution is Save The Message

The software is free (trial) however the costs after the 30 day trial are $9.99 for a basic account, $99 for a professional" account.

edited Oct 05 '12 at 20:41

Stu Wilson

6,621

answered Oct 01 '12 at 20:52

Russell

41

Seth Johnson · Answer 7 · 2021-08-14T01:14:20.667

There are numerous tools (as linked elsewhere here), both free and expensive, to export message data. They all rely on interpreting data from an unencrypted iPhone backup. You can actually do this yourself if you're particular about how the data is exported.

The key facts are:

Your backup lives inside ~/Library/Application Support/MobileSync/Backup/{uid}/.
The manifest.db is an SQLite database mapping all the files in that directory to actual filenames on the device.
The Library/SMS/sms.db file on your iPhone is another database containing all the message and attachment data.
Combining the manifest and sms databases lets you query and export all the conversations and attachments from decrypted files in your backup directory.

I wanted to future-proof my exported messages (or make their contents human-readable and easily accessible), so I wrote a script to load these database, export the chats as JSON files, and archive all the attachments alongside each chat (message group).

The result is a kind of hacky but working (for me) tool that I've uploaded to GitHub: iPhone message export. This script might be a good starting point if you're interested in doing these backups yourself.

(The price is free, I've successfully tested on macOS with an iOS 14 backup. I think if windows backups are stored the same way, the same python code should work there as well.)

after searching for hours, Seth Johnson's script is the only solution I've found that works effectively (on any OS) without downloading any apps. — Matt, Dec 28 '21 at 19:25

score 1 · Answer 8 · answered Aug 01 '12 at 07:02

Believe it or not, there's an app for that!

The app SMS Export ($4.99) will allow you to export your SMS to the software on both your Mac and Windows.

You can make a back-up of your entire SMS-database or export the SMS-messages to your computer:

You can converted SMS to HTML, CSV or Text. Then you can load your SMS into any program like Excel or Word and print them.

ptim · Answer 9 · 2013-02-12T06:46:04.333

My destination for the export was a new Smasung Galaxy Note, so the Samsung Kies software (eventually) managed to import the SMSs from an unencrypted iPhone backup. Kies is free for Samsung phones. It was necessary to 'update drivers' from one of the menus in Kies before this worked for me. Kies also prevents me running Android File Transfer on 10.8, so I uninstalled Kies once the import was complete.

Otherwise, I've successfully used DiskAid on the Mac to export my SMSs to a flat text file. A useful reference, but I'd rather it exported a friendly (ie standard) SQLite database so I could easily use the data elsewhere.

DiskAid is $29.90 at the time of answer, but they also offer free educational licenses to folk with email addresses at tertiary institutions.

note, Kies got only SMSs, not MMSs (or at least, not the photos) — ptim, Feb 12 '13 at 06:48

score 0 · Answer 10 · edited Nov 21 '23 at 04:51

0

I wrote a free, open-source tool to do this called imessage-exporter .

For iOS, you would point it at the root of an unencrypted iOS backup. It also supports macOS.

edited Nov 21 '23 at 04:51

agarza

2,274

answered Nov 20 '23 at 22:24

Christopher Sardegna

31

How can I export SMS text messages from my iPhone?

10 Answers10

Linked

Related