Meal Planning Spreadsheet Template: Build a Weekly Plan

How-to basics · Updated November 20, 2026

A meal planning spreadsheet template is a weekly grid for choosing meals, recording recipes, and organizing the groceries you need. In Excel for Microsoft 365 on Windows, start with days down the first column, meal types across the top, and a separate recipe and grocery area; a small lookup table can also estimate weekly meal costs.

What a meal planning spreadsheet should include

A useful template does more than hold seven days of meal names. It connects the plan to the practical decisions that make meals happen: who is eating, what ingredients are already available, how much preparation time is realistic, and what needs to be bought. You can begin with a simple grid and add detail only when it solves a recurring problem.

A workable first sheet can use these columns:

  • Day: Monday through Sunday, or the dates for the week.
  • Breakfast, lunch, dinner, and snacks: Enter a dish, recipe name, or planned leftovers.
  • People: Record how many people the meal should serve, if portions vary across the week.
  • Notes: Add reminders such as “use spinach first,” “pack for work,” or “thaw chicken Tuesday.”

Keep the recipe catalog and grocery list on separate sheets once the plan grows. A recipe catalog might record a recipe name, servings, ingredients, preparation time, and cost per serving. A grocery sheet can group items by category, show quantities, and include a checkbox or status column. Separating these jobs keeps the weekly grid readable while making the information easier to reuse.

Set up the weekly plan in Excel

In a new workbook, name the first worksheet Weekly Plan. Put Day in A1, Breakfast in B1, Lunch in C1, Dinner in D1, Snacks in E1, People in F1, and Estimated Cost in G1. Put the seven days in A2:A8. Use a second worksheet called Recipes for your recipe catalog and a third called Groceries if you want a dedicated shopping list.

Make the plan easier to scan by formatting the headings, widening the meal columns, and turning on Wrap Text for meal names. Freeze the heading row with View > Freeze Panes > Freeze Top Row so it stays visible as you scroll. To make the plan easier to update, select the used range and choose Insert > Table. A table adds filter controls and carries formatting into new rows; it is most useful when you extend the plan beyond one week or maintain a longer recipe list.

Use consistent meal names if you plan to connect entries to a recipe catalog. For example, choose either “Bean chili” or “Chili, bean” and use that spelling throughout rather than entering several variations. Data > Data Validation can create a dropdown list from recipe names, reducing typos. In Microsoft 365 for Windows, select the meal cells, choose Data > Data Validation, and set Allow to List; select the recipe-name range as the source. If the source is on another worksheet, a named range can make it easier to reference. Excel for Mac has Data Validation as well, although the ribbon layout can differ; Excel for the web supports many common validation tasks but some editing options may vary.

Add a recipe catalog and cost estimate

On the Recipes sheet, enter recipe names in J2:J20 and estimated cost per serving in K2:K20, with headings in J1 and K1. These example locations correspond to the cost formula below; you can choose other locations, but adjust the formula ranges to match. Cost per serving is an estimate, not a live grocery price: update it when prices or ingredients change, and decide whether to include pantry staples, condiments, and cooking oil.

With meal names in B2:E2 on Weekly Plan, the number of people in F2, recipe names in Recipes!J2:J20, and cost per serving in Recipes!K2:K20, enter this formula in G2:

=SUM(IFERROR(XLOOKUP(B2:E2,Recipes!$J$2:$J$20,Recipes!$K$2:$K$20),0))*F2

The formula looks up each meal name, adds the matching per-serving costs, and multiplies by the number of people. For example, if the four meals cost $1.50, $3.00, $5.00, and $0.50 per serving and three people are listed, the estimated daily total is $30.00. XLOOKUP is available in Microsoft 365 and Excel 2021 or later. IFERROR treats blank or unmatched meal names as zero, which keeps an unfinished day from showing an error; it can also conceal a misspelling, so verify that meal names match the catalog. Copy G2 down through G8 after checking that the references adjust as intended.

With daily estimates in G2:G8, enter this formula in G9 to add the weekly estimate:

=SUM(G2:G8)

If every daily estimate is $30.00, this returns $210.00. Label G9 as a weekly total and make clear whether it represents estimated meal costs or actual shopping spending. Those amounts can differ: a grocery trip may include ingredients for later weeks, household supplies, or bulk packages that cost more upfront than the portion used in one week.

Turn the plan into a useful grocery list

A meal grid does not automatically make a reliable shopping list. The recipe “vegetable soup,” for example, could call for carrots, onions, stock, and beans, but the dish name alone does not tell the spreadsheet how much of each ingredient to buy. For a simple weekly routine, write ingredients in a separate list and combine repeated items by hand. This is often faster and less error-prone than building a complex workbook before you know what information you need.

Useful grocery-list columns include item, quantity, unit, category, and status. Categories such as produce, pantry, dairy, and frozen make the list easier to use in a store. Keep units consistent where possible: “2 cans” and “400 g” are different kinds of quantities and should not be added together. If an ingredient appears in multiple recipes, total it only when the units are compatible. Note what is already in the pantry so the list reflects what must be purchased rather than every ingredient a recipe uses.

For a more advanced workbook, use a recipe-ingredient table with one row per ingredient per recipe, then filter that table to the recipes selected for the week. A structured design is more maintainable than putting a whole ingredient list into one cell. Automatic aggregation is possible, but it requires careful handling of units, substitutions, and recipe scaling. Excel’s Power Query can help transform structured tables, but it is not necessary for a household plan with a modest number of recipes.

Choose a planning style that fits your week

There is no single best level of detail. A family with a repeating schedule may prefer a reusable menu, while someone with irregular shifts may want a flexible list of meals rather than fixed dates. Start with the planning horizon and decisions that matter most to you.

  • Fixed daily plan: Assign a particular meal to each day. This is useful when ingredients have short shelf lives or the household needs predictable meals.
  • Flexible meal bank: List several dinners for the week without assigning a day. Choose among them based on time, appetite, or changing plans.
  • Batch-cooking plan: Record preparation dates, portions, and freezer status alongside meals. This helps distinguish food intended for later from food that must be cooked that day.
  • Budget-focused plan: Add estimated cost per serving and a weekly estimate. Compare similar meals, but remember that the estimate depends on portion sizes and local prices.
  • Nutrition-aware plan: Add fields for dietary requirements or nutrients only if you have reliable data and a reason to track them. A spreadsheet cannot replace individualized advice from a qualified health professional.

Planning every meal can be counterproductive if the week is unpredictable. A useful compromise is to plan dinners closely, keep a few flexible lunch options, and leave one slot for leftovers or eating out. The template should reduce decisions, not create a daily obligation to follow a schedule that no longer fits.

Common spreadsheet problems and practical fixes

The most common problem is overbuilding the workbook. Tracking dozens of details—every nutrient, price, brand, and preparation step—takes time and can make the plan harder to maintain. Begin with meal, day, and grocery information. Add a new column only when it answers a question you regularly face, such as “Which meals take less than 20 minutes?”

Inconsistent names are another source of errors. If “Chicken tacos” appears in the plan but “Tacos, chicken” appears in the recipe list, a lookup may not find the intended cost. Use dropdowns, standardize names, and check unmatched entries instead of assuming a blank cost means a free meal. Also avoid typing quantities and units into a single value if you expect to total them; separate “Quantity” and “Unit” fields are easier to validate.

Finally, distinguish planned meals from completed meals. A plan can change because of schedule shifts, forgotten ingredients, or leftovers. If you want to learn from those changes, add a status field such as Planned, Made, Replaced, or Leftovers. Review the sheet at the end of the week and carry forward only useful information. The purpose is to make future planning easier, not to maintain a perfect record.

Food safety and storage notes

A spreadsheet can remind you when to thaw food, use delicate produce, or label leftovers, but it does not determine whether food is safe. Storage time depends on the food, how it was handled, refrigerator temperature, and other conditions. Follow current guidance from a relevant food-safety authority, keep the refrigerator at a safe temperature, and do not rely on smell or appearance alone to judge safety.

For a freezer plan, record the date food was prepared and the date it was frozen, not just the recipe name. Use clear labels and rotate older items forward. When planning meals around leftovers, include a realistic use-by reminder and handle cooling, refrigeration, and reheating according to official food-safety recommendations. People who are pregnant, older, immunocompromised, or preparing food for young children may need to take extra care and consult authoritative guidance.

Spreadsheet template versus apps and paper

An Excel template offers control over columns, formulas, and printing. It works well if you already use Excel, want a plan tailored to your household, or need to keep a local workbook. Its main drawback is upkeep: someone must enter recipe details, revise prices, and assemble the grocery list. A shared workbook can help household members contribute, but coordinate edits to avoid duplicate or conflicting entries.

Meal-planning apps may offer recipe imports, shared lists, or automatic grocery features, depending on the product and its current plan. Those conveniences can save setup time, but they may involve account requirements, paid features, or limits on customization. A paper planner is quick and private, and it may be enough if you do not need calculations or reusable recipe data. Choose the format you are likely to update consistently, rather than the one with the longest feature list.

Frequently Asked Questions

How do I make a meal planning spreadsheet in Excel?
Put the days of the week in rows and meal types in columns, then add a separate grocery list or recipe catalog if needed. Start with a basic grid, format it for readability, and add dropdowns or cost formulas only when they will save effort.

Can Excel automatically make a grocery list from my meal plan?
It can, but a reliable automatic list needs structured recipe and ingredient data, including quantities and units. A manually combined list is often simpler for a small recipe collection. A meal name by itself does not contain enough information to calculate ingredients.

How can I plan meals on a budget?
Estimate cost per serving for common recipes, record the planned number of servings, and compare the weekly estimate with your own spending target. Treat the result as a planning aid: local prices, package sizes, substitutions, and food already in your pantry affect the actual bill.

Should I plan every meal for the whole week?
Not necessarily. Some people plan only dinners or leave flexible slots for leftovers and schedule changes. A realistic plan is more useful than a complete one that is difficult to follow.

Can I use the same template in Google Sheets?
Yes, you can recreate the basic grid and grocery list in Google Sheets, but Excel-specific formulas and menu instructions may need adjustment. Check function availability and syntax in Sheets before copying formulas, especially if the workbook uses newer Excel functions such as XLOOKUP.

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.