How to Create a Family Meal Plan in Excel

by Catherine Johnson

Planning your family’s meals for the week can be a confusing and trying experience. Creating a meal plan in Excel makes it easy to manage your shopping list and monitor your family’s nutrition and health. Here is a step-by-step guide for creating a family meal plan in Microsoft Excel.

Open Microsoft Excel. Go to “File” and select “Create New Workbook”.

Click “File” and select “Page Setup”. Under the “Page” tab, go to the page orientation section and choose “Landscape”.

Build the header row. Starting from the left, enter the following titles into each column: Day, Breakfast, Lunch, Dinner, Ingredients

Under the Day column, enter the days of the week into each row.

As you plan your family’s weekly meal plan, enter each meal of the day under the appropriate column in each row. Under ingredients, list all of the ingredients that are needed to prepare the meals for that day.

Print out the meal plan and bring it with you to the grocery store. You can clearly see the ingredients you need to purchase for the week under the last column.


  • check Spend fifteen minutes once a week planning the week's meals for your family. This will make your grocery shopping much easier.
  • check Use the Excel sheet to keep track of what food groups your family is consuming.

Items you will need

About the Author

Catherine Johnson is a freelance writer and designer. Her writings on computer software, electronics, cooking, digital photography, home office productivity, organization, and online technologies have been published by Demand Studios, eHow, Bright Hub, and Associated Content. She has also produced award-winning graphic design, digital images, and websites since 2003.