Pantry Inventory — Google Sheets Template
One-Minute Summary
This Google Sheets pantry inventory spreadsheet lets you track dry goods, canned items, spices, and other non-perishables. Organize by category, add quantities and expiration dates, and check the list before you shop. Make a free copy to your Drive. Reduces duplicate purchases, cuts food waste, and makes meal planning easier when you know exactly what you have.
Preview & Access
Make a Copy (Google Sheets)How to Access
- Click the button above
- Sign in to Google (free)
- The template opens in your Drive
- Edit, share, or download as needed
What’s in this template
This Google Sheets pantry inventory uses category-based organization. Each section (Grains, Canned Goods, Baking, Spices, Oils, etc.) has a header and rows for items. Optional columns for Quantity and Expiration Date. Simple structure — no complex formulas, just a clear list you maintain over time.
Tab structure
Single tab (or multiple): One tab for the main pantry. Optionally add tabs for “Freezer,” “Spice Rack,” or “Emergency Stock” if you keep extras for power outages or emergencies.
Categories included
The default categories match typical U.S. pantry organization: grains and pasta, canned vegetables and beans, baking staples, spices, oils and condiments. Add or remove sections to fit your kitchen.
Key features and use cases
Prevent duplicate buys: How many times have you bought rice, pasta, or canned beans only to find you already had some? This list eliminates that. Check before you shop. Saves money and reduces pantry clutter.
Meal planning support: When you meal plan, you need to know what’s available. “Do I have chickpeas?” — check the sheet. “What needs to be used soon?” — sort by expiration. Plan meals around what you have.
Reduce waste: Expiration tracking ensures you use older items first. No more discovering expired cans in the back. A quick sort by date before meal planning helps you prioritize.
How to customize
Quantity units: Use whatever works — “2 bags,” “1 can,” “3/4 full.” Consistency helps. Some people use “L” for low, “M” for medium, “F” for full instead of exact amounts. Pick a system and stick with it.
Shopping list link: When you identify low items, copy them to your grocery list (or our Grocery List template). Some users add a “Add to list” checkbox — when checked, a formula or manual copy pulls those items into a separate “To Buy” section.
Print for pantry: Print the sheet and tape it to the pantry door. Update on paper during the week, then transfer changes to the digital sheet before shopping. Hybrid approach for those who prefer paper in the kitchen.
Related Templates
- •
- •
Frequently Asked Questions
Is this really free?
Yes. Make a copy and it's yours. No signup, no trial, no watermark. You need a free Google account.
How often should I update it?
At minimum, before each big grocery trip. Ideally, update when you use something (takes 10 seconds). A quick weekly audit (5 minutes) keeps it accurate. More updates = more useful.
What about refrigerator items?
This template focuses on pantry (shelf-stable) items. For fridge items, use our printable pantry/fridge inventory or add a 'Fridge' tab with categories like Dairy, Produce, Leftovers. Fridge items change faster — update more often.
Can I share this with my household?
Yes. Share the sheet with family. When someone uses the last can of beans, they update it. Everyone stays on the same page. Reduces 'I thought we had that' moments.
Do I need to track every single spice?
No. Track what matters to you. Staples like rice, pasta, canned goods are most valuable. Spices are optional — or just list them without quantity if you rarely run out. Tailor the level of detail to your needs.