How to put iPhone text messages into Google Sheets
Export the conversation to a CSV file on a Mac, then in Google Sheets choose File, Import, Upload and pick the file. Choose to replace the spreadsheet or insert a new sheet, keep the separator as comma, and untick the option that converts text to numbers and dates if you want times left exactly as exported.
Steps
- In TextExhibit, open the conversation and export to CSV.
- Open Google Sheets, create a new spreadsheet, and choose File, Import, Upload. Drag the CSV in.
- Choose Insert new sheet(s) or Replace spreadsheet. Set Separator type to Comma.
- Untick Convert text to numbers, dates and formulas if the choice is shown, so date text is kept as exported.
- Click Import data. Freeze the first row via View, Freeze.
Useful things to do next
- Filter by sender to see one person's messages: Data, Create a filter.
- Search for a word with Edit, Find and replace.
- Count messages per day with a pivot table on the date column.
- Add a column of your own for notes or exhibit numbers.
Privacy note
Uploading a CSV of private texts puts them on Google's servers. TextExhibit itself keeps everything on your Mac and uploads nothing, but once you upload the file to a cloud service, the rules of that service apply. If the content is sensitive, use Excel or Numbers on your Mac instead; see exporting to Numbers.
A few useful formulas
To split the date from the time in a column, use =INT(A2) for the date and =A2-INT(A2) for the time if Sheets reads the column as a date. To count messages per day, use a pivot table or =COUNTIF(D:D,D2). To find rows that contain a word, use a filter with Condition: Text contains. If Sheets did not read your dates as dates, use Format, Number, Date time.
What to keep in mind
- A shared Sheet can be edited by others. Keep a read-only original and the manifest of hashes.
- Very long messages may be cut off in the cell display, but the content is in the cell.
Questions
Do emoji show correctly?
The CSV is UTF-8, and Sheets reads it correctly. A font may show some emoji as boxes.
Does the CSV list photos?
It lists attachment file names, not the pictures.
Can I import several conversations?
Yes, import each into its own sheet tab and add a column naming the conversation.
Why does Sheets show hashes (###)?
The column is too narrow. Widen it.
Can several people edit the sheet?
Yes, so keep a protected copy of the original.
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.