What This Tool Actually Does
Keycaps Tracker Ultimate is a specialized spreadsheet and logging system built for mechanical keyboard enthusiasts who collect keycaps. It tracks inventory, purchase history, pricing trends, batch numbers, and which profiles or sets you already own. The core value is that it stops you from accidentally buying duplicate sets or forgetting what you already have sitting in a drawer somewhere. The standard version is a Google Sheets template you can copy to your Drive. The process takes roughly 10 to 15 minutes if you already have your collection logged somewhere, even if that somewhere is just a chaotic photo gallery and a half-finished note on your phone. Open the template. You will see several tabs. The Inventory tab is where your main data lives. The Purchases tab logs when and where you bought something. The Market Trends tab tracks price changes over time, which matters more than people expect when buying limited runs.
Here is how I actually set it up in practice. I started by dumping every keycap set I owned into a single row per set, not per individual key. That meant entries like "GMK Ninja Artisan" with columns for profile, material, switch compatibility notes, and purchase price. I spent about 40 minutes doing this for my existing collection of roughly 60 sets. A lot of the fieldwork was just digging through old Discord messages and invoice emails from 2021 and 2022. Do not skip the invoice lookup step. The price you paid five years ago is essential data when you are trying to spot whether a current resale listing is actually a good deal or just hyped up nonsense. The template includes a few drop-down fields for common profiles like Cherry, MX, XDA, DSA, and Sakura. If you work with obscure profiles like KAT or MT3, just type them in. The tracker does not validate those cells against a master list, so you have to be disciplined about spelling. I learned this the hard way when I had three entries for what I thought was the same GMK set because I spelled "SA Profile" one time as "S.A. Profile" and the sort function treated them as completely different rows. Filter by the name column, delete the duplicate, and move on. The Market Trends tab uses simple conditional formatting. When a tracked item's current market price drops below 80 percent of your purchase price, the cell turns green. When it exceeds 150 percent, it turns red. This is useful for knowing when to hold and when to sell, though it is not financial advice by any stretch.
How It Works Under the Hood
The tracker relies on basic Google Sheets functions. VLOOKUP pulls pricing data from the Market Trends tab based on the set name. SUMIF tallies your total spending by year. COUNTIF flags duplicates based on set name and profile combinations. Nothing fancy. The design choice to keep it formula-light is intentional. Complex array formulas in a shared spreadsheet break when someone else edits a row out of order. This is why the template avoids them. I ran into a specific issue about six months ago that took me longer to fix than I care to admit. I imported a CSV export from a marketplace app directly into the Inventory tab using a pipe character as the delimiter instead of a comma. The entire row shifted. Every data point after the first field moved one column to the right, corrupting the VLOOKUP references. The tracker showed prices for half my collection as #REF errors and the other half as text strings that the SUMIF function silently ignored. The fix was to create a clean copy of the sheet first, paste the raw CSV into a blank tab, use the TEXT-TO-COLUMNS feature with comma delimiter, verify the alignment visually against my purchase records, and only then copy-paste values into the Inventory tab. This whole ordeal added about 25 minutes to what should have been a five-minute import. Going forward I always do the text-to-columns step on a scratch sheet before touching the actual tracking tab.
Get the Full Details
What People Miss About Using This
Most beginners treat the tracker as a passive log. They add items and forget about it. The tracking only becomes useful if you check it before every purchase decision. There is a difference between logging what you have and actively using the data to make decisions. I started running a simple filter every time I saw a new group buy announced: filter by material and profile match. If the result came back empty, the set was worth considering. If it came back with three results, I skipped it unless the artisan pieces were unique enough to justify the overlap. Another thing that is not obvious from the template: the batch number column. Keycaps from the sameGMK run can vary slightly in color between production batches. Tracking the batch helps you understand why two seemingly identical sets in your collection look different under warm light. I found this out when I compared a 2019 GMK Absolut Light run to a 2022 reissue and spent three weeks convinced I had bought a fake before realizing the colorway shift was documented in the batch notes. The tracker saved me from an unnecessary forum post asking if my set was counterfeit. The biggest limitation of this approach is that it requires honest and consistent input. If you only log what you want to remember and skip the items you regret buying, the spending summaries become meaningless. I once had a period of about four months where I stopped logging purchases because I was frustrated with the template. When I came back and ran the annual spend summary, the numbers looked impossibly low. Adding the missing entries back in increased my total that year by nearly 40 percent. The tracker does not lie, but it will reflect whatever level of effort you put into maintaining it.
For people managing collections larger than 100 sets, the spreadsheet approach starts to show strain. Row count overhead becomes real when you add filters, conditional formatting, and lookups across hundreds of entries. At that scale I would recommend moving to a dedicated database solution or at minimum splitting the spreadsheet into separate files by material type. The template was designed for the typical collector who owns somewhere between 20 and 80 sets, which covers the majority of the community. If you want the file, search for "Keycaps Tracker Ultimate Google Sheets" and you will find the main template link in the top post of the relevant thread. The creator updates it periodically when the Google Sheets API changes affect the formula compatibility. The last update I checked addressed a regression in the TO_TEXT function that was causing date-formatted cells to display as serial numbers instead of readable dates. That was about three weeks ago, so the current version should work without issues for most users.
