If you want to backup iPhone text message on Windows, here is a free method to do that, first we access iPhone SMS database file then view or export iPhone text message from it SMS.db file using SQLite DB browser and then backup iPhone text messages as .csv file / Excel spreadsheet.
Backup iPhone Text messages or Export iPhone SMS
First you need to access iPhone files, to browse the iPhone files and folders you have to SSH into iPhone. If you didn’t SSH into your iPhone yet, Follow this guide: how to SSH into iPhone and then come back here on the next step-2.
When you successfully connected to your iPhone using WinSCP on Windows,navigate to the following folder in WinSCP :
/private/var/mobile/Library/SMS/ this folder is sms.db location which contains all your iPhone Text Messages in SQLite Database format.
Just copy and transfer this “sms.db” file on your computer desktop.
SMS.db on your computer desktop.
Download SQLite Database Browser and extract it.
Run “SQLite Database Browser” .EXE file from extracted folder to run SQLite DB Browser.
Click “Open Database” icon to open the saved “SMS.db” file.
Choose “SMS.db” file that we have saved in step-3.
To view your iPhone SMS, click on “Browse Data” tab and select “message” table from table drop down menu as shown below.
Here you can view all iPhone text messages with Address, Date, Text and some other information.
Export iPhone text messages, click on “File” menu, select “Export” and select “Table as CSV file” option.
Select “message” database table from “Table name” drop down menu and hit Export button.
Type file name with .csv extension and hit “Save” button.
After success this will prompt with Export completed message.
Here you have your all iPhone text message in CSV format, in other words iPhone SMS in Excel Spreadsheet. You can view iPhone text messages CSV file in Microsoft Excel, Google Docs, or in other free CSV viewer.