Personal template
Meal Planner & Grocery List
A week of meals plus a costed shopping list that totals itself.
- Live formulas
- 13
- Columns
- 5
- File
- 8 KB
$5
Checkout opening soonOr get it with all 66 paid templates in the complete pack — $45.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide.
About this Meal Planner & Grocery List template
Planning the week's meals saves money and ends the nightly 'what's for dinner' debate. This Excel meal planner sets out breakfast, lunch and dinner for each day with the number of servings, and includes a shopping list that totals itself.
The shopping summary shows the grocery total, the number of items on the list and the cost per serving.
Good for
- →Planning a family's meals for the week
- →Keeping the weekly food shop to a budget
- →Batch cooking and meal prep
What it works out for you
Shopping
- →Grocery total
- →Items on the list
- →Cost per serving
What you fill in
The table has 5 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Day
- →Breakfast
- →Lunch
- →Dinner
- →Servings
How to use it
Plan the week at the top, then build the shopping list below. The grocery total updates as you add items.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Functions it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
COUNTAIFERRORSUMQuestions about the Meal Planner & Grocery List
How is the cost per serving calculated?
The grocery total divided by the total number of servings planned for the week.
Do the meals link to the shopping list?
No. Plan the meals, then add what you need to the shopping list with a price for each item.
Can I use it for more than one week?
Save a copy for each week, or keep your favourite weeks to reuse.
