Free Meal Planner Spreadsheet: Plan Meals in Excel

Yes—you can make a free meal planner spreadsheet in Excel by laying out a week of meals, adding a separate shopping list, and using a few built-in formulas to total planned meals and estimated costs. You can build it yourself in Excel for Microsoft 365, or look for a ready-made template under File > New; template availability can vary. Excel for the web also offers a no-cost way to create and edit workbooks with a Microsoft account, though its features and interface differ from desktop Excel.

What a free meal planner spreadsheet can do

A meal planner spreadsheet is a reusable table for deciding what to eat and organizing the work behind those choices. At its simplest, it is a weekly grid with days down the side and meals across the top. A more useful workbook connects that grid to recipes, ingredients, and a shopping list. The purpose is not to automate every decision; it is to make the decisions visible so you can spot gaps, use food you already have, and shop with a clearer list.

“Free” can mean a spreadsheet you create yourself, a downloadable workbook shared without charge, or a template included in an application. Check the source and any usage terms before downloading a file. Avoid enabling macros in a workbook from an unfamiliar source, and do not enter private information into a template unless you understand where the file is stored and shared.

A spreadsheet is especially handy when your plans change from week to week or you want to adapt the same layout to different household needs. It is less helpful if you expect it to generate nutritionally complete meals automatically. A blank planner organizes information; it does not assess a person’s medical or dietary requirements.

Choose a layout that fits your household

Start with the decisions you actually make. A household that only plans dinners may need seven rows and two columns: day and dinner. If breakfast, lunch, dinner, and snacks all need planning, use a column for each. Include an optional notes column for preparation tasks, leftovers, or reminders such as “defrost chicken.” Avoid adding fields you will not maintain; a complicated template can become more work than the planning it is meant to simplify.

A practical workbook can have three worksheets:

Weekly Plan: the days, meals, recipe names, and preparation notes.
Recipes: recipe names, servings, ingredients, and any useful notes.
Shopping List: ingredients to buy, quantities, units, categories, and optional estimated prices.

Use consistent recipe names across the plan and recipe list. “Bean chili” and “chili” may look like the same meal to a person, but they are different text entries to a spreadsheet unless you standardize them. If a meal is flexible, write a clear placeholder such as “leftovers” or “choose from freezer,” rather than leaving the cell blank and later wondering whether it was forgotten.

Build a basic weekly planner in Excel

In Excel for Microsoft 365 on Windows, open a blank workbook and rename the first sheet Weekly Plan. In row 1, enter headers such as Day, Breakfast, Lunch, Dinner, and Prep Notes. Enter Monday through Sunday in A2:A8, then fill in meals as you decide them. You can add a second sheet with the plus button beside the sheet tabs and name it Shopping List.

Put one meal or task in each cell. Keep a dish name short, and put longer instructions on the recipe sheet.
Make the headings easy to scan. Select the header row and use Home > Bold; use Home > Wrap Text if headings or notes need more than one line.
Keep the day names in the same order every week. When the first row contains headings, View > Freeze Panes > Freeze Top Row can keep those headings visible while you scroll.
Save a blank copy as a reusable starting point, then use Save As to make a new file for each planning period if you want to preserve past weeks.

On Mac, the same worksheet approach and most ribbon commands are available, although the placement or wording of controls can vary slightly by Excel version. Excel for the web uses a browser interface, and some desktop commands may be arranged differently. If you want a dropdown for repeated meal names, select the cells and choose Data > Data Validation, then set Allow to List and enter the permitted choices as the source. The dialog may look different across platforms.

Add useful formulas without making the sheet complicated

Formulas are optional. A planner can work perfectly well as a plain grid, but a small count can help show how much of the week is filled in. With dinner entries in D2:D8 on the Weekly Plan sheet, enter =COUNTA(D2:D8) in another cell. If six dinner cells contain text and one is blank, the result is 6. COUNTA counts non-empty cells, so a cell containing a note or placeholder also counts as planned.

For a simple estimated grocery total, arrange the Shopping List columns as A: Item, B: Quantity, C: Unit, D: Estimated Price per Unit, and E: Estimated Line Cost. With quantity in B2 and unit price in D2, enter =B2*D2 in E2 and copy it down. If B2 is 2 and D2 is 3, the result is 6 in the currency used for the price. The quantity and unit price must match: for example, a quantity in kilograms needs a price per kilogram, not a price per package.

With line costs in E2:E11 and the total placed in E12, enter =SUM(E2:E11) in E12. If the first three line costs are 6.00, 2.50, and 3.60 and the remaining cells are blank, the result is 12.10. This is only an estimate: package sizes, taxes, discounts, and changing store prices can make the checkout total different. Format price cells as currency using Home > Number Format; formatting changes how a value appears, not the underlying calculation.

Turn the plan into a practical shopping list

Write ingredients on the shopping sheet in the form you will use at the store. Combining duplicates is important: if two recipes both need onions, list the total amount you intend to buy rather than creating two separate entries that could lead to overbuying. Include a unit such as cans, grams, or bunches, and use a category like produce, pantry, or dairy if it helps you shop in a logical route.

Before adding an item, check whether it is already in your pantry or freezer. A simple “Have?” column with values such as Yes or No can distinguish ingredients to use from items to purchase. You may also want to separate household staples from recipe-specific ingredients. Keep the list readable on a phone or printed page; narrow columns and long recipe notes make it harder to use while shopping.

A useful routine is to review the plan once before shopping and again before the week begins. The first review catches missing ingredients; the second lets you move a meal if schedules change. If you often buy an ingredient in a standard package that is larger than a recipe needs, note the leftover amount and plan a second use. That is usually more reliable than assuming every quantity in a recipe corresponds exactly to a package sold at a store.

How to choose or adapt a template

In desktop Excel, File > New opens the template area, where you can search for terms such as “meal planner” or “weekly menu.” The displayed selection may depend on your Office installation and connected services, so do not assume a particular template will always be available. If you download a workbook from another site, check that its layout suits your needs before entering a full week of information.

Look for a template that has enough room for your usual meals, a clear place for ingredient quantities, and no features you cannot maintain. Test it with one ordinary week. Check whether printing cuts off columns, whether the shopping list is easy to update, and whether any formulas still work after you add rows. If the workbook contains macros, you usually do not need to enable them for a basic planner. A straightforward .xlsx file with visible worksheets and ordinary formulas is often easier to inspect and adapt.

Keep a clean original before making substantial changes. If a formula or layout becomes confusing, the blank version gives you a way to start again without losing the reusable structure. Cloud storage can make a file available on multiple devices, but review its sharing settings if other people should not see it.

Common problems and sensible fixes

The most common problem is planning more meals than the week allows. Leave room for one flexible meal, leftovers, or an unplanned change instead of treating every cell as a commitment. Another frequent issue is building a shopping list from recipes without checking what is already at home. A short pantry check before shopping can prevent buying duplicate staples.

Too much detail: move full recipes to the Recipes sheet and keep only dish names and brief reminders in the weekly grid.
Inconsistent names: choose one name for each recipe and reuse it. This makes searching and copying plans easier.
Unclear quantities: record both amount and unit, such as “2 cans” or “300 g,” rather than writing “2” alone.
Broken totals: confirm that the formula range includes all intended rows and that quantities and prices are numeric values rather than text.
A list that is hard to use: sort or group items by store section, and remove recipe instructions that do not belong on the shopping sheet.

Do not assume a colorful template is automatically more capable. Color can distinguish categories, but it does not make a formula correct or ensure a meal is suitable. If you add new rows, check that totals include them. Excel tables created by selecting a range and choosing Insert > Table can expand as you add rows, but a simple range may be easier for a small, fixed weekly list.

Spreadsheet, app, or paper planner?

A spreadsheet is a good fit if you want to change the layout, keep reusable recipes, or estimate shopping costs without paying for a dedicated planning service. It gives you control over the information, but you are responsible for maintaining the list and checking formulas. A meal-planning app may offer recipe discovery, household sharing, or automatic ingredient lists, depending on the product; check its current price, privacy terms, and feature limits before relying on those tools.

Paper can be faster for people who prefer writing by hand or do not want to open a device in the kitchen. A useful middle ground is to plan in Excel and print the weekly grid or shopping list. If more than one person edits a workbook, agree on how to mark changes and avoid keeping several conflicting copies. Excel for the web can support browser-based editing, while desktop Excel offers a broader set of workbook features; exact collaboration options depend on the account and storage setup.

Food safety and dietary needs

A meal plan is an organizational aid, not a food-safety checklist or medical nutrition plan. If someone has an allergy, verify ingredient labels and consider cross-contact risks during preparation; a recipe title alone cannot confirm that a dish is safe. For a medical diet or questions about nutrient needs, use guidance from a qualified health professional rather than treating a generic spreadsheet as personalized advice.

Plan storage and leftovers realistically. In the United States, FoodSafety.gov advises keeping a refrigerator at 40°F (4°C) or below and generally using refrigerated cooked leftovers within three to four days. Follow the applicable local food-safety guidance, especially when storing food for longer or handling higher-risk ingredients. A notes column can record when a dish was prepared, but the workbook does not replace safe refrigeration, clean handling, or checking official guidance.

Frequently Asked Questions

Is there a free meal planner spreadsheet for Excel?
Yes. You can create one in a blank workbook, search File > New for an available template, or use a workbook shared at no charge. Check the source, terms, and any macros before downloading or enabling features.

Can I use a meal planner spreadsheet without paying for Excel?
Excel for the web is available at no cost with a Microsoft account, subject to Microsoft’s current account and feature terms. A compatible spreadsheet application may also open many .xlsx files, but formatting or formulas can behave differently, so check the workbook after opening it.

What should a weekly meal planner include?
At minimum, include days and the meals you intend to plan. A practical version also has recipe names, brief preparation notes, and a separate ingredient list with quantities and units. Add breakfast, lunch, snacks, or cost estimates only if you will use them.

How do I make a grocery list from the meal plan?
List the ingredients needed for planned recipes, combine repeated ingredients, check your pantry and freezer, and record purchase quantities with units. A basic spreadsheet will not automatically extract recipe ingredients unless you build or use a template with that capability.

Can a spreadsheet calculate my grocery budget?
Yes. Enter a quantity and a matching estimated price per unit, multiply them for each line, and sum the line costs. The result is an estimate rather than a guaranteed checkout price, and it depends on accurate quantities and current prices.

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.