Meal Planning Excel Sheet: Build a Weekly Planner

How-to basics · Updated November 20, 2026

Yes—you can make a meal planning Excel sheet with a weekly meal grid and a separate grocery list. In Excel for Microsoft 365 on Windows, enter days, meals, dishes, and servings in a worksheet, then use a second worksheet to track ingredients and shopping; simple formulas can count planned meals and combine repeated ingredient quantities.

What a meal planning spreadsheet can do

A spreadsheet gives you a flexible place to decide what to eat, note what needs using, and turn meal choices into a shopping plan. Unlike a fixed calendar, it can be changed to suit a household’s routines: one person might plan only dinners, while another may want breakfast, lunch, snacks, and leftovers included.

It helps to separate two jobs that are often confused. The meal plan records dishes and when you intend to make them. The shopping list records ingredients and the amounts you need to buy. A dish name such as vegetable curry is useful in the plan, but it is not a complete shopping list until its ingredients and quantities are accounted for.

An Excel sheet does not automatically know the ingredients in a recipe. Unless you build a recipe database and connect it to the plan, you must enter or copy the required ingredients yourself. Treat the workbook as an organizer, not as a nutrition database or a substitute for checking food labels and recipe instructions.

A practical workbook layout

Start with two worksheets named Meal Plan and Shopping List. On Meal Plan, put these headings in cells A1:F1: Day, Meal, Dish, Servings, Ingredients or recipe link, and Prep notes. Use rows 2 through 22 for 21 meal slots: three meals for each of seven days. If you only plan dinners, use seven rows instead. Keeping one meal per row makes it easier to sort, filter, and count entries.

For example, Monday, Dinner, lentil soup, 4, lentils; carrots; stock, and cook extra for lunch are distinct pieces of information. Put each piece in its own column rather than typing the whole plan into one cell. If the ingredients column becomes too long, put the recipe name or link there and list the required quantities on the Shopping List sheet.

On Shopping List, use columns for Ingredient, Quantity, Unit, Needed for, and Purchased. A row might read carrots, 3, whole, soup, and an unchecked box or blank status. Separate quantity from unit: 500 and grams are easier to total consistently than a single entry such as 500 g. Use consistent ingredient names and units if you want to combine repeated items reliably.

Build the sheet in Excel

  1. Open a blank workbook and rename the first worksheet Meal Plan. Enter the six headings in row 1, then add the days and meal types you actually plan to use.
  2. Enter dishes as you decide them. Leave undecided slots blank rather than filling them with guesses; a blank cell makes it easier to see what still needs planning.
  3. Create the Shopping List worksheet and enter one ingredient per row, including a quantity and unit when known. If an ingredient is used in multiple recipes, either list each requirement on its own row or consolidate it carefully.
  4. To make either range easier to filter and expand, select the headings and data, then choose Insert > Table and confirm that the table has headers. Tables add filter controls and generally extend as new rows are entered.
  5. Save the workbook with a descriptive name and make a fresh copy when starting a new planning period if you want to preserve previous weeks.

These steps describe Excel for Microsoft 365 on Windows. Excel for Mac also has tables and data validation, though ribbon placement and some dialog details can differ. Excel for the web supports many common spreadsheet tasks, but some features and controls may differ from the desktop application; check the available commands in your version rather than assuming every dialog is identical.

Make repeated entries easier

Consistency is important when people, days, or meal types are typed by hand. Excel’s Data Validation feature can provide a drop-down list for a column. For instance, select the meal-type cells and choose Data > Data Validation, then set Allow to List and provide entries such as Breakfast,Lunch,Dinner. A list reduces variations such as dinner, Dinner, and evening meal, which can otherwise complicate sorting and summaries.

You can also use formatting to make information easier to scan. Select the relevant cells and use Home > Conditional Formatting > New Rule to highlight, for example, meal slots that still have no dish. Conditional formatting changes how cells look; it does not fill in a plan or verify that ingredients are available. For a simple, no-formula alternative, apply a light fill to blank slots manually as you review the week.

If you use checkboxes for purchased items, keep the status in its own column. Do not put a tick mark into the ingredient or quantity cell, since that mixes the shopping data with its completion status. A plain status such as Needed or Bought also works and is easy to edit across Excel versions.

Useful formulas for counts and quantities

Formulas are optional. They are most useful when they answer a clear question, such as how many meal slots are filled or how much of a repeated ingredient is listed. On the Meal Plan sheet, if dish names are in C2:C22, this formula counts nonblank dish cells: =COUNTA(C2:C22). If seven dish cells are filled, the result is 7. It counts filled cells, not distinct recipes or people served.

On that same sheet, if planned serving counts are in D2:D22 and the entered values are seven meals with 2 servings each, this formula totals the servings entered: =SUM(D2:D22). The result is 14. That number represents the sum across meal rows, not necessarily 14 different people or a precise estimate of food needed; leftovers and recipe yields still need judgment.

For a shopping summary, suppose the Shopping List sheet has ingredient names in A2:A30, numeric quantities in B2:B30, and units in C2:C30. Put an ingredient name in D2, and use this formula in E2 to add its quantities: =SUMIF($A$2:$A$30,D2,$B$2:$B$30). If A2 contains rice with 1.5, A8 contains rice with 0.5, and D2 says rice, the result is 2. The formula only adds quantities; it cannot tell whether one entry is cups and another is grams. Group items by both ingredient and unit before relying on the total.

These examples use ordinary Excel functions and comma argument separators. If your regional settings use semicolons as formula separators, Excel may display formulas differently. For a small planner, fixed ranges are usually understandable; update the ranges when adding rows beyond row 30, or use an Excel table and adapt the formula to its columns.

Turn the plan into a useful shopping list

Review recipes before shopping and record amounts in a consistent unit. If two dishes call for half a can of tomatoes each, a combined requirement of one can is reasonable only if both entries refer to the same product size. If one recipe lists a bunch of herbs and another lists a measured weight, do not add them as though they were equivalent. For pantry staples, note whether the amount is the recipe requirement or the amount you still need to buy.

A practical list can include a category column such as Produce, Pantry, Dairy, or Frozen, so items can be grouped in the order you shop. You can filter the table by category or sort it alphabetically. Add a Purchased column to track progress, and use a Notes column for details such as ripe bananas or a preferred brand. These are simple organizational aids; they do not guarantee that an item is in stock or that a substitution will work in a recipe.

Before finalizing the list, check cupboards, the freezer, and the fridge. Subtract what you already have from the amount required, and consider whether a package size means you will have leftovers. This quick review is often more useful than adding elaborate automation to a basic planner.

Choose a template or build your own

A ready-made workbook can save setup time, especially if it already has a weekly grid, grocery list, and print-friendly layout. Before using one, check that its categories fit your routine, that formulas are visible or understandable, and that it does not require macros or external connections you do not need. Make a copy before changing a template so the original remains available.

Building a sheet yourself takes longer at first but makes it easier to remove unused sections. A minimal planner with days, dishes, servings, ingredients, and a shopping status is often easier to maintain than a large workbook with calorie tracking, budgets, recipe databases, and dashboards. Add a feature only when you know what decision it will help you make.

Excel is a good fit if you want a customizable grid, filters, formulas, and a file you can print or edit offline in the desktop application. A dedicated meal-planning app may be more convenient if you want built-in recipe collections, automatic grocery lists, or household sharing, but those features and their availability depend on the specific service. A paper list or calendar may be simpler if you plan only a few meals and do not need calculations.

Common problems and practical fixes

  • The list is hard to maintain: Keep the first version small. Planning dinners only is a valid starting point; add breakfasts or lunches after the basic routine works.
  • Totals look wrong: Check spelling, spaces, units, and whether quantities are numbers rather than text. Do not combine different units in one total.
  • Rows disappear from a formula: Confirm that the formula’s cell range includes the new rows. If the plan grows often, use an Excel table or extend the range.
  • Recipes feel repetitive: Add a Cuisine or Main ingredient column, then sort or filter to see whether the week has variety. A spreadsheet can reveal repetition, but it cannot decide what variety means for your household.
  • Plans are abandoned midweek: Leave one or two flexible slots for leftovers, a quick meal, or changing schedules. A plan is a guide, not a requirement to cook every listed dish.

One common misconception is that a meal plan automatically reduces food waste or grocery costs. It can help you notice overlaps and plan around food already on hand, but the result depends on what you buy, how portions are used, and whether plans change. Compare what you intended to buy with what you actually used, then adjust the next week’s quantities.

Nutrition, allergies, and food safety

A meal planner can record dietary notes, but it does not verify that a recipe is suitable for a particular allergy, medical condition, or nutritional goal. Ingredient labels and manufacturing information can change, and restaurant or packaged foods may have details not captured in a personal spreadsheet. For an allergy or medically restricted diet, confirm ingredients and preparation practices from reliable sources and consult an appropriate qualified professional when needed.

Use the notes column to flag reminders such as a household member’s preference or a recipe that needs a substitution, but keep the actual instructions clear. A spreadsheet is also not a food-storage timer: follow safe storage and handling guidance for perishable foods, and do not assume that a planned date makes food safe to eat. If a meal is moved, update the plan and assess the food according to applicable food-safety guidance.

Frequently Asked Questions

How do I make a simple meal planner in Excel?
Make a Meal Plan worksheet with columns for day, meal, dish, servings, and notes. Add a separate Shopping List worksheet with one ingredient per row, plus quantity, unit, and a purchased status. Start with a week of dinners if a larger plan feels difficult to manage.

Can Excel automatically create a grocery list from recipes?
Not from a dish name alone. Excel needs the recipe ingredients and amounts in a structured form before it can collect or total them. A basic workbook requires you to enter the ingredients; a more advanced recipe database can automate some of that work but needs careful setup.

Is there a free meal planning Excel template?
Some templates are available through Microsoft’s template gallery and other providers, but availability and design can change. Review the workbook’s formulas and features before entering personal information, and avoid enabling macros unless you understand why the file needs them.

How many meals should I plan each week?
Plan only as many as you can realistically use. Some households plan every meal, while others plan dinners and leave other meals flexible. Include expected leftovers and busy days rather than assuming every slot needs a new recipe.

Can I use the same meal planning sheet in Google Sheets?
You can upload or recreate a simple workbook in Google Sheets, but formatting, formulas, and some Excel features may not transfer exactly. Check the converted sheet after importing it, especially data validation, conditional formatting, and any formulas or table features you rely on.

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.