Convert iPhone SMS Database to Excel File

  • Back up your iPhone using iTunes.
  • Open the directory ~/Library/Application Support/MobileSync/Backup/ for Mac or C:UsersYourUserNameAppDataRoamingApple ComputerMobileSyncBackup for Windows 7.
  • Find the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28. This is a SQLite database file.
  • Open the database file by using a SQLite Editor such as SQLite Expert.
  • Your SMS messages are inside the database named “message”.