A ready-to-use Excel inventory template: one sheet, one row per product. Stock value and reorder flags calculate on their own. No signup needed.
Already filled it in? Import the file into StockFlow free and scan stock with your phone.
Download the template
- Excel (.xlsx): formulas already built in. Delete the sample rows and start typing.
- CSV: same columns, no formulas. Use it as a clean import format.
Both download instantly. No email, no account.
What's in the Excel inventory template
| Column | What goes in it |
|---|---|
| SKU | Your unique product code |
| Product_Name | Name as your team knows it |
| Category | For filtering |
| Location | Rack, shelf or zone |
| Unit | pcs, box, m … |
| Quantity_On_Hand | Current stock |
| Reorder_Point | Level at which you reorder |
| Unit_Cost | Cost per unit |
| Stock_Value | Formula (yellow) |
| Reorder_Flag | Formula (yellow) |
| Supplier | Who you reorder from |
| Last_Counted | Date of the last count |
| Notes | Anything else |
How the built-in formulas work
The yellow columns calculate automatically. In row 5 (the first data row):
- Stock_Value:
=F5*H5→ quantity × unit cost. - Reorder_Flag:
=IF(F5<=G5,"REORDER","OK")→ shows REORDER when quantity is at or below the reorder point.
Adding rows? Copy the formulas down from the row above. Want red highlighting? Conditional Formatting → New Rule → "Use a formula" → =$J5="REORDER" → red fill.
Using the template with a barcode scanner
A USB barcode scanner types like a keyboard. Click a cell, scan, and the code appears, followed by Enter.
- Put the barcode in the SKU column (or add a Barcode column next to it).
- Find an item fast: press Ctrl+F, scan, and Excel jumps to the row.
Limit: Excel won't change quantities when you scan. You still type the count. In StockFlow, scanning with your phone camera updates stock directly. See barcode scanning.
Adding product pictures
In recent Excel versions (Microsoft 365) you can use Insert → Pictures → Place in Cell to put a photo inside a cell. Add a "Photo" column and place one image per row. In older versions, images float over the cells and don't sort or filter with the rows. Keep photos small: the file grows quickly.
Where an Excel inventory template breaks down
- A second location or warehouse.
- More than one person updating stock in the same shift.
- You need history: who changed what, when.
- Receiving and picking need to update stock, not just a cell someone remembers to edit.
Outgrown the spreadsheet? Import it into StockFlow free
Free for up to 25 products · paid plans from $19/mo · no credit card
Import this Excel inventory template into StockFlow
- Create a free StockFlow account.
- Go to import and upload this .xlsx or .csv.
- Match the columns (SKU, name, quantity, location, reorder point, cost, supplier).
- Check the preview and import. Your reorder points carry over as low-stock alerts.
Full guide: import inventory from CSV or Excel. Comparing options: StockFlow vs Excel · Excel inventory alternatives · all templates · inventory list template.
Outgrown the spreadsheet? Import it into StockFlow free
Free for up to 25 products · paid plans from $19/mo · no credit card
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”