Pantry Inventory Spreadsheet
For households that want to know what's in the pantry before heading to the store. Track staples, how many you like to keep on hand and expiration dates to cut down on duplicate buys and waste.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| Spaghetti, 1 lb | Pasta & Grains | Pantry Shelf 2 | box | 4 | 3 | auto | 1.5 | auto | Neighborhood Grocery | 2027-02-01 |
| Diced Tomatoes, 28 oz | Canned Goods | Pantry Shelf 1 | can | 6 | 4 | auto | 1.89 | auto | Neighborhood Grocery | 2026-10-15 |
| Extra Virgin Olive Oil, 1 L | Oils & Vinegars | Cabinet by Stove | bottle | 1 | 1 | auto | 11.99 | auto | Warehouse Club | 2026-08-01 |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Set a 'keep at least' number for staples like pasta, rice and canned tomatoes and add them to the grocery list when you hit it.
- Rotate cans by bringing older ones to the front after each shopping trip.
- Do a quick five-minute pantry check before writing each week's meal plan.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateBrewery Inventory SpreadsheetFood Pantry Inventory TemplatePizza Shop Inventory TemplateWinery Inventory Spreadsheet