ELSE COURT

Home › Home & Seasonal › Meal Planner Spreadsheet with Weekly Menu & Grocery List

The Meal Planner, a weekly meal planner spreadsheet for Excel and Google Sheets. A preview of the dashboard shows meals planned, the cost of the menu, what is left to buy, the weekly budget and food to use soon. Tabs: Week, Grocery List, Recipes, Ingredients, Dashboard.

Meal Planner Spreadsheet with Weekly Menu & Grocery List

Planning meals takes less effort when the shopping list builds itself. In the Meal Planner you type your recipes and ingredient prices once, then choose what to eat on a one-page weekly menu.

The Grocery List is created from that menu: quantities are added up across all recipes, what you already have at home is taken off, and the rest is grouped by category with an estimated cost. Tick items as Bought while you shop.

It is a digital download for Excel and Google Sheets, made for anyone who cooks at home and wants a simple weekly routine.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Who it's for

How it works

  1. Set the number of people and your weekly budget on Start Here (optional).
  2. Add your ingredients with unit and price, then your recipes and their ingredient lines.
  3. Choose a recipe for each meal on the Week tab.
  4. Open the Grocery List, filter what is still to buy and tick items as you shop.

See inside

Meal planner dashboard with 8 tiles (meals planned, menu cost, still to buy, budget, budget left, items to buy, use soon, data warnings), a ring of meals by type, menu cost by day, still to buy by category, the most expensive items, today's menu and the week at a glance.Week tab: a printable menu for seven days with breakfast, lunch, dinner and snack. Choose a recipe for each meal, set the servings, and see the cost of every day plus optional calories, protein, carbs and fat per person, and a notes row.Grocery List tab built from the weekly menu: category, item, quantity needed, unit, amount on hand, quantity to buy and estimated cost, with a Bought column to tick as you shop. Items are grouped by category, and a box for extra items sits next to the list.Recipes tab, your recipe book: name, meal type, servings, minutes, optional calories and macros, notes, the cost of each recipe, the cost per serving, servings planned this week, and an optional rating, difficulty and link. Room for 100 recipes.Ingredients tab: name, category, unit, price per unit and amount on hand, with the quantity needed this week, the quantity to buy and the cost. Food already in your pantry comes off the grocery list, and an optional expiry date flags what to use soon. Room for 300 ingredients.Recipe Lines tab: one line per ingredient. Choose the recipe, choose the ingredient, type the quantity for the whole recipe. The unit, the line cost and a data check are filled in for you. Room for 1,000 lines, sortable and filterable.The 7 tabs of the Meal Planner (Start Here, Dashboard, Week, Grocery List, Recipes, Recipe Lines, Ingredients) and three steps: download, add your recipes, plan your week. No form, no sign-up, no macros, instant digital download.

Frequently asked questions

Do I need to enter all my recipes first?

You build it as you go. Start with a few recipes and ingredients you use often; the book holds up to 100 recipes and 300 ingredients.

Are the nutrition numbers included?

No. Calories and macros are optional and are calculated only from the numbers you type. This is not nutrition or health advice.

Does it work in Google Sheets?

Yes. The PDF guide includes a link to make your own Google Sheets copy. The Excel and Google Sheets versions are separate files.

Is there an example file?

Yes. A second Excel file is filled with a sample week, 20 recipes and 46 ingredients.

More in Home & Seasonal

The Christmas Gift Tracker spreadsheet for Excel and Google Sheets, with room for 300 gifts. A dashboard preview shows days to go, gifts in hand, spent, budget left and the next date, with labels for Idea, To buy, Ordered, Bought, Wrapped and Given.
Christmas Gift Tracker & Holiday Budget SpreadsheetPlan gifts, budgets and purchases for everyone on your list.

Ready to get organized?

View on Etsy