I'd like to build a spreadsheet of all my games and was wondering if any of you know of a way to get my lists of games out of Steam & GOG and into Excel? Purchase data would also be awesome if there is a way of getting this out?

Well, for GOG there is gogrepo or adalia fundamentals, do a search and you should find these. They are scripts for adding functionality to the website or downloading backup copies etc.

What I would say is this - and I say this after decades of doing this - don't use Excel. It may look appealing, simple to enter data and do various things. However it is not a database, I found that my sheet with several thousand rows on had somehow got sorted without sorting all the columns for instance. All that information was lost.

There are a few free collector programs, Sizimi for instance, or you could just build one in SQLite or something. I ended up, again after many years, buying collectorz.com's game collector (I got the higher one for multiple changes). I am reasonably happy with it, and I use the exported CSV output in Excel to do structure checks and such like. I would really like to move to LaunchBox which is currently free, and if you are just starting, would probably recommend you go have a look there first. Its free, has a lot of functionality, but is geared more to running roms through emulators. For my purposes where I have 20k records and now way of simply importing the metadata across, this isn't an option at the moment, which is a shame. But you starting off, start in either of one of these, or build it yourself, Excel will fail you at some point.

Excel is a very good spreadsheet program but too many people try to use it as a database.

So, any cheap or free decent database programs out there?

Thanks for your advice. I was really looking for quick solution and as I work with Excel pretty much all day everyday I really just need to be able to copy the list of games I've got into it - from there I can do what I want with it. I thought I had found a quick way as you can copy your purchase history directly from Steam but that only accounted for half of my games - the other half have been purchased elsewhere. I will look into those programmes you have mentioned when i've got a bit more time though. Thanks again.

Steam Calculator should help with your Steam list.
I'm guessing it won't list DLC though.

You can see the games you've purchased elsewhere and activated on Steam as well. There's a link "View licenses and product key activations" under your account page. This one includes everything.

Link: https://store.steampowered.com/account/licenses/

Yes, everyone works with excel. Vba is great too. However once you start getting data in it becomes quite hard to manage. There is the sorting issue I mentioned, but then there is duplication, data cleaning etc. I have collectors and it is many thousands of rows, took months to get all the data, standardise, clean etc. And that is with internet retrieval on some of it. Work up front will save you manyfold down the line. Depends what you want it for. Sqlite is a stand alone exe.which can operate on a file like a db, used in embedded apps. Mysql is free, its a big db though. Sqlserver is another. Plenty of nosql dbs out there as well, xml databases.
So clarify use, your skill levels and willingness to put into etc. Would you need entry forms. Import/export. Data scraped from the internet - ie a benefit of launchbox or collectorz is that they can grab metadata from the net on games.

Thanks I can definitely work with this. Exactly what I was looking for. Cheers!

I've been using completionator.com. It's a free online database that can import both Steam and Gog game lists, as well as bulk data entry import, and has some very interesting features.

Additionally, you can export your database to Excel.


Seek out moho_00 for more details.

That's awesome thanks. I'll check that out...

Plenty. For lightweight use I recommend DB Browser for SQLite. It's actually what I use to browse through GOG API response data, which I'm storing in a SQLite database.

Hey folks! I stumbled across this thread and I'd like to share my little script, in case anyone needs it, and since it also fits the request in the title. I've also described the database itself in the wiki so you can browse it yourself, as another user mentioned.

Oddly, I can't post links so google this.

github myusername/gog-galaxy-export-script

That's GOG's forum and its countermeasure against spam accounts going active and dumping links everywhere. It works against the well intentioned just as much as it acts as a wall against the influx of garbage.

https://github.com/ab1908/gog-galaxy-export-script