Excel Weekly Meal Planner 20150618

There is an Excel weekly meal planner on my website, and you can use it to organize your meals, and create a shopping list. I hadn’t used it for quite a while, and after opening it this week, I decided it was time for an update.

Excel Weekly Meal Planner http://blog.contextures.com/

The Old Version

In the old version, the meals were entered in a long list, and you could choose up to 3 items for each meal.

The system worked, but it wasn’t ideal. In the meal entry sheet, there wasn’t even a spot to indicate which meal you were planning, if there were 2 or more meals on the same day.

.excelmealplan04

The New Version

In the new version, the layout is set up for 3 meals, and snacks, with a separate column for each weekday.

Within each meal block, there are 5 cells with drop down lists, so you have more room to enter meal items.

excelmealplanner01

Grocery Items and Costs

Another change to the new version is that you can enter the food costs too. Based on the meal items you selected, and the food costs on the ingredients sheet, the weekly grocery cost can be calculated.

If an item wasn’t selected for the current week’s meals, its quantity and cost are zero.

excelmealplanner02

The Shopping List

The shopping list still works the same – just click a button and it updates the pivot table with the grocery items for the week’s meals.

But now the shopping list will show the costs too, so you can bring enough money to the grocery store, when you go shopping.

excelmealplanner03

Download the File

To download the sample file, go to the Excel Meal Planner page on my Contextures website. The file is in xlsm format, and contains macros that create the shopping list. After you unzip the file, be sure to enable macros, if you want to use the shopping list feature.

If you have any ideas for the next version of the weekly meal planner, please let me know.

Excel Weekly Meal Planner http://blog.contextures.com/

__________________

You may also like...

3 Responses

  1. Kalika Neal says:

    I love this template but one improvement would be the option to add misc. items without cluttering up the meal items tab. Things like cooking spray, butter, condiments, etc. that may not always be called for in a recipe but will be needed. Also, non-food items such as toilet paper, laundry detergent and cleaning supplies are always on my list. I’ve tried to adjust the pivot table without success, as my excel skills are just beyond beginner. Adding these would make a complete list for everything I need. Thanks!

  2. Bhupendra says:

    This is fantastic use of Excel. Brilliant piece of sharing

  3. Brook says:

    Thank you so much for this. It is perfect and Exactly what I had been trying to build with no success. Thank you again!!!

Leave a Reply

Your email address will not be published. Required fields are marked *