1 / 20

Plan the week, and your grocery list writes itself

Weekly Meal Planner Spreadsheet

Pick a recipe for each meal and this spreadsheet adds up every ingredient, takes away what you already have, and lists the rest by store section so you can shop in order.

SpreadsheetExcel + Google Sheets8 linked tabsAuto grocery list

$10.99 one time, buy direct

Buy direct · $10.99

Instant download: the spreadsheet (.xlsx) and the free 8-page Quick Start PDF guide, right after you pay.

Buy on Etsy · $12.99

35% off on Etsy: code SAVE35

Pay once, no subscription
No macros, no add-ons
Opens empty, ready for your own recipes
Free 8-page Quick Start PDF guide included

What's in the Weekly Meal Planner

Week Plan

7 days with Breakfast, Lunch, Dinner and Snack rows. Pick a recipe from the dropdown, or type your own like Leftovers or Eat out.

Grocery list that writes itself

In store-section order, with a Got it check mark for each item and an estimated cost. Room for 150 lines.

Pantry

Up to 200 foods with store section, unit, what you have on hand and an optional price. It works out what to buy, rounded up to whole units.

Recipe book

Up to 60 recipes with meal, servings, minutes, calories per serving and a note or link, plus each recipe's cost per batch.

Ingredients

One row per ingredient, up to 400 rows. Pick the recipe, pick the food from your Pantry list and type how much it uses.

Dashboard

Meals planned, items to buy, estimated grocery cost against your weekly budget, average calories a day, a calories-per-day chart and your shopping by store section.

Your own categories

Comes with 4 meal rows, 12 store sections and 19 units. Rename, reorder or add your own and the dropdowns follow.

Start Here

Your household name, the week you're planning and an optional weekly grocery budget.

How it works: 3 steps

List your foods
Add the foods you buy on the Pantry tab, with what you have on hand.
Add your recipes
Your recipes, then one row per ingredient: pick the food and type how much it uses.
Plan the week
Pick your meals on the Week Plan. The grocery list and Dashboard fill in by themselves.

Watch the how-to

See how to set up and use the Weekly Meal Planner, start to finish.

Plus the free 8-page Quick Start PDF guide comes with your purchase.

Built to catch mistakes

A Check column on Recipes, Ingredients and Pantry flags a missing name, a name used twice, a food that isn't on your Pantry list, a missing amount, or a renamed store section. The Dashboard tells you how many rows need a look.

Formulas are protected in Excel, so a stray keystroke can't break them
You type in the lemon cells; the light-mint cells calculate for you
For a new week, change the date on Start Here, clear the meal boxes and pick again
Your recipes stay put from week to week

What you get, how you get it and what you need

What you get

The Weekly Meal Planner spreadsheet (.xlsx) with 8 linked tabs
The free 8-page Quick Start Guide (PDF) with real screenshots: setup, your pantry, recipes, the week plan, the grocery list and the Dashboard
A one-time purchase, no subscription

How you get it

Buy direct: right after you pay, you land on your download page with the spreadsheet and the guide.
On Etsy: open Purchases in a web browser and click Download Files. The Etsy phone app can't download files.
Open it in Excel (desktop), or upload it to Google Drive and use File, then Save as Google Sheets. The guide shows each step.

What you need

Microsoft Excel (desktop), Google Sheets (free) or LibreOffice Calc (free)
No macros, no subscription, no add-ons.

Good to know

Calories are the numbers you type for each recipe, added up for you. It isn't nutrition or medical advice.
Grocery costs are estimates from the prices you enter.
Google Sheets removes the locks when it imports, so type only in the lemon cells.
The photos show a sample week. Your file opens empty, ready for your own foods and recipes.
It's a digital download. Nothing is shipped.

Reviews

The Weekly Meal Planner Spreadsheet doesn't have reviews yet.

Our Etsy shop has 150 reviews with a 4.8-star average.

Read all our reviews on Etsy →

Questions

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and use File, then Save as Google Sheets. Sheets removes the locks when it imports, so type only in the lemon cells. It also works in Excel (desktop) and LibreOffice Calc.

Can I use my own recipes?

Yes. Add up to 60 recipes and 400 ingredient rows. The file opens empty, ready for your own foods and recipes.

Does it take away what I already have?

Yes. Type what you have on hand on the Pantry tab. It works out what you need this week and what to buy, rounded up to whole units.

How do I start a new week?

Change the date on Start Here, clear the meal boxes and pick again. Your recipes stay put.

Can I set a grocery budget?

Yes. Type an optional weekly grocery budget on Start Here, and the Dashboard shows your estimated grocery cost and what's left in your budget.

Who is it for?

Families, couples, meal preppers, students, budget shoppers and anyone who wants a simple plan for the week and a grocery list they don't have to write.

How do I get it after I buy?

Buy direct and you land on your download page right after you pay, with the spreadsheet and the free Quick Start PDF guide. On Etsy, open Purchases in a web browser and click Download Files.

Can I see it before I buy?

Yes. Watch the how-to video on this page to see how it works.