An Excel weekly meal planner is a worksheet that lays out meals by day, helps you turn those meals into a shopping list, and gives you a place to track practical details such as servings or prep tasks. In Microsoft Excel for Microsoft 365 on Windows, start with a blank workbook, put the seven days across the top and meal types down the side, then fill in the meals you plan to make.
What a weekly meal planner can do
A spreadsheet planner is useful because it keeps decisions that are often scattered across notes, recipes, and shopping reminders in one place. A simple grid can answer the main question—what is for dinner on Thursday?—while additional columns or worksheets can help with planning around leftovers, ingredients, food preferences, and time available for cooking.
Excel does not provide one universal weekly meal-planner layout that everyone must use. You can make a small, printable plan or build a workbook with separate recipe and shopping-list sheets. The right level of detail depends on how you shop and cook. If you only need to remember dinners, a seven-column grid may be enough. If you want to coordinate breakfasts, lunches, and snacks too, add those as rows.
A planner is a decision aid, not a nutrition assessment or food-safety system. It can help you notice that several meals use the same ingredient or that a busy evening needs a quick option, but it cannot determine whether a menu meets an individual’s medical or dietary needs.
Set up the weekly grid in Excel
For a practical first version, open a blank workbook and create a sheet called Meal Plan. Use this layout:
- Put Meal in cell A2 and the days of the week in B2:H2.
- Put Breakfast, Lunch, Dinner, and Snack in A3:A6.
- Enter one planned meal in each matching day-and-meal cell, such as Thursday Dinner in E5.
- Use a separate row or notes column for reminders such as thaw chicken, pack lunch, or use leftover rice.
To make the headings easier to read, select the day-heading cells and use Home > Bold, then choose a fill color from Home > Fill Color. You can widen columns by dragging the boundary between column letters, or select the columns and use Home > Format > AutoFit Column Width. Turn on text wrapping for meal cells with Home > Wrap Text so a longer dish name can appear on more than one line.
For a week that starts on a date rather than a named weekday, put the starting date in B1 and enter the remaining dates in C1:H1. You can type the dates directly or use the fill handle to extend a sequence. Format selected date cells from Home > Number Format using a date format that is easy to scan. The weekday names can remain in row 2, so the plan shows both the day and the calendar date.
To keep the layout readable on screen, select the first day column and choose View > Freeze Panes > Freeze Panes if you want the meal labels and headings to remain visible while scrolling. The command freezes rows above and columns to the left of the active cell, so select B3 first to keep rows 1–2 and column A in view. Freeze Panes is available in Excel for Microsoft 365 on Windows; Excel for the web has its own View controls, and the available options can vary by browser experience.
Choose the right amount of detail
A planner should reduce work, not create another chore. Before adding fields, decide what is currently difficult: remembering dinner, using food before it spoils, packing lunches, or coordinating several people. Then add only the information that helps with that problem.
- Basic plan: meal names in a weekly grid. This suits someone who wants a quick visual reminder.
- Prep-aware plan: add a short prep note beside each day, such as soak beans or chop vegetables.
- Household plan: add a servings note or a column for who is responsible for cooking.
- Shopping-focused plan: add a separate ingredient list grouped by grocery category.
- Flexible plan: mark some meals as options rather than fixed appointments, leaving room for leftovers or schedule changes.
Keep recipe instructions out of the weekly grid if they make it crowded. Record a short meal name in the plan and store full recipes on another worksheet, in a linked document, or in a source you already use. A clear name such as lentil soup with bread is usually more useful in a calendar cell than a long recipe title or a list of every ingredient.
Make a shopping list that matches the plan
Create a second worksheet with a name such as Shopping List. Use columns for Ingredient, Quantity, Unit, Category, and Purchased. Add one row for each item you need to buy, then sort or filter the list by category so produce, dairy, pantry goods, and frozen items can be reviewed together. To turn on filters, select the header row and choose Data > Filter. Use the filter arrows to show one category at a time, or sort the category column to group similar items.
Write quantities and units consistently. For example, record 2 cans of tomatoes as quantity 2 and unit cans, rather than combining the number and unit in different ways on different rows. If two recipes both require the same ingredient, combine the amounts only when the units are compatible. Two cups and 300 grams should not be added as though they were the same unit. Check the recipe, package size, and what you already have before buying.
A shopping list does not automatically become accurate just because it is in a spreadsheet. A meal plan can name an ingredient without specifying how much is required, and recipes may have different serving sizes. Review each recipe and adjust the quantity for the number of people eating. Also check the pantry and refrigerator: the planner can remind you what the recipes call for, but it cannot know what you already own unless you maintain a separate, current inventory.
Use simple formulas and helpful formatting
A formula can provide a quick check that planned meals have been entered. With meal names in B3:H6, where the 28 cells represent four meal types across seven days, enter =COUNTA(B3:H6) in a summary cell. If 21 cells contain meal names and the remaining seven are blank, the result is 21. COUNTA counts nonempty cells, so a cell containing a note or placeholder also counts; use actual meal names in the grid if you want this number to represent planned meals.
You can use formatting to make exceptions visible without adding complicated calculations. For example, type Prep needed in a note cell when a task must happen in advance, or use a consistent color for meals that take little time. If you apply color, include text or another cue too; color alone may be hard to distinguish for some readers and does not explain what the color means.
For a shopping list, you can select the Purchased column and use Home > Conditional Formatting > Highlight Cells Rules > Text that Contains to make a chosen status stand out, if you enter text such as Yes when an item is bought. Conditional formatting changes appearance; it does not check whether the correct ingredient or quantity was entered. For a beginner template, ordinary filters and clear headings often provide more value than a large set of formulas.
Plan for leftovers, time, and changing schedules
One common planning mistake is assigning a new recipe to every meal. That can create too much cooking and too many ingredients to manage. Instead, deliberately plan a leftovers meal after a dish that makes extra portions, or schedule a second use for an ingredient. For example, roast vegetables on Monday and plan to add the remaining vegetables to Tuesday’s grain bowls. Note the intended reuse in the planner so the leftovers do not become an afterthought.
Match meals to the time and energy available on each day. A slow-cooked dish may suit a day when you can prepare it early, while a short pasta meal or a prepared component may be more realistic after a late appointment. If the schedule is uncertain, label one dinner as flexible and keep a few reliable pantry or freezer options available. A plan is meant to support real life; changing it is not a failure.
Consider storage and food handling when planning leftovers. Follow reliable food-safety guidance for prompt refrigeration, storage time, and reheating, and use appliance instructions where relevant. The spreadsheet is not a timer or a guarantee that food is safe. If you are unsure how long a food has been stored or whether it was handled appropriately, do not rely on a cell in the workbook to settle that question.
Save, print, and reuse the workbook
Save the file with a useful name, such as Weekly Meal Planner.xlsx, in a location you can find again. To reuse the plan, duplicate the worksheet: right-click its sheet tab, choose Move or Copy, select Create a copy, and confirm. Rename the copy for the new week and replace the dates and meals. Keeping a previous week can help you remember meals that worked, but remove outdated shopping items rather than carrying them forward automatically.
For a paper copy, choose File > Print and review the print preview before printing. A seven-day grid can be too wide for a portrait page, so try landscape orientation and adjust scaling or margins in the print settings. Check that text remains legible; shrinking a crowded worksheet to fit one page can make it difficult to read. Excel for Mac has comparable print controls, though some dialog labels and locations differ from Windows. Excel for the web also offers printing, but page layout options may be more limited than the desktop application.
If the workbook is shared, save it in OneDrive or SharePoint and use Excel’s sharing controls so household members can view or edit the same file. Agree on how changes are recorded—for example, whether an empty cell means no plan or a meal still to be chosen. Avoid putting sensitive personal information in a broadly shared workbook.
Excel compared with apps and printable planners
Excel is a good fit when you want a layout you can customize, sort, print, or extend with a shopping list. It also makes it easy to keep several weeks in one file. Its trade-off is that you must build and maintain the structure yourself. A spreadsheet will not necessarily import recipes, calculate nutrition, or automatically know what is in your kitchen.
A dedicated meal-planning app may be more convenient if you specifically need recipe importing, meal suggestions, grocery-list syncing, or nutrition features. Those features depend on the app and may require an account or paid plan, so check its current terms and privacy details. A printable planner is simpler if you prefer handwriting and do not need searchable records. Neither choice is automatically better: select the format that fits how you actually plan and shop.
Common problems and practical fixes
- The sheet feels crowded: plan fewer meal categories, shorten meal labels, and put recipe details elsewhere.
- The shopping list misses items: compare every planned recipe with the list and check quantities before shopping.
- Plans are abandoned midweek: leave room for one flexible meal, a leftovers night, or a quick backup.
- Copied weeks contain stale information: update dates, ingredients, and prep notes instead of assuming last week still applies.
- People cannot tell what is unfinished: define a simple status such as blank, planned, or purchased, and use it consistently.
Another misconception is that a more automated workbook is always a better planner. Automation can help with repetitive tasks, but a complicated workbook can be harder to update than a plain grid. Start with the smallest layout that solves the real problem. Add a feature only when you can explain what decision it improves and how you will keep its underlying data accurate.
Frequently Asked Questions
How do I make a weekly meal planner in Excel?
Enter the days of the week across the top of a worksheet and meal types down the left, then fill in the cells with planned meals. Add a separate shopping-list sheet if you want to track ingredients.
Does Excel have a built-in meal-planner template?
Excel may show templates through File > New, and available templates can change over time. Search there for meal-planning or weekly-planner templates, then check that the layout suits your needs before entering information.
How can I make a grocery list from an Excel meal plan?
Create a separate list with ingredient, quantity, unit, and category columns. Review the recipes in the plan, enter the required items, combine only compatible quantities, and check what is already at home.
Can Excel automatically create a shopping list from meal names?
Not from meal names alone. Excel would need structured recipe and ingredient data, plus a way to connect each planned meal to its ingredients. For a simple workbook, entering and checking a separate list is often the most dependable approach.
Can I print an Excel meal planner?
Yes. Use File > Print to preview the sheet, then adjust orientation, margins, or scaling so the week fits while remaining readable. A landscape page is often more suitable for a seven-day grid.
Should I plan every meal for the whole week?
Only if that level of planning helps. Many people plan dinners and a few lunches, while leaving breakfasts, snacks, or one dinner flexible. Choose a routine you can maintain and revise it when your schedule changes.
Related
- Excel To-Do List Examples and Simple Templates
- Excel Text Number Format: How It Works and When to Use It
- Excel Text Filters: How to Find Matching Rows Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert Data From Image in Excel: A Step-by-Step GuideTo insert data from an image in Excel for Microsoft 365 on Windows, open the worksheet, choose Data…
- Excel Table With Headers on the Side: What Actually WorksNo—an Excel Table has a header row across the top; it cannot use a column on the left…
- Excel Shortcut Keys: Learn the Essentials and Work FasterTo learn Excel shortcut keys, start with a small set you will use every day: Ctrl+C and Ctrl+V…
- How to Add a Shared Mailbox in Microsoft OutlookTo add a shared mailbox in Outlook, first ask your Microsoft 365 or Exchange administrator to grant your…
- Large Excel File Won’t Open? Causes and Practical FixesIf a large Excel file won’t open, first copy it to a local drive, close other programs, and…
- Split Cell Data Into Columns in Excel: Best MethodsTo split cell data into multiple columns in Excel for Microsoft 365 on Windows, select the cells, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.