Easy Weekly Meal Planner in Excel: Step-by-Step Guide

Walter Jul 15, 2026

Streamlining your weekly meals just got a whole lot easier with an Excel meal planner. This simple yet powerful tool allows you to organize your meals, grocery lists, and even nutritional information all in one place. Let's dive into a step-by-step guide on how to create your personalized weekly meal planner in Excel.

Free Monthly Meal Planner For Excel
Free Monthly Meal Planner For Excel

Before we start, ensure you have Excel or a compatible spreadsheet program installed. We'll be using Excel's built-in features and some simple formatting to create an efficient and user-friendly meal planner.

Menu Planner
Menu Planner

Setting Up Your Meal Planner

First, let's set up the basic structure of your meal planner. Open a new workbook in Excel and name it "Weekly Meal Planner". In the first row, from A1 to G1, create the following headers: Day, Meal Type (Breakfast, Lunch, Dinner, Snacks), Meal, Recipe Name, Time, and Groceries Needed.

How to Make Editable Digital Printable Meal Planners for Free
How to Make Editable Digital Printable Meal Planners for Free

Freeze the top row for easy navigation as you fill in your meals. To do this, click anywhere in the data range (A1:G1), go to the "View" tab, and click "Freeze Panes". Select "Freeze Top Row".

Setting Up Days and Meals

Meal Planner Spreadsheet – Plan Your Week with Excel or Google Sheets
Meal Planner Spreadsheet – Plan Your Week with Excel or Google Sheets

In column A, starting from A2, list the days of the week. In column B, below B2, create a dropdown list for meal types. To do this, select B2, go to the "Data" tab, click "Data Validation", then select "List" from the dropdown. In the 'Source' field, enter "Breakfast, Lunch, Dinner, Snacks" and click 'OK'.

With the cell still selected, click the small black square in the bottom-right corner and drag it down to copy the data validation for the remaining days of the week.

Adding Meals and Recipes

Streamline Your 2026 Meal Planning with Google Sheets Templates
Streamline Your 2026 Meal Planning with Google Sheets Templates

Now that you have your days and meal types set up, start adding your meals. In column C, starting from C2, begin entering your chosen meals for each day and meal type. In column D, link the recipe name to its corresponding URL. To do this, select the cell, type "=HYPERLINK(" and paste the URL, then close with a ")".

Enter the prep time for each meal in column E and any specific groceries needed for that meal in column F. You can sort and filter your planner by meal type, prep time, or groceries using the buttons in the header.

Meal Ideas and Grocery List

141 Free Excel Templates and Spreadsheets | MyExcelOnline
141 Free Excel Templates and Spreadsheets | MyExcelOnline

Once you've filled in your meals, you might find it helpful to have a section dedicated to meal ideas and a printable grocery list. Add two new sheets to your workbook: "Meal Ideas" and "Grocery List".

In the "Meal Ideas" sheet, list out your go-to recipes, how-to's, and any inspiration you find online. In the "Grocery List" sheet, use the 'Remove Duplicates' function (found under the "Data" tab) to compile a master list of ingredients you'll need for the week. Group items by category (e.g., proteins, produce, dairy) for easier grocery shopping.

the printable meal planner is shown in black and white
the printable meal planner is shown in black and white
Comprehensive Meal Planner Spreadsheet for Google Sheets & Excel
Comprehensive Meal Planner Spreadsheet for Google Sheets & Excel
Free Printable Meal Planner (29 Pages)
Free Printable Meal Planner (29 Pages)
a laptop with the title how i use excel for meal planning, grocery lists, and organizing
a laptop with the title how i use excel for meal planning, grocery lists, and organizing
Ultimate Meal Planner Spreadsheet Template for Google Sheets & Excel
Ultimate Meal Planner Spreadsheet Template for Google Sheets & Excel
Free Google Sheets Meal Planning Template with Grocery List
Free Google Sheets Meal Planning Template with Grocery List
Weekly Macro Meal Planner: Excel & Google Sheets Template
Weekly Macro Meal Planner: Excel & Google Sheets Template
Weekly Menu
Weekly Menu
Weekly Meal Planning Spreadsheet With Grocery List
Weekly Meal Planning Spreadsheet With Grocery List

Automating Your Grocery List

To make your grocery list even more efficient, you can automate the process by using a simple formula. In the "Grocery List" sheet, enter the following formula in cell A2: "=IF(LEN(C2)>0, B2 & ": " & C2, "")". Drag this formula down to copy it for the rest of your ingredients. This will list only the items needed and their respective meal.

Now, whenever you update your meals, your grocery list will automatically reflect the changes. Simply select all the data in your "Grocery List" sheet, go to the "Home" tab, and click "Sort & Filter" to group items together.

Congratulations! You've just created a comprehensive weekly meal planner in Excel. By organizing your meals, recipe ideas, and grocery lists all in one place, you'll save time, reduce food waste, and make meal planning a breeze. Happy cooking!