Posted in

5 Free Weekly Meal Planner Templates in Excel

5 Free Weekly Meal Planner Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A weekly meal planner template takes the daily “what’s for dinner?” question off the table. Spend fifteen minutes once a week deciding what you will eat, and you will shop once, waste less food, eat more balanced meals and save money on takeaway. On this page you can download five free weekly meal planner templates in Excel: a weekly meal planner for breakfast, lunch, dinner and snacks, a meal plan grocery list with a running cost total, and a monthly dinner planner calendar, plus a batch-cooking meal planner and an allergy-aware weekly meal planner.

Each file is a real, editable .xlsx spreadsheet built for this page. The day names and calendar dates fill in automatically from the date you enter, and the grocery list adds up your estimated spending against a budget. The templates also open in Google Sheets and LibreOffice Calc, and they print on a single page for the fridge.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

Why Plan Your Meals Each Week?

  • Less stress. Deciding once a week is much easier than deciding every evening when you are tired.
  • Less food waste. You buy only what you plan to use, and you can plan leftovers into later meals.
  • Lower grocery bills. A list based on a plan helps you avoid impulse buys and extra trips to the store.
  • Healthier eating. When meals are planned, it is easier to include vegetables, whole grains and a variety of proteins.
  • Fewer takeaway nights. With ingredients already at home, cooking becomes the easy option.

Download the Free Weekly Meal Planner Templates

All five templates are hosted on this website and free to download. The preview shows each spreadsheet as it prints.

1. Weekly Meal Planner

Weekly meal planner template in Excel with breakfast, lunch, dinner and snacks

The weekly planner has one row for each day of the week and columns for breakfast, lunch, dinner and snacks. Enter the first day of the week in the “Week of” cell, and the day names update automatically. The first three days include example meals so you can see how it works; replace them with your own. A notes area at the bottom is useful for reminders such as “defrost chicken on Tuesday night” or “double the soup for Thursday’s lunch”.

The planner prints on one landscape page, making it easy to stick on the fridge where everyone in the household can see what is planned.

2. Meal Plan Grocery List

Meal plan grocery list template in Excel with sections, cost total and budget

The grocery list turns your meal plan into a shopping list. Each row has the item, quantity, unit, store section and estimated cost, plus a tick box column for use in the store. The section column has a drop-down list (produce, dairy, meat, seafood, pantry, frozen, bakery, other) so you can sort the list to match the layout of your supermarket. The total of estimated costs is calculated at the bottom, and if you enter your weekly grocery budget, the sheet shows how much you have left.

3. Monthly Dinner Planner

Monthly dinner planner calendar template in Excel with automatic dates

The monthly planner is a calendar for planning dinners a month at a time. Enter the first day of the month, and the dates fill into the correct weekdays automatically, with Monday as the first day of the week. Each date has a space below it for the dinner you plan to cook. Many families use the monthly view for theme nights, such as pasta on Mondays, fish on Fridays and a slow-cooker meal on Sundays, and then fill in details week by week.

4. Batch-Cooking Meal Planner

Batch-cooking meal planner template in Excel with cook day, leftover uses, portions and notes

Plans what you will cook in a batch and which later meals it will cover, before you fill in the weekly meal planner. Each row has a cook day, the dish, the leftover meals it will serve, portions, and a note (for example, freeze two portions). Count lunches you will actually eat. Cool, label and refrigerate or freeze leftovers promptly. A Sunday chilli that also covers Wednesday lunch is the sort of row this sheet is for. Adjust portions down if you usually overcook.

5. Allergy-Aware Weekly Meal Planner

Allergy-aware weekly meal planner template in Excel with meals by day and allergens to avoid in the header

A week of breakfast, lunch and dinner with the allergens to avoid written in the header and on a notes row, so sauces and snacks are checked, not only the main dish. This is a planning aid, not medical advice. If someone has a diagnosed allergy, follow the advice they have already been given, and do not assume a meal is safe because it is written here. Keep a second usual meal in mind when you eat out or accept a dish you did not cook.

How to Plan Your Meals in 6 Steps

  1. Check your calendar. Note busy evenings, late meetings, sports practice or guests, and plan quick meals for those days.
  2. Look at what you have. Check the fridge, freezer and pantry and plan meals that use up food that needs eating.
  3. Choose dinners first. Dinner is usually the biggest meal. Pick five or six dinners and plan one leftovers or flexible night.
  4. Add breakfasts, lunches and snacks. Keep these simple and repeat favorites through the week.
  5. Write the grocery list. Go through each meal and add the ingredients you do not already have to the grocery list.
  6. Prep ahead. If you have time at the weekend, wash and chop vegetables, cook grains or make a sauce to save time later.

Meal Planning Tips

  • Cook once, eat twice. Make a larger batch of soup, chili or curry and plan it for a second dinner or for lunches.
  • Use theme nights. Themes such as stir-fry night or soup night make planning faster.
  • Rotate favorites. Keep a list of meals your household enjoys and rotate them every few weeks.
  • Plan for flexibility. Leave one evening for leftovers, eating out or a simple fallback meal.
  • Check prices. Plan around foods that are in season or on offer that week.
  • Involve the family. Let each person choose one dinner a week; they are more likely to enjoy the meals.

Meal Planning on a Budget

Use the grocery list total to keep spending in check. Set a weekly budget, then adjust the plan if the total goes over: swap expensive ingredients for cheaper alternatives, plan more vegetarian meals with beans or lentils, or use frozen vegetables, which are often cheaper and last longer. Buying staples such as rice, oats and pasta in larger packs can also reduce costs over time. Compare your actual receipt with the estimated total each week, and over a month or two you will get a clear picture of what your household really spends on food.

Meal Planning for Different Households

A meal planner works for any household, but the focus changes. Families with young children may plan simple, familiar dinners with one new dish a week. Couples or single people may plan to cook three or four times and use leftovers for lunches. People with special diets, such as vegetarian, gluten-free or low-salt, can use the notes column to record substitutions. If you are planning for health reasons, the planner can be used alongside a food journal to keep track of what you actually eat.

Storing and Using Leftovers Safely

Planned leftovers save time, but they need to be stored properly. Cool cooked food quickly, put it in the fridge in covered containers and eat it within the time recommended by your local food safety guidance, which is often around three to four days. Label containers with the date so everyone knows what to use first. If you will not eat leftovers in time, freeze them in portions, and write “freezer meal” on a future day of the planner so the food actually gets used rather than forgotten at the back of the freezer.

Printing the Planner

Each template is set up to print on one page. In Excel, choose File > Print, check that the scaling is set to “Fit Sheet on One Page” and print. A printed weekly plan on the fridge is a simple reminder for everyone in the house, and you can write changes on it during the week.

Using the Planner in Google Sheets

Upload the .xlsx file to Google Drive and open it with Google Sheets to share the plan with your household. Everyone can see the week’s meals on their phone, and anyone can add items to the grocery list during the week when they notice something is running low. In the store, tick items off as you go.

Getting Started If You Have Never Planned Meals

If meal planning is new to you, start small. Plan just three dinners for the coming week and leave the other nights open. Choose recipes you already know, and write down the ingredients you need. After a few weeks, increase to five dinners and add lunches. Keep each completed weekly planner, either printed in a folder or as a separate tab in the spreadsheet, so you build up a library of plans you can reuse. After two months, you may have enough plans to simply rotate them, which makes weekly planning take only a few minutes.

You can also check these important templates like the food journal templates for recording what you actually eat, and the family monthly budget planner templates for setting your grocery budget.

You may also like the daily planner templates for organizing busy days, and the house cleaning checklist templates for keeping the kitchen and home on track.

Frequently Asked Questions

How do I use the weekly meal planner?

Enter the first day of the week, then write your planned breakfast, lunch, dinner and snacks for each day. The day names update automatically.

Does the grocery list calculate totals?

Yes. Enter an estimated cost for each item and the total is calculated automatically. Add your weekly budget to see how much is left.

Can I share the meal planner with my family?

Yes. Open the file in Google Sheets and share it, so everyone can see the plan and add items to the grocery list.

How many meals should I plan each week?

Most people plan five or six dinners and leave one night for leftovers or eating out. Breakfasts and lunches can be simple and repeated.

Will the template work in older versions of Excel?

Yes. The templates use standard formulas that work in Excel 2010 and later, Google Sheets and LibreOffice Calc.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.