How to open iPhone text messages in Numbers on a Mac

Short answer

Export the conversation to CSV on your Mac, then control-click the file and choose Open With, Numbers, or drag it onto the Numbers icon. Numbers shows one row per message, so you can sort by time, filter by sender and add your own columns, and you can save the work as a new .numbers file.

Transcript page of a TextExhibit PDF: each message with the time to the second and time zone, the sender’s name and phone number, page number and Bates number
A transcript page: time to the second, sender, number, page and Bates number. From an export of made-up sample messages.

Steps

  1. Export the conversation to CSV with TextExhibit.
  2. Open Numbers, choose File, Open and pick the CSV, or use Open With on the file in Finder.
  3. Numbers asks about delimiters in some versions; choose comma and UTF-8.
  4. Save immediately with File, Save and a new name so the original stays unchanged.

Handy things to try

  • Sort: click a column header, then the arrow, and choose Sort Ascending by the time column.
  • Filter: click Sort & Filter in the toolbar, then Filter, and add a rule for the sender.
  • Highlight: select cells and use Format, Cell, Fill to mark messages of interest.
  • Add a note column for your own comments, kept apart from the exported columns.

Keep the evidence clean

Keep the original CSV, PDF and manifest untouched and do your analysis in a copy. If anyone later asks where a number came from, you can point to the original files and their SHA-256 hashes. For a printable view, use the PDF; a spreadsheet is for analysis, not for reading a conversation start to finish.

Common snags

If dates show as numbers like 45000, the cell format is a plain number: change it to Date & Time. If the first row is not treated as a header, select it and use Table, Header Rows. If characters look odd, re-open the file and choose UTF-8 when asked. Save a copy early, because Numbers can write over the original CSV if you choose to save in the same place.

What to keep in mind

  • Numbers may display long time stamps in its own format. The time zone column in the CSV tells you the zone.
  • Numbers does not show photos from the conversation, only file names.

Questions

Can I export straight to a .numbers file?

No. Export CSV and open it in Numbers.

Does it work on iPad Numbers?

You can open the CSV there too, by moving the file to the iPad.

Will emoji display?

Yes, in most fonts.

Does Numbers handle thousands of rows?

Yes, comfortably.

Can I export from Numbers back to CSV?

Yes, File, Export To, CSV, for your copy.

Export the whole conversation

TextExhibit turns a conversation into one PDF with exact times, names and numbers, photos in place and page numbers, on your Mac. Free to preview; $24.99 once to export.