Pantry Inventory Template

Know what is in the kitchen, what is running low and what expires soon — and get a ready-made shopping list.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Pantry

Fields

13

Views

grid, calendar, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Pantry

13 fields · 8 sample rows

  • Pantry (Grid)
  • Shopping list (Grid)
  • Expiry calendar (Calendar)
  • Kitchen at a glance (Dashboard)
ItemTextCategorySingle selectStorageSingle selectQuantityNumberUnitSingle selectKeep at leastNumberStockFormulaBuyFormulaExpires onDateDays to expiryFormulaFreshnessFormulaPrice per unitCurrencyUsual storeSingle select
Basmati riceGrains & pulsesPantry shelf4.0kg2.0Stocked017 Jul 2027240Fresh₹140DMart
Toor dalGrains & pulsesPantry shelf0.5kg1.0Running low1.519 Mar 2027120Fresh₹170Local kirana
Turmeric powderSpicesSpice rack150.0g100.0Stocked5015 Sep 2027300Fresh₹1Local kirana
MilkDairyFridge1.0L1.0Running low121 Nov 20262Use soon₹66Blinkit
PaneerDairyFridge0.0g200.0Out400₹1BigBasket
Peanut butterCanned & jarsPantry shelf1.0jars1.0Running low116 Nov 2026-3Expired₹350BigBasket
Frozen green peasFrozenFreezer2.0packs1.0Stocked017 Feb 202790Fresh₹120DMart
TomatoesFresh produceFridge1.5kg1.0Stocked0.524 Nov 20265Use soon₹40Farmers market
Field details
Item · Text
Category · Single select
Grains & pulses, Spices, Dairy, Snacks, Beverages, Canned & jars, Baking, Fresh produce and 1 more
Storage · Single select
Pantry shelf, Fridge, Freezer, Spice rack
Quantity · Number
Unit · Single select
kg, g, L, ml, packs, pieces, jars
Keep at least · Number
Stock · Formula
IF({Quantity} <= 0, 'Out', IF({Quantity} <= {Keep at least}, 'Running low', 'Stocked'))
Buy · Formula
MAX(0, {Keep at least} * 2 - {Quantity})
Expires on · Date
Days to expiry · Formula
IF({Expires on}, DATETIME_DIFF({Expires on}, TODAY(), 'days'), BLANK())
Freshness · Formula
IF({Expires on}, IF({Days to expiry} < 0, 'Expired', IF({Days to expiry} <= 7, 'Use soon', 'Fresh')), '')
Price per unit · Currency
INR
Usual store · Single select
BigBasket, DMart, Local kirana, Farmers market, Blinkit

Pantry Inventory Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates