Inventory and warehouse spreadsheet template. Free, and ready to become an app.
Track items, stock levels, reorder points and bin locations alongside the orders, shipments, suppliers and warehouse moves that change them. Download the workbook free. When the counts need to be right for everyone at the same time, describe it to Tadabase AI and it builds the inventory app, with low-stock alerts that actually fire.
Excel · Google Sheets · Numbers · 6 sheets
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
6 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Inventory
Every item with its category, current stock, reorder level, storage location and status.
Item ID · Item Name · Category · Stock Level · Reorder Level · Location · Status
-
Orders
Customer orders against items, with quantities and order and shipping dates.
Order ID · Customer Name · Item ID · Quantity · Order Date · Shipping Date · Status
-
Shipments
Carrier, tracking number and delivery date for every order that left the building.
Shipment ID · Order ID · Carrier · Tracking Number · Shipping Date · Delivery Date · Status
-
Suppliers
Supplier directory with contact person, email, phone and address.
Supplier ID · Name · Contact Person · Email · Phone · Address
-
Warehouse Operations
Receiving, packing and restocking moves, who did them and their status.
Operation ID · Type · Item ID · Quantity · Date · Responsible Person · Status
-
Dashboard & Reports
At-a-glance totals: inventory items, pending shipments and low-stock items, plus a report log.
Metric · Value · Description
Fine for one person. Hard for a team.
Where the spreadsheet starts to cost you time once more people depend on it.
-
Stock does not move by itself
An order or a receipt in one tab does not change the stock level in another. Someone has to remember to update both.
-
Reorder alerts are a colour, not a message
A cell turns red when stock drops below the reorder level, but nobody is told unless they open the file.
-
The floor and the office see different files
Warehouse staff on a phone and buyers at a desk end up with copies that disagree by lunchtime.
Same structure, with logins and automations.
Start from a real prompt, change anything that doesn’t fit, then build it.
Loads this prompt into the prompt box- Inventory and warehouse app An inventory and warehouse app — items with category, bin location, stock level and reorder point; receiving, picking and restocking moves update stock automatically; when an item falls below its reorder point the buyer gets an email with the supplier's details. Warehouse staff use a phone view to log moves, buyers manage suppliers and purchase orders, and managers see a dashboard of low stock and pending shipments.
- Inventory & purchase orders An inventory system that tracks products and stock by warehouse and bin, alerts the buyer when stock falls below a per-item re-order point, and lets staff raise purchase orders to suppliers with an approval step above a spend threshold. Receiving posts against the PO and updates stock automatically, and every product shows a full movement history — receipts, transfers, adjustments, and sales.
- Orders and shipments tracker An order fulfilment app — orders reserve stock when placed, warehouse staff pack and ship them with carrier and tracking number, the customer gets an email when the order ships and when it is delivered, and managers see late shipments on a dashboard.
Starting from Inventory and warehouse app
Opens the builder with your prompt. Free for 14 days, no card needed.
Questions about this template.
Is the spreadsheet template really free?
Yes. It is a normal .xlsx file that opens in Excel, Google Sheets or Numbers. No sign-up is needed to download it.
Can stock update automatically when an order ships or a delivery arrives?
In the app, yes. Describe the rule ("a receipt adds to stock, a shipment takes it away") and the AI builds it as a workflow you can open and read, with the reorder email on top.
Can I bring the data I already have in the spreadsheet?
Yes. Once the app is built, import each sheet into the matching table from a CSV or Excel file. The importer maps your columns to the fields and shows any row it could not bring in, and why.
When should I move from the spreadsheet to an app?
When more than one person edits it, when someone outside your team needs to see part of it, or when you start copying rows between tabs by hand. Those are the points where a spreadsheet starts losing data quietly.
Keep the structure. Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can try it free for 14 days.
- 14-day free trial, no card
- Unlimited app users
- Live on your own domain