What is a CSV file of text messages?
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.
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.