Get this free Excel weekly meal planner, based on the Excel workbook that I use for my menu plans every week. Enter your favourite meals and their main ingredients, and search recipes by ingredient. Click button to create weekly grocery shopping list, and print the weekly calendar to put on your fridge door, for Sunday to Saturday.
To help you make the job of meal planning easier, you can use this Excel weekly meal planner template. Enter your favourite meals, list their basic ingredients, and click a button to create a shopping list for a week's meals. To see a quick overview of how the Excel Weekly Meal Planner works, watch this short video.
Note: For special occasions, see my Excel holiday dinner planner.
The first step is to choose some recipes for your weekly meals. There are a few recipes in the sample file, to get you started.
To find more recipes, you can look through your collection of cookbooks, or find recipes online.
Meal Planner Recipes
To find recipes that use a specific ingredient, you can search the recipes that are already entered on the Meal_Ingredients sheet. For example, you might want to use a specific ingredient from your pantry or fridge, before its "Best Before" date.
After you select your recipes, you will enter them on the Meal_Items worksheet, if they haven't been entered already. There are a few sample items in the Excel weekly meal planner, and you can add new items to the list, at any time.
To add a new recipe:
NOTE: You can also enter items that you purchase weekly, such as "Milk, weekly", or "Coffee, ground". Later, those items can be added to the "Other" row on the weekly menu, so they get added to the shopping list.
After you have entered the recipe names in the spreadsheet, go the Recipe_Ingredients worksheet. Soon, you will be selecting the ingredients for your recipes, and those ingredients should be entered in the cost list first.
To check for ingredients, and add new ones:
Meal Planner with Inventory
If you download the Basic Meal Planner with Inventory, there are
Ingredient Storage Locations
On the Admin_Lists sheet, there's a small table with locations where you might store your ingredients at home. You can edit this list, and add new locations, or delete storage locations that you don't need.
On the Recipe_Ingred sheet, there are location columns at the left side of the Ingredients table.
For any ingredient that you want to track:
In the screen shot below, ground beef is in the fridge freezer, and in the basement freezer, for a total of 3 pounds.
After you have entered the recipe names and ingredient costs, go the Meal_Ingredients worksheet. It has a list where you will enter the main ingredients for each recipe.
NOTE: You don't need to enter ingredients that you usually have on hand, such as salt and pepper, or cooking oil.
Meal Planner with Inventory
If you download the Basic Meal Planner with Inventory, there are additional columns in the Meal_Ingredients table
Those columns have formulas that calculate the amounts for the shopping list. You can ignore those columns and formulas -- they're just used for the shopping list.
NOTE: The On Hand column might not show the total amount that you have on hand. The formula splits the total amount by the number of times that ingredient in used in the current week's menu.
For example, we have 3 pounds of ground beef on hand, and it's used 3 times this week, so each row shows 1 pound in the On Hand column (3 divided by 3 = 1)
After you have entered all the ingredients, you're ready to start the weekly meal planning.
Other Items and Notes
If there are other items to add to the shopping list, enter those in the "Other" row.
After you select each day's meals, click the Shopping List button at the top of the WeekPlan sheet.
Meal Planner with Inventory
If you download the Basic Meal Planner with Inventory, there are two filters at the top of the pivot table - Meal Item, and Need.
There are extra columns in the pivot table too:
After the shopping list has been created, the items are summarized by category, in an Excel Pivot Table. You can print the list, add any other grocery items that you need, and then head to the grocery store.
NOTE: You don't need to read this section, unless you want to know how the macros work in the weekly meal planner.
Shopping List Button
When you click the Shopping List button, it runs a macro, which uses an advanced filter to copy all the ingredients for the selected meals to the ShoppingList sheet, and sorts the printable meal plan shopping list by ingredient name.
Here's how the advanced filter works:
In the sample file, you'll find this code on a regular code module. It creates the shopping list, based on the selected meals.
Sub CreateShoppingList() Dim wsShop As Worksheet Dim wsIngred As Worksheet Dim wsList As Worksheet Dim wsItems As Worksheet Dim wsPrint As Worksheet Set wsShop = Sheets("ShoppingList") Set wsIngred = Sheets("Meal_Ingredients") Set wsItems = Sheets("Meal_Items") Set wsPrint = Sheets("ShopListPrint") wsIngred.Columns("B:J").AdvancedFilter _ Action:=xlFilterCopy, _ CriteriaRange:=wsItems.Range("CritShop"), _ CopyToRange:=wsShop.Range("ExtShop"), _ Unique:=False With wsShop .Cells(1, 2).CurrentRegion.Sort _ Key1:=.Range("C1"), _ Order1:=xlAscending, _ Header:=xlYes End With With wsPrint .PivotTables(1).PivotCache.Refresh .Activate End With End Sub
There are several menu planners, so download the meal plan templates that you need.
Last updated: January 2, 2024 2:44 PM