Why home inventory spreadsheets get abandoned

Nearly every home inventory starts as a spreadsheet. It is free, it is familiar, and for the first fifty rows it is genuinely the best tool available.

Then most of them stop. Not because people are lazy — because two specific things get hard, and both of them are things a spreadsheet is structurally poor at.

Where spreadsheets are genuinely better

Let us be fair first, because this matters if you are choosing.

• Totals and sums. Nothing beats a spreadsheet for "what is all this worth".
• Bulk editing. Changing two hundred rows at once is trivial and painful anywhere else.
• Portability. It is a file. You own it, you can email it, nothing can take it away.
• No cost, no account, no lock-in.

If your inventory is a list of forty valuable items for insurance and it does not need photographs, a spreadsheet is the right answer and you should stop reading.

The first failure: photographs

An inventory without photographs is a list of assertions. With photographs it is evidence — which is the entire difference in a claim, and the specific shots that matter are worth knowing.

Spreadsheets handle photographs badly. You can embed images, and the file becomes enormous and slow. You can link to files, and the links break as soon as anything moves. You can keep a folder alongside and reference filenames, which works until there are four hundred photographs and nobody maintains the naming.

The photographs end up in a camera roll, disconnected from the rows they belong to. That is the point at which the spreadsheet stops being an inventory and becomes a list.

The second failure: where things are

The other half of an inventory is location, and location is not one field. A thing is in a bin, which is in a garage. Sometimes twelve of a thing are split across three bins.

In a spreadsheet you end up with a Location column typed by hand. Then the bin moves, and forty rows are wrong, and correcting them is boring, so it does not happen. Within a year the location column is a historical record rather than a current one.

The moment the location data is untrustworthy, the inventory stops answering the only question you actually ask it: where is this thing?

The third, quieter failure: it is not with you

An inventory is consulted standing in a garage, in a loft, or in a storage unit. A spreadsheet on a laptop is not there. Mobile spreadsheet apps exist and are miserable to use one-handed with a torch.

So the loop breaks. You are looking at the bins, the answer is on a computer indoors, and you open the bins instead. After enough of that, nobody updates the file.

What to actually do

If your inventory is small and static — high-value items for insurance, no photographs, reviewed annually — use a spreadsheet. It is the right tool and it costs nothing.

If it is large, photographed, or moves — a garage, a storage unit, a house move — a spreadsheet will not survive the year. You want photographs attached to items, locations as real relationships rather than typed text, and the whole thing readable on the phone in your hand while you are standing in front of the boxes.

That is what we built Waoo Storage to be. Items hold photographs, bins hold items, locations hold bins, and each bin gets a printed QR label you can scan to see inside it. It works with no signal, which matters in a concrete storage unit. The free tier holds one location and fifty items.

Whatever you choose, make sure you can leave

The one thing worth insisting on is export. Any inventory tool that will not give you your data back as a spreadsheet is a tool that can hold your records hostage.

Ours exports to CSV, and to a full file including every photograph path, at any time and on the free tier. That is not generosity — it is the minimum you should accept from anything you are going to spend an afternoon filling in.

The honest summary

Spreadsheets are not bad at inventories. They are bad at photographs and at locations, and those two things are what an inventory is for once it grows past a list. Start with a spreadsheet if you like. Move when you notice you have stopped updating it.