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.
17,108 Comments - Last post 1 hour ago by RSDA
7 Comments - Last post 1 hour ago by Fluffster
6 Comments - Last post 2 hours ago by MikeWithAnI
1,555 Comments - Last post 4 hours ago by LinustheBold
224 Comments - Last post 5 hours ago by MeguminShiro
971 Comments - Last post 6 hours ago by InSpec
282 Comments - Last post 6 hours ago by Wok
12 Comments - Last post 2 minutes ago by quinnix
62 Comments - Last post 5 minutes ago by FateOfOne
25 Comments - Last post 13 minutes ago by derton2000
67 Comments - Last post 21 minutes ago by Almostn33t
93 Comments - Last post 25 minutes ago by Habaruku
30,443 Comments - Last post 37 minutes ago by War1ock
414 Comments - Last post 57 minutes ago by trentjaspar
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.