Meal Planner Spreadsheet for Google Sheets and Excel

MEAL PLANNER SPREADSHEET FOR GOOGLE SHEETS AND EXCEL

A meal planner spreadsheet with a grocery list and the real cost of every dish. It prices each dish from what you actually pay for groceries, then builds the shopping list from the menu minus your pantry.
Works in any currency; the file only ever divides pack prices into cost per serving.

📊 WHAT IT DOES

✓ Plan: pick a dish for each meal and see the cost of the day as you go.
✓ Shopping list: the week's menu minus your pantry — what to buy and what it comes to.
✓ Pantry: what's already in the cupboard, fridge and freezer, priced, and taken off the list first.
✓ Cost per serving: every dish you cook, cheapest plate first, against the same plate bought ready.
✓ Grocery log: one line per receipt, so the gap between the plan and the receipts shows up early.
✓ Grocery budget: what's left to spend this month, and where it ends up if nothing changes.
✓ Prep plan: everything in the week that keeps, gathered into one cooking session.
✓ What to cook: the cheapest, the quickest, and what's about to go bad — answered without typing anything.

📂 WHAT'S INSIDE: 35 TABS AND 84 CHARTS

✓ Start with these: Home, Start here, Setup
✓ Describe it once: Ingredients, Recipes, Recipe items, Pantry
✓ Fill in weekly: Plan, Shopping list, Grocery log, Eating out, Price book
✓ What it costs: Cost per serving, Week cost, Grocery budget
✓ Where it goes: Spend by category, Spend by store, Price trend
✓ The food itself: Prep plan, Menu month, Rotation, Ratings
✓ What is left: Leftovers, Freezer
✓ The big picture: Seasonal, Year, Home vs out, Savings
✓ Deciding: What to cook, Guests, Review
✓ Keeping it going: Check-in, Notes, Read me, Free gift

📝 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, fill in the shaded cells: your name, people at the table, your grocery budget and your shopping day.
3. Add what you buy on Ingredients, what a dish is made of on Recipe items, then pick meals on Plan each week.
4. Everything else fills in by itself. Home shows the week ahead, the average plate and what's spent so far.

📥 WHAT YOU GET

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

💻 GOOD TO KNOW

✓ Works with a free Google account. No add-ons, no subscription, no bank connection.
✓ Type only in the shaded cells. Formulas are protected, so you can't break them by accident.
✓ Best on a computer. The Google Sheets app works for quick entries on your phone.
✓ Amounts show in dollars. The formulas work the same in any currency.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.