Skip to content

How to export iMessages and iPhone SMS to a file

Apple has no export of messages. They live in a database: chat.db on a Mac, sms.db in an iPhone backup. ChatExhibits opens either one in your browser. Here is how to get the file.

By Martin Ferret · Published · Last updated

On a Mac: copy chat.db

  1. 1For your full history, turn on Messages in iCloud: in Messages, Settings, then iMessage, Enable Messages in iCloud, and let it sync.
  2. 2Quit Messages, so the latest messages are written to the database.
  3. 3In Finder, choose Go, then Go to Folder, and type ~/Library/Messages.
  4. 4Copy chat.db to your Desktop. To include photos, copy the Attachments folder too and zip both together.

If macOS asks whether to give access to that folder, Apple explains what this permission does.

From an iPhone: an unencrypted backup

  1. 1Connect the iPhone to the computer with a cable and trust the computer.
  2. 2On a Mac, open Finder and select the iPhone; on Windows, open the Apple Devices app.
  3. 3Leave Encrypt local backup unticked, then click Back Up Now and wait for the end.
  4. 4Open the backup folder: ~/Library/Application Support/MobileSync/Backup on a Mac, or Apple\MobileSync\Backup in your user folder on Windows.
  5. 5Zip the backup’s folder and drop it on ChatExhibits, or drop the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28 from its 3d folder.

With iMazing (CSV)

  1. 1In iMazing, select your iPhone, then Messages, and click Start.
  2. 2Select the conversation, then Export, then Excel or CSV.
  3. 3Keep the header row and the chat session name, then choose where to save.

Good to know

  • An encrypted backup cannot be read. Turning encryption off asks for the backup’s password.
  • Attachments kept only in iCloud are not on the computer and cannot be included.
  • The database names nobody as the phone’s owner; you type your name once in ChatExhibits.

What ChatExhibits does with your iMessage export

Sources

Common questions

Is it safe to give my Messages database to a website?

The file is opened inside your browser and never sent anywhere. Still, it holds every conversation on the device, so keep the copy somewhere private and delete it afterwards.

Why are recent messages missing?

While Messages is open, recent messages may sit in a side file. Quit Messages, wait a moment and copy chat.db again.

Can I use an iCloud backup?

No. An iCloud backup is not a file on your computer. Make a backup on the computer, without encryption.

Keep reading

Open your export

Read inside this browser. Never uploaded, never stored.

WhatsApp, Android SMS, Messenger, Instagram, Telegram or iMessage

No export yet?

How to export your messages
Where to find a WhatsApp export on this phone

iPhone

  1. In WhatsApp, open the chat and tap the contact or group name.
  2. Tap Export Chat, choose Attach Media, then Save to Files.
  3. Come back here, tap Choose your export, and pick it in Files.

Android

  1. In WhatsApp, open the chat, tap the three dots, More, then Export chat.
  2. Choose Include media, then save it to your phone (Files or Downloads).
  3. Come back here, tap Choose your export, and pick it.

Everything works on this phone, and the document is made right here. Only voice note transcription needs a computer.