What order are exported text messages in, and can you reverse it?

Short answer

An exported conversation is in time order, with the oldest message first and the newest last, the same way you read the thread in Messages. If you need newest first, use the CSV and sort the time column in a spreadsheet, and keep the PDF in its original order.

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.

Why time order

  • It is how people read a conversation.
  • Replies and reactions make sense in that order.
  • Page numbers and Bates numbers run in the same sequence.

Re-sorting

  1. Export CSV with TextExhibit.
  2. Open in Excel, Numbers or Google Sheets.
  3. Select the time column, sort descending for newest first.
  4. Save under a new name. Do not overwrite the export.

Messages that look out of order

Messages can arrive late if a phone was offline, so a message sent at 9:00 may show up after one sent at 9:01. The export uses the stored time. If something looks wrong, check the time zone and the stored time before assuming an error. See time zones.

Checking the order yourself

Pick three messages you remember well, one near the start, one in the middle and one near the end, and find them in the PDF. If the order of those three is right, the whole thread is almost certainly right, because the sort is by stored time and not by anything you can accidentally change. If you re-sort the CSV, add a column first that holds the original row number, so you can always get back to the first order. That one small habit saves a lot of confusion.

What to keep in mind

  • Sorting a spreadsheet by a column that Excel has turned into text can give odd results. Check a few rows.
  • A reversed copy is a derived copy.

Questions

Can the PDF be newest first?

Treat the PDF as oldest first, the normal reading order.

Does sorting change the original?

Only if you save over it.

What if two messages have the same time?

They are shown in the order stored.

How do I get back to the original order after sorting?

Add a row-number column before you sort, then sort by that column to restore it.

Are group chat messages in the same order for everyone?

The export uses the time stored on the phone you exported from, so the order matches what that phone shows.

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.