How to put iPhone text messages into Google Sheets

Short answer

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.

TextExhibit on a Mac: a list of conversations on the left and one conversation with a landlord on the right, with the Export button below
A conversation open in TextExhibit. Shown with the app’s built-in sample conversations; the names and numbers are made up.

Steps

  1. In TextExhibit, open the conversation and export to CSV.
  2. Open Google Sheets, create a new spreadsheet, and choose File, Import, Upload. Drag the CSV in.
  3. Choose Insert new sheet(s) or Replace spreadsheet. Set Separator type to Comma.
  4. Untick Convert text to numbers, dates and formulas if the choice is shown, so date text is kept as exported.
  5. 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.