Free Inventory Spreadsheet: Build and Use One in Excel

How-to basics · Updated November 21, 2026

Yes—you can make a useful free inventory spreadsheet in Excel by listing each item once, recording its quantity and reorder level, and using simple formulas to calculate stock value and flag items to replenish. The layout below works in Excel for Microsoft 365 on Windows and can be adapted for a small shop, office, workshop, or household.

What a basic inventory spreadsheet tracks

An inventory spreadsheet is a structured list of the goods or supplies you have, where they are, and whether you may need to order more. It is not automatically connected to a store, barcode scanner, or supplier. Unless you add an integration or enter updates yourself, the figures reflect only the information recorded in the workbook.

A practical starter sheet gives each item its own row and separates identifying details from quantities and costs. For example, a small retailer might record a particular blue mug as one item, with its own SKU, shelf location, current quantity, and reorder level. If the same mug comes in different sizes or colors, list each version separately when those versions need distinct counts or purchasing decisions.

A spreadsheet can be enough when the item list and number of updates are manageable. It gives you a low-cost way to find stock, compare counts with reorder points, and estimate the value represented by recorded quantities. It is less suitable when several people need simultaneous, tightly controlled updates or when sales and purchasing systems must adjust stock automatically.

Recommended columns for a free template

Start with one worksheet named Inventory and these columns. Use a consistent identifier such as a SKU; item names alone may be ambiguous, especially when products have similar descriptions.

  • SKU: A unique code for the item or variant. If you do not use SKUs, create another consistent identifier.
  • Item: A clear description, such as “Blue ceramic mug, 12 oz.”
  • Category: A useful grouping, such as packaging, office supplies, or finished goods.
  • Location: The shelf, room, bin, or storage area where the item is kept.
  • Qty on hand: The latest physical count or reconciled quantity.
  • Reorder level: The quantity at or below which you want to review replenishment.
  • Unit cost: Your recorded cost per unit, using a consistent currency and cost basis.
  • Stock value: A calculated estimate based on quantity and unit cost.
  • Supplier: The usual supplier or a useful contact reference.
  • Last counted: The date the quantity was physically checked.
  • Status: A formula-driven reminder such as REORDER or OK.

Keep the first row for column headings and avoid merged cells, blank rows inside the list, and multiple items packed into one cell. If you need more detail, add fields such as unit of measure, barcode, batch number, expiration date, or preferred order quantity. Add those only when they help a real process; unused columns make routine updates slower.

Build the sheet in Excel

In Excel for Microsoft 365 on Windows, enter the headings in row 1, then add one item per row. Select the range and choose Home > Format as Table, pick a style, and confirm that the table has headers. You can also select the range and press Ctrl+T, then confirm the header option. A table provides filter controls on the headings and makes it easier to format and extend the list.

Use consistent formats: quantities should be numeric, unit costs should use a currency format, and count dates should be dates rather than text. To display a currency, select the cost and value columns and use the currency controls on the Home tab. Choose one unit of measure per item, or record the unit explicitly; a count of “12” is hard to interpret if one person means individual pieces and another means cases.

For categories or locations, you can use Data > Data Validation to create a dropdown list. A controlled list reduces variations such as “Back room,” “Backroom,” and “rear room,” which can interfere with filtering. Update the allowed list when your locations or categories change. If the workbook is shared, agree on who edits quantities and how often before relying on it as the current record.

Formulas for value and low-stock reminders

Formulas remove some repetitive arithmetic, but they do not verify that the entered quantity or cost is correct. Put formulas in the first data row and fill them down. In an Excel table, formulas entered in a calculated column are generally propagated to other rows in that column.

With quantity in E2 and unit cost in G2, enter this in H2 for stock value: =E2*G2. If E2 contains 12 and G2 contains 8.50, the result is 102.00 in the same currency as the unit cost. Format column H as currency for readable display.

With quantity in E2 and reorder level in F2, enter this in K2 for a simple status: =IF(E2<=F2,"REORDER","OK"). If E2 is 4 and F2 is 5, the result is REORDER; if the quantity is 6, the result is OK. A blank or incorrectly entered quantity can produce a misleading status, so keep the quantity field complete and numeric.

With stock values in H2:H1000, enter this in a summary cell outside the item table to total the recorded values: =SUM(H2:H1000). If the only populated value in that range is 102, the result is 102. The total is an estimate based on the cost figures and quantities in the sheet; it is not necessarily the same as a formal accounting valuation.

To make low stock easier to spot, select the status column and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, then set the text to REORDER and choose a format. Conditional formatting changes appearance, not the underlying value, so the status remains available to filter or search.

Set reorder levels thoughtfully

A reorder level is a signal to review an item, not a guarantee that an order should be placed automatically. A common planning idea is to account for the quantity likely to be used while a supplier’s order is in transit, plus a buffer for uncertainty. The right level depends on demand, supplier lead time, storage limits, order minimums, and how costly it would be to run out. Those factors vary by item, so there is no universal number that fits every inventory list.

For example, a workshop that uses a few boxes of gloves each week may choose a higher review threshold if delivery takes several weeks. A rarely used spare part may need a different threshold, even if it costs more per unit. Treat the spreadsheet flag as a prompt to check current usage and supplier conditions. Review the level when demand or delivery times change rather than assuming last year’s setting is still appropriate.

Also distinguish a reorder level from a target quantity. The reorder level says when to consider replenishment; the target or order quantity says how much to buy. They can be recorded in separate columns if your purchasing process needs both.

Keep quantities accurate over time

The main weakness of a simple spreadsheet is that a correct formula cannot compensate for missing or late updates. If stock is sold, used, received, damaged, or moved without recording the change, the displayed quantity becomes stale. Establish a routine that makes ownership clear: for instance, one person records receipts and issues, while another periodically checks selected items against a physical count.

For a small list, updating the quantity after each change may be manageable. If changes are frequent or several people handle stock, consider a separate movement log with one row per receipt, issue, return, or adjustment. A movement log preserves a history, whereas replacing the quantity in the main list records only the latest balance. You can reconcile the two approaches, but a movement-based setup requires clear transaction types, dates, item identifiers, and careful formulas or review procedures.

  • Count items in a consistent unit and record the date of the count.
  • Investigate differences instead of silently changing figures; note a reason for adjustments when useful.
  • Use unique identifiers and consistent location names to reduce duplicate or misplaced records.
  • Save a dated backup or use version history where available, especially before a major cleanup.
  • Review blank costs, negative quantities, and items that have not been counted recently.

Excel can freeze the heading row as you scroll: choose View > Freeze Panes > Freeze Top Row. Sorting and filtering are useful for finding a location or category, but sort the entire table rather than a single column. Sorting only one column can separate quantities from the items they belong to.

Common spreadsheet problems and limits

Duplicate rows are a frequent source of incorrect totals. Before adding an item, search by SKU or another unique code. Similar descriptions can conceal duplicates, while identical product names may refer to different sizes or batches. Decide what counts as a distinct item and apply that rule consistently.

Another common issue is treating estimated value as exact. The value formula multiplies the recorded quantity by the recorded unit cost; it does not account on its own for changing purchase prices, shipping, damaged goods, or the cost method an organization may use for accounting. Use it as an operational estimate unless the workbook has been designed and reviewed for a specific accounting purpose.

A shared file also needs sensible access controls and a backup plan. Avoid exposing supplier pricing or other business information to people who do not need it. Passwords and sharing permissions are not a substitute for reliable backups, and spreadsheet formulas can be overwritten accidentally. Protecting formula cells may reduce accidental edits, but it does not replace keeping a recoverable copy.

Free spreadsheet or inventory app?

A spreadsheet is appealing because it is flexible and familiar, and a basic version can be created without buying inventory software. Excel for the web is available at no charge with a Microsoft account, although its feature set and working experience are not identical to the desktop application. Availability and account terms can change, so check Microsoft’s current offering. The Excel steps above are for Microsoft 365 on Windows; the web and Mac interfaces can differ in some details.

Dedicated inventory software may be more appropriate when you need automatic updates from sales, barcode workflows, purchase-order handling, audit trails, or multiple users working against a shared live count. Those products vary in features and price. A useful decision is to compare the time spent maintaining the spreadsheet and the cost of errors with the cost and setup effort of an app. If the list is small and changes are occasional, a spreadsheet may remain entirely adequate.

Frequently Asked Questions

Can I download a free inventory spreadsheet?
A starter layout can be created in Excel using the columns and formulas above; this article does not attach a workbook file. If you download a template elsewhere, check its formulas, permissions, and data requirements before entering business information.

Can I use Excel for free for inventory?
Excel for the web is offered at no charge with a Microsoft account, while desktop Excel is part of Microsoft’s paid offerings. Check Microsoft’s current terms and feature availability. A basic inventory list does not require advanced functions.

What is the best formula for inventory?
For a simple sheet, multiplying quantity on hand by unit cost estimates stock value, and an IF formula can flag quantities at or below a reorder level. Neither formula validates the physical count or decides how much to purchase.

How do I track stock coming in and going out?
For occasional changes, update the on-hand quantity promptly and record the count date. For frequent movements, keep a separate dated log of receipts, issues, returns, and adjustments, then reconcile it with physical counts.

Is a spreadsheet enough for a small business?
It can be, if the item list is manageable, updates are timely, and the people responsible for recording changes are clear. Consider inventory software when manual updates, simultaneous editing, or integration needs create too much risk or effort.

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.