I need to generate a text export of the list under the MyApps-> Library Tab of the Play Store App for Android. I need a list of every App that I have ever installed from the Play Store, and not just a list of the subset of those which are currently installed. Thanks, Jim
Use Google Takeout to export out of Google services a list of all activity involving the Google Play Store for a Google account.
No root or even device is required as you are exporting out of Google's collected cloud data, you just need account credentials.
For reference I just did it for my account and was able to obtain a zip file containing the following JSON files:
Devices.json Installs.json Library.json Order History.json Play Settings.json Purchase History.json Redemption History.json Reviews.json
If you check
Installs.json you should be able to extract out the name of the app from "title" as well as when it was first installed/last updated.
A few caveats that I see:
- Apps on pre-Google Play devices appear to show up with package app name (i.e. com.publisher.awesomeapp). The earliest in my history is 2011. So there appears to be Android Market installs are held in this dataset.
Devices.jsononly seems to hold recently accessed devices. I'm pretty sure I had older devices with Google Play but they aren't listed. Its possible those old devices (Gingerbread/KitKat) have 'aged' out due to lack of access so that might explain why the older app installs like from 2011 show
"deviceDisplayName": "Unknown Device"
titlecould either be plain app name or package name.
As the files are in text in JSON format, it shouldn't be too difficult extract out what you need.
From @JimCramer's comments, one can use https://json-csv.com/ to get a
csv file from a
- Download Google Takeout
Library.jsonfile to that service
- Review "Choose Output Options", if required
- Click "Convert JSON to CSV"
- For the
Library.jsonfile there will be three columns:
'DocumentType', 'Title', 'Acquisition Time'
- Download CSV result file
- Import into spreadsheet, sort by 'DocumentType' to get
Android Appsand enjoy
From what I recall, Excel itself can import
If you don't want a third-party site to have access to your data. A search in your favorite search engine naming your spreadsheet tool with the topic of 'JSON conversion' will show either how to do it or what plugins/scripts are required for the effect.
You would need root access for this to work. (It was earlier possible with just
adb backup but Play Store now permits only key-value backup)
The file library.db under /data/data/com.android.vending/databases/ has a table named ownership (column named doc_id contains the package names) which lists all the packages ever installed through the Google account currently registered with Play Store. If you have multiple accounts logged in, you would get data for all of them. If you had used the accounts on multiple devices, you would get data from all of them too.
You have multiple choices now. You can search for an app from Play Store which can load that database and permits exporting the table. You can, alternatively, pull that database (move it first into /sdcard/) into your PC and use a software that can load an SQlite database. I have used DB Browser for SQLite in past and I know that it can export a table (not column) into a CSV file, which then can be opened by an office suite, such as MS Office.
If you have sqlite3 installed in your PC, you can do:
sqlite3 library.db .output packages_table .dump ownership
This would create a text file named
packages_table. Rename its extension to
.CSV and open it in an office suite. Look for the packages under the column