5

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

8
+100

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:

  1. 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.
  2. Devices.json only 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"
  3. title could 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 json file.

  1. Download Google Takeout zip file.
  2. Unpack zip file
  3. Upload Library.json file to that service
  4. Review "Choose Output Options", if required
  5. Click "Convert JSON to CSV"
  6. For the Library.json file there will be three columns:

    'DocumentType', 'Title', 'Acquisition Time'

  7. Download CSV result file
  8. Import into spreadsheet, sort by 'DocumentType' to get Android Apps and enjoy

From what I recall, Excel itself can import json files.

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.

| improve this answer | |
  • 1
    +1 This is good. It doesn't require root access though gives same useful amount of data I could get from library.db, but in a more human friendly manner. – Firelord Dec 5 '18 at 7:35
  • 1
    @Firelord I do wish that for the more recent apps it did give the package name as well and not just the app name. I did submit to Google Takeout feedback for such a improvement. – Morrison Chang Dec 5 '18 at 7:41
  • @Morrison Chang - I wanted to let you know that your Anser/Procedure worked, and to thank you very much for replying to my question because it saved me a lot of time and gave me exactly what I wanted. I am grateful. The ZIP Takeout File from the Google Play Service downloaded to my device. . I unpacked it and found the file Library.json. I then uploaded that file to the free Json to CVS file conversion utility on the web page json-csv.com which eaily converted my file to .csv and .xlsx format, and downloded that back to my local storge. – Jim Cramer Dec 10 '18 at 20:08
2

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 doc_id.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.