Inventory List Spreadsheet Template: Build and Use One

An inventory list spreadsheet template is a structured worksheet for recording what you stock, how many units you have, where they are, and when to reorder. In Excel for Microsoft 365, start with columns for item ID, item name, category, location, quantity on hand, reorder point, unit cost, stock value, supplier, last counted, and status; the example below shows how to set it up and calculate the useful fields.

A copyable inventory list template

Put these headings in row 1 of a blank worksheet. Each item or product gets one row, beginning in row 2. Keep the headings simple and use one row per distinct item, rather than combining several products into one cell.

Column	Heading	Example entry
A	SKU or item ID	MUG-014
B	Item name	Ceramic travel mug
C	Category	Drinkware
D	Location	Shelf B2
E	Quantity on hand	24
F	Reorder point	8
G	Unit cost	3.50
H	Stock value	84.00
I	Supplier	Northside Supply
J	Last counted	2026-10-28
K	Status	OK

The sample is illustrative: the date is simply an example of a count date, and the unit cost is not a quote or recommended price. If you need a lightweight list, omit fields you will not maintain. If several people use the file, agree on what each field means before adding records; consistent entries matter more than having a long set of columns.

What each field is for

An item ID or SKU distinguishes products that have similar names. Use a stable identifier where possible, especially if the same product comes in different sizes, colors, or packaging. A name such as “blue mug, 12 oz” is more useful than “mug” when someone has to find the item. Category helps group stock for review, while location points staff to the shelf, room, bin, or storage area.

Quantity on hand is the physical count currently recorded in the sheet. Reorder point is the level at which a business wants to review or replenish an item; it is not automatically the right order quantity. Unit cost can support a rough stock valuation, but the meaning of cost should be consistent—for example, whether it includes shipping or other costs depends on the organization’s accounting method. A supplier field is a reference, not proof that an item is currently available from that supplier.

Last counted records when the physical quantity was checked, rather than when the row was edited. Status can flag a low quantity for review. Depending on how the sheet will be used, other useful fields may include unit of measure, minimum order quantity, expiration date, serial number, asset tag, or notes. Add sensitive information only if there is a clear need and the file is appropriately protected.

Set up the sheet in Excel

Open a blank workbook and enter the headings in row 1. Enter one item per row and keep the same kind of data in each column.
Enter quantities as numbers, costs as numbers, and count dates as actual Excel dates. Avoid typing extra words into numeric cells; record units in a separate column if needed.
Select the heading row and the item rows, then choose Insert > Table. Confirm that the table has headers. Excel tables make it easier to filter, sort, and extend the list as new rows are added.
Use clear number formats. Select the cost and value columns and choose a suitable currency format from Home > Number. Format quantity columns as numbers, and format the count column as a date.
Keep the headings visible while scrolling by choosing View > Freeze Panes > Freeze Top Row. Use the table’s filter arrows to show a category, location, supplier, or status.

On Excel for the web, the table and formatting options are also available, though the ribbon layout can vary slightly with the browser window. Excel for Mac has corresponding table and view controls; menu placement or keyboard shortcuts may differ from Windows. The worksheet structure and formulas below work in current Microsoft 365 versions on both platforms.

Calculate stock value and low-stock status

A formula can reduce repetitive arithmetic, but it only works if the input columns are accurate. In the template above, stock value is quantity on hand multiplied by unit cost. With quantity in E2 and unit cost in G2, enter this in H2:

With quantity on hand in E2 and unit cost in G2, =E2*G2 returns 84 when E2 is 24 and G2 is 3.50. Copy the formula down the column for the other item rows. If the data is formatted as an Excel table, entering the formula in the first data row will usually fill the calculated column for the table.

A status formula can compare quantity on hand with the reorder point. With quantity in E2 and reorder point in F2, enter this in K2:

With quantity on hand in E2 and reorder point in F2, =IF(E2<=F2,"Reorder","OK") returns Reorder when E2 is 8 or less and OK when E2 is greater than 8. For the sample quantity of 24 and reorder point of 8, the result is OK. Copy the formula down K for the remaining rows.

These formulas do not decide how much to buy. They only calculate a value from the numbers entered or flag a threshold you chose. To make low-stock rows easier to see, select the status cells and use Home > Conditional Formatting > Highlight Cells Rules, or apply a rule to the quantity column. Check the rule range when new items are added; using an Excel table helps the range expand with the data.

Keep counts and updates reliable

A spreadsheet is only as current as its updates. Decide who records receipts, sales, transfers, damaged goods, and adjustments, and when those changes are entered. If the file is a count sheet rather than a live transaction system, label it accordingly and record the date of each physical count. A number copied from an old report is not necessarily the current quantity.

Count items using a consistent unit, such as individual pieces, cases, or meters. Do not mix units in one quantity column.
When similar products have variants, give each variant its own row and identifier. A row for a small black shirt should not also represent a large black shirt.
Use filters to review one location or category at a time, and sort only the full table so names do not become separated from their quantities.
Keep a dated backup or version history before substantial changes. A separate change log can record adjustments, who made them, and why.
Reconcile selected spreadsheet quantities against physical counts regularly. Investigate differences rather than simply overwriting them without a record.

For a small collection, a periodic count may be manageable. A busy operation with frequent movements may need to update stock after each transaction or use a dedicated inventory system. The appropriate process depends on how quickly stock changes and how costly a missed or incorrect count would be.

Choose fields and features for your use

A household pantry list, a workshop parts list, and a retail stock register share a basic idea but need different details. A pantry sheet may benefit from expiration dates and storage locations. A tool register may need a serial number, assigned person, and condition. A shop may need SKU, supplier, reorder point, and unit cost. Start with the decisions the list should support, then add only the fields needed to make those decisions.

For a simple list, filters and formulas may be enough. For a larger list, an Excel table is useful because its filter controls and formatting extend as rows are added. Data validation can limit entries in fields such as category or location: select the cells, choose Data > Data Validation, and define an allowed list or rule. Keep the permitted values documented so different users do not create duplicates such as “Warehouse,” “warehouse,” and “WH.”

Do not treat a spreadsheet as a complete purchasing, accounting, or warehouse-management system. It does not automatically know about a delivery, sale, or return unless someone records that event or connects it to another system. A formula can highlight a threshold, but it cannot verify the physical stock or confirm supplier lead times.

Common problems and ways to prevent them

Duplicate rows are a frequent source of confusion. Two entries for the same item can make the total appear larger or lower than it is. Use a unique ID and periodically check for duplicates. In Excel, the table’s sort and filter features can help inspect IDs, but a visual review is still important when IDs have been typed inconsistently.

Another problem is mixing data and notes. Entries such as “about 10,” “10 boxes,” or “10?” are hard to calculate reliably in a quantity field. Store a numeric quantity separately from its unit and explain uncertainty in a notes field. Similarly, check that dates are stored as dates, not text that only looks like a date; text dates may not sort chronologically or behave as expected in date calculations.

Accidentally sorting only one column can mismatch items and quantities. Use the filter or sort controls on the Excel table, or select the entire data range before sorting. Also avoid merged cells inside the data area: they interfere with sorting and filtering. If multiple people need to edit at once, store the workbook in a shared location that supports collaboration and agree on a process for resolving conflicting updates.

Finally, a reorder flag is not an automatic purchase instruction. Demand, supplier delivery time, seasonality, and minimum order quantities may affect what should be ordered. Treat the flag as a prompt to review the item, not as a substitute for judgment or a purchasing policy.

When a spreadsheet is not enough

A spreadsheet is often a reasonable starting point when the list is small, stock changes are limited, and a few people can maintain the file. It is inexpensive to create, flexible, and easy to adapt. Its drawbacks become more important as the operation grows: updates depend on people, audit trails may be limited, simultaneous editing can create process problems, and it may not connect to sales, purchasing, or barcode scanning.

Consider dedicated inventory software when several locations need synchronized quantities, stock moves frequently, users need role-based access, or records must connect to orders and sales. A barcode or point-of-sale system may reduce manual entry, but it still needs accurate product setup and a process for handling exceptions. Compare costs, data-export options, integrations, and training needs before switching. A spreadsheet can also remain useful for a small, clearly defined task even when a larger system manages the main stock record.

Frequently Asked Questions

What should an inventory list spreadsheet include?
At minimum, include a unique item identifier, item name, quantity on hand, and location if items are stored in more than one place. Category, reorder point, supplier, unit cost, and last-counted date are useful additions when they support a real task.

How do I make an inventory spreadsheet in Excel?
Enter field names in the first row, add one item per row, and select Insert > Table. Format quantities, costs, and dates appropriately, then add formulas only where useful. Test formulas on a known example before filling them down.

Can Excel automatically track inventory?
Excel can calculate values and flag quantities against thresholds, but it cannot know about stock movements that have not been entered. Automatic tracking requires a connected data source, integration, or another system that records transactions.

How often should I update an inventory list?
Update it whenever the process requires a reliable current balance, such as after receipts, sales, transfers, or adjustments. The right schedule depends on how quickly stock changes; frequent movement usually calls for more frequent recording and physical checks.

Is a spreadsheet better than inventory software?
It can be better for a small, simple list because it is flexible and easy to start. Software may be more suitable when many users, locations, transactions, or integrations make manual spreadsheet maintenance difficult. The best choice depends on the scale and control requirements.

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.