To make a meal plan spreadsheet in Excel, create a weekly table with columns for date, meal, recipe, servings, and notes, then add a recipe-cost sheet and a grocery list if you need them. In Microsoft Excel for Microsoft 365 on Windows, enter the headings, select the range, and use Home > Format as Table to make the plan sortable and easier to maintain; the same basic design works in Excel for Mac and Excel for the web.
What a meal plan spreadsheet can do
A meal planner is a schedule, not a nutrition prescription. It can show what you intend to eat, when to prepare it, and which ingredients you need to buy. A basic sheet might cover seven days and three meals a day, while a more useful household planner may include snacks, leftovers, recipe links, preparation tasks, or a field for who is cooking.
The main benefit is visibility. You can spot repeated meals, plan around a busy evening, use ingredients in more than one dish, and avoid buying food for recipes that are not on the schedule. The spreadsheet does not automatically guarantee lower spending or less food waste: those results depend on the accuracy of the plan, portion estimates, prices, and what your household actually eats.
Keep the first version simple. If you start with a large nutrition database, elaborate dashboards, and several linked worksheets, maintaining the workbook can take more effort than planning meals. Add detail only when it solves a recurring problem.
Choose a layout that fits your routine
There are two common ways to display the week. A calendar-style grid has weekdays across the columns and meal types down the rows. It is easy to scan and works well when the main goal is seeing the week at a glance. A list-style table has one row per planned meal, with fields such as date, meal, recipe, servings, and notes. It is easier to sort, filter, and extend with cost or preparation information.
For a flexible workbook, use a list as the source of truth and make a separate calendar view only if you want one. A practical Plan sheet can have these columns:
- Date: the date the meal is planned.
- Meal: breakfast, lunch, dinner, or snack.
- Recipe: the dish name, written consistently.
- Servings: the number of portions you intend to make.
- Preparation: a brief task such as thaw chicken or cook rice.
- Notes: leftovers, substitutions, or who is cooking.
Put one meal on each row rather than combining breakfast, lunch, and dinner in one cell. Separate rows make it easier to filter for dinner, identify blank dates, and add calculations later. If dates are stored as real Excel dates rather than typed labels such as Monday, you can sort by date and reuse the workbook for another week.
Set up the workbook in Excel
Create a workbook with tabs named Plan, Recipes, and Grocery. The Plan sheet holds the schedule. On Recipes, record recipe names and any details you want to reuse, such as the source, usual serving count, estimated total cost, or preparation time. On Grocery, collect the ingredients required for the meals you selected. Separate sheets keep the weekly schedule readable while giving reusable information its own place.
On Windows, type headings in the first row, select the headings and several blank rows beneath them, and press Ctrl+T. Check that My table has headers is selected, then choose OK. On Mac, use Insert > Table; the exact shortcut can vary with keyboard settings. Tables expand as you add rows and provide filter buttons in their header cells. Give each table a descriptive name from Table Design, such as PlanTable or RecipeTable, if you later want to use structured references.
Use Data > Data Validation to make a dropdown for a field such as Meal or Recipe. For a small fixed list, choose List and enter the allowed values separated by commas, or point the list to cells containing those values. Dropdowns reduce inconsistent entries such as Dinner, dinner, and Diner, which otherwise make filtering and lookups less reliable. Excel for Mac also has Data Validation; labels and dialog placement may vary slightly by release.
Format the Date column as a date and cost columns as currency. Keep notes as ordinary text. Freeze the heading row with View > Freeze Panes > Freeze Top Row if the table is long. These are presentation choices: number formatting changes how a value appears, not the underlying date or amount.
Add useful cost calculations
If you want a rough meal budget, store an estimated total recipe cost and the number of servings on the Recipes sheet. Cost estimates can come from current package prices and the quantities used, but they should be treated as estimates: prices vary by store, location, brand, package size, and date. Do not mix a recipe’s total cost with its cost per serving.
Assume the Recipes sheet has recipe names in A2:A50, servings in B2:B50, total recipe cost in C2:C50, and cost per serving in D2:D50. With the first recipe in row 2, enter =C2/B2 in D2. If the recipe costs $12 to make and yields four servings, D2 returns $3 per serving. Copy the formula down for the other recipes, checking that servings are greater than zero.
On Plan, assume recipe names are in C2:C22, planned servings are in D2:D22, and Recipes!A2:A50 contains names while Recipes!D2:D50 contains cost per serving. In E2, enter =XLOOKUP(C2,Recipes!$A$2:$A$50,Recipes!$D$2:$D$50,"Not found"). For a recipe named Chili with a $3 cost per serving, E2 returns 3. XLOOKUP is available in Microsoft 365 and Excel 2021 or later; if a workbook will be opened in an older Excel edition, use a compatible lookup method or enter the cost manually. Keep recipe names unique in the lookup list.
With servings in D2 and the returned cost per serving in E2, enter =D2*E2 in F2 to calculate the planned meal cost. If Chili is planned for four servings at $3 each, F2 returns $12. Copy the formula down the Plan table. With meal costs in F2:F22, enter =SUM(F2:F22) in F23 to total the listed meals; if the example contains only the $12 Chili meal and all other rows are blank or zero, the total is $12. This is a planned ingredient-cost estimate, not necessarily the amount paid at checkout, since pantry stock, package sizes, and unused ingredients affect spending.
Turn planned meals into a grocery list
A grocery list can be a simple checklist that you type after choosing the week’s recipes. This manual approach is often best for a small plan because it lets you account for what is already in the cupboard and decide whether to substitute an ingredient. Add columns for ingredient, quantity, unit, store or aisle, and purchased. Use a consistent unit for each ingredient, such as grams or millilitres, and avoid adding unlike units together.
For a partly automated list, make one row for each ingredient line needed by a planned meal. Include Recipe, Ingredient, quantity per serving, planned servings, unit, and quantity to buy. If a recipe’s ingredient amounts are written for a whole batch rather than one serving, either divide them into per-serving quantities or use a clearly labeled batch multiplier. Copying ingredient lines for a recipe planned twice is more transparent than trying to build a complex automatic shopping system before the basic plan is reliable.
When the same ingredient appears on several rows with the same unit, you can total those rows. Assume the Grocery sheet has ingredient names in A2:A100, units in B2:B100, and quantities to buy in C2:C100. With the desired ingredient in E2 and its unit in F2, enter =SUMIFS($C$2:$C$100,$A$2:$A$100,E2,$B$2:$B$100,F2) in G2. If two rows list 200 g of onions and 150 g of onions, and E2 is Onions and F2 is g, G2 returns 350. This formula totals matching rows only; it does not convert grams to cups or combine different units.
Mark pantry items separately rather than silently reducing quantities. For example, a Needed column can show the recipe quantity and an On hand column can record what you already have. That makes the shopping amount easier to review and helps prevent an old pantry estimate from being mistaken for a current inventory count.
Make the sheet easier to read and reuse
Use formatting to reveal information, not decorate every cell. Apply a subtle fill to the heading row, wrap text in notes, and keep the same meal names throughout the workbook. On Windows, select the relevant range and use Home > Conditional Formatting > Highlight Cells Rules to flag values such as blank servings or a preparation date that needs attention. Conditional formatting changes the appearance of cells when a rule is met; it does not correct the underlying plan.
Save a clean template before filling in a new week. You can duplicate the Plan sheet, update its dates, and retain the Recipes sheet so that recipe details do not have to be re-entered. If each week is stored in its own tab, use clear names such as 2026-11-02 rather than Week 1; a date-based name is less ambiguous when looking back later. Another option is to keep one Plan table and replace its rows each week, archiving a copy only when you need a record.
Consider adding a simple Status field with values such as Planned, Prepared, or Replaced if plans change often. A recipe link or source field is useful when ingredients and instructions come from a website or cookbook. Store the source rather than copying a long recipe into the schedule; the plan should remain quick to scan.
Common problems and sensible limits
- Inconsistent recipe names: A lookup may fail if the Plan says Vegetable Chili but the Recipes sheet says Veggie Chili. Use a dropdown or standardize names.
- Incorrect serving assumptions: A cost per serving is only comparable when the serving count and recipe quantities are reasonable for your household. Portions are not automatically equal to nutritional servings.
- Mixed measurement units: A total of 350 g is meaningful, but adding 350 g and 2 cups is not. Keep different units separate unless you have a reliable conversion for the particular ingredient.
- Stale prices: A saved estimate can become outdated. Record when prices were checked if the cost figure matters, and update estimates when package prices change.
- Overcomplicated automation: A spreadsheet can organize a plan, but it does not know what is in your refrigerator or whether a recipe substitution is acceptable unless you enter that information.
A meal planner is also not a substitute for individualized dietary advice. People managing allergies, medical conditions, or specific nutritional needs should verify ingredients and seek appropriate guidance. For ordinary planning, use the Notes column to flag allergies or restrictions, but do not assume a spreadsheet can detect every risk in a packaged ingredient or recipe.
Excel template, app, or paper plan?
An Excel template is a useful starting point when you want a ready-made layout, but inspect its formulas and headings before relying on it. A template may include features you do not need or use macros, external links, or nutrition estimates that require review. Download files only from a source you trust, and avoid enabling macros unless you understand why the workbook needs them.
A dedicated meal-planning app may offer recipe imports, shared lists, or phone notifications with less setup, though features and prices differ by product. A paper planner is easier to use without a device and can be enough for a stable routine. Excel is most suitable when you want control over columns, calculations, and reusable lists, and are willing to maintain the data yourself. You can also print the Plan or Grocery sheet from Excel when a paper copy is more convenient.
Frequently Asked Questions
Is there a meal plan template in Excel?
Excel may show templates in its New workbook screen, and Microsoft also provides downloadable templates. Availability can depend on the Excel version, account, and template catalog. You can also create a basic planner by entering headings for date, meal, recipe, servings, and notes, then formatting the range as a table.
How do I make a weekly meal plan in Excel?
Choose a week, make one row for each meal, and enter its date, meal type, recipe, and planned servings. Add preparation notes and a grocery list if useful. Review the schedule for conflicts, ingredients you already have, and meals that need advance preparation before shopping.
Can Excel create a shopping list from a meal plan?
Yes, if you enter the ingredients associated with each planned meal. A straightforward method is to list ingredient lines and quantities on a Grocery sheet, then total repeated ingredients with SUMIFS when their units match. Excel cannot infer a recipe’s ingredient needs from its name alone; those data must be entered or imported from a reliable source.
Can Excel calculate meal costs?
It can calculate estimates from recipe costs, servings, and the number of portions planned. Keep the assumptions visible and update prices when necessary. The resulting total may differ from checkout spending because groceries are bought in package sizes and some ingredients may already be on hand.
Is a meal plan spreadsheet the same as a diet plan?
No. A meal plan spreadsheet is an organizational tool for scheduling meals and ingredients. It does not assess nutritional needs or replace professional advice. If a plan must meet a medical or other specific dietary requirement, verify the details with an appropriate qualified professional.
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
- Clear Email Cache in Outlook 365: Safe StepsTo clear the email cache in classic Outlook for Microsoft 365 on Windows, close Outlook, then rename the…
- How to Lock Cells in Excel While Scrolling a WorksheetTo keep headings or columns visible while you scroll in Excel for Microsoft 365 on Windows, select the…
- How to Add a Watermark to Every Page in Microsoft WordIn Word for Microsoft 365 on Windows, select Design > Watermark and choose a built-in option to place…
- How to Protect an Excel Sheet in Google DriveTo stop people editing particular tabs or cells in an Excel workbook stored in Google Drive, open a…
- Google Sheets Duplicate Rows: Find and Remove ThemYes. In Google Sheets, select the data range and choose Data > Data cleanup > Remove duplicates to…
- How to Hide Cells in Excel Without Deleting DataTo hide cells in Excel, select the rows or columns containing them, then choose Home > Cells >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.