• Depressurizer
  (Get the latest zip here[github.com])
  
  
  
  
• WPS Office[www.wps.com]
  (If there's any crapware bundled, don't install it, but you'll probably be fine.)
  Other software might work, but this is what I use (has spreadsheet software included) and unfortunately I cannot get Google Sheets to work with this. Feel free to try Microsoft Excel if you have it. WPS is free.
  
  
• Windows (Sorry, this guide isn't compatible with Mac/Linux!)

Depressurizer is a program designed to organise your Steam library with category management. However, we won't be using it for that purpose in this tutorial. It allows us to export XML files and we'll be using that to create our text file. Extract the zip somewhere and open Depressurizer and wait for it to do its thing. This shouldn't take too long. You'll be presented with a window like the below.



In my case, Depressurizer is already populated with a list of categories created by tags. You can do this for organising your library if you find another guide for that. If you haven't used Depressurizer before your categories will either be quite blank or just your manually created categories will appear. In any case, back to the point, you want to use the Save Profile As. We can create our XML with this. I saved it in the program's directory as "temp.profile"—name it whatever.



It's WPS time. I'm using some features that may be present in other software.

I find WPS a bit of a pain. Several years ago in this guide's infancy I used Excel 2003 which was very simple. This isn't too bad. Let's open the main suite, in this case "WPS Office 2019". Use the "Open" option and locate the directory you just saved your profile to.



Well, s**t. It seems your file didn't save after all. Eh, just pulling your leg. Simple, just change your file type to "All Files". Choose "temp.profile", or whatever filename you chose. You'll be asked the open method. Simply choose "WPS Spreadsheets".



This certainly appears nonsensical. Indeed, this database is just in a format that's interpreted by Depressurizer. Nonsensical is putting it nicely! This is chaotic. If you're like many people who have contacted me about this, there are certain types of games you don't want in your list. This might be free games, or game DLC or sometimes not even games at all: software. Don't worry about duplicates. We'll get round to all of that later into the guide. While 'O' has all of your games, 'N' is our current focus. Let's see...



The vast majority of entries are "PackageNormal". These are standard commercial games. Obviously, "PackageFree" are free. It seems that "WebProfile" are extra content of some sort or DLC. I'm not covering software here. I can do other things some other time, but the odds are you'll have little software on Steam, so removing them from your text list manually is doable in a minute or two. I brought up all of this because many people want to remove freeware or DLC. Scroll to the top and click the second row of 'N'.



Scroll to the bottom of everything in 'N' and make sure you're not clicking anything else in the document. (Scroll bar should be okay.) Now be certain you're holding the shift key, then click that bottom row.



If all went well you've now selected all of them. Next you need to click a tab near the top of the window, "Data".


Look at "Sort". See that smaller icon? That allows us to sort our selections in an ascending order. Just click that.



You've probably learned enough already to remove some games in WPS. You might be wondering why there are so many duplicates in some of these screenshots. That's because multiple categories create extra database rows. So if you have a game that's both a visual novel and a puzzle, that might be two rows, and so on. Either way, dupes will be cleaned up.

You might want to take a look at some of these. "Unknown" might contain a few things. It seems to be used for non-Steam games. "SteamConfig" seems pretty useless to me. So, to get rid of these (and "PackageFree") like before you click the top/bottom item in each entry, then use shift to select the lot of them. To get rid of your selection, right-click, then choose Delete > Table Rows.

Now my list only has paid commercial games (except a rare few software entries) which is what I wanted. Looks like this section's almost done. Finally let's click the bottom game in the 'O' column.



Shift multi-select again, capturing all those games! With them all selected you can either do Ctrl+C or Home (tab) > Copy to... copy! I reckon it's time to whip out good ol' Notepad. Paste for great justice!



If you're as much of a Steam junkie as me, that'll be a gigantic list! Never fear... I'm here.

You've almost got your list now. That was pretty easy, huh? So is the rest of the guide. I don't think any more images are needed. First of all, let's take care of those duplicates. We'll be using a very helpful site called Text Mechanic. Follow this link[textmechanic.com].

All you need to do is paste the list that you copied into the box. Simply click the button that says "Remove Duplicate Lines" and the problem is solved. (You can select your whole list to copy it again with Ctrl+A.) There's a final step. For whatever reason the list won't be entirely alphabetized. Do the same thing as on Text Mechanic here[alphabetizer.flap.tv], just using the "Alphabetize" button. You might want to remember to click "Ignore Case".

That's it. Enjoy your plain and simple list. Be sure to rate this guide if you found it useful!

p.s. In case you want proof this actually works (or would rather just laugh at all the crappy games I own) here's my own game list[pastebin.com] at the time of writing.