What is a CSV file of text messages?

Short answer

A CSV file is a plain text table, with one row per message and columns for things like date, sender and text, that opens in Excel, Numbers or Google Sheets. TextExhibit exports a CSV alongside the PDF, so you can sort, filter and count messages.

TextExhibit Export finished screen listing the PDF, CSV, HTML and manifest.txt files, each with its SHA-256 hash
An export finished: the PDF, CSV, HTML and the hash list, in one folder. Shown with the app’s built-in sample conversations; the names and numbers are made up.

What it means in plain words

CSV stands for comma-separated values. It is simple and readable by many programs.

It does not hold layout or pictures. Photos appear as file names.

How it applies to text messages

Open the CSV in a spreadsheet to filter by sender, search for a word, or count messages per day. See exporting texts to CSV or Excel.

Lawyers use it for review and timelines.

An example

A lawyer sorts a CSV by date and filters for the word paid, to find payments mentioned in six months of messages.

Opening a CSV safely

Open the CSV in Numbers, Excel or Google Sheets. If the date column turns into odd numbers, format it as date and time. Do not save over the original file. Save a copy as a spreadsheet, and do your sorting there.

Long messages, line breaks and emoji can make rows tall. Use text wrap or widen the column. If you plan to produce the CSV to another side, keep the original export and its hash in the manifest, and produce that original rather than a spreadsheet you changed.

Useful spreadsheet moves

Sort by sender to see each person's messages together. Filter for words like paid, sorry, lawyer. Add a column with a formula that counts messages per date and chart the busiest days. Freeze the top row so headings stay visible.

When you copy messages into a report, quote them exactly and cite the date and time. Never retype from memory.

What to keep in mind

  • Spreadsheets can change date formats. Keep the original CSV unchanged.
  • Long messages may wrap.
  • This is general information, not legal advice.

Questions

Is CSV a forensic format?

No.

Can I import it into review tools?

Many accept CSV.

Does it include attachments?

As names, with copies in a folder.

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.