An Excel meal plan template is a workbook for assigning meals to days, keeping recipes and ingredients together, and organizing a shopping list. In Microsoft Excel for Microsoft 365 on Windows, start with a weekly grid, add a separate ingredient list, and use a simple SUMIF formula to total repeated ingredients.
What an Excel meal plan template should contain
A useful planner makes it easy to answer three questions: what are we eating, what do we need to buy, and what must be prepared ahead of time? A single grid can handle the first question, but a separate ingredient sheet is easier to maintain when meals share ingredients or a recipe serves several people.
For a basic weekly plan, create columns for the day, breakfast, lunch, dinner, snacks, and notes. Use one row for each day. Notes can capture practical details such as “use leftovers,” “thaw chicken,” or “late meeting.” Avoid adding nutrition or cost columns unless you intend to keep those figures current; an empty or outdated field can be more misleading than helpful.
- Plan: days and meal slots, with notes for prep or leftovers.
- Recipes: recipe names, serving counts, and links or instructions.
- Ingredients: ingredient name, quantity, unit, recipe, and optionally store section.
- Shopping: a consolidated list that you can check off while shopping.
These can be separate worksheets in one workbook. For a small household or a short plan, a single worksheet is enough; separate sheets become more useful as the recipe and ingredient lists grow.
Build the weekly meal grid
In a blank workbook, rename the first worksheet Plan. In row 1, enter Day, Breakfast, Lunch, Dinner, Snacks, and Prep notes. Enter Monday through Sunday in cells A2:A8. Select the range and use Home > Format as Table, or choose Insert > Table, then confirm that the table has headers. A table makes it easier to apply consistent formatting and extend the range when you add rows.
Keep meal names short in the grid: “lentil soup” is easier to scan than a full recipe. If a meal comes from a recipe sheet, use the same recipe name in both places. You can make the week reusable by saving an untouched copy as a template, then using Save As for each new week. Include a date range near the top so a printed plan or copied file is not mistaken for the current one.
For a simple dropdown of meal choices, put your recipe names in a list on another sheet. Select the cells where you want the dropdown, then choose Data > Data Validation. Set Allow to List and use the recipe-name range as the source. If Excel rejects a cross-sheet source in that box, create a named range for the recipe list and use that name as the source. A dropdown helps keep names consistent, but it is optional; typing directly into the grid is faster for a short plan.
Keep recipes and ingredient quantities organized
Create a Recipes sheet with columns for recipe name, servings, preparation notes, and a web link or location for the full instructions. Keep ingredient details in a separate Ingredients sheet: use columns for Recipe, Ingredient, Quantity, Unit, and Store section. For example, a chili recipe might have rows for beans, tomatoes, onion, and cumin. Store quantity and unit separately so that 2 and cans are not mixed into one text entry.
Choose a consistent basis for quantities. If the recipe is written for four servings but your household needs two, either scale the quantities before entering them or add a planned-servings column and calculate adjusted amounts. Do not combine unlike units as if they were interchangeable: 1 cup and 200 grams of flour cannot be safely summed without a conversion. For ingredients that are usually bought as packages, you may prefer shopping units such as “1 bag” or “2 cans” rather than trying to convert them to weight.
For recipe instructions, a link to a trusted source can keep the spreadsheet compact. If the recipe is your own, record the steps or a short reminder. Make sure the recipe name is stable across the Plan and Ingredients sheets; small differences such as “Veggie pasta” and “Vegetable pasta” can make filtering or totaling less reliable.
Turn the ingredient list into a shopping list
A shopping list can be a filtered copy of the ingredient rows, or a separate summary where each ingredient appears once. The simplest reliable method is to sort or filter by ingredient and manually combine the quantities, checking that units match. Excel’s table filters can help you view only the ingredients for a selected recipe, while sorting by Store section can group produce, pantry items, and refrigerated foods.
To total repeat quantities, put the ingredient to summarize in E2. Assume ingredient names are in A2:A100, numeric quantities are in B2:B100, and all quantities for that ingredient use the same unit. Enter this formula in F2:
=SUMIF($A$2:$A$100,E2,$B$2:$B$100)
If the rows for oats contain 0.5 and 0.25, and both amounts are measured in cups, the result is 0.75 cups. The formula adds quantities only; display the unit in a neighboring cell or include it as a label. It will not convert cups to grams or distinguish between “each,” “cans,” and “grams,” so summarize each ingredient-unit combination separately. Check the result against the recipe rows before shopping, especially if the ingredient is entered with different spellings.
Use simple formulas without overbuilding
Formulas are most useful when they save repetitive counting or addition. For example, a meal count can show whether the week is mostly planned or still has gaps. Assume meal entries are in B2:E8, with one cell per meal slot. If 20 of those cells contain meal names, this formula returns 20:
=COUNTA(B2:E8)
COUNTA counts nonempty cells, including text, so it counts a cell containing “Leftovers” as a planned meal. It does not tell you whether the meals are varied or whether the ingredients are on hand. Blank slots are not automatically a problem; they may be intentional if you expect to eat out or use leftovers.
Keep formulas visible and understandable. A template with a few totals is usually easier to correct than one built around complicated automation. If you copy formulas down a shopping summary, use fixed ingredient ranges such as the dollar-sign references in the SUMIF example so the source range does not shift. Excel recalculates these formulas as you edit the source cells.
Make the plan fit real routines
A template should reflect how meals are actually chosen and cooked, not an idealized week. If lunches are usually leftovers, make that a selectable meal entry. If one person cooks on certain nights, add a Cook column or include the name in Prep notes. If shopping happens twice a week, add a shopping-day field or split the grocery list into two sections so produce is not bought too early.
Use a small set of categories that are meaningful to your household. Examples include quick meals, freezer meals, vegetarian dinners, or recipes that use a particular appliance. Categories can help you find options when you are short on time, but they do not need to become a complex rating system. Excel’s filters work well for a modest recipe table.
Print layout matters if the plan will be posted on a refrigerator. Set the page orientation and print area so the entire week fits on a page, and check Print Preview before relying on it. On Windows, use File > Print to inspect the layout. Excel for Mac has comparable print controls under File > Print, though the dialog appearance can differ. A digital workbook is easier to update; a printed list is convenient at the store, but becomes outdated when plans change.
Food safety and dietary details
A spreadsheet can remind you to thaw food or use leftovers, but it does not make food safe by itself. The U.S. Department of Agriculture advises refrigerating perishable food within two hours, or within one hour when the temperature is above 90°F (32°C), and keeping a refrigerator at 40°F (4°C) or below. USDA guidance generally recommends using refrigerated leftovers within three to four days. Check current official guidance for details, since the safe handling time depends on the food and conditions.
For food allergies, record relevant restrictions in a clearly visible note and verify ingredient labels each time you shop; manufacturers can change products. Avoid treating a meal-plan spreadsheet as medical nutrition advice. People managing a medical condition or a specific therapeutic diet should confirm meal choices with a qualified health professional. If multiple people edit the workbook, agree on how to mark allergens and changes so an important note is not hidden in a cell comment.
Common problems and how to avoid them
- Quantities do not add up: Check that the ingredient names match and the units are compatible. Use separate totals for different units.
- The plan becomes stale: Put dates on the week and start each new plan from a clean copy, rather than overwriting the only reusable version.
- Cells are hard to scan: Wrap text for notes, keep recipe names concise, and use consistent colors sparingly. Color alone should not communicate an allergy or other critical warning.
- Too much data entry: Start with the meals you repeat often. Add detailed ingredient rows only for recipes where a shopping total is genuinely helpful.
- A formula shows zero: Check whether the search text exactly matches the ingredient entries, and confirm that the quantity cells contain numbers rather than text.
One common misconception is that a template automatically creates a complete grocery list from meal names. A meal name by itself does not tell Excel what ingredients or quantities a recipe needs. That relationship has to be recorded in an ingredient table, imported from a suitable source, or assembled manually. Keeping that limitation in mind prevents a polished-looking plan from being mistaken for a verified shopping list.
Template versus other planning methods
Excel is a good fit when you want control over columns, formulas, printing, and a reusable archive of past weeks. A paper planner may be quicker for someone who prefers handwriting and does not need totals. A dedicated meal-planning app may offer recipe importing, shared accounts, or shopping-list features, but its capabilities and costs vary by product. Google Sheets is another spreadsheet option when browser-based collaboration is the priority; its menus and some functions differ from Excel.
You can begin with a blank workbook, adapt a template available from Microsoft or another provider, or build a minimal grid yourself. Before using a downloaded workbook, inspect its formulas, links, and any macros. Do not enable macros simply because a template requests it; macros can run code. For most personal weekly plans, a workbook without macros is sufficient.
Frequently Asked Questions
Does Excel have a built-in meal plan template?
Template availability can vary by Excel version and the templates shown online. Look for templates from Excel’s start screen or use a trusted source, then check that its layout suits your meals and that formulas work as expected. You can also make a basic weekly grid with the steps above.
How do I make a meal plan in Excel?
Create a row for each day and columns for meal slots, then enter meal names and preparation notes. For a more complete system, keep recipes and ingredients on separate sheets and build a shopping summary from the ingredient rows.
Can Excel create a grocery list from my meal plan?
Yes, if you record each recipe’s ingredients and quantities in a structured list. You can filter those rows or use a formula such as SUMIF to total repeated ingredients with compatible units. Excel cannot infer a recipe’s ingredients from a meal name alone.
How do I plan meals for more than one person?
Record the number of planned servings and adjust recipe quantities to match. Keep units consistent, and confirm that the recipe scales sensibly; simply doubling every ingredient may not suit every recipe or cooking method.
Can I use the same template every week?
Yes. Save a clean master copy, then use Save As to make a dated workbook for each week. This preserves the blank template while allowing you to review previous plans or reuse meals that worked well.
Related
- Excel Hide Shortcut: Hide Rows, Columns, and Sheets
- Excel: Highlight Cells With Dates Before Today
- Excel Hex Number Format: Convert Numbers to Hex
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Table Reference Format: A Practical GuideIn Excel, a table reference uses the table name and, when needed, a column or item in square…
- How to Compare Documents in Microsoft WordTo compare two Word files, open the desktop version of Word and choose Review > Compare > Compare…
- Excel Conditional Formatting Icon Sets ExplainedConditional formatting icon sets are Excel rules that place symbols—such as arrows, traffic lights, or flags—beside cell values…
- Excel Shortcut to Make All Cells Fit Text AutomaticallyIn Excel for Microsoft 365 on Windows, select the cells or columns, then press Alt, H, O, I…
- Average in Excel: How to Calculate ItTo calculate an average in Excel, enter =AVERAGE(A2:A6) in an empty cell, replacing A2:A6 with the range that…
- How to Double Space in Microsoft Word on Any DeviceTo double-space text in Microsoft Word, select the text—or press Ctrl+A on Windows or Command+A on Mac to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.