Excel Meal Planning Template: A Practical Guide

How-to basics · Updated November 19, 2026

An Excel meal planning template can be a simple weekly grid that tracks meals, portions, preparation notes, and estimated costs. In Microsoft Excel for Microsoft 365 on Windows, set up a Meal Plan sheet with one row per meal, then use a few formulas to calculate meal costs and a weekly total.

What a meal planning template can include

A useful template connects the decisions you make while planning with the practical jobs that follow: shopping, preparing food, and keeping spending visible. It does not need to be elaborate. A clear weekly plan is often easier to maintain than a workbook full of features you rarely use.

For a basic version, create these columns on a sheet named Meal Plan: Day, Meal, Recipe, Portions, Cost per portion, Total cost, and Prep notes. Each row represents one meal. For example, Monday dinner might list vegetable chili, four portions, an estimated cost of $2.75 per portion, and a note to cook rice alongside it. The template can calculate the meal’s estimated total cost as $11.00.

You can add separate sheets as your needs grow:

  • Recipes: recipe names, ingredients, quantities, servings, and links or notes.
  • Shopping List: ingredients to buy, quantities, units, and a checkbox or status column.
  • Pantry: staples already on hand, if tracking them is useful to your household.
  • Lists: reusable options for meals, stores, or categories.

Keep the first version focused. A meal plan can be useful without tracking every nutrient, every pantry item, or the precise cost of each ingredient.

Set up the weekly plan sheet

Open a blank workbook and rename the first worksheet Meal Plan. In row 1, add the column headings Day, Meal, Recipe, Portions, Cost per portion, Total cost, and Prep notes. Enter planned meals below, with one row for each breakfast, lunch, or dinner you want to track. If you plan only dinners, you can make a shorter list with seven rows rather than filling a 21-meal grid.

Make the headings easy to work with by selecting the table range and choosing Home > Format as Table. Confirm that My table has headers is selected. An Excel table adds filters to the header row and extends formatting and formulas when you add rows. Choose a simple style with readable contrast; the color is less important than legibility.

Use consistent values in the Meal column, such as Breakfast, Lunch, and Dinner. Put the number of portions you expect to make in Portions. In Cost per portion, enter an estimate in your local currency, and format the cost columns as currency using Home > Number. If you do not want to estimate costs, leave those columns out until you have a reason to track them.

For a flexible plan, include a date or day column and a meal category column instead of placing weekdays across the top as separate columns. A list of rows is easier to filter, sort, extend, and summarize. A calendar-style grid can be more glanceable, however, so choose the layout that best matches how you plan.

Use formulas for meal costs

Formulas can handle repetitive arithmetic while leaving the actual meal choices to you. With Day in column A, Meal in B, Recipe in C, Portions in D, Cost per portion in E, Total cost in F, and Prep notes in G, enter this formula in F2:

=IF(OR(D2="",E2=""),"",D2*E2)

It leaves the total blank when portions or cost per portion is missing. If D2 contains 4 and E2 contains 2.75, the result is 11.00. If the range is an Excel table, the formula should fill down as you add table rows; otherwise, use the fill handle to copy it into the rows you need. Format column F as currency so the result displays in a familiar way.

To total the estimated cost for a week, place a label such as Weekly estimate in a summary area and enter this formula in the cell beside it, assuming meal totals are in F2:F22:

=SUM(F2:F22)

If the completed rows contain $11.00, $8.50, and $6.00, the result is $25.50. The figure is only as reliable as the estimates entered; it is not a receipt total or a guaranteed grocery bill. You can also calculate planned portions with =SUM(D2:D22) when portions are in D2:D22. That result adds the numeric entries in the range.

Make a shopping list that works

A shopping list is most useful when it records the ingredient, quantity, and unit together. Create a Shopping List sheet with columns for Ingredient, Quantity, Unit, Store or aisle, and Purchased. Examples might be “canned tomatoes,” “2,” “14-ounce cans,” and “produce” or “pantry.” Add one line per ingredient you intend to buy, and mark items already at home rather than automatically purchasing duplicates.

For a first workbook, build the list by reviewing the recipes in the weekly plan and combining repeated ingredients yourself. If two dinners use onions, add their quantities and write one combined line. This manual check is often more dependable than trying to automate a list before recipe data is consistently structured. Keep units consistent when combining amounts: two cups and one tablespoon are not simply three cups.

A more detailed recipe catalog can use one row per ingredient, with columns for Recipe, Ingredient, Amount, Unit, and Recipe servings. For example, a chili recipe might have separate rows for beans, tomatoes, and spices. That structure makes it possible to scale a recipe thoughtfully, but automatically combining ingredients across several planned recipes takes additional formulas or tools and careful handling of units. Do not assume that two entries with the same ingredient name can be added if one is measured by weight and the other by volume.

For most households, a clear list that can be checked while shopping is more valuable than a fully automated list that silently miscalculates quantities.

Plan around time, leftovers, and portions

Start with the week’s real constraints: evenings when nobody has time to cook, meals away from home, and ingredients that need using soon. Put the fastest or already-prepared options on busy days, and reserve longer recipes for days when preparation time is available. A Prep notes column can record details such as “thaw overnight,” “chop vegetables in advance,” or “double the sauce.”

Plan leftovers deliberately. If a recipe makes six portions but only four are needed for dinner, note where the remaining two portions will go, such as lunch the next day. This makes the portion number more meaningful and can reduce accidental overbuying. Distinguish servings from recipe yield: a recipe that serves four does not necessarily provide four adult-sized portions for every household.

Leave some space for flexibility. A planned meal can be marked as “leftovers,” “freezer meal,” or “flex night” rather than assigning a new recipe every day. The template is a planning aid, not a rule that every listed meal must happen exactly as scheduled. If plans change, update the sheet and shopping list so the workbook remains useful.

Customize the workbook without making it fragile

Adapt the columns to the decisions your household actually makes. A household managing a food budget may want a weekly target and estimated meal costs. Someone coordinating cooking may want a Cook or Prep time column. People planning around dietary needs may find a Notes field more useful than a long list of labels. Keep sensitive health information out of a shared workbook unless there is a clear reason and appropriate permission to include it.

For dropdowns, put allowed values on a Lists sheet, select the cells where choices should appear, and choose Data > Data Validation. In Settings, choose List and provide a source range or a named range. A list can help keep entries consistent, but changing a list later may require updating its source. Avoid typing several different versions of the same category, such as “Dinner,” “dinner,” and “Evening meal,” if you expect to filter or summarize it.

You can add a visual cue for meals with missing information by selecting the relevant cells and choosing Home > Conditional Formatting. Use a rule that highlights blanks or a value you define, and make sure the formatting communicates a real action rather than merely decorating the sheet. To keep headings visible while scrolling, select the cell below the header row and choose View > Freeze Panes > Freeze Panes. If you use a table, its filter arrows can help show only dinners or a particular week.

Common problems and how to avoid them

  • Mixing units: Record units explicitly and convert quantities before combining them. “One bunch” and “200 grams” are not directly interchangeable.
  • Using different recipe names: A recipe entered as “lentil soup” in one place and “lentil stew” in another may not match in a lookup or summary. Use one consistent name.
  • Overestimating formula accuracy: A cost-per-portion estimate can omit pantry ingredients, price changes, or waste. Treat it as a planning estimate and update it when useful.
  • Making the sheet too complex: Detailed nutrition, inventory, and price tracking can create more work than the plan saves. Add one feature at a time and keep it only if it helps.
  • Deleting formulas accidentally: If a formula cell is overwritten, restore it from a nearby row or copy the formula down again. Consider protecting formula cells if several people edit the workbook, while leaving input cells editable.

One common misconception is that a spreadsheet automatically creates an accurate grocery list from meal names. It cannot infer the ingredients or quantities in a recipe unless that information is entered and connected in a consistent structure. Even then, substitutions, package sizes, and pantry supplies need human judgment.

Excel template, printable planner, or meal-planning app?

Excel is a good fit if you want to control the layout, keep a reusable recipe list, filter rows, or adapt formulas to your own routine. A basic template can be built without paying for a specialized planner, although Excel itself may require a Microsoft 365 subscription or a qualifying license. Check Microsoft’s current licensing details for the version you use; the workbook design does not make Excel free.

A printable planner is simpler when you prefer handwriting and do not need calculations or reusable digital records. A meal-planning app may suit people who want built-in recipe imports, shared lists, or other features that a spreadsheet does not provide by default. App features and prices vary, so compare the functions you actually need rather than assuming every app includes the same tools.

Excel files can be stored locally or in a cloud location such as OneDrive for access across devices. If multiple people edit a shared workbook, agree on how to update meals and shopping items to avoid conflicting changes. For casual planning, a shared digital list may be enough; for a complex household workflow, test the setup for a week before moving all recipes and records into it.

Frequently Asked Questions

Does Excel have a built-in meal planning template?
Excel’s available templates can vary by version and account. You can look for meal or food planning templates from the New screen, but a simple workbook with a weekly plan and shopping list is also easy to create yourself using the layouts above.

How do I make a weekly meal plan in Excel?
Create columns for day, meal, recipe, portions, cost per portion, total cost, and notes. Enter one meal per row, add a cost formula if needed, and make a separate shopping list for ingredients and quantities.

Can Excel automatically generate a grocery list from recipes?
It can be set up to summarize structured recipe ingredients, but it will not know what a recipe contains just from its name. You must enter ingredient amounts consistently and account for units, servings, pantry stock, and substitutions.

How do I calculate the cost of a meal?
Enter the number of portions and estimated cost per portion, then multiply them. In the layout described above, the formula in F2 is =IF(OR(D2="",E2=""),"",D2*E2). Four portions at $2.75 each produce an estimated total of $11.00.

Can I use the template in Excel for the web or on a Mac?
Many basic features, including cell formulas, tables, and standard formatting, are available across Excel platforms, but ribbon placement and some options can differ. The steps here describe Excel for Microsoft 365 on Windows; check the corresponding menus in the web or Mac interface if a command is elsewhere.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.