How could I get or export a list of my free and purchased assets in an excel sheet

Questions & Answers
, ,
1

This is not a question for unity engine, it’s actually question for the Unity Asset Store website.
May be there is a way to fetch the data from Unity’s build it package manager!
Does anyone knows how I could get a detailed list of all my assets as an excel or json file format?

I need the following information:

  • Package Name
  • Creator
  • Price
  • Purchased Date
  • Last Update
2

I found a manual way to do using Microsoft Word and Excel. I took some time, but worked pretty well. Note I’m using Office 2016 so things might not be exactly as describe if you use a different version. Here are the basic steps:

  1. Open Asset Store: https://assetstore.unity.com
  2. Click the My Assets icon near the top right of the screen
  3. Switch “Sort” to "Name (asc) which will make it easier to keep track of things
  4. Switch “View” to “100” so you can see more on page
  5. Click and hold the left mouse button just left of the “1” in the “1-100” near the top left and drag until you get to the bottom last entry and stop just to the left of the “Open in Unity” button
  6. Press “Ctrl” + “C” to copy the first 100.
  7. Open New Document in Microsoft Word.
  8. In Word click the little down pointer at the bottom of the “Paste” button on the top left and choose “Merge Formatting.” If you don’t do that you’ll get a lot of extra formatting which really makes the process difficult
  9. Press “Ctrl” + “H” to open the “Find and Replace” popup window
  10. In the “Find what:” box paste this text: Organization*Open?in?Unity
  11. Click the “More” button on the bottom left and check the “Use wildcards” checkbox.
  12. Click “Replace All” and it will delete every thing from each entry except for:
    A. Company Name (with Hyperlink)
    B. Name of the Asset
    C. Size in either KB or MB
    D. Date of Purchase
  13. NOTE: You’ll still have the header text with the “1-100” “Release Note” etc. I left that to be deleted until after I had downloaded all of my assets. I just did a “Find” for “Release” and it found each of those lines which I deleted.

NEXT PAGE (This part will be repeated until you’ve done the final page.)
14. Go back to Asset Store
15. Click the “Next” button to go to the next page of 100 assets
16. For me each new page loaded with all 100 assets selected
17. Click “Ctrl” + “C” to copy the new 100
18. Go to Step 8 above and keep going until you’ve downloaded everything and run the find/replace command to delete all the excess.

GETTING A LIST WHICH CAN BE PASTED INTO SPREADSHEET:
19. You’ll see there is a single “Paragraph Mark” between of the four pieces of data for each asset and two “Paragraph Mark” so here is how I it more of a list with one asset per row:
20. Press “Ctrl” + “H” to open the “Find and Replace” popup
21. Click “More” and deselect the “Use wildcards” checkbox
22. In the “Find what:” box delete the early text.
23. With the cursor in the “Find what:” box click on the “Special” dropdown and choose “Paragraph Mark” and then do that one more time so you have TWO paragraph marks in the “Find what” box
24. In the “Replace with:” box I type &&&&&
25. Click “Replace All” button and the double paragraph marks will have been deleted and there will be the &&&&&. Don’t worry it will look strange, but fixed in just a couple more steps.
26. In “Find what:” box delete one of the paragraph marks which is represented by two characters.
27. In the “Replace with:” box delete the &&&&&
28. With cursor in the “Replace with:” box click on “Special” button and choose “Tab Character”
29. Click “Replace All” to remove all the single line-breaks and replace them with tabs.
30. Click “Ctrl” + “H” to open “Find and Replace” popup
31. Delete paragraph mark in “Find what:” box
32. In “Find what:” box type &&&&&
33. In “Replace with:” box delete what is there.
34. With cursor in “Replace with:” box click the “Special” button and Choose “Paragraph Mark”

You’ll now have a list of your assets put into a spreadsheet. Don’t forget to delete the header text as mentioned above in step #13. For me I just did this:

  1. Open Excel
  2. In the Word document I press “Ctrl” + “A” to select the entire list.
  3. In Excel I press “Ctrl” +“V” and you should get four neat columns of assets.

Hope this helps at least one other person. Happy Game Dev…ing.