Skip to content
Free tool · No signup

Free inventory tracker table

A ready-made stock list you can fill in right here. Item, category, units held, unit price and last restock date, with your stock value totalled as you type.

Saves in this browserEditable columnsCSV and JSON exportNo account

What each column is for

Seven fields do the work of a full inventory system. Rename any of them, change the type, or add your own in the Structure tab.

TextItem nameWhatever you actually call it out loud, not a catalogue code you have to look up first.
ListCategoryA short dropdown so you can group and scan. Edit the options to match what you stock.
NumIn stockUnits held right now. This is the figure worth updating whenever stock moves, not at audit time.
NumUnit priceTurns a list of things into a number you can put in a set of accounts or an insurance claim.
DateLast restockedThe single best signal of what is moving and what has been sitting on the shelf for a year.
Yes / noReorderTick anything running low. The stats row counts them, so you never scroll to find them.
NoteNotesSupplier, shelf, batch, anything that has no column yet. Give it a column once you write it twice.
Your ownAdd a columnSKU, supplier, reorder level, storage location or expiry date. Structure tab, Add column, pick a type.

How to use it

The table already holds two example rows so you can see the shape of it. Type over them, or delete them and start clean.

01Add one row per itemOne row per SKU or product, never per unit. Use the count column for quantity.
02Fill in count and priceStock value totals underneath as you type, so you always know what the shelf is worth.
03Shape the columnsOpen Structure to rename, reorder, retype or add fields. Existing rows keep their values.
04Export when you need itCSV for Excel, Numbers or Google Sheets. JSON keeps the column structure as well as the data.

What to track in an inventory list

What earns a column, and what quietly kills the habit of updating it.

A useful inventory list answers three questions quickly: what do I have, how much of it, and what is it worth. Everything beyond that is optional detail, and adding too much of it is the usual reason people stop updating a stock list at all.

The five fields worth having in almost every case are:

  • Item name that matches what you actually call it out loud, not a catalogue code you have to look up.
  • Category, so you can group and filter. Keep the list of categories short enough to remember.
  • Quantity in stock, updated whenever stock moves rather than at a monthly audit.
  • Unit price, which turns a list of things into a number you can put in a set of accounts or an insurance claim.
  • Last restocked date, the single best signal of what is moving and what is sitting still.

Fields worth adding for a business rather than a home inventory: supplier, reorder level, storage location and SKU. Add them in the Structure tab rather than trying to squeeze them into the notes column.

Who this suits

  • Small shops and market stalls keeping track of what is on the shelf between stock takes.
  • Home inventories for insurance, where the value column matters more than the count.
  • Workshops and makers tracking parts, filament, timber or components.
  • Offices logging equipment, licences and consumables.
  • Anyone testing whether they need inventory software at all before paying for it.
📦

Want this on your iPhone?

This table lives in one browser. Pocket Tables gives you the same stock list, plus any other personal database you want to build, on the phone that is already in your pocket.

  • ✓Every column type here, plus photos and links
  • ✓Synced across your devices and backed up
  • ✓Works offline, no account required
  • ✓Build any table you like, not just this one

Download on the App Store

About this tool

This inventory tracker runs entirely in your browser. Rows, columns and totals are held in this device’s local storage, so nothing is uploaded, nothing is shared and no account is created. Clearing your browsing data, or opening the page on another device or browser, gives you a fresh table — export to JSON first if you want to carry your work across.

Common questions

Is this inventory tracker really free?

Yes. There is no signup, no trial period and no cap on rows. It is a free browser tool from the team behind the Pocket Tables iPhone app.

Where is my inventory data stored?

In your browser’s local storage on this device only. Nothing is sent to a server. That also means clearing your browsing data, or opening the page on a different device or browser, gives you a fresh table.

Can I add my own columns, like supplier or SKU?

Yes. Open the Structure tab, choose Add column, then name it and pick a type: text, number, dropdown, checkbox, date or note. You can also rename, reorder and delete the columns it starts with.

Can I open my inventory in Excel or Google Sheets?

Yes. Choose CSV to download a file that opens directly in Excel, Numbers or Google Sheets. JSON export keeps the column definitions as well as the data.

How is the stock value calculated?

Units in stock multiplied by unit price, summed across every row. It updates live as you type, and ignores rows where either figure is blank.

Can I use this on my phone?

Yes. The table scrolls sideways on a small screen, and the Cards view shows one item at a time with labelled fields, which is easier for entering stock on the move. For something that syncs between devices and stays backed up, use the Pocket Tables app.

Related tools

More free tables from the same set, all saved in your browser.

Monthly budget table →Income and spending in one table, with money in, money out, what is left and your savings rate worked out as you type.
All free tables →The full set of fill-in-the-browser personal databases.
Habit tracker →Tick habits off day by day on a continuous heat map, with streaks counted for you.

Get Pocket Tables →