Weekly Meal Planner in Google Sheets With a Grocery List That Builds Itself
Plan breakfast, lunch, dinner and snacks for the week in Google Sheets, then let a formula turn your ingredients into one grocery list sorted by aisle.
Efficiency Sheets ·

Meal planning saves time and money for one reason: you decide once, on the weekend, instead of standing in front of the fridge every evening. The part most people skip is the grocery list. In Google Sheets, it can build itself from the meals you plan.
The meal grid
Make a grid with days across the top (Sunday to Saturday) and meals down the side: breakfast, lunch, dinner, snacks. Fill in what you'll eat.
The ingredients table
Below the grid, or on a second tab, list every ingredient the week's meals need, with three columns:
- Item (A): chicken thighs, rice, spinach
- Category (B): meat, produce, dairy, grains, canned, frozen
- Quantity (C): 2, 1, 3
The grocery list formula
On a new tab, one formula turns that table into a shopping list, with each item once and quantities added up, sorted by aisle:
=QUERY(Ingredients!A2:C,"select B, A, sum(C) where A is not null group by B, A order by B label sum(C) 'Qty'",0)
If you only want a plain list of unique items, this works too:
=SORT(UNIQUE(FILTER(Ingredients!A2:A,Ingredients!A2:A<>"")))
Add a checkbox column next to the list (Insert → Checkbox) and tick items off in the shop.
A planning routine that sticks
- On Saturday or Sunday, check what's already in the fridge.
- Plan dinners first, using those ingredients.
- Cook once, eat twice: plan leftovers as the next day's lunch.
- Fill in the ingredients and the list builds itself.
- Keep good weeks. A few saved weeks become a rotation you can reuse.
A ready-made version
The Meal Planner has breakfast, lunch, dinner and snacks from Sunday to Saturday, and a grocery list that builds itself from your ingredients, sorted into 10 aisles. It comes with a full example week.
Questions
How much can meal planning save?
It mostly cuts takeout and food you throw away. Many people find their grocery bill drops simply because they only buy what the week's meals need.
Do I have to plan every meal?
No. Planning dinners alone does most of the work. Add breakfasts, lunches and snacks once that's a habit.
Can my partner see the grocery list?
Yes. Share the Google Sheet and the list is on both your phones in the Google Sheets app.
What if the same ingredient is in several meals?
A QUERY formula adds up the quantities, so the list shows it once with the total amount.

The Meal Planner
$7.97 · one-time · instant download