A spreadsheet, several tabs, some highlights when they are "used" in a GA, and remove entirely a week after they are marked as received. Listed where I want to give them away.
Comment has been collapsed.
I also have a calculated field to tell me how many times I have GA'd each game on SG (to inform me when I'm hitting the 5 per game threshold), and I have a status for running GAs, but otherwise that pretty much covers my one tab (minus the Steam stuff - that's all in another set of tabs to keep track of my collection, wishlist, etc.).
Comment has been collapsed.
Name | Steam link | Key/Gift link | Price | Source
Link is colour coded for games under 65% ratings, price is colour-coded for bundle and non-bundle according to site rules.
Used keys are moved to a different tab immediately so the available list doesn't get cluttered.
Comment has been collapsed.
Also a spreadsheet user here. OpenOffice Calc in my case, I go pretty basic and just do Title-Source-Key-Status-Notes.
As an alternative, you may want to consider using a database like MS Access or MySQL. It would take a bit longer to get set up, but much better at things like search/sort/filter and more customizable. I currently have a WIP database solution for my games collection/wishlist and might add something in there for key management down the line, though I haven't had a huge need to organize my keys beyond what a spreadsheet can handle fairly readily.
Comment has been collapsed.
I don't have too many keys. At the moment they are saved in my E-Mail account within the original bundle page. Since I only generate keys for games I either activate on my account of for a giveaway I can see easily which ones are used and which are not used. But like I said I have only 5 bundles bought plus minus one.
Comment has been collapsed.
Personally, I gave up
ACE - Arena: Cyber Evolution - ACE Founder Pack DLC
H990K-V9LYK-LPFYD
Glow Ball - The billiard puzzle game
Z8HFG-XDJFD-087BN
Ionball 2: Ionstorm
DA3YZ-5P6MI-ZAZGE
Pahelika: Revelations HD
J9KAK-FN6KI-PJT9G
Siege Wars
6LDJ6-HLH9R-C8Y3Q
:D
Comment has been collapsed.
No problem. Happy to know at least one guy grabbing keys can say thanks.
Comment has been collapsed.
I originally just had game name and key in a text file, with no further information. So most of my list is missing which bundle and what date I got it. And sometimes I was not very descriptive, like "Arena Cyber Evolution DLC" ... which DLC is it? who knows :)
Comment has been collapsed.
Spreadsheet (Open office Calc)
Games for trade
Games I may want but may trade if I find something better (thus not on my "have" list in the trade forum)
Games I want but won't redeem until I've played more of my current library
Delete anything once redeemed by me or others.
Most of my gibs so far have been gifts so no category for it on my spreadsheet yet. All current keys due for giveaways are simply on the bundle website I got them from.
Comment has been collapsed.
I get rid of leftover keys before the list gets too long....
Comment has been collapsed.
Easy. For every new Steam key I acquire, I immediately try to redeem it on Steam. If it tells me I already own the game, I create a giveaway here, minimum duration, open to all. No need to complicate things. (I wasn't always this efficient, and it was a pain in the posterior.)
Comment has been collapsed.
I do something like this, but I don't try to redeem games, I check from the store page whether I own the game or not. This is to save time, and to prevent the key activation lock thingy. I always set duration to 1 day so that people from different timezones have a chance to enter.
Comment has been collapsed.
Since you covered most of it I use Color Backgrounds on Excel Cells to see at a glance for activated, keep, given.
Also for others reference there's an app which might be useful: http://steamcommunity.com/groups/gkeybank
Comment has been collapsed.
Just two columns, game name and key.
Three sheets - the main one is unused keys of course
second sheet is for keys for my currently running GAs, when all are marked as received they go to the
third sheet, which is keys I've given away. Don't know why I keep this one. Maybe just to stroke my ego at the number of rows in there?
Comment has been collapsed.
To keep tabs on what was sent, and if there is some trouble after the key was marked, it is possible to search for it. Or if the key was sent through Steam chat, it is possible to re-send it.
Plus, in general, if one works in an office, they learn that you never delete data, you just archive it.
Comment has been collapsed.
1,089 Comments - Last post 17 seconds ago by MeguminShiro
109 Comments - Last post 4 minutes ago by maximilyn
163 Comments - Last post 5 minutes ago by CalamityUP
211 Comments - Last post 39 minutes ago by Koalala
407 Comments - Last post 1 hour ago by Vodeni
200 Comments - Last post 1 hour ago by Vodeni
16,598 Comments - Last post 1 hour ago by WaxWorm
32 Comments - Last post 2 minutes ago by FateOfOne
29 Comments - Last post 5 minutes ago by AlexSaysSG
17,327 Comments - Last post 26 minutes ago by GeekDoesStuff
6,579 Comments - Last post 30 minutes ago by Oppenh4imer
103 Comments - Last post 31 minutes ago by erom96
20 Comments - Last post 32 minutes ago by Oppenh4imer
46 Comments - Last post 48 minutes ago by BrinkleyPT
I use an Excel spreadsheet with the several fields. Some are mandatory, some are less important but can help with sorting the list (i.e. when choosing which games to create giveaways for). Once a game is given (or in the past - traded), it's hidden from the list because I set the spreadsheet to only display rows where status of the key is available (blanks).
Mandatory fields:
Optional Steam-specific fields (if I don't have something better to do with my time)
Any other ideas or suggestions?
L4+ GAEndedComment has been collapsed.