Meal Planning Template: Weekly Meal Planner with Automatic Shopping List (Google Sheets)

Pick your meals for the week and the shopping list writes itself. This Google Sheets template turns a simple weekly plan into a complete shopping list, with quantities scaled to how many people you're cooking for, added up across the week and sorted by supermarket aisle.

How it works

1. Add your recipes and their ingredients, or start with the 24 sample recipes.
2. Choose a recipe for each meal from the dropdowns on the Week Plan.
3. Open the Shopping List. It's already done.

What it does for you

• Scales every recipe to the number of people you're feeding, or to a custom number of servings for a meal
• Adds up the same ingredient across the week, so three recipes that use onions become one line
• Takes off what you already have using the Pantry tab
• Sorts by aisle in the order you shop, and you can change the aisle order
• Rounds tins, packs and pieces up to whole numbers
• Handles leftovers and eating out: choose them for a meal and nothing is added to the list
• Shows prep time for each day and the whole week
• Tick items off as you shop and add extras like kitchen roll

What's inside

• Week Plan: 7 days × breakfast, lunch, dinner and snack, with servings for each meal
• Shopping List: builds itself, with Needed, In pantry and To buy columns plus an Extras list
• Recipes: a library for up to 150 recipes, with meal type, servings, prep time and notes
• Ingredients: up to 1,000 ingredient rows, with a Check column that flags anything missing
• Pantry: up to 100 items you already have
• Lists: your units, meal types and aisle order
• 24 sample recipes and a filled-in sample week to show how it works
• A Start Here guide with step-by-step set-up instructions

Format

• Delivered as an .xlsx file. Upload it to Google Drive and save it as a Google Sheet in a few clicks; the Start Here guide walks you through it.
• Use it in the Google Sheets app on your phone once set up.
• Also opens in Microsoft Excel and LibreOffice Calc. No macros, no add-ons, no subscriptions.
• Instant digital download. No physical item is shipped.

Good to know

This is a planning and shopping tool. It doesn't count calories or nutrients and doesn't give dietary or medical advice. The sample recipes are general examples; check labels for allergens and follow food safety guidance.

Licence

Personal and household use. Make as many copies as you need for yourself and share your working copy with the people you live with. Reselling or sharing the template is not permitted. See the included licence (VX-HLTH-03) for full terms.

Google Sheets is a trademark of Google LLC and Microsoft Excel is a trademark of Microsoft Corporation. This product is not affiliated with or endorsed by either company.