Home Inventory Spreadsheet: Free Template and Setup

How-to basics · Updated November 21, 2026

Yes. You can make a free home inventory spreadsheet in Excel by creating a workbook with columns for each item’s room, description, quantity, estimated replacement cost, and documentation. Add a few optional fields—such as serial number, purchase date, and photo link—and you have a practical record to update over time; the spreadsheet does not replace your insurance policy or proof of ownership.

What a home inventory spreadsheet is for

A home inventory is a record of belongings and useful details about them. It can help you remember what you own, locate identifying information, and assemble documentation if you need to report a loss. A spreadsheet is a flexible format because you can sort items by room, filter for valuable belongings, and add columns to fit your household.

It is most useful when it is specific enough to identify an item. A row that says “electronics” is hard to act on; “Sony television, 55-inch, living room” is more informative. For a high-value item, a model or serial number, purchase record, and photo can make the record more useful. You do not need to record every inexpensive object individually: grouping ordinary kitchen utensils or books by category may be a sensible compromise.

A spreadsheet is not an official insurance valuation, a guarantee that an item is covered, or a substitute for checking policy limits and exclusions. Its role is to help you keep an organized account of your belongings and supporting information.

Free template columns to start with

Use one row per item when individual identification matters. These headings make a useful starting template; copy them into the first row of a blank worksheet, then add one item per row:

  • Room: bedroom, kitchen, garage, or another location.
  • Category: furniture, electronics, jewelry, tools, clothing, or similar.
  • Item description: enough detail to distinguish the item.
  • Brand and model: where relevant.
  • Quantity: the number represented by the row.
  • Estimated replacement cost per item: a current estimate, not necessarily the original price.
  • Estimated total: quantity multiplied by the per-item estimate.
  • Purchase date and source: if known, such as a retailer or secondhand purchase.
  • Serial number or identifying details: especially useful for electronics and equipment.
  • Photo or document location: a link or filename, not necessarily an embedded image.
  • Notes: condition, accessories, or other identifying information.

For example, a row might describe a cordless drill in the garage, include its brand and model, quantity one, an estimated replacement cost, and a link to a photo of its label. A set of everyday drinking glasses could instead be recorded as one group with a quantity and a short description.

How to create the spreadsheet in Excel

In Excel for Microsoft 365 on Windows, open a blank workbook and type the headings across row 1. Enter a few sample rows before formatting so you can see how much space the descriptions need. Select the headings and sample data, then choose Insert > Table and confirm that the table has headers. On a Mac, use Insert > Table as well; the available dialogs can look different from Windows.

Excel tables make it easier to filter and sort the list, and their formatting can extend as you add rows. Give the table a descriptive name from the Table Design tab if you want to refer to it in formulas later. To keep headings visible while scrolling, select View > Freeze Panes > Freeze Top Row. If the workbook grows, filters on the table headers let you show one room, category, or brand at a time.

Format the cost columns as currency using Home > Number, then choose a currency format. The exact symbol and decimal display depend on your regional settings. Avoid merging cells inside the data table: merged headings can interfere with sorting and filtering. Keep notes short in the table and store longer documentation separately, linking to it where practical.

Calculate estimated item values

A quantity-times-cost calculation gives a consistent estimate for each row. With quantity in column E and estimated replacement cost per item in column F, enter the following in G2 for the first item: =E2*F2. If E2 is 2 and F2 is 35, G2 returns 70. Copy the formula down the Estimated total column for other rows. The calculation is arithmetic, not a valuation method: the amount in F2 still needs to be a reasonable estimate for the item and the purpose of your record.

You can also total the values currently listed. If the item totals are in G2:G1000, enter =SUM(G2:G1000) in a summary cell outside the table. If the only completed item total is 70 and the rest of the range is blank, the result is 70. Update the range if your inventory extends beyond row 1000. This gives a sum of your entries, not a promise of what an insurer will reimburse; policies can use different settlement terms, limits, deductibles, and documentation requirements.

Keep original purchase price separate from estimated replacement cost if both are useful to you. They answer different questions: one records what you paid at the time, while the other is your estimate of what replacing the item might cost now. For older, used, or unusual belongings, a current replacement estimate may take more research than checking a recent receipt or retailer listing.

Photos, receipts, and supporting records

A description and a number alone may not identify an item well after years have passed. Take photos that show the item clearly, and for equipment, consider a separate close-up of the label or serial number. For a room, an overall photo can provide context, while individual photos are more useful for distinctive or higher-value belongings. Keep images readable and named consistently, such as by room and item, rather than relying on a camera’s default filenames.

Receipts, appraisals, warranties, and manuals can be useful supporting documents, but do not assume every record is necessary for every possession. Store digital copies in a folder structure that matches your spreadsheet, or use a stable cloud-storage link if you have one. Check that links still work when you reorganize folders. If you embed photos directly in the workbook, the file can become large and harder to share, so linked files are often easier to manage.

Do not rely on a spreadsheet stored only on the computer or device that could be lost in the same event as the belongings. Keep a separate backup in a secure location, such as an account with appropriate access protection or an external drive stored elsewhere. The right arrangement depends on your privacy needs and how you manage files.

How to keep the inventory current

An inventory becomes less useful if it describes a home you no longer have. Set a reminder to review it periodically and make an entry when you buy, sell, donate, or replace a significant item. You can add a Last reviewed date column or include the date in a separate summary sheet. A simple routine—updating a few important rows after a purchase—is usually easier than rebuilding the whole list at once.

When moving, use the room and box information to track where belongings are packed. For shared households, decide who updates the workbook and how duplicate entries will be avoided. If multiple people edit a cloud-hosted copy, agree on consistent descriptions and avoid keeping several competing versions called “final.” For a single-user file, retain a clearly dated backup before major changes.

Review names and categories as well as prices. A camera recorded only as “camera” may be difficult to distinguish from another; adding model details can solve that. Likewise, if an item is no longer owned, delete it or mark it disposed of rather than leaving it in the active inventory with no explanation.

Privacy and file security

A home inventory can contain sensitive details: what you own, where it is stored, and possibly serial numbers or purchase information. Share it only with people who need access, and think carefully before placing a public link to the workbook or its photo folder. If you use cloud storage, review the sharing permissions rather than assuming that a link is private.

Use a strong password and the security options available for the account or device where the file is stored. Excel’s workbook protection features can discourage accidental changes, but worksheet protection is not the same as encrypting a file or securing an online account. Do not put payment card numbers, account passwords, or other secrets in an inventory. A useful record does not need them.

Spreadsheet versus other inventory methods

A spreadsheet is a good fit if you want a low-cost, editable list and are comfortable maintaining rows and files. It works offline when the workbook is saved locally, and it can be adapted for a room-by-room list, a collection, or moving boxes. Its drawbacks are manual upkeep and the need to organize photos and backups yourself.

A dedicated home inventory app may offer guided prompts, barcode scanning, or built-in image storage, but features, privacy practices, pricing, and export options vary by product. Check whether you can export your data in a usable format before depending on an app. A paper list is simple and does not depend on a device, but it is harder to search and update, and it still needs safe storage. Some households use both: a spreadsheet for searchable records and a printed summary or separate backup for access if a device is unavailable.

Common mistakes and limitations

  • Being too vague: Replace labels such as “furniture” with descriptions that distinguish items, and include make or model where useful.
  • Confusing cost with coverage: A spreadsheet total does not establish what a policy covers or how a claim will be settled. Read the policy and ask the insurer about documentation or limits.
  • Using inconsistent amounts: Decide whether the cost column represents current replacement estimates, original purchase prices, or another clearly named measure.
  • Leaving blank values unexplained: Use a note such as “unknown” or “estimate needed” rather than letting a blank look like a confirmed zero.
  • Keeping no backup: A local workbook may be lost with the device, so keep a separate, reasonably secure copy.
  • Over-documenting low-value items: Record everyday items in groups when individual detail would take more effort than it adds.

There is no universal number of rows or exact level of detail that suits every household. Prioritize items that are difficult to identify, replace, or document from memory, then choose a manageable level of detail for the rest. If you need to know how a particular item or collection is treated under a policy, ask the insurer or a qualified professional rather than relying on a spreadsheet formula.

Frequently Asked Questions

Is there a free home inventory spreadsheet template?
You can create one at no cost by entering the headings in this guide into a blank worksheet. Excel availability depends on your software or account access, but the template structure itself does not require a paid inventory app.

What should I include in a home inventory?
Start with the room, category, description, quantity, estimated cost, and any useful identifying details. Add serial numbers, purchase records, and photos where they help distinguish or document an item.

Should I list every item in my house individually?
No. Individual rows are most useful for identifiable, valuable, or hard-to-replace belongings. You can group ordinary low-cost items—such as kitchen utensils or books—if the group description and quantity are useful for your purposes.

How often should I update a home inventory?
Update it when important belongings change and review the list periodically. There is no single required schedule; a regular reminder can help you catch outdated rooms, descriptions, or estimates.

Does a spreadsheet prove what insurance will pay?
No. It is a personal record, not a coverage decision or guarantee of reimbursement. Policy terms, limits, deductibles, and the evidence requested can differ, so check your own policy and contact the insurer with questions.

Where should I store the inventory and photos?
Keep a backup separate from the device holding your main copy, and restrict access because the file may reveal personal information. A secure cloud account or an external drive stored separately are possible approaches; choose one you can maintain and retrieve when needed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.