Meal Planning Spreadsheet: Build a Weekly Planner in Excel

A meal planning spreadsheet is a workbook for scheduling meals, recording recipes, and organizing the ingredients you need to buy. In Excel for Microsoft 365 on Windows, start with a weekly meal list, a recipe-and-ingredient sheet, and a grocery list; even a simple version can help you see the week at a glance and shop from one organized plan.

What a meal planning spreadsheet can do

A spreadsheet can be as simple as seven days with spaces for dinner, or it can connect meals to recipes, serving counts, ingredients, and shopping quantities. Its main advantage is flexibility: you can adapt the columns to your household’s routine instead of working around the fixed layout of an app or printed planner.

A useful plan makes a few everyday decisions visible. It can show which nights need a quick meal, where leftovers fit, and which ingredients are already in the pantry. It can also make repeated routines easier to manage: for example, assigning a “use leftovers” night can reduce the number of new meals to plan, while a recipe column lets you find the instructions you need.

A spreadsheet does not automatically know what is in your refrigerator, whether a recipe suits an allergy, or whether a quantity is enough for everyone. Those details still need your judgment. Think of the file as a planning and record-keeping tool, not an automatic nutrition, food-safety, or inventory system.

Choose a layout that matches your routine

Before adding formulas, decide how you want to plan. A calendar-style grid is quick to scan: weekdays run across the top, and meal types run down the side. A list is often easier to filter, sort, and expand because each planned meal occupies one row. For a growing workbook, use a list for the underlying information and, if useful, make a separate weekly view for display.

A practical starting point is a Meal Plan sheet with these columns:

Day: Monday, Tuesday, or a date.
Meal: Breakfast, lunch, dinner, or snack.
Recipe: The dish planned for that slot.
Servings: The number of portions you intend to prepare.
Notes: For example, “use frozen vegetables” or “cook extra for lunch.”

One row per meal works well when your schedule varies; a week with dinner planned every day would have seven dinner rows, with extra rows for other meals as needed. If you prefer a visual calendar, keep the same information in a grid, but be aware that a grid can be less convenient for sorting or summarizing.

Set up the recipe and ingredient data

Create a second sheet called Recipe Ingredients. Use one row for each ingredient used by a recipe, with columns for Recipe, Ingredient, Quantity per serving, and Unit. For example, a lentil soup recipe might have separate rows for lentils, broth, and carrots. If the ingredient amounts in your source recipe are for four servings, divide them by four before labeling them “per serving.” That makes it easier to scale the amounts consistently.

Keep units meaningful and consistent. If a recipe lists flour in cups, record cups rather than mixing cups, grams, and bags in the same quantity column. Some ingredients are naturally counted as items, such as two onions, while others are measured by weight or volume. You can keep the unit in its own column and combine quantities only when both the ingredient and unit match.

Recipe names need to match between sheets for simple formulas to find them. “Lentil soup” and “Lentil Soup ” (with an extra space at the end) may not behave as the same text in a straightforward lookup. Use a consistent naming convention, and consider keeping the recipe name in a dropdown rather than typing it repeatedly.

Build the weekly plan in Excel

On the Meal Plan sheet, enter your planned rows and format the headings so they are easy to distinguish. You can make the range an Excel table using Home > Format as Table. Tables include filter buttons and expand when you add rows, which can be useful as the plan grows. Pick a clear style and keep the column headings descriptive.

To reduce inconsistent entries, you can add dropdown lists. Put meal types in a small list on a separate area or sheet, select the cells where you will enter the meal type, and use Data > Data Validation to set the validation criteria to a list. You can use the same idea for recipe names, although a long recipe list may be easier to maintain in a dedicated range. Data validation helps guide entry; it does not prevent every possible error, such as pasting an unexpected value into a cell.

Freeze the heading row if you expect the list to extend beyond one screen: choose View > Freeze Panes > Freeze Top Row. If you use a calendar grid instead, consider adding a small notes area for prep tasks and leftovers rather than squeezing long instructions into each day’s cell.

Make a shopping list from the plan

A grocery list can be handwritten in a dedicated sheet, or partly calculated from the meal plan. A manageable semi-automatic approach is to list each recipe ingredient on the Grocery List sheet and calculate how many servings of that recipe are planned. Assume Meal Plan has recipe names in C2:C22 and serving counts in D2:D22. On Grocery List, put the recipe name in A2 and the planned servings in E2. For a recipe named “Lentil soup,” with rows planned for 4 and 2 servings, enter:

=SUMIF('Meal Plan'!$C$2:$C$22,A2,'Meal Plan'!$D$2:$D$22)

The formula returns 6 for that example. On the same Grocery List row, suppose D2 contains the ingredient quantity per serving, such as 0.5 cups of lentils. Put the total planned servings in E2, then calculate the amount needed in F2 with:

=D2*E2

With D2 equal to 0.5 and E2 equal to 6, the result is 3 cups. This setup scales each recipe ingredient, but it does not automatically combine the same ingredient across different recipes. You can group matching ingredient-and-unit rows and add their amounts, or simply keep separate entries and combine them while reviewing the list. Check quantities against the actual recipe and package sizes before shopping.

Make the sheet easy to read and maintain

Formatting is most helpful when it communicates something. Use a consistent date format, keep units in their own column, and make headings visually distinct. In Excel, Home > Conditional Formatting can highlight selected values—for example, a text label such as “Leftovers” or a cell marked “Prep.” Avoid using color as the only signal; include words so the sheet remains understandable when printed in grayscale or viewed by someone who cannot distinguish the colors.

Separate planning information from recipe instructions. A short recipe name and a link or reference to the full recipe are usually easier to scan than several lines of cooking directions in a weekly cell. If the source is a website, save the link in the recipe record; if it is a family recipe, note where the instructions are stored. Add a “last made” or “rating” column only if you will maintain it—unused tracking fields make a workbook harder to keep current.

At the start of a new week, copy or clear the planning rows, check what food is already available, and then choose meals. After shopping, note substitutions that matter for next time. A light weekly review is more sustainable than trying to record every pantry item or every meal in exhaustive detail.

Common problems and practical fixes

The list becomes too complicated. Start with meals, recipes, servings, and a short notes field. Add nutrition, cost, or inventory columns only when they answer a question you actually need to solve.
Ingredient amounts do not add up. Check that the recipe’s base serving count is known, that quantities are recorded per serving if you are scaling them, and that units match before combining amounts.
The formulas miss a planned recipe. Check spelling, spaces, and whether the meal plan’s recipe names are in the range the formula references. If you add rows below row 22, update the stated range or use an Excel table-based setup.
The grocery list includes too much. A planned quantity is not the same as a purchase quantity. Review pantry stock, package sizes, leftovers, and whether an ingredient is optional before buying.
The plan is abandoned after a busy week. Leave flexible slots for takeout, leftovers, or quick meals. A plan can be useful without being followed perfectly; revise it when appointments or preferences change.

Templates, apps, and spreadsheet trade-offs

Building your own workbook offers control over categories and layout, and Excel can work offline when the file is saved locally. A template is quicker if its structure already fits your household, but inspect its formulas and categories before relying on them. A dedicated meal-planning app may offer recipe databases, automatic grocery lists, or phone-friendly features, but its options, pricing, and data handling vary by product.

For someone planning a few dinners each week, a basic spreadsheet may be enough. If several people need to update the plan at the same time, a shared cloud workbook or an app designed for collaboration may be more convenient. If the task is only to remember dinners, a paper calendar or notes app can be simpler. The right choice is the one that is easy to update and clear to the people who use it.

Food preferences, allergies, and safe use

A notes column can record preferences such as vegetarian meals, disliked ingredients, or a reminder to check a product label. Treat those notes as reminders, not proof that a meal is safe. Packaged ingredients and recipes can change, and people with allergies or other medical dietary needs should verify ingredients and preparation details using reliable, current information appropriate to their situation.

Be careful about storing sensitive information in a shared workbook. A meal plan usually does not need medical histories or other personal details. If you share a file, review who can access it and whether the notes are appropriate for everyone with access. A spreadsheet also cannot track food storage or determine whether leftovers remain safe; handle and store food according to applicable food-safety guidance.

Frequently Asked Questions

What should a meal planning spreadsheet include?
A useful basic version includes the day, meal, recipe, servings, and notes. Add a recipe ingredient table and grocery list if you want to estimate shopping quantities. Keep the layout limited to information you expect to use.

How do I make a meal plan in Excel?
Create a sheet with one row per planned meal and columns for day, meal type, recipe, servings, and notes. Add dropdowns with Data > Data Validation if they help keep entries consistent, then review the plan against your schedule and available food.

Can Excel automatically create a grocery list?
Excel can calculate ingredient quantities when recipe ingredients, per-serving amounts, and planned servings are recorded in a consistent structure. Combining the same ingredient across multiple recipes may require extra formulas or a manual review, so check the final list before shopping.

Is a weekly grid or a meal list better?
A grid is easy to scan like a calendar, while a row-based list is generally easier to filter, sort, and expand. Choose the format that suits how you review your plan; you can also store the data as a list and create a separate visual weekly view.

How can I plan meals for leftovers?
Include a planned leftover meal or add a note such as “cook extra for lunch” to the recipe row. Adjust the servings you plan to cook, and check the resulting ingredient quantities rather than assuming a leftover portion will be available.

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.