Free spreadsheet template
Inventory Tracker Spreadsheet Template
Download a free inventory tracker CSV template for Excel or Google Sheets with reorder levels and supplier fields.
This free CSV opens in Excel and imports into Google Sheets. It includes item, location, quantity, reorder level, unit cost, supplier, and count date fields.
If your browser previews the CSV instead of downloading it, right-click the link and save the CSV file.
Template preview
| SKU | Item Name | Category | Location | Quantity | Reorder Level | Unit Cost | Supplier | Last Counted |
|---|---|---|---|---|---|---|---|---|
| INV-001 | Printer Paper | Office | Supply Room | 24 | 10 | 6.50 | Acme Office | 2026-01-15 |
| INV-002 | USB-C Cable | IT | Tech Cabinet | 8 | 12 | 9.99 | Cable Source | 2026-01-18 |
Field guide
| Column | Purpose | Example value |
|---|---|---|
| SKU | Stable item identifier for lookups and duplicate checks | INV-001 |
| Quantity | Current counted stock on hand | 24 |
| Reorder Level | Threshold for restocking alerts | 10 |
| Unit Cost | Estimated cost per unit for inventory value | 6.50 |
| Last Counted | Most recent physical count date | 2026-01-15 |
After import, add these formulas
=E2*G2=IF(E2<=F2, "Reorder", "")=SUMIFS($J$2:$J$100, $C$2:$C$100, "Office")How to use it
- Open the CSV directly in Excel, then save as .xlsx if you want formatting or formulas.
- In Google Sheets, create a blank sheet and use File > Import to upload the CSV.
- Use the SUMIFS and COUNTIFS builders to add reorder summaries by category, supplier, or location.
Related spreadsheet formulas
FAQ
Is this a paid download?
No. The MVP templates are free CSV files.
Does the template include macros?
No. It is a simple CSV with no macros or scripts.