Scanning a barcode with a phone
Scan with your phone

Count, move, and find stock with the camera already in your pocket. Works offline, syncs later.

Try the live demo →
Organized stock on shelves
Switching from Sortly?

Bring folders, photos, and history over in an afternoon — with pricing that stays predictable at renewal.

See pricing →
Folder-style inventory list
Free spreadsheet templates

Excel, Google Sheets, and printable count sheets — ready to download, no signup needed.

Get the templates →
Home › Learn › Templates › Google Sheets inventory template

Free Google Sheets inventory template

A working inventory spreadsheet that opens straight in Google Sheets — auto-calculated totals and stock value, and a low-stock flag that trips when quantity drops below your minimum. Download the .xlsx, open it in Sheets in one step, and start counting. No email, no add-on to install.

Get the template

Free · opens in Google Sheets · no email required · updated July 2026

SInventory — Google SheetsPreview
ItemSKUQtyMinUnit valueStatus
Copy paper A4 (ream)PPR-A4-804620$4.20OK
Packing tape 48mmTPE-PCK-48C210$2.80REORDER
Totals48$221.201 low
Opens in Google Sheets

Google Sheets inventory template

Not a blank grid: item, SKU, location, quantity, min and unit-value columns, with auto-summed quantity and stock value and a reorder flag that highlights anything below its minimum. Built as an .xlsx so it opens in Google Sheets, Excel and LibreOffice alike.

  • ✓Item, SKU, location, quantity, min and unit-value columns
  • ✓Auto-summed totals, stock value and a low-stock reorder flag
  • ✓Opens in Google Sheets, Excel and LibreOffice — one file
Download free — .xlsx (opens in Google Sheets).xlsx · opens in Sheets · no email

Open the template in Google Sheets

The download is a real .xlsx, and Google Sheets opens .xlsx natively — no add-on to install. Four steps and the formulas are live.

1

Download the .xlsx

Use the button above — it saves free-inventory-spreadsheet.xlsx to your device. No email, no macros.

2

Open Google Sheets

Go to sheets.google.com and sign in. From a blank sheet, choose File → Import.

3

Upload the file

Pick the Upload tab, drag in the .xlsx, and choose “Replace spreadsheet”. Google converts it to a native Sheet.

4

Start counting

The totals, stock value and low-stock highlight are already wired — fill the Min column and type your counts.

What is in the template

Seven columns cover a real stock list — Status is calculated from Quantity against Min, so low stock flags itself.

ColumnWhat it holdsExample
ItemPlain-English name of the itemCopy paper A4 (ream)
SKUYour code or barcode for the itemPPR-A4-80
LocationWhere it lives — shelf, bin or roomAisle 3, Shelf B
QuantityHow many you have on hand right now46
MinReorder threshold — the low-stock flag trips below this20
Unit valueCost per unit, used for the stock-value total$4.20
StatusAuto-calculated OK / REORDER flag from Quantity vs MinOK

How to use these templates

1
Download, then import into Sheets
Grab the .xlsx above, open Google Sheets, and use File → Import → Upload to drop it in. The totals and low-stock formulas carry across untouched.
2
Fill the Min column first
The reorder flag only earns its keep once Min is set. Start with your 20 fastest movers — that is where a stock-out actually costs you.
3
Count once, enter once
Walk the shelves on paper or on your phone, then type the counts into the sheet in one sitting so the totals and stock value stay honest.

Template questions

Is this a real Google Sheet or an Excel file?
It is a real .xlsx workbook, and Google Sheets opens .xlsx files natively. Use File → Import → Upload inside Google Sheets, or open the file and choose File → Make a copy. We do not hand you a native .gsheet link because the same one file works in Sheets, Excel and LibreOffice — one download, every app.
How do I open the .xlsx in Google Sheets step by step?
Open sheets.google.com, click the folder (Open file picker) → Upload, and drag in the downloaded .xlsx — or from any open sheet use File → Import → Upload → Replace spreadsheet. Google converts it to a Sheet and keeps the SUM totals and the conditional low-stock formatting.
Do the formulas and low-stock colours survive the import?
Yes. The auto-summed quantity and stock-value formulas and the conditional low-stock highlight are standard functions Google Sheets supports, so they carry over on import. Edit a quantity and the totals and the reorder flag update live, exactly as they do in Excel.
Is it really free, and can I share it with my team?
Free, no email, no watermark. Copy it, share it and adapt it freely, including commercially — a link back is appreciated but never required.
When does a Google Sheet stop being enough?
Common signs: two people edit at once and overwrite each other, you need a history of who changed what, or counting eats more than an hour a week. That is usually around 100 items — the point where a real inventory app with scanning and an audit trail pays for itself.

When the sheet stops scaling, scan instead

StockZip picks up where a Google Sheet gives out: scan an item to count it, get low-stock alerts and reorder suggestions automatically, and keep a full audit trail of who changed what. Your sheet imports in one click — free for your first 100 items.

Start freeSee CSV import

Keep exploring

All templates →
Free template
Inventory spreadsheet template
The parent hub: Excel workbook, printable, list and setup checklist.
Feature
CSV import & export
Outgrown the sheet? This template imports into StockZip in one click.
Guide
How to set reorder points
Fill the Min column with numbers that actually protect you.
Google Sheets inventory template
Free · opens in Sheets
Get the template