Freezer Inventory Spreadsheet, Kitchen Inventory and Pantry Tracker with Expiration Tracker and Grocery List, Google Sheets Excel

A freezer inventory and kitchen tracker for households that keep finding food at the back of the freezer, or buy what they already have. Type each item once and see what to eat first, what is past its date and what to buy.

🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1W4Bfa_7QDVJRFEBMIglLN4ZA550M2jkcE7Cno7kcKH0/edit?gid=71734479

📊 WHAT IT DOES

✓ Inventory: one row per item with where it lives (freezer, chest freezer, fridge, pantry or your own), the category, how many and when it went in.
✓ Freezer food with no use-by date gets one worked out: the day you froze it plus the months you set.
✓ Each item gets a status that colors itself: Past date, Use soon, Low, Out or OK, with the days left.
✓ Use First: the 20 items with the nearest use-by date, soonest first, so nothing gets forgotten.
✓ See how many items are in the freezers and how long the oldest one has been there.
✓ Shopping List: items at or below the number you want on hand fill in by themselves, next to your own extras.
✓ Tick Got it in the store and the line crosses itself out.
✓ Places and categories are lists you can type over.
✓ Three charts: items by place, every item by state, and what to restock by place.

📂 WHAT'S INSIDE: 4 TABS AND 3 CHARTS

✓ Start here: your kitchen, how many days count as use soon and how long freezer food keeps
✓ Inventory: four cards and every item
✓ Use First: four cards and the 20 items to eat first
✓ Shopping List: four cards, what is running low and your extras

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, type how many days count as use soon and how long freezer food keeps.
3. On Inventory, add each item with where it lives, how many and the day it went in.
4. Open Use First before you cook, and Shopping List before you shop.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own kitchen
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this spreadsheet (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No app, no ads, no subscription.
✓ Room for 300 items and 50 extra shopping lines. No year is built in.
✓ Past date means the date has passed, so check it: frozen food stays safe longer but can lose quality.
✓ Formulas are protected, so you can't break anything by accident.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for quick entries on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas.
✓ Free updates for life.

This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.