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, count date, and inventory value formulas.
This is a lightweight CSV starter, not a finished Excel workbook. Add formulas after import if your spreadsheet app does not preserve formula cells.
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 | Inventory Value |
|---|---|---|---|---|---|---|---|---|---|
| INV-001 | Printer Paper | Office | Supply Room | 24 | 10 | 6.50 | Acme Office | 2026-07-01 | =E2*G2 |
| INV-002 | USB-C Cable | IT | Tech Cabinet | 8 | 12 | 9.99 | Cable Source | 2026-07-02 | =E3*G3 |
| INV-003 | Shipping Box | Shipping | Warehouse | 120 | 50 | 1.20 | PackRight | 2026-07-02 | =E4*G4 |
| INV-004 | Black Toner | Office | Supply Room | 6 | 8 | 48.00 | Acme Office | 2026-07-03 | =E5*G5 |
| INV-005 | Address Labels | Shipping | Warehouse | 40 | 20 | 3.75 | PackRight | 2026-07-03 | =E6*G6 |
| INV-006 | Mechanical Keyboard | IT | Tech Cabinet | 12 | 6 | 42.00 | Cable Source | 2026-07-04 | =E7*G7 |
| INV-007 | Wireless Mouse | IT | Tech Cabinet | 18 | 10 | 18.50 | Cable Source | 2026-07-04 | =E8*G8 |
| INV-008 | Desk Chair | Furniture | Main Office | 5 | 6 | 135.00 | FurnishCo | 2026-07-05 | =E9*G9 |
| INV-009 | Bubble Wrap | Shipping | Warehouse | 30 | 15 | 8.25 | PackRight | 2026-07-05 | =E10*G10 |
| INV-010 | Mailing Envelope | Office | Supply Room | 75 | 30 | 0.18 | Acme Office | 2026-07-06 | =E11*G11 |
| INV-011 | USB-C Dock | IT | Tech Cabinet | 4 | 5 | 89.00 | Cable Source | 2026-07-06 | =E12*G12 |
| INV-012 | Grid Notebook | Office | Supply Room | 60 | 25 | 2.50 | Acme Office | 2026-07-07 | =E13*G13 |
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-07-01 |
| Inventory Value | Optional formula column for quantity times unit cost | =E2*G2 |
After import, add these formulas
=E2*G2Paste this in J2 and fill down through J13 if the CSV import does not preserve formulas.
Returns with the included sample rows: 156 for INV-001.
=IF(E2<=F2,"Reorder","")Paste this in a new flag column beside the table and fill down through row 13.
Returns with the included sample rows: Reorder for INV-002 after the formula is filled down.
=SUMIFS($J$2:$J$13,$C$2:$C$13,"Office")Enter this summary formula outside the table after column J contains row-level inventory values.
Returns with the included sample rows: 607.50 for Office.
=SUM($J$2:$J$13)Enter this summary formula outside the table after column J contains row-level inventory values.
Returns with the included sample rows: 3096.92.
How to use it
- Open the CSV directly in Excel, then use Save As and choose .xlsx before adding formatting or formulas.
- In Google Sheets, use File > Import > Upload, then choose Insert new sheet so the imported table stays separate.
- Verify that J2:J13 contains the row formulas, then use the category and total inventory summary formulas outside the table.
Related spreadsheet formulas
FAQ
Is this a paid download?
No. These starter templates are free CSV files.
Does the template include macros?
No. It is a simple CSV with no macros or scripts.