Let's see if I can tell you the steps without mistakes:
Go to Steamdb.info
At the top, choose Calculator.
Enter your profile URL or SteamID, then click "get disappointed".
At the bottom left there's a menu. Click "Games" just below "Information". NOT the one under Steam Links. Above.
Now you're seeing a paged list of all your games, 100 games per page by default.
Just under "Owned games" you can choose how many games per page. Choose "All (slow)" and wait for the page to be generated.
Now, if you only want to have the names, keep the control+shift keys pressed, click in the first name cell space (not in the name itself, it's a link), and then move the mouse down to the next cell. In Firefox that selects all cells in a column. You can release the keys and now Control+C to copy, and paste in your fav text editor, in Excel, wherever.
If you want to have more intormation, right click anywhere clear, and choose "see source code". Copy all and paste in a good text editor (I use Notepad++ but there are plenty of good free multipurpose full-featured text editors). Now it's a matter of getting rid of what's on the header and the bottom and keep the code of the list. With some smart substitutions and including tabs, you'll end with a tab separated list of appIDs, names, prices, time spent, rating... Import/paste into a spreadsheet and play with it.
This is what a single row looks in HTML so you know what you'll face, it will not be hard to get it sorted out:
<tr class="app" data-appid="2092750" data-capsule="capsule_231x87.jpg?t=1729930228">
<td></td>
<td class="applogo">
<a href="/app/2092750/" tabindex="-1" aria-hidden="true">
<img src="/static/img/applogo.svg" alt="">
</a>
</td>
<td class="text-left">
<a href="/app/2092750/">Tina & Rook! Cookie Quest!</a>
</td>
<td class="muted i" data-sort="-1">-</td>
<td class="i muted" data-sort="0">Free</td>
<td data-sort="6">6m</td>
<td>86.69%</td>
</tr>
Comment has been collapsed.
also https://store.steampowered.com/account/licenses/ have full list
Comment has been collapsed.
nope, that is Licenses and product key activations
you wont find store purchases there
Comment has been collapsed.
oh yeah, disregard that
but there is another problem with this list, you can't see inside packages
Counter-Strike Complete - Aug 2012 - multiple apps https://steamdb.info/sub/16223/apps/
Steam Publisher Weekend Bundle 2021 - cryptic name; is some smite thing
2K Humble Bundle 2016 $1+ Tier - contains 7 apps https://steamdb.info/sub/90302/apps/
Classic Game Bundle - 6 apps https://steamdb.info/sub/194353/apps/
Comment has been collapsed.
Just trying to copy mine into an Excel spreadsheet. Takes a while :D
Comment has been collapsed.
What you should try...
Playnite with the HTML Exporter add-on is doing an extraordinary good job at that !
Even with default settings, what you get is a full-featured grid-view with images linking to the full descriptions of the games. Everything is sortable and there's even a built-in search engine. (You can have it as text list also with another built-in template)
Comment has been collapsed.
A few years ago there was a site that could mention all the games you owned on steam and easily transport it to an excel sheet, but i forgot the name but i don't even think it exists anymore.
I guess licenses is a way, but you get demo's and junk you might not want, and i really would suggest Excel, because you can do so much more.
I make an extra box and fill in games/programs/dlc etc (even give dlc a seperate color) so you can even sort on that, and i make a box filled in with the word steam, so i can even copy and paste all the stores (gog/epic/etc) in another tab and sort and see in which stores i have this or that game.
And a tick off box for whenever i finished a game.
Do note on occasion sometimes a dev decides to alter their name (especially in my case with so many games) and that makes your list kinda incomplete, i sometimes have to check everything again, but for some rainy day.
Comment has been collapsed.
Nothing is messy when you've done it from scratch, added more stuff over time, and know where is everything and what it means. The only reason columns are so narrow is so I can see all of them at once, and I have them at a small typeface size too. But usually I don't need to see the data not shown. I once tried to change the order of the columns to a more "logical" one, but it didn't work well. It works well the way it is. Tho I'm not sure if I should keep maintaining certain columns or delete them, given that I use the list in a different way now than when I started.
Spanish is also a valuable skill in this situation.
Comment has been collapsed.
Well yes when i imported my list i got also a lot of junk columns which i deleted, but your picture has a lot of double information, like 2 columns with steam, dates 3 times everywhere.
And would you really be interested in things like versions etc how about all the constant updates, how do you keep up?
Or why it would matter where it was bought, or how much it was. I mean to each their own, but i would draw lines myself and how mine is, is clean enough and the most essential of what i would personally want to keep.
To be honest i didn't know if that was a "joke" screenshot (due so much info) or a genuine list.
And genre that is what i tried, but sometimes a game defines itself in 5 genres, or when a HOG game even was called adventure games, it's where i gave up and dropped that.
Comment has been collapsed.
There are only 2 relevant dates; when I acquired it and when I last updated it. There's no duplicate information. Don't confuse Steam with zSteam, they have two different meanings and uses.
I could go without the version, yes. It was when I had a small library and kept the games updated. But everytime I think of it, I feel al the investiment I put in that column and can't help myself to keep it. One day I'll feel like "whatever" apathic and finally delete a few columns. I suffer from "information creep", much like development processes suffer from "feature creep".
To me it is very important to know how much I spend in games. Thus all that info goes to another sheet where a dynamic table and some extra formulas tell me how much I've actually spent each month, each year... I could forget about everything but the last 2 years, but the previous info there tells me other things I'm not going to discuss.
Genres are a personal thing. I've made my own. "Adventure games" has lost any meaning long ago.
I created that list in 2017 with only 2 sheets and about 5% of the info it has now. It grew, and grew, and well it's like Tetsuo in Akira, soon it will devour me.
Comment has been collapsed.
I have a list of all games which will be released in the next 13 years. It appeared in my computer out of the blue.
I also have in my to-do list "find a time machine and rob it". Which I guess will take about 13 years to be removed from the to-do list.
I didn't get any list of winning lottery numbers. I guess the future me is an idiot... Or a rich guy so I don't have to worry about lottery now.
Comment has been collapsed.
there was a site that could mention all the games you owned on steam and easily transport it to an excel sheet
Could be this one?
Comment has been collapsed.
Could be, it's been 10000 games ago, and probably 10 years or more since i used that site and since then every game i got, i just added them manually. I could swear i even made a thread about it to tell other people, but i can't find it in my history.
I am guessing it does a steady job (atleast if you just want a list of your games) and atleast this has a lot more options then when i made it.
I also definitely see potential to filter out retro games or point and click f.e if you are in the mood for one, will definitely bookmark this site, thanks.
Only downside is when you got large lists of games (why i never use big picture mode either, and like text view in clients (not all do) but that are minor problems.
Comment has been collapsed.
I also definitely see potential to filter out retro games or point and click f.e if you are in the mood for one, will definitely bookmark this site, thanks.
No problem. Yes, that site is great to filter games by ratings, genre, etc. simply to choose one to play if you own a huge library.
Comment has been collapsed.
The best way to get all your apps is to use the dynamic Steam API
https://store.steampowered.com/dynamicstore/userdata/
This will give you a list of appID's (games, software, music, movies etc)
For packages (subsID's) you have rgOwnedPackages
The rest is up to you to map appID to a name and more info
Comment has been collapsed.
Also you can use this if you love chinese manual labor https://steamcommunity.com/sharedfiles/filedetails/?id=444067719
Comment has been collapsed.
You can use chatgpt help for coding.
But you can use steam api, for example, http://api.steampowered.com/IPlayerService/GetOwnedGames/v0001/?key={Your-Key}&steamid=76561198047330685&include_appinfo=1
Example is for my account, this would give all your games in json, you can read it up more in https://steamcommunity.com/dev
and then use python code to just get the game data you need in .csv or .txt aka output to a file..
Edit: If I had free time I would help you with it but I'm quite busy now..
Comment has been collapsed.
http://www.lorenzostanco.com/lab/steam/
Load your library there and then export to CSV:
Comment has been collapsed.
900 Comments - Last post 23 seconds ago by ElBolovo
331 Comments - Last post 3 hours ago by RobbyRatpoison
325 Comments - Last post 3 hours ago by eeev
36 Comments - Last post 3 hours ago by sensualshakti
500 Comments - Last post 3 hours ago by sensualshakti
155 Comments - Last post 4 hours ago by akylen
35 Comments - Last post 4 hours ago by Foxhack
50 Comments - Last post 3 minutes ago by PastelLicuado
9 Comments - Last post 12 minutes ago by PastelLicuado
6 Comments - Last post 14 minutes ago by Kappaking
72 Comments - Last post 19 minutes ago by pizurk
8,266 Comments - Last post 56 minutes ago by eeev
8 Comments - Last post 1 hour ago by ddapro
20 Comments - Last post 1 hour ago by Yindy
Hi, is there any way I can easly export my steam gamelist to an excel or as a text list?
Thank you!
Comment has been collapsed.