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.