A meal planner template in Excel can be a simple weekly grid for meals, a place to track estimated costs, and a companion grocery list. In Microsoft Excel for Microsoft 365 on Windows, start a blank workbook, add columns for each day’s meals, then use a few basic formulas to total costs or count planned dinners; the guide below explains a practical setup you can adapt.
What a meal planner template can include
At its simplest, a meal planner is a table that helps you decide what to eat on particular days. A useful template can also keep recipes, ingredients, preparation notes, and a rough weekly budget together. It does not need macros or complicated formulas to be helpful: a clearly labeled grid that is easy to update is often the best starting point.
Before building one, decide what you want the workbook to solve. If the main challenge is choosing dinners, a dinner-only plan may be enough. If you want to coordinate lunches, breakfasts, leftovers, and shopping, make those separate fields. Adding columns you will not use can make a planner harder to maintain, so start with the minimum and expand only when a real need appears.
Build a basic weekly plan in Excel
In a new workbook, rename the first sheet Weekly Plan. In row 1, enter these headings: Day, Breakfast, Lunch, Dinner, Snacks, Prep and notes, and Estimated cost. In A2:A8, enter Monday through Sunday, one day per row. The remaining cells in each row are for that day’s meals, notes, and optional estimated cost. This arrangement keeps the week visible without requiring a separate worksheet for every day.
- Open Excel and choose Blank workbook. Save it with a recognizable name, such as Weekly Meal Planner.
- Enter the headings and days. Make the headings bold and use Home > Format as Table if you want filter arrows and table formatting. Confirm that the table has headers.
- Adjust column widths so meal names and notes are readable. Turn on text wrapping for longer notes using Home > Wrap Text.
- Enter meal ideas as plain text, or include a recipe name and a link in the notes. Keep the layout consistent so it is easy to scan.
- Save the workbook, then duplicate the sheet for a new week or clear meal entries while retaining the headings and formatting.
For example, Monday’s dinner cell might say Lentil soup, while its notes cell says Cook extra for Tuesday lunch. A meal name is usually more useful than a long recipe pasted into the grid; keep full instructions in a recipe sheet, a document, or a trusted recipe source and use the planner to point to them.
Add useful totals without making the sheet complicated
If you enter estimated costs in G2:G8, use the next cell below the final day for a weekly total. With costs in G2:G8 and the total in G9, enter =SUM(G2:G8) in G9. For an illustrative week with costs of $8.50, $9.00, $7.25, $10.00, $6.75, $11.00, and $12.00 in G2:G8, the result is $64.50. Format the cost cells as currency with Home > Number Format; the displayed currency symbol depends on your regional settings.
A meal count can help you spot gaps in the plan. With dinner entries in D2:D8, enter =COUNTA(D2:D8) in a separate summary cell. If all seven dinner cells contain text, the result is 7; if two are empty, it is 5. COUNTA counts non-empty cells, so a cell containing a space or a formula returning an empty-looking string may still affect the count. For a basic planner, leave unplanned cells genuinely blank.
These formulas work in Microsoft 365 and older Excel versions that support SUM and COUNTA. You do not need a special meal-planning function. If your Excel uses a different regional list separator, formula entry may follow that setting; the examples use the standard comma convention where arguments are needed.
Make a grocery list that matches the plan
A weekly meal grid does not automatically combine ingredients. For a practical first version, add a second worksheet named Grocery List with columns for Item, Quantity, Unit, Recipe or day, and Bought. List each ingredient on its own row. For example, enter chickpeas, 2, cans, Monday dinner, and leave Bought for a check mark or a simple Yes/No entry.
Separate entries can be more useful than immediately trying to combine everything. One recipe might need 1 onion and another might need 2 onions, but adding amounts is only meaningful when the units match. A cup, a can, and a gram are not interchangeable quantities. Check package sizes and recipe instructions before combining items, and distinguish fresh, frozen, and pantry versions when that matters.
For a reusable list, keep planned ingredients in one column and add a separate purchased-status column. You can filter the Bought column to focus on items still needed. On a formatted Excel table, use the filter arrow in the column heading; if filters are not visible, select the data and choose Home > Sort & Filter > Filter. A manual grocery list is often clearer than a formula-generated list when recipes use different units or you want to add household items that are not part of a meal.
Use a recipe catalog and dropdowns
If you repeat meals, create a Recipe Catalog sheet with columns such as Recipe, Main ingredients, Preparation time, and Link. The weekly plan can then use consistent recipe names instead of several spellings of the same dish. A simple option is to copy recipe names into meal cells. For a selectable list, select the cells you want to control, such as D2:D8, then choose Data > Data Validation. Set Allow to List and provide a short comma-separated list of meal names in Source, then select OK.
For a longer list that changes often, put recipe names in a range on the Recipe Catalog sheet and use that range as the validation source. Excel’s data-validation list source has restrictions around references to another worksheet, so a named range is a practical way to point to a list stored elsewhere. On Windows, select the recipe range and use Formulas > Define Name to give it a name; then use that name as the list source. Check the validation dropdown after setup and update the named range if you add recipes outside its original cells.
These dropdowns are optional. They are most useful when multiple people edit the workbook or when consistent spelling matters for sorting and filtering. They can be frustrating if you need to enter a one-off meal that is not in the source list, so keep the source list current or allow users to enter other values where that suits your household.
Choose a layout that fits your routine
There is no single best layout. A weekly grid makes it easy to see the full week, while a long table with one row per meal can be easier to filter or sort. Choose based on how you plan and what you need to find quickly.
- Weekly grid: Best for seeing meals across days at a glance. It is easy to print, but adding several meals or detailed ingredients can make it wide.
- Meal-by-meal table: Use columns for Date, Meal, Recipe, Ingredients, and Notes, with one row for each planned meal. This is more flexible for filtering, but the entire week is less visually compact.
- Separate plan and shopping sheets: Keeps the meal schedule readable and the grocery list focused. It requires you to transfer ingredients, unless you build and maintain a more advanced workbook.
- One sheet per week: Helpful for preserving past plans, but many worksheets can become difficult to navigate. A dated table or a copy of a standard weekly sheet may be easier to manage.
For most households, a weekly grid plus a separate grocery list is a sensible balance. If you plan several weeks at once, put dates in the first column and consider a long table so you can sort and filter by date or meal type.
Formatting, printing, and sharing
Use formatting to make the plan easier to read rather than to decorate every cell. Bold headings, consistent colors for meal types, and wrapped text can help. Avoid relying on color alone to communicate important information: include labels such as Vegetarian or Prep ahead in a notes column, especially if another person will use the workbook.
To make a paper copy, check the page layout before printing. In Excel for Windows, use Page Layout > Orientation to choose landscape for a wide weekly grid, and use Page Layout > Print Area > Set Print Area if you want to print only the plan. Check File > Print for the preview and scaling options; shrinking a large sheet too much can make text difficult to read. Excel for Mac has similar Page Layout and print-preview controls, though their location or wording can vary slightly by release. Excel for the web also supports basic editing and printing, but some desktop layout controls may differ.
If you share the workbook, explain which cells are intended for editing and whether costs are estimates. A shared file can be stored in OneDrive or SharePoint so people with access can work with the same copy. Avoid keeping sensitive personal information in a household meal planner unless there is a clear reason and appropriate sharing permissions.
Common problems and practical fixes
- The plan is too ambitious: Leave room for leftovers, takeout, or an unplanned meal. Planning seven completely different dinners can create extra shopping and preparation work if your schedule is unpredictable.
- The grocery list does not add up: Check units and serving sizes before combining quantities. Ingredient amounts can change when a recipe is scaled, and package sizes vary.
- The sheet is hard to read: Shorten meal names, wrap text, widen the relevant columns, or move recipe details to the catalog sheet.
- The cost total looks wrong: Confirm that the cost cells contain numeric values rather than text. Enter 8.50 as a number, then apply a currency format. Text values may not be included in a SUM total.
- A dropdown does not show new recipes: Check whether the validation source or named range includes the newly added cells.
A meal planner is a planning aid, not a food-safety system. Use safe storage practices and follow current guidance from reliable public-health authorities for refrigeration, cooking, and leftovers. When a household member has an allergy or dietary restriction, verify ingredients and prevent cross-contact; do not rely on a color or an informal note as the only safeguard.
Excel template versus apps and other options
Excel is useful when you want to control the layout, print a plan, keep personal records, or tailor the workbook to a household’s routines. A blank workbook also avoids dependence on features you may not need. Excel may include templates in its New or start screen, but available templates can vary by version, account, and connected services. Search the template gallery for meal or food planning if you prefer to adapt an existing design, and inspect its formulas and fields before relying on it.
A dedicated meal-planning app may offer recipe databases, automatic grocery lists, or mobile reminders, depending on the product. Those conveniences may come with account requirements, subscription costs, or limitations on exporting data; check current terms before choosing one. A notes app or a printed page can be enough if you only need a short list. The key comparison is not which tool has the most features, but which one you are likely to keep updated.
Frequently Asked Questions
Does Excel have a meal planner template?
Excel’s template gallery may offer meal-related templates, but availability can vary. Search from the New or start screen, or create the weekly grid described above in a blank workbook. Review a downloaded or built-in template before using it, particularly if it contains formulas or external links.
How do I make a weekly meal planner in Excel?
Make a row for each day and columns for the meals you want to plan, such as breakfast, lunch, and dinner. Add optional notes and estimated costs, then create a separate grocery-list sheet if you want to track ingredients. Start with a simple layout and add features only when they solve a recurring problem.
Can Excel automatically create a grocery list from my meal plan?
A basic weekly grid does not know which ingredients belong to each meal, so it cannot create a reliable list by itself. A more advanced workbook can connect recipe data to planned meals, but quantities and units need careful organization. For many users, entering ingredients on a separate list and checking them against recipes is more dependable.
How do I total meal costs in Excel?
Enter each day’s estimated cost as a number in a cost column. If those values are in G2:G8, put =SUM(G2:G8) in G9 to calculate the total. Format the result as currency, and remember that the figure is only as accurate as the prices and portions entered.
Can I use the same template every week?
Yes. Keep a clean master sheet, then make a copy for each new week or clear only the meal entries after saving a dated copy. This preserves the headings and formatting while keeping previous plans available if you want to repeat meals.
Related
- Job Task List Template in Excel: How to Build and Use It
- Jump to a Row Number in Excel: Go To, Name Box, and More
- Just Saved Excel File? Where to Find It and Recover It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Will Google Sheets Get Power Query? What to Use InsteadNo—Google Sheets does not currently have a built-in version of Microsoft Power Query, and Google has not announced…
- Highlight Duplicates in Excel: A Step-by-Step GuideTo highlight duplicate values in Excel for Microsoft 365 on Windows, select the cells to check, then choose…
- Excel Data Validation Multi-Select Drop-DownsExcel’s Data Validation drop-down allows only one selection per cell by default. To keep adding selections in the…
- How to Hide Rows in Excel: Keyboard Shortcuts GuideIn Excel for Microsoft 365 on Windows, select a cell in the row or rows you want to…
- Excel Open Shortcut Keys for Windows and Mac UsersIn Excel for Microsoft 365 on Windows, press Ctrl+O to open the Open screen, or press Ctrl+F12 to…
- Excel Column A Hidden? How to Unhide ItIf column A is missing in Excel, select the column header immediately to its right, then choose Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.