How to build a timeline from your text messages

Short answer

Export the conversation to CSV, copy the rows that mark key moments into a new sheet, and add a column for your short notes, so the timeline points back to the exact message and time. Keep the timeline as a separate working document and hand over the full PDF export beside it, so the reader can check each entry against the original.

TextExhibit PDF page showing a reaction, an edited message with its edit time, an unsent message, and SMS messages marked as SMS
A reaction, an edited message, an unsent message and SMS texts, each marked. From an export of made-up sample messages.

Steps

  1. Export the whole conversation to CSV and PDF with TextExhibit.
  2. Open the CSV and save a copy named timeline-working.
  3. Delete the rows you do not need in the copy, or mark the key ones with a highlight.
  4. Add columns: your note, the page or Bates number from the PDF, and any related document.
  5. Sort by time. Check that each entry matches the PDF.

What to put in each row

  • Date and time with the time zone.
  • Who sent it.
  • The words, quoted exactly.
  • A one-line note of why it matters.
  • The page or Bates number in the PDF.

Keep it honest

A timeline is a summary, and summaries can mislead if they leave things out. Include context rows around key moments, and do not alter the quoted words. If you add other events such as calls, emails and payments, mark them clearly as coming from other sources. Ask your lawyer if they want a particular layout.

A column that saves you later

Add a "source" column for every row, with the page or Bates number from the PDF and the file name of the CSV. When your lawyer or a mediator asks where a line came from, you can find it in seconds. Also add a "checked" column with a tick when you have compared the row with the PDF. A timeline you have verified once is useful; one you only half trust is a liability.

What to keep in mind

  • A timeline is not itself evidence of what happened, only a guide to the record.
  • If you shorten messages, say so. Quote the full message where the exact words matter.

Questions

Should I include messages that hurt my case?

Ask your lawyer. Leaving things out can cause problems later.

Can I add emails and calls?

Yes, as separate entries with their source marked.

Will the timeline be filed?

That depends on the matter. Ask the lawyer or the clerk.

How long should a timeline be?

Short enough to read in a few minutes, with the full record behind it.

Can I include my own notes about what I felt?

Keep those in a separate column from facts.

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.