Excel Inventory Template: How to Track Stock

How-to basics · Updated November 22, 2026

The fastest way to track inventory in Excel is to download a pre-built template from Microsoft’s template gallery (File > New, search “inventory”) or build a simple table yourself with columns for Item, Quantity, Cost, and Reorder Level. A basic sheet can be set up in under ten minutes, and with a few formulas it will automatically flag low stock and calculate total value.

Why Use Excel for Inventory Tracking

Excel is a middle ground between pen-and-paper logs and full inventory management software. It is free if you already have Microsoft 365, works offline, and is familiar to most people. For a small business with a few hundred SKUs, a spreadsheet is often enough to know what you have, what you need to reorder, and what your stock is worth. It also gives you full control over the layout—you can add columns for supplier, location, or batch number without paying for a custom system.

However, Excel is not a database. It does not handle multiple users editing at once well, and it has no built-in barcode scanning. If you need real-time updates from a point-of-sale system or you have thousands of transactions daily, a dedicated inventory app is a better fit. For most small operations, though, Excel is a practical, low-cost starting point.

Core Components of an Inventory Template

A useful inventory template should answer three questions: what do I have, what is it worth, and what do I need to reorder? The following columns cover those basics:

  • Item ID / SKU – a unique code for each product.
  • Item Name – a human-readable description.
  • Category – optional, helps filter and sort.
  • Quantity on Hand – current stock count.
  • Reorder Level – the quantity at which you should order more.
  • Unit Cost – what you pay per unit.
  • Total Value – computed as Quantity × Unit Cost.

You can add more columns later, such as Location, Supplier, or Last Updated. The key is to keep the data clean: one row per item, no merged cells, and no blank rows in the middle of the table.

How to Build a Simple Inventory Tracker from Scratch

If you prefer to build your own instead of using a template, follow these steps in Excel for Microsoft 365 on Windows (steps are similar on Mac and Excel for the web):

  1. Open a new workbook and type headers in row 1: Item ID, Item Name, Quantity, Unit Cost, Reorder Level.
  2. Enter your data starting in row 2. For this example, assume items are in rows 2 to 10.
  3. In cell E2 (assuming D is Unit Cost), enter the formula for total value: =C2*D2 and drag down to fill.
  4. To flag low stock, use conditional formatting: select the Quantity column (C2:C10), go to Home > Conditional Formatting > Highlight Cells Rules > Less Than, and enter the reorder level for that row—but since reorder levels vary, a better approach is a formula-based rule. Select C2:C10, go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and enter =C2<E2 (assuming E is Reorder Level). Set a red fill.
  5. Add a total row at the bottom, for example in cell C11: =SUM(C2:C10) for total units, and in D11: =SUM(D2:D10) for total cost.

This gives you a live view of stock levels. The conditional formatting rule will highlight any item whose quantity falls below its reorder level, so you can reorder before you run out.

Using Built-in Excel Inventory Templates

Microsoft provides several free inventory templates directly in Excel. To access them, click File > New and type “inventory” in the search box. You will see options like “Inventory List,” “Inventory with Reorder,” and “Asset Inventory.” These are professionally designed and include pre-set formulas, formatting, and sometimes charts. For example, the “Inventory with Reorder” template includes a column for reorder points and uses conditional formatting to highlight low stock. Simply replace the sample data with your own.

On Mac, the process is the same: File > New from Template, then search. Excel for the web also has a template gallery, but some advanced features like macros are not supported. If you need a template that uses VBA (for example, to automate data entry), you must open it in the desktop version.

Common Problems and How to Avoid Them

Even a good template can fail if you do not use it correctly. The most common issues are:

  • Data entry errors – typos in SKUs or quantities lead to inaccurate stock. Use data validation (Data > Data Validation) to restrict entries to whole numbers for quantity, or create a dropdown list for categories.
  • Multiple versions – if you save the file to a shared drive and two people edit it, changes can be lost. Use Excel’s co-authoring feature (save to OneDrive or SharePoint) or keep a single “master” file.
  • No backup – a corrupted file can wipe out months of data. Enable AutoSave if you are using OneDrive, or make regular manual backups.
  • Mixing units – if you sell in packs and singles, keep separate columns for “Units per Pack” and “Packs on Hand,” or standardize everything to one unit.

Another misconception is that Excel can automatically sync with your sales channels. It cannot—unless you use third-party add-ins or Power Automate. For most small businesses, manual entry after each sale is acceptable, but if you have high volume, consider a barcode scanner that types into Excel (many USB scanners act as a keyboard).

Comparing Excel to Dedicated Inventory Software

Excel is not the only option. Here is how it stacks up against common alternatives:

  • Excel – low cost, flexible, offline, but manual and error-prone for large inventories.
  • Google Sheets – similar to Excel, but better for real-time collaboration and free for personal use. Some functions differ, but basic inventory tracking works the same.
  • QuickBooks / Xero – these accounting platforms have built-in inventory modules that track cost of goods sold and integrate with sales. They are better if you need financial reporting, but they cost a monthly fee.
  • Dedicated inventory apps (e.g., Sortly, inFlow, Zoho Inventory) – designed for inventory management, with barcode scanning, multi-location support, and purchase orders. They are easier to scale but require a subscription.
  • Pen and paper – still used by some very small businesses, but it is impossible to get real-time value or reorder alerts.

If your inventory is under 500 items and you only need to track quantities and costs, Excel is likely sufficient. Above that, or if you need to share data with an accountant, a dedicated system saves time.

Costs and Safety Considerations

Excel itself is part of Microsoft 365, which costs about $6–$10 per user per month (personal or business plans). If you already have it, the marginal cost of using a template is zero. Free alternatives like Google Sheets offer similar functionality at no cost, though they lack some advanced Excel features.

From a safety standpoint, the biggest risk is data loss. Always keep a backup of your inventory file, especially if it is your only record. If you are tracking items that are hazardous or perishable, add columns for expiration dates or safety data sheet numbers, and use conditional formatting to highlight items that are about to expire. For regulated industries, ensure your spreadsheet meets any record-keeping requirements—Excel can do this, but you must be disciplined about data entry.

Frequently Asked Questions

Can I track inventory in Excel for free?
Yes, if you use Excel for the web (free with a Microsoft account) or Google Sheets. The desktop version of Excel requires a Microsoft 365 subscription or a one-time purchase, but many templates are free within the app.

How do I automatically reorder when stock is low?
Excel cannot automatically place an order, but you can use conditional formatting to highlight low-stock items, and you can set up an email alert using Power Automate (a separate Microsoft service) that sends an email when a cell value drops below a threshold.

What is the best Excel formula for inventory value?
The simplest is =Quantity*UnitCost for each row, then sum the column. For more complex scenarios, use SUMPRODUCT to calculate total value in one formula: =SUMPRODUCT(C2:C10,D2:D10) where C is quantity and D is unit cost.

Can I use Excel to track inventory with barcodes?
Yes, if you have a USB barcode scanner that acts as a keyboard. When you scan a barcode, the scanner types the number into the active cell. You can then use VLOOKUP to pull up the item name and update the quantity. This works, but it is not as fast as dedicated inventory software.

Why does my Excel inventory template not update when I enter a sale?
Because Excel is not a live system—it only calculates what you type. If you want a sales log to automatically reduce inventory, you need to use a more advanced setup with formulas that subtract quantities based on a sales sheet, or use a macro. A simpler approach is to manually adjust the quantity after each sale.

Is Excel suitable for a restaurant or food inventory?
Yes, but you must track expiration dates and batch numbers. Add columns for “Expiration Date” and use conditional formatting to highlight items that expire within 7 days. Also, consider using a template designed for food, which often includes a “Days on Hand” calculation.

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.