Free Excel Meal Plan Template: Build a Weekly Planner

How-to basics · Updated November 20, 2026

Yes—free Excel meal plan templates are available, and you can also build a simple weekly planner in a blank workbook. In Excel for Microsoft 365 on Windows, look under File > New and search for “meal planner”; if you do not find a layout that suits you, a schedule, grocery list, and a few optional formulas are enough to make your own.

Where to find a free Excel meal plan template

Start in Excel’s template gallery: choose File > New and search for terms such as “meal planner,” “weekly meal plan,” or “meal and grocery list.” The gallery and its search results can vary by Excel version, account, and internet availability, so a particular template may not appear for everyone. You can also look for downloadable Excel workbooks from reputable template providers. Check that the file is an Excel workbook, such as .xlsx, and that its layout works for your routine before entering personal information.

Excel for the web is another option for basic planning. It is available at no cost with a Microsoft account, although access and features can change and may differ from the paid desktop application. A blank workbook is often all you need: you can enter a weekly schedule, format the headings, and keep a separate grocery list on another sheet. This avoids downloading a file whose formulas, formatting, or instructions you do not understand.

A template is a starting point, not a guarantee of a complete nutrition plan. Most are organizers: they help you decide what to cook and what to buy. Unless a workbook clearly explains its data and calculations, do not treat it as a source of verified nutrition, allergy, or medical advice.

What a useful meal planner should include

A good plan makes the next practical decisions easier without forcing you to fill in unnecessary details. For a typical household, set up one worksheet for the menu and another for groceries. Add a recipe or notes sheet only if you regularly need to keep cooking instructions or ingredient amounts alongside the schedule.

  • Weekly menu: days of the week, meal types such as breakfast or dinner, and the planned dish.
  • Servings: the number of portions you expect to make, especially when recipes need scaling.
  • Grocery list: ingredient, amount, unit, and an optional category such as produce, dairy, or pantry.
  • Notes: leftovers, a meal to prepare ahead, or ingredients already at home.
  • Optional spending estimate: an approximate price for each grocery item, rather than a promise of the final checkout total.

Keep the plan flexible. A blank space for “leftovers” or “use what’s in the fridge” can be more useful than a fully booked schedule. If several people share the workbook, a notes column can record who is cooking or flag a meal that needs to be swapped.

How to build a weekly planner in Excel

In a new workbook, rename the first worksheet “Meal Plan.” In row 1, enter headings such as Day, Meal, Dish, Servings, and Notes. Add one row for each planned meal. For example, Monday, Dinner, lentil soup, 4, and “make extra for lunch” can go on a single row. Using one row per meal makes it easier to sort, filter, or count entries than placing several meals in one cell.

  1. Enter the days and meals you actually plan to track. A dinner-only planner can have seven rows; a full-day plan will need more.
  2. Select the filled range, then choose Home > Format as Table. Confirm whether the table has headers. A table gives the list filter buttons and extends formatting as you add rows.
  3. Use a second worksheet named “Groceries.” Add columns for Ingredient, Quantity, Unit, Category, and, if useful, Estimated Cost.
  4. Save the workbook with a clear name, such as “Weekly Meal Plan.xlsx,” and copy the sheet for a new week if you want to preserve earlier plans.

On Excel for Mac, the table feature is also available from the Home tab, though the ribbon arrangement can vary with the window size and version. Excel for the web offers tables as well, but some desktop controls may be arranged differently. If you prefer not to use a table, ordinary cells still work; the key is to keep one kind of information in each column and use a clear header row.

Make the grocery list useful, not just longer

Build the list after choosing meals, then check it against what is already in your kitchen. That quick inventory can prevent buying a second bag of rice or another bottle of oil when you have enough. Grouping entries by category helps in the store, but quantities need consistent units: “2 cans” and “400 g” are more actionable than “some beans.” Keep units clear rather than adding unlike amounts together.

Some ingredients appear in several recipes. A consolidated list is helpful only when you can combine amounts safely and accurately. For example, two recipes that each require one onion can become a two-onion shopping item. But “one bunch of herbs” and “20 grams of herbs” should not automatically be treated as equivalent. If you prefer a simple template, list each recipe’s ingredients separately and mark duplicates while reviewing the list, rather than using a complicated formula that could conceal a unit mismatch.

For planning on a budget, enter estimated prices as numbers in a separate column and use the total as a rough comparison. Store prices, package sizes, discounts, and taxes can make the actual bill different. If you track costs, label estimates and dates so that an old price does not look current.

Optional formulas for a simple template

Formulas are not necessary for a useful meal planner. They help when you want a quick count or a rough total, but they cannot decide whether the plan is balanced or whether you already own an ingredient. In the examples below, enter the formula in an empty cell outside the data range.

With meal types in B2:B22 on the Meal Plan sheet—for example, the word Dinner in seven of those cells—enter =COUNTIF(B2:B22,"Dinner"). The result is 7, the number of rows marked Dinner. The spelling in the formula must match the entries in the meal column.

With estimated item costs in E2:E30 on the Groceries sheet, and sample costs of 18.50, 12.25, and 6.00 with the remaining cells blank, enter =SUM(E2:E30). The result is 36.75 in the same currency as the entered estimates. Format the result as currency using Home > Number Format if you want a currency symbol. Excel’s SUM function ignores blank cells, but text such as “about $5” is not a reliable numeric cost entry.

These formulas use standard Excel functions available in Microsoft 365. They work only if the described ranges and data are in place. If your regional settings use a different list separator, Excel may display or expect formulas differently; the examples use commas as argument separators.

How to choose between a download and a homemade workbook

Choose a ready-made file if you want polished formatting immediately and its fields match your routine. Before committing, look for readable headings, room for your usual number of meals, a grocery section, and instructions for any calculated totals. A template with macros or unfamiliar external links is usually unnecessary for a basic weekly plan; prefer a standard .xlsx workbook when you only need cells, tables, and ordinary formulas.

Build your own if existing templates include lots of fields you will never use, or if you need a particular pattern such as dinners for two weeks, a rotating menu, or a separate list for each store. A homemade sheet also makes it clear what a formula counts. The trade-off is that you must set up and maintain the layout yourself. A practical compromise is to download a simple workbook, save a copy, and remove or rename columns rather than trying to preserve every feature.

Think about how you will use it: on a laptop while planning, on a phone in the store, or shared with another person. A wide sheet with many columns can be awkward on a phone. If mobile access matters, use short headings, avoid tiny text, and keep the grocery list compact. If collaboration matters, store the workbook in a location that supports sharing and check that everyone can open and edit it.

Common problems and simple fixes

  • The list becomes difficult to read: freeze or repeat attention on a clear header row, widen columns, and avoid merging cells inside the data table. Merged cells can interfere with sorting and filtering.
  • Costs do not add up: enter prices as numbers, not text containing explanatory words. Check that the formula range includes every item and that estimates use the same currency.
  • Ingredients are duplicated: review the grocery list after planning. Similar names such as “scallion” and “green onion” may refer to the same item, but Excel will not know that automatically.
  • A plan feels too rigid: leave a flexible meal slot, or plan a short list of interchangeable meals rather than assigning every dish far in advance.
  • Old weeks get overwritten: duplicate the worksheet or save a dated copy before replacing the plan. Keep one clean master sheet if you reuse the same structure.

Do not assume a spreadsheet’s serving count scales every ingredient correctly. Multiplying a recipe by a factor can be straightforward for many ingredients, but cooking time, seasoning, pan size, and some leavening ingredients may not scale in a simple linear way. Use the original recipe’s guidance and adjust carefully.

Food, allergy, and privacy considerations

A meal plan can help you remember household preferences, but it does not verify that a food is safe for a particular person. Check ingredient labels and preparation practices for allergies or other dietary restrictions, and consult a qualified health professional for advice about a medical diet. For safe storage and cooking temperatures, use current guidance from an appropriate public-health or food-safety authority; a planning template is not a food-safety reference.

Be thoughtful about sharing. A grocery plan may reveal routines, household details, or dietary information. Share only with people who need access, use the sharing controls of the storage service, and avoid putting sensitive medical notes in a workbook that is broadly accessible.

Frequently Asked Questions

Is there a free meal planner template in Excel?

Excel’s File > New template gallery may offer meal-planning layouts, and you can search for “meal planner.” Availability varies. You can also create a basic version in a blank workbook or use Excel for the web where available at no cost with a Microsoft account.

Can I make a meal plan in Excel without formulas?

Yes. Enter meals in a weekly table and ingredients in a separate grocery list. Formulas are optional; they are useful for simple counts or estimated totals, but are not required to plan meals or organize shopping.

How do I make a grocery list from a meal plan in Excel?

Add a Groceries worksheet with columns for ingredient, quantity, unit, and category. Copy in the ingredients for the meals you selected, check your cupboards, combine clear duplicates, and sort or filter the list by category if that helps.

Can Excel automatically create a grocery list from recipes?

A basic meal-plan template will not automatically understand recipe text or combine different ingredient names and units. Automation requires a carefully structured recipe database and formulas or other tools, plus consistent ingredient data. For many households, reviewing and consolidating a short list manually is simpler and less error-prone.

Is Excel free for meal planning?

The workbook itself can be created without buying a separate meal-planning template. Excel for the web has a no-cost option with a Microsoft account, while the desktop Excel application is generally provided through a paid Microsoft 365 plan or another qualifying license. Check Microsoft’s current account and product terms for availability.

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.