Meal Planner & Grocery List: Weekly Plan, Auto Shopping List by Aisle (.xlsx)
Plan a week of meals from your own recipes and get a shopping list that builds itself: every ingredient added up, scaled to the number of people eating, minus what you already have, rounded up to whole packages, sorted by store section, with an estimated cost.
What's inside:
- Plan: breakfast, lunch, dinner and snack for 7 days, picked from dropdowns. Shows meals planned, different recipes, estimated cost, cost per meal and total cooking minutes.
- Recipes: up to 100 recipes with meal type, servings, minutes and your rating. Recipe Items: 600 rows for the ingredients in each recipe.
- Ingredients: up to 250 items with unit, store section, package size, price, what you have at home and extras to buy (like coffee or paper towels).
- Shopping List: fills itself in, sorted by store section in the order you walk the store, with amount, packages and estimated cost. Pick Yes under Got it? as you shop, and it shows how many items are left.
- Setup: week start date, number of people eating, your store sections and meal names.
- Instructions tab first, dropdowns, locked formula cells and a layout designed for small screens.
Who it's for: Families and busy people who cook from the same set of recipes and are tired of writing the grocery list by hand.
It uses only standard formulas, so it doesn't need a Microsoft 365 subscription. The sample recipes and prices are made up. Prices vary by store, so type your own for a real estimate. This file doesn't give nutrition or diet advice.
Everything is typed in by hand. There is no live data and no account connection. The sample data is made up, so you can delete it and enter your own.
Format: one .xlsx file. Open it in Excel, or upload it to Google Sheets. It uses only standard formulas that both support. No macros, no add-ons, no links to other files.
Delivery: instant download after checkout. The download link is also in your receipt email.
Questions or a problem with the file? Use this store's Contact page, or email the address in your receipt. If the file doesn't work for you, we'll fix it or refund you.
License: personal use. Use it for yourself and your household. Please don't resell, share or re-upload the file.
Built and tested with AI assistance.