Skip to content
Home Contents Inventory cover: a sample sheet with items recorded, replacement value and missing receipts and a bar chart, beside the Dashboard and Items tabs

Home Contents Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This template is for a household that wants a written record of its belongings, for an insurance review, a move or a simple check of what the home holds. The Items tab records every item with its room, category, serial number, purchase date and price, replacement value, and whether a receipt is saved and a photo taken. The Dashboard totals the replacement value and counts missing receipts and photos. The Room checks grid tracks progress room by room.

Work through one room at a time, adding each item and its replacement value at today's prices. Take a photo of the item and of its serial plate, then tick the boxes so gaps show up on the dashboard. Store a second copy away from the house, such as a cloud drive. Review the figures each year, and check with your insurer how it values items before you rely on any total.

Useful for

  • Preparing a list of contents for an insurance renewal
  • Recording belongings before a move
  • Checking which rooms still lack photos and receipts

What's included

  • 4 tabs: Dashboard, Items, Room checks, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Items: a table
  • Room checks: a grid
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Items tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What should I use as the replacement value?

Replacement value is what it would cost to buy a similar item new today, which is often more than what you paid. Check current prices online or in shops for each item. Your insurer may use its own method, so ask how it values contents.

How many photos should I take?

Take at least one clear photo of each item, plus close-ups of serial numbers, labels or makers' marks where you have them. For a large set of items, a short video walking through each room can speed things up. Store the photos in the same folder as the sheet.

Should I list every small item in the house?

Focus on items that are valuable or hard to replace, such as electronics, furniture, tools, jewelry and art. Group low-value things like kitchen utensils on one line with a combined value. A partial list done well is more useful than no list at all.

  • #inventory
  • #home-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…