How to build a timeline from text messages

Short answer

Export the thread to CSV, sort by date and time, and add columns for event, source page and notes. The export gives each message a date and time to the second and the time zone, which is what a careful timeline needs.

TextExhibit PDF page listing each attachment with its size and SHA-256 hash, then the start of the transcript with delivered and read times
Attachments listed with their SHA-256 hashes, then the transcript. From an export of made-up sample messages.

Steps

  1. Export the CSV and PDF.
  2. Open the CSV, sort by timestamp.
  3. Add a column for the event or fact and one for the PDF page.
  4. Mix in other sources: calendar, emails, receipts.
  5. Mark gaps and be careful with time zones.
  6. Share only the timeline, not the original, unless asked.

Time zone care

If someone traveled, the same clock time can mean different moments. Keep the time zone column. See time zone and UTC.

What to avoid

  • Mixing summary and quotes.
  • Dropping context.
  • Assuming time zone.

A small example

Say a lease dispute turns on whether the tenant reported a leak before March 10. The paralegal exports the thread, sorts the CSV by timestamp, and finds a message on March 6 at 7:14 pm saying there is water under the sink, with a reply from the landlord the next morning. Those two rows go into the timeline with the page numbers of the PDF, next to the plumber's invoice dated March 12.

Keep columns for date, time, time zone, sender, a short neutral description, the PDF page and the source. A neutral description describes, it does not argue. If two sources disagree on a time, show both rather than choosing.

Presenting the timeline

Keep the timeline short and let the exhibit speak. A one-page chart with date, time and a few words, plus the PDF page number, is easier to follow than a long narrative. Keep the source files so anyone can check a line.

Use a neutral style, and do not mix facts with arguments in the same column.

What to keep in mind

  • A timeline is work product, not the exhibit itself.
  • Message times reflect the device clock.
  • Not legal advice.

Questions

Can I use CSV in Excel?

Yes.

Do I show page numbers?

Yes, for each row.

Can the timeline go to court?

Ask the attorney.

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.