Weekly Meal Planner Template with Grocery List

Answer “what’s for dinner?” once a week, not every night. This weekly meal planner spreadsheet lets you plan breakfast, lunch, dinner and snacks for seven days from your own recipe library — and it builds the grocery list for you, scaled to the number of people you feed and sorted by store aisle. Use it as a ready-made weekly meal planner template in Excel or Google Sheets.

Who this template is for

• Families planning weekly dinners
• Meal preppers and budget shoppers
• Anyone tired of the daily what's-for-dinner question

Features

• 7-day meal plan with breakfast, lunch, dinner, snack and notes for each day
• Drop-downs that list your own recipes (or type anything, like “Leftovers”)
• Recipe library with meal type, prep time and servings
• Ingredients list per recipe with amount, unit and aisle
• Automatic grocery list: amounts scaled to your household, the same item from different recipes added together, grouped by aisle
• Checkboxes to tick items as you shop, plus an Extras column for household items
• Weekly stats: meals planned, total cooking time, grocery items and different recipes
• Today’s row highlighted; 18 sample recipes to get you started

How to use it

1. Add your favorite recipes and their ingredients (or keep the samples).
2. Pick the week’s start date and how many people you are feeding.
3. Choose a meal for each slot from the drop-down.
4. Open the Grocery List and go shopping.

What’s included

• Weekly Meal Planner (.xlsx) with Meal Plan, Grocery List, Recipes and Ingredients tabs
• “Start Here” guide with simple instructions in plain English

Compatibility

Works in Microsoft Excel (2016 or later, Microsoft 365, Mac) and Google Sheets. No macros.

FAQ

Can I use it every week? Yes — change the start date and the meals, and the grocery list updates.

Do I have to enter ingredients? Only if you want the automatic grocery list. The meal plan works on its own.

Can I print it? Yes, the meal plan and grocery list are print-ready.

Does it work in the free version of Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.

Can I use it on a Mac, iPad or phone?

Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.

How do I get the file?

Right after checkout you get a download link on the confirmation page and by email.

More templates like this: Life & Event Planners.

This is a digital product. No physical item will be shipped.