Stowkeep

Home inventory template: a spreadsheet or an app?

·5 min read

Stowkeep: expiry dates, shopping and lent items — all on one screen.
Stowkeep: expiry dates, shopping and lent items — all on one screen.

Most home inventories start as a spreadsheet: it's free, it's familiar and it takes a minute to open. That's a fine start. The trouble usually begins a month later, when the photos live in one place, the receipts in another, and nobody remembers to update the file.

Below is a simple template you can copy into any spreadsheet, how to fill it in, and an honest look at when a spreadsheet is enough and when an app saves you time.

The template: 10 columns worth keeping

Create a sheet with these column headers, in this order:

  1. Item — what it is: "Laptop", "Road bike".
  2. Place — where it lives, from big to small: "Home › Office › Desk drawer".
  3. Category — electronics, furniture, tools, kitchen, clothing.
  4. Quantity — for sets: chairs, glasses, tyres.
  5. Purchase date — the month is enough if you don't know the day.
  6. Price — what you paid, with the currency.
  7. Serial number — for electronics, appliances and tools.
  8. Warranty until — the end date, not the length.
  9. Photo — a link to the photo in your cloud storage.
  10. Note — model, colour, who it was lent to, anything else.

That's it. More columns look thorough, but they are the first thing people stop filling in.

How to fill it in without losing a weekend

  • Go room by room. Finish one room before starting the next, so you always know what's done.
  • Valuables first. Electronics, jewellery, bikes, tools, instruments. A spoon can wait forever.
  • One row per item, one per set. Six identical chairs are one row with a quantity of 6.
  • Write the place the same way every time. "Garage › Rack 2 › Blue box" is searchable; "the blue thing in the garage" isn't.
  • Photograph the label too. The model and serial number are on it, and typing them from a photo is easier than from behind the TV.

What a spreadsheet does well

  • It's free and works on any computer.
  • You control every column and every formula.
  • Totals are easy: a sum of the Price column is your rough household value.
  • It's easy to send — to an insurer, a moving company or a family member.

If you need a list once — for a single insurance review or a single move — a spreadsheet may be all you need.

Where a spreadsheet starts to hurt

The problems show up when the inventory has to stay alive for years:

  • Photos are separate. A link in a cell breaks when you reorganise your cloud folders.
  • It's awkward on a phone. You add things when you buy them, standing in a shop or a hallway, not at a desk.
  • No reminders. A warranty end date in a cell won't tell you anything before it expires.
  • Two people, two copies. When a partner edits their own copy, you end up with two versions of the truth.
  • Finding things is slow. Searching a sheet works at a desk, not when you're standing in the garage wondering which box.

Doing it with Stowkeep

Stowkeep is a home inventory app for iPhone and Android that keeps the same structure as the template above — just on your phone.

  • Places as deep as you need: home › room › wardrobe › shelf › box. Search shows the full path to every item.
  • Every item has a card with the same fields as the template: name, category, quantity, up to three photos, price, serial number, barcode, purchase date and warranty end date, plus a note.
  • Faster than typing: scan a receipt or a whole shelf to add several items at once, or dictate them by voice.
  • Reminders for warranty end dates and for checks and maintenance.
  • Shared home: invite family or roommates, and everyone sees the same list instead of separate copies.
  • Your spreadsheet whenever you want it: export everything, or only the places you choose, to CSV for Excel, Numbers or Google Sheets, or to PDF for an insurer. The file always has every field.

The first 30 places and 100 items are free, which is enough to try it on one room or all your valuables.

Quick checklist

  1. Copy the 10 columns into a new sheet.
  2. Go room by room, valuables first.
  3. One row per item or set; write places the same way.
  4. Photograph each item and its label.
  5. Keep a copy outside the house and update it after big purchases.
  6. If updating feels like a chore, move the list to your phone.

FAQ

What should a home inventory include?At least what the item is, where it is, what it cost and when you bought it. Add serial numbers and photos for anything valuable.
Is Excel or Google Sheets good enough for a home inventory?For a one-off list, yes. For a list you keep up to date for years, with photos, reminders and more than one person, an app is easier.
Can I get my data back out of an app?Check before you start. Stowkeep exports to CSV and PDF at any time, so your inventory is never locked in.

This guide is general information, not insurance advice. Check your own policy for what it requires.

More on this topic