How can I access the database of an iPhone app I have purchased to copy it to an Excel spreadsheet? And how can I access its media files to copy them to my hard drive?
If the data does not show in iTunes File Sharing, you can use iExplorer to read your iTunes backup for the app’s container.
Here are the steps that have solved my problem.
Database: Use iExplorer to create a backup of your iPhone. In iExplorer go to
X/App - Y/Documents/where
Xis the name of the backup folder and
Yis the name of the app preceded by the name of the company that sells it. This folder contains an SQLite database file (with the extension
Media: Open iTunes on your iMac, make sure the app is downloaded (if not - download it), then browse in Finder to
~/Music/iTunes/iTunes Media/Mobile Applications/. Copy the file
Y.ipato your desktop, where
Yis the app's name. In the desktop change the file's extension to
.zip. Extract the zip file. Search for the app executable, right-click and select
Show Package Contents. All the media files are there.