Set it to check if Column B is equal to 1 -> “OK” Select cell B1 -> Go to Data (tab or menu bar) -> Standard Filter (in the “more filters” menu option but immediately visible if using tabbed interface in LibreOffice). It will place a 0 in the B column otherwise. This is because the game title/name is always followed by “Overall Reviews:” and that’s why the =if(…) statement looks for it on the next cell in the A column. With cell B1 still selected, drag the bottom right corner of the cell down all the way to the last row containing text.Įxplanation: This will place a “1” in the B column beside any entry in the A column that has a game title/name. Select cell B1 and type in =IF(A2="Overall Reviews:",1,0) and hit enter. ~~Now we need to clean the list to only leave the cells that contain a game’s title/name.~~ Right click -> paste special -> unformatted text in cell A1 -> “OK” the default import options. Zoom out on the webpage as far as possible and scroll up and down a bit if needed to have it all load (hopefully zooming out all the way lets you see the whole list like mine, otherwise you may have to copy paste in sections). ~~Getting the Steam wishlist into a cell-based system~~ However, I hope it's an interesting way to get introduced to basic coding that could help you elsewhere (I use it for all kinds of stuff to automate tasks). What is described below would probably take me 15 minutes or so to code, execute and finish importing my wishlist, but since I thought it might help someone else, I figured I would take extra time to write nice coding comments and type up the details of the guide. This may take an equal time to setup and execute (if you've never done something like this before) than it would if you just manually went between your Steam wishlist and GOG and manually added them all.
You can technically use different programs, but these are all free and open source, so you’d have to figure out how to change my AutoHotkey script included here if you want to use different programs. It requires the programs AutoHotkey (awesome simple open source script program that I use a bunch), Libreoffice Calc, and Mozilla Firefox. Here is roughly how I did it, so I’m sharing it here just in case it can help someone else do the same thing. Your Steam account may create 1000 game server accounts.Now that GOG has a good return policy, and is DRM free, the last big obstacle to getting all my future games on GOG has been trying to transfer my huge Steam Wishlist over to GOG.Your Steam account must own the game for which you are creating a game server account.Your Steam account must have a qualifying registered phone.Your Steam account must not be limited.Your Steam account must not be currently community banned or locked.
An expired token can be regenerated below. This is to prevent misuse by someone else who may have had access to your account.Ī game server login token that goes unused for a long period of time (the game server never logs in) will expire.
If you reset your Steam password via the Steam help web site, or if Steam Support resets your password, all your GSLTs will be regenerated. If you have distributed a game server login token to a third party, please delete the token below. If your game server accounts are banned for any reason, you may be restricted from playing the associated games.ĭo not distribute game server login tokens to third parties. You are solely responsible for these tokens. Here you can manage dedicated game server accounts associated with your Steam account.