Missing a template? Request it →
№ · Spreadsheets · Home

Plan the week. The grocery list writes itself.

Pick the week's meals from your own recipes and every ingredient adds up, scaled to your household, sorted by store section, with the pantry staples left off.

Google Sheets · Excel .xlsx · Blank + filled example

Language

Instant download. Permanent link in your account.

Instant download. Permanent link in your account. Yours forever, no subscription. Open it live, read‑only.

Meal Planner & Grocery ListWeek
Meal Planner & Grocery List, the Week tab

The week: four meals a day, coloured by what is in them.

The honest split of labour

You pick the meals. It writes the list.

You type

  • Your recipes and their ingredients, once
  • The week’s meals
  • Your household size and pantry staples

It works out

  • The grocery list, added up and scaled
  • Sorted by store section
  • The week’s mix and minutes of cooking
Compared

A plain spreadsheet, and this one.

A plain spreadsheet The planner

A recipe list on one side. The whole week of meals, laid out, on the other.

  1. 1

    Buy it once.

    $29, no subscription. Your order email and your account both carry the download, permanently.

  2. 2

    Copy it into your Drive.

    One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.

  3. 3

    Start in the example.

    The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.

№ · Plan once, shop once

A meal planner spreadsheet that writes the grocery list from your own recipes

The Meal Planner & Grocery List is for whoever does the planning and the shopping for a household and is tired of writing the list twice. On Settings, say how many people you cook for (four to start), the day your week starts, and your store sections in the order you walk the shop. Then build your recipe bank: each recipe on Recipes with its meal type, servings and minutes, and its ingredients on Ingredients, one row each with quantity, unit and store section.

The week, then the list

The Week tab holds four meals a day for seven days, picked from dropdowns of your recipes and coloured by what is in them, with the week’s mix and the minutes of cooking. Open the Grocery List and it is already written: quantities added up across recipes, scaled to your household, and set out as one card per store section, in shop order.

  • The same ingredient in two recipes is one line, added together, when it has the same name and unit in both.
  • Salt, oil and whatever is always in your pantry go on the pantry list and never reach the shopping.
  • Cooking for more one week? Change People and every quantity follows: a recipe for four is doubled for eight.

The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.

Before you ask

The questions we actually get

Does it come with recipes?

The blank copy is for your own recipes. The example copy in the download is filled in, so you can see a planned week and its grocery list working first.

How does the grocery list add things up?

It totals each ingredient across the week's recipes and scales it to the people you cook for. The same ingredient counts as one line when its name and unit match in every recipe.

Can I sort the list by aisle?

Yes. Put your store sections on Settings in the order you walk the shop; the first eight become the cards on the Grocery List, in that order.

How many meals a day can I plan?

Four, for seven days, from dropdowns of your recipes. Meal types such as chicken, vegetarian or breakfast are yours to rename.

Does it work in Excel?

Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable.

Meal Planner & Grocery List

Dinner planned, list written.

Meals and groceries in one place, in Google Sheets and Excel, no subscription, no year baked in.

Get the planner · $29

Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.

№ · Reviews

Be the first to say something.

Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.

Read by a person before it goes up, usually within a day. Your email stays with us and never appears on the page.

Instant download.

Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.

One-time purchase.

No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.

Quiet, secure checkout.

Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.