Home inventory: spreadsheet vs. app

A spreadsheet is free, and that is close to the only real advantage it has. Most inventories that start in one do not fail because a grid cannot hold the data. They fail because a spreadsheet is built for typing at a desk, and almost everything an inventory needs to do happens somewhere else — standing in a shop, unpacking a delivery in the hallway, glancing at a shelf on your way past it. The tool decides whether the habit survives contact with real life more than the intention behind starting it does.

What a spreadsheet is genuinely good at

It is honest about being a grid, and it is excellent at things that are actually tabular and mostly static — names, quantities, categories, sometimes a serial number for a claim. If the goal is a one-time snapshot, built carefully over a weekend and rarely opened again, a spreadsheet does the job and nothing about it will surprise you later. The trouble starts once the goal shifts from "a record" to "a habit," because a habit has to survive being touched dozens of times a month, usually from a phone, often one-handed, often in a hurry.

Where it actually breaks

In roughly this order. First, entry: typing a row on a phone in a shop aisle is slow enough that most people mean to "add it later" instead, and later rarely comes. Second, retrieval: a spreadsheet has no fast way to answer "do I already own a wok?" — you either remember which tab and which row, or you scroll a document that was never built to be searched under pressure at a checkout. Third, and quietest: nothing keeps it current. There is no signal telling you an item has sat untouched for eight months, because a spreadsheet does not know when you last used the object — only when you last edited the row, and those stop being the same thing almost immediately.

Why that third failure matters more than it looks

A list of what you own answers one question: do I have it. A list that also knows when you last used each thing answers a second, more useful one: what do I actually own that I am not using. That second question is most of what makes an inventory worth keeping at all, and it depends on a last-used date that updates itself with almost no effort — or it will not get updated. A cell you have to manually date every time you touch an item goes stale within a month, for the same reason exercise logs and expense trackers go stale: not one bad decision, just the ordinary friction of one more manual step, repeated often enough.

What a purpose-built app actually changes

Not the idea — the friction around it. Saying "wok, kitchen, two" out loud is faster than opening a spreadsheet, finding the right sheet, and typing into three cells, and photographing a shelf and letting recognition draft the entries is faster again once there is more than a couple of items. Kept does both — voice capture turns a spoken sentence into a structured list, and a batch photo can draft up to ten items at once — with nothing entering the inventory until you confirm it on a review screen. None of that is about novelty. It is that the fastest path to "logged" is usually the only path that gets used consistently.

The search side matters just as much as the entry side. Kept's check-before-you-shop screen is built for the exact moment a spreadsheet cannot reach — standing in a shop, typing what you are about to buy, and getting back whether you already own one, how many, and how many of those have gone untouched for months. A spreadsheet can, in principle, answer the first part of that if you happen to have it open at the time. It cannot answer the third part at all, because nothing in it recorded when the thing was last touched.

When a spreadsheet is still the right tool

For a single-purpose, mostly-static record it is genuinely fine, arguably better — an insurance schedule of high-value items, a list built for settling an estate, a moving inventory you will use once and then archive. In those cases you want something portable and exportable, outside of any one app, and a spreadsheet is exactly that. The real distinction is not spreadsheet-bad, app-good. It is that a record you build once and rarely revisit can live almost anywhere, while a record you are meant to check before every purchase and glance at every month needs to be as close to free as checking your phone already is — or it will quietly stop being checked.

What actually decides it

Ask how the list will be used, not how it will be built. Something you will only ever read back fits comfortably in a spreadsheet. Something you are going to search from a shop aisle, and half-consciously check every time a shelf goes quiet, needs to live somewhere that makes both of those nearly effortless. Match the tool to that use, and the rest of the decision mostly makes itself.