How to export a chat to a CSV spreadsheet
Quick answer
In TextPort:
- Open the chat in Saved Chats.
- Tap Export at the bottom.
- Tap Spreadsheet. Spreadsheet Preview opens.
- Tap the share button in the top right.
- Tap Share to send it, or Files to save it.
- On Mac: How to export one chat to PDF, CSV, or TXT on Mac
- On Windows: How to export a conversation to PDF, CSV, or TXT on Windows
What you need
- ✓TextPort on your iPhone
- ✓A chat saved in TextPort
Steps
-
Tap the chat in Saved Chats
Open TextPort. The chat opens.
-
Tap Export
It is the blue button at the bottom. Export Chat opens.
-
Tap Spreadsheet
TextPort builds the file. Spreadsheet Preview opens.
TextPort may ask you to unlock this.
-
Tap the share button
It is the blue button in the top right. A card opens.
-
Tap Share or Files
Share (1) sends the file to an app. Files (2) saves it on your iPhone or in iCloud Drive.
Done
You have a CSV file. Each message is one row, with its type, date and time, name, phone or email, and text.
Problems
Export Failed
Tap Try Again. If it fails again, close the chat and open it once more.
A phone number or a message starts with an apostrophe.
TextPort adds it so the spreadsheet app keeps the number as text. You can leave it.
There is no Timestamp column.
The chat has its times hidden. In the chat, tap …, then Show Timestamps. Export again.
You need only some dates.
None of these match.
Email [email protected]. Say which step you were on. Say what you saw. We usually reply within a day.
Questions
-
Excel, Numbers, and Google Sheets all open it. So does any text editor.
-
No. The Attachment column shows the file name. To save the files, read How to see all photos, videos, and files in a chat.
Next guides
-
How to export a chat to PDF
You will get a PDF of one chat, with names, dates, and times, ready to share or print.
-
How to export a chat to a text file
You will have a plain text file of the chat, with one line for each message.
-
How to export only a date range
Your export will hold only the messages between the dates you pick.
-
How to save an export to Files or iCloud Drive
Your exported file will be saved in the Files app or in iCloud Drive.
Start exporting your messages
Available for iPhone, Mac, and Windows. No computer required.
