How to export iPhone messages to Excel
By Caner Kaya, Kayabyte · Last updated 16 October 2026
A spreadsheet is a great way to work with a long conversation. You can sort by date, filter by sender, search for a word, count how many times something happened, or build a timeline. Lawyers often like an Excel list next to a PDF because it’s easy to review. But the iPhone has no way to export messages to Excel or CSV, and neither does the Mac.
This guide explains what you can do for free, and where an app saves a lot of work.
What a useful messages spreadsheet looks like
Before you start, decide which columns you need. A good layout is one row per message, with:
| Column | Example |
|---|---|
| Date | 2025-03-14 |
| Time | 18:42:07 |
| Direction | Received |
| Sender name | Jordan Smith |
| Sender number or email | +1 555 0100 |
| Message text | Can you take them on Saturday instead? |
| Attachment | IMG_2041.HEIC |
| Service | iMessage / SMS / RCS |
Use a proper date format (year-month-day sorts correctly), and keep the date and time as real values, not text, so Excel can sort and filter them.
Option 1: Type it up (free, for short conversations)
For a few dozen messages, typing is honestly the quickest free route.
- Open the conversation on your iPhone or Mac.
- In Excel or Numbers, create the columns above.
- Go through the messages in order. On iPhone, swipe left and hold to see the exact time of each message.
- Type or copy each message into its own row. On iPhone you can touch and hold a message, tap Copy, and paste it into a note or the spreadsheet.
It’s slow and easy to make mistakes, so double-check against the phone. If the spreadsheet is for a legal case, note that it was typed by hand.
Option 2: Copy from Messages on a Mac (free, partial)
If your messages sync to a Mac through Messages in iCloud, you can copy text from the Mac:
- Open the conversation in Messages on the Mac and scroll up to load the messages you need.
- Click a message bubble and press Command-C to copy it, then paste it into your spreadsheet.
- Repeat for each message.
The Mac doesn’t copy the date, time or sender with the text, so you’ll still need to add those yourself. This route mostly saves typing for long messages.
Option 3: From a PDF into Excel (free, messy)
If you already have a PDF of the conversation, for example from printing on a Mac (see How to print iMessages from a Mac), you can try copying its text into Excel, or opening it with a tool that converts PDF tables to Excel. Messages printouts aren’t tables, so the result usually needs a lot of cleaning, and dates may not come across. It’s worth a try for a one-off, but don’t expect a tidy sheet.
Option 4: Command-line tools (free, technical)
There are free, open-source tools that can read the Messages database on a Mac, or an iPhone backup, from Terminal. They mostly produce text or web pages; getting a spreadsheet usually means another conversion step. If you’re comfortable with Terminal, they can work well. If words like “Terminal” and “database” make you uneasy, skip this one. You don’t want to risk your messages while learning.
Option 5: Export from an iPhone backup with an app
The most complete and accurate route is an app that reads your messages directly and writes the spreadsheet for you.
- Back up your iPhone to your Mac in Finder. See How to make an iPhone backup on a Mac (and encrypt it).
- Open the backup in the app, choose the conversation and dates.
- Export to Excel.
Because the data comes straight from the messages, every row has the exact date, time and sender, with no typing.
Where Exhibitly helps
Exhibitly is a Mac app we make that does option 5. It reads an iPhone backup made in Finder (encrypted too, with your password) or the Messages on your Mac, and for each export creates:
- An Excel file with one row per message: date, time, direction, sender name, phone number or email, the message text and any attachment.
- A matching PDF with the same messages, page numbers and photos inline, so a reader can go from a row to the page.
- A folder of original attachments with SHA-256 fingerprints.
You can export a whole conversation, a date range or selected messages. Everything happens on your Mac and nothing is uploaded. The free preview includes Excel export, limited to 50 messages per export (the PDF carries a watermark).
Ideas for using the spreadsheet
Once your messages are in Excel:
- Filter by sender to read only what one person wrote.
- Search for keywords like “pick up”, “rent”, “paid” or a place name.
- Count events. Add a column where you tag messages (for example “late”, “cancelled”, “agreed”), then use a pivot table or COUNTIF to count them by month.
- Build a timeline. Copy key rows into a separate sheet with a short description of each event. See Custody evidence binder: what to include for how lawyers often use one.
- Check response times by comparing the time of a message with the time of the reply.
A few cautions
- Keep the original. Excel files are easy to edit, which is good for your own analysis but means a spreadsheet alone is weaker as evidence than the original messages or a PDF export. Keep an untouched copy of the export, and work on a duplicate.
- Watch the date format. Excel may change dates based on your region, swapping day and month. Check a few rows against the phone.
- Keep it private. A spreadsheet of personal messages is sensitive. Don’t store it in a shared folder.
- If the spreadsheet is for a legal case, check with your lawyer or court about what format they want. Some prefer CSV, some PDF, some both.