Can't tell which switches you've already lubed?
“keyboard spreadsheets... anyone else?” — real buyer, https://geekhack.org/index.php?topic=122430.0
Spreadsheets are the community's default for tracking switches and keycaps, and they hit a wall fast. You buy two hundred of a switch, lube them in batches, and weeks later cannot tell lubed from unlubed by feel. You own a dozen keycap sets and cannot remember which one is mounted on which board versus which is boxed in storage. A grid can hold all of that, but it is painful to update and useless on your phone when you are actually at the desk with parts in front of you.
What you really need are a few switch-specific fields a generic spreadsheet never gives you: quantity owned versus quantity lubed, the lube you used and the method, whether films are applied, and the actuation force, so you can filter to exactly the switches you want for a build. For keycaps you want the set name, colourway, profile, layout kit, and a 'currently on' field that says which board each set lives on. The moment those are filterable, the bags on your desk stop being a mystery.
Keyboards Studio replaces the spreadsheet with purpose-built logs. The Switch Log tracks quantity-owned versus quantity-lubed, lube and method, films, and specs, with a quick filter for what is still unlubed, and the Keycap Inventory records colourway, profile, layout, and which build each set is mounted on. A built-in Switch Library lets you mark presets as owned. It is a one-time purchase, offline single-file app with no account and no subscription, your data stays local, and you can export to CSV anytime.
Keyboards Studio — one file, offline, yours forever.
No account, no subscription. One purchase, personalized with your name, works without internet.
Common questions
- How do I track which switches are lubed?The Switch Log stores quantity owned and quantity lubed per switch, plus the lube and method used, with a quick filter to show what is still unlubed so you know exactly what is left in the bag.
- Can I record which keycap set is on which board?Yes. Each Keycap Inventory entry has a status and a 'currently on' field, so you can see at a glance which sets are mounted, which are in storage, and on which build.
- Why is this better than a Google Sheet?It gives you switch- and keycap-specific fields and one-tap filters in a mobile-friendly interface, instead of a generic grid that breaks on your phone. It is offline, a one-time purchase, and your data stays local with CSV export.