sodcalculator

10 Tech How-To

Extract SMS & iMessage from iTunes Backup

Guide 10-32090 · Updated · Step by step

This guide shows you how to pull your text messages, iMessages, and MMS attachments out of an iTunes (or Finder) backup file. You’ll end up with a readable database of your conversations and the photos or videos that were sent in them. Before starting, you’ll need a computer with your backup already made and a few free tools installed.

What You’ll Need

  • A Windows PC or Mac with the iTunes backup you want to extract from (on macOS Catalina or later, backups are made through Finder).
  • A backup extraction tool. Free, reliable options include iBackup Viewer (Windows and Mac) or iPhone Backup Extractor (free tier works for messages).
  • A SQLite database browser, such as DB Browser for SQLite (free, all platforms), if you want to inspect the raw database.
  • About 500 MB of free disk space for the extracted files.

Step-by-Step

  1. Locate your backup. On Windows, iTunes backups are in %APPDATA%\Apple Computer\MobileSync\Backup. On Mac, they are in ~/Library/Application Support/MobileSync/Backup. Each folder inside is one backup, named with a long string of letters and numbers (the device UDID). If you have several, sort by date modified to find the newest.
  2. Install the extraction tool. Download and install iBackup Viewer or iPhone Backup Extractor. Both are free for this task. Launch the program and point it to the backup folder you found in step 1. The tool will scan the backup and list the apps and data it contains.
  3. Locate the SMS database. In the tool’s interface, look for a section called “SMS”, “Messages”, or “iMessage”. This is the app group that stores all your text conversations. Click on it to see a preview of your messages.
  4. Export the messages. Choose the export option. Most tools let you export as a PDF, CSV, or HTML file. Pick CSV if you want to open it in Excel or Google Sheets, or HTML if you want a readable web page with attachments. Select a destination folder and start the export.
  5. Extract attachments (photos/videos). The same tool will usually have a separate section for “Attachments” or “Media”. Export these to a folder. They are named with long random strings, but the file extension (jpg, mov, etc.) is preserved. You can rename them later if needed.
  6. Verify the export. Open the CSV or HTML file you created. Check that the phone numbers, dates, and message bodies look correct. If you exported attachments, open a few to confirm they aren’t corrupted.
  7. (Optional) Inspect the raw database. If you want the complete, unfiltered data, use DB Browser for SQLite to open the sms.db file directly from the backup. The tool in step 2 can usually “Reveal in Finder/Explorer” the extracted database file. In DB Browser, browse the message table for texts and the attachment table for media references.

Common Mistakes

  • Using an encrypted backup without a password. If you enabled “Encrypt Backup” in iTunes/Finder, the extraction tool will ask for that password. If you forgot it, you cannot extract anything. There is no workaround.
  • Exporting the wrong backup. If you have multiple devices, the backup folder names are not labeled with device names. Check the backup’s modification date or use the tool’s preview to confirm it’s the right phone.
  • Not exporting attachments separately. Many users export the message list and think the photos are missing. Attachments are stored in a different part of the backup and need a separate export action.
  • Opening the CSV in Excel and seeing garbled dates. The dates in the raw database are in Apple’s format (seconds since 2001). The extraction tools convert them for you, but if you open the raw DB, you’ll need to convert: add 978307200 to the value, then treat it as a Unix timestamp.

Tips

  • Make a fresh backup before extracting. If your phone is still available, plug it in and create a new backup so you get the most recent messages.
  • Use encrypted backups for full data. If you plan to extract health data or passwords, you need an encrypted backup. For messages alone, a normal backup is sufficient.
  • Check the file size. If your backup is very large (tens of GB), it likely contains many videos. The extraction may take a while; let it run.
  • Rename exported attachments using a script. If you have hundreds of photos with random names, use a simple batch rename tool to sort them by date or conversation.
  • Keep the backup folder intact. Do not delete the backup after extraction until you’ve verified everything you needed is present.

Troubleshooting

The tool says “No backup found” even though I have one. Make sure you pointed the tool to the correct folder. On Windows, the path may be hidden; type %APPDATA% into the file explorer address bar to get there. On Mac, the Library folder is hidden by default—hold the Option key while clicking “Go” in Finder to see it.

It asks for a password and I don’t remember it. Unfortunately, there is no way to bypass an encrypted backup password. If you truly cannot recall it, your only option is to start a new unencrypted backup from the phone (if it still works) and extract from that. You will lose any messages that were only in the encrypted backup.

The messages export looks empty. This usually means the backup was made from a device that had iMessage disabled, or the messages were stored in iCloud and not on the device. Check if the backup contains other data (photos, app data) to confirm it’s the right device. If you use iCloud Messages, your texts are not in the local backup—you’d need to extract from iCloud instead.

Attachments export but won’t open. The files may have been extracted without their original file extension. Try adding the correct extension (e.g., .jpg for photos, .mov or .mp4 for videos) based on the file’s content. You can check the file type by opening it in a hex editor or using the file command on Mac/Linux.

The tool crashes on a large backup. Try extracting only the SMS database first, not the attachments. If that works, export attachments in smaller batches. Alternatively, use a different tool—iPhone Backup Extractor tends to handle large backups better than iBackup Viewer.

Frequently Asked Questions

Can I extract deleted text messages? Only if the backup was made before the messages were deleted. Backups do not contain data that was removed from the phone before the backup was taken.

Do I need to jailbreak my iPhone? No. These tools read the backup files, which are standard on any computer. No jailbreak or phone access is required.

Will this work with an iCloud backup? No, this guide covers local iTunes/Finder backups. iCloud backups are encrypted and not accessible this way. You would need an iCloud extraction service, which is more complex and often paid.

Are the extracted messages readable on a new phone? Not directly. The CSV/HTML export is for viewing. If you want to transfer messages to a new iPhone, you should use the official “Restore from Backup” feature instead.

Can I extract messages from someone else’s backup? Yes, if you have the backup file and the password (if encrypted). However, doing so without the owner’s permission may violate privacy laws in your jurisdiction.

How long does the extraction take? For a typical backup with a few thousand messages, the text export takes under a minute. Exporting hundreds of attachments can take 10–30 minutes depending on file sizes.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →