How to Build a Weekly Meal Plan in a Spreadsheet (With Auto Grocery List)

Meal planning fails when it lives in your head and the grocery list lives on a sticky note. A free weekly meal planner spreadsheet links the week’s meals to an auto-generated grocery list — you shop once, cook what you planned, and waste less.

Plan the week in one grid

Put days across the top and meal slots down the side — breakfast, lunch, dinner, snacks if you want them. Fill cells with meal names or recipe links, not ingredients yet. The goal is a realistic week, not a chef’s tasting menu.

Rules that keep plans executable:

• Two anchor meals you repeat every week (same breakfast, batch-cooked lunch).
• One empty slot for leftovers or takeout so the plan flexes.
• Shop-day alignment — plan heavy cooking on days you actually have time.

Let the sheet build the grocery list

The template pulls ingredients from your meal rows into a consolidated shopping list. Duplicate items sum automatically — three recipes that need onions become one line with the total count.

Before you leave for the store:

1. Cross-check the list against what is already in the pantry.
2. Add household staples (coffee, paper towels) in a separate section so they do not mix with recipe lines.
3. Optional: pair with the grocery budget spreadsheet to cap spend before you shop.

Make it stick

Photograph the filled grid and pin it inside the pantry door. The plan only works if everyone in the house can see what dinner is tonight without opening a file.

Revise Sunday night for ten minutes. Small adjustments beat abandoning the system after one overambitious week.

These templates are operational household tools, not dietary or medical advice.