How to turn a chat into a spreadsheet

iPhone, Mac, and Windows 3 steps · Updated

Quick answer

  1. In TextPort, open the chat. Export it as Spreadsheet.
  2. Save the CSV file, or send it to yourself.
  3. Open the file in Excel, Numbers, or Google Sheets.

Each message is then one row, with its date, sender, and text.

What you need

  • ✓TextPort on your iPhone, Mac, or Windows PC, with the chat in it
  • ✓Excel, Numbers, or a Google account

Steps

iPhone

  1. Export the chat as Spreadsheet

    Follow Export a chat to CSV. Tap Files to save the file.

    The Export Chat sheet with Spreadsheet highlighted

Mac

  1. Export the chat as Spreadsheet

    Follow Export one chat on Mac. Click Spreadsheet (2). Pick a folder.

    The Export Conversation sheet with PDF, Spreadsheet, Text File, and Attachments

Windows

  1. Export the conversation as Spreadsheet (CSV)

    Follow Export a conversation on Windows. Check Spreadsheet (CSV). Pick a folder.

  1. Open the file

    On a computer, double-click it. On iPhone, tap it in Files, tap the share button, then tap Excel or Numbers.

    For Google Sheets, click File, then Import, then Upload. Pick the file.

  2. Read the rows

    Each row is one message. The columns differ a little between iPhone, Mac, and Windows.

Done

The chat is in a spreadsheet. You can sort it, filter it, and count it there.

Problems

Emoji or accents look wrong in Excel.

Open a blank sheet. Click Data, then From Text/CSV. Pick the file. Set File Origin to 65001: Unicode (UTF-8).

A date shows as ####.

The column is too narrow. Make it wider.

A cell starts with an apostrophe.

On iPhone, TextPort adds it to text that starts with =, +, -, or @. The spreadsheet app then keeps it as text. You can leave it.

You need more than one chat.

On iPhone, tap … in Saved Chats, then Select. Tap the chats, then tap the export button. On a computer, see many chats on Mac or all conversations on Windows.

You need only some dates.

See Export only a date range, or only some dates on Windows.

The chat is not in TextPort yet.

See Pick a way to import a chat.

None of these match.

Email [email protected]. Say which step you were on. Say what you saw. We usually reply within a day.

Questions

TextPort

Start exporting your messages

Available for iPhone, Mac, and Windows. No computer required.

Download for iPhone