Excel + Google Sheets
Weekly Meal Planner
Weekly meal planner spreadsheet for Google Sheets and Excel: a recipe organizer whose planned meals build your grocery list, minus what's already in your pantry, with an optional calorie and macro tracker.
Plan the week once and the grocery list writes itself. Save your recipes, drop them into the week, and the sheet compiles exactly what you need to buy, checked against what's already in your pantry.
Coming to Etsy this week
Instant download on Etsy: Excel files plus a link to your own Google Sheets copy.
What’s inside · 14 tabs
- Welcome / 02 Setup: Your units, categories and goals, set once
- Recipe Card: Add a recipe with ingredients, servings and category
- Recipe Book: Your growing library
- Recipe Finder: Browse the library by category when "what's for dinner" hits
- Meal Planner / 07 Meal Schedule: Breakfast, lunch and dinner across the week
- Inventory: What's already in the pantry, so you don't buy doubles
- Shopping List: Built from the recipes you planned, minus what you have
- Printable Shopping: A one-page list grouped by aisle
- Calorie Tracker: Optional daily goals for calories, fat, protein, carbs and fibre
- Weight Tracker: Multi-profile log with automatic BMI, imperial or metric
- Dashboard: Recipes, estimated weekly grocery spend and nutrition, with charts
- 14 A recipe database tab that quietly powers the rest
Features
- The shopping list is generated, not typed: from your actual planned recipes
- Pantry-aware: what you already own is subtracted before you shop
- Printable aisle-grouped list for the supermarket
- Calorie and macro tracking is optional: the planner works fine without it
- Any currency and both unit systems
- Filled EXAMPLE workbook + clean BLANK workbook included
- Every formula tested before publishing
You’ll need
- Microsoft Excel 2016 or newer (desktop; Microsoft 365 not required) or a free Google account for the Google Sheets version.
- Best on desktop or laptop.
More in Lifestyle trackers
