Ridiculous, sure, fine. I'm still doing it.
A long time ago, I started making a spreadsheet of all the games I've played or owned, etc. I knew I had I big Steam library, but when you count all the Free games on Steam and the games on other platforms and all the consoles I own and the games for those and…well, it's a lot.
I have 23,186 games to catalog, and the number being so high is a big part of why I want to automate and complete it as best I can. Using the attached example, you can see a lot of holes/redundancies (start year and start date, for example; manually-entered and rounded-up prices for another; etc) and this is a pretty solid chunk compared to most of the games on the list.
I know there's a way to use Steam's API to export a list of my games, but it won't count any games that have been removed from the store (iirc) and it won't include stuff that's free or just doesn't have a very wide playership (I think basically anything that says "Steam is still learning about this game" on its store page), so doing it this way would only be a partial solution. Furthermore, I also obviously want to do this with my other platforms like Epic, GOG, EA, PSN, and so on. I also have hundreds of physical console games.
I'd additionally like to include prices (where available) from things like Pricecharting, "filter out" columns for games that aren't "beatable" or have no ending (the 2048 web game here, for example) so that when I'm seeing, let's say, how many games I've beaten in 2014, those don't get counted.
I have extremely limited experience with APIs and am trying to use this as an excuse to learn more.
Besides not-doing this (I'm gonna do it), what are some ways I could help automate this? Would Playnite be helpful?
Posted by Sexweed42069