Weekly Meal Prep Planner Excel - Free Template

1. Step 1 — Open the Weekly Plan sheet and change cell B2 to the relevant week commencing date. Adjust the dates in the meal rows to match your schedule.
2. Step 2 — Enter each meal, choosing a Meal Type and Recipe Category from the drop-down lists.
3. Step 3 — Add servings, preparation time, calories per serving, protein per serving and estimated cost. Record whether preparation is required.
4. Step 4 — Change Prepared? to Yes when each meal is completed. Preparation Status and the completion percentage update automatically.
5. Step 5 — Open Ingredients & Shopping and enter ingredients, quantities, units and estimated unit costs. Mark Already Have? as Yes for items already in stock.
6. Step 6 — Choose a preferred supermarket and review the calculated To Buy? and Estimated Total Cost (£) columns before shopping.
7. Step 7 — Use the Dashboard to review cost, servings, calories, protein, meal counts, shopping items and preparation progress.

A weekly meal prep planner suits households, students, gym users, shift workers and anyone who wants to decide meals before the working week begins. It is particularly useful when several meals need to share ingredients, such as chicken breast used for rice bowls and leftovers.

Planning a realistic week

Use the Weekly Plan sheet during a Sunday planning session or before a supermarket order. The sample rows show 2 servings of overnight oats at £1.35, followed by 4 servings of chicken tikka rice bowls at £3.80. Those entries give 6 planned servings and £5.15 of illustrative meal cost before other rows are added.

Enter Breakfast, Lunch, Dinner or Snack in Meal Type. Recipe Category choices include Vegetarian, High protein, Quick meal, Batch cook, Fish and Family favourite, so you can review the type of food being planned rather than relying on meal names alone.

Making batch cooking visible

A parent preparing family meals can enter 4 servings for a dinner and note Portion into microwave-safe containers in Notes. A single person might enter 2 servings for overnight oats and mark the meal as requiring preparation. The Prepared? field then gives a simple record of what has actually been completed.

The Ingredients & Shopping sheet supports a practical UK shop. For example, the sample list records 1 kg of chicken breast at £6.50 from Tesco, 1 kg of brown rice at £1.80 from Aldi and 4 tins of tomatoes at £0.55 each from Asda. Use these figures as examples only and update them for current prices.

Using the workbook at different points

Complete the meal plan first, build the ingredient list before shopping, then update preparation status during the week. The Dashboard brings together the resulting weekly cost, servings, calories, protein, meal-type counts and shopping items still required.

The workbook separates entries from calculated results. On Weekly Plan, you enter meal details in rows 6 to 105; formulas calculate Day from the date, Preparation Status from Prepared?, Total Calories from servings multiplied by calories per serving, and summary measures from the planning range.

Checking the meal calculations

If a meal has 4 servings and 620 calories per serving, Total Calories becomes 2,480. If its estimated cost is £3.80, that amount contributes to Total weekly cost and to the average meal cost calculation. The workbook also sums servings and averages protein per serving.

Use the Yes and No validation lists consistently. Prepared? accepts Yes or No, while Preparation Status changes to Complete when Prepared? is Yes and Outstanding when it is not. Blank meal rows are handled by the formulas so unused capacity does not need to be deleted.

Building the shopping estimate

On Ingredients & Shopping, Estimated Total Cost (£) is calculated as Quantity Required multiplied by Estimated Unit Cost (£). A quantity of 4 and unit cost of £0.55 therefore produces £2.20. To Buy? changes according to Already Have?, allowing stock already held at home to be excluded from the shopping requirement.

The Linked Meal field uses a validation list based on meal names in Weekly Plan. Linked Calories/Serving uses a lookup from the plan, so matching meal names matter. If you rename a meal after linking ingredients, review those links rather than assuming the relationship has changed safely.

Use stable entries and review outputs

Enter numbers as numbers, not text with units attached: use 1 in Quantity Required and kg in Unit. Keep £6.50 in the cost field rather than typing a note into the calculation area. The Dashboard contains formulas and three charts, but it does not replace checking the source rows.

The main risk is not a complicated formula; it is inconsistent input. A meal entered as Dinner in one row and as a free-text variation elsewhere can make the Dashboard counts misleading. The validated Meal Type list prevents that particular drift when you use the supplied choices.

Incorrect serving and cost assumptions

If 4 servings are entered for chicken tikka rice bowls but the ingredient quantity is only enough for 2, the workbook will still calculate the figures you supplied. For example, 4 servings at 620 calories gives 2,480 total calories, but the spreadsheet cannot judge whether the food quantity is realistic.

Similarly, entering £6.50 as the total price when it is actually the unit price changes the shopping estimate. One 1 kg item at £6.50 is clear; four tins at £0.55 should produce £2.20, not £0.55. Review quantity, unit and unit cost together.

Unfinished preparation records

Leaving Prepared? as No means the meal remains Outstanding. If 7 planned meals exist and only 5 rows are changed to Yes, the completion calculation reflects 5 completed meals out of 7 populated meal rows. Do not mark a meal prepared merely because it was planned.

Another failure occurs when an ingredient is marked Already Have? as Yes even though it has been used up. The automatic To Buy? result will show No, so the shopping list understates what is needed. Check cupboard, fridge and freezer quantities before changing that field.

Broken links between sheets

Linked Calories/Serving depends on the meal name matching Weekly Plan. If the ingredient row refers to Chicken tikka bowls while the plan says Chicken tikka rice bowls, the lookup may return a blank. Correct the linked meal text instead of manually typing a substitute into the calculated output.

Use the workbook at three fixed points: plan meals before shopping, check ingredients while placing the order, and update preparation after cooking. A routine is easier to maintain when each stage has a defined action rather than treating the file as a diary.

A practical three-stage habit

• Plan: set B2 to the selected week, review the previous meal choices and enter the next meals in rows 6 to 105.
• Shop: update unit costs, mark existing stock as Yes in Already Have? and review rows where To Buy? is Yes.
• Prepare: change Prepared? to Yes immediately after portioning or completing a meal, then check the Dashboard.

For example, a household with 8 planned meals can reserve 15 minutes to confirm servings and ingredients, then use the Dashboard to see whether all 8 have been marked complete. If only 6 are complete, the preparation overview gives a prompt to investigate the two outstanding rows.

Keep entries consistent

Use the drop-down lists instead of inventing categories. Keep meal names distinctive when linking ingredients, and update prices whenever the supermarket basket changes. The Instructions sheet specifically identifies costs as planning estimates, so treat £6.50 chicken or £1.80 rice as editable examples rather than fixed prices.

Do not overwrite formulas in calculated columns such as Total Calories, Estimated Total Cost (£), To Buy? or Preparation Status. If you need a different result, change the source inputs. Copying a completed workbook for a new week can work for a simple routine, but check dates, meal names and old preparation statuses before relying on it.

When to move on

A spreadsheet remains suitable while one person or a small household can maintain the 100-row planning range and review the calculations. If multiple people need simultaneous editing, recipe-level stock control or a larger historical database, consider moving to a dedicated meal-planning or inventory system while retaining this workbook for straightforward weekly planning.