Meal Planner and Grocery List

A meal planner spreadsheet that builds your grocery list from the week's meals, sorted in the order of the aisles at your store.

What's included

• Recipe library for up to 100 recipes with meal type, servings, time, tags, cost per serving and how often you've planned it
• Ingredients list for each recipe, using the items and units from your pantry list
• Meal plan for 52 weeks with breakfast, lunch, dinner and snack, picked from your recipes or typed in
• Grocery list for any week you pick, grouped by aisle, minus what you already have, with an extras list
• Pantry list for up to 200 items with on hand, keep-at-least amounts, use-by dates and low or out flags
• Grocery spending log with a monthly budget and totals by store
• Dashboard with this week's meals, items to buy, estimated cost and spending this month
• A Start Here tab and a 2-page Quick Start Guide (PDF)

How it works

Add your recipes once, then pick meals for the week. The grocery list fills in by aisle and estimates the cost from the prices you enter. Mark items as you shop and log the trip to see how the month compares with your budget. It comes with a sample family's recipes and a few weeks of meals.

Files and apps

• Meal Planner and Grocery List.xlsx
• Quick Start Guide.pdf
• Works in Excel 2016 or newer (Windows or Mac), Microsoft 365 and Google Sheets. No macros or add-ins. Formula cells are locked without a password so they don't get typed over; the cells you fill in are white.
• To use it in Google Sheets, upload the file to Google Drive, open it with Google Sheets and choose File > Save as Google Sheets. It works in the Google Sheets phone app too.

This is a digital download. Nothing is shipped. After you buy, the files are on your Etsy Purchases page (or in the Payhip download email).

License

Household license: for use by one household. You can edit it and print it for your own use. Please don't resell, share, give away or upload the files, changed or not.

Questions or stuck on a formula? Email Bengopoyan1@gmail.com. More templates at payhip.com/KeelandCharter and etsy.com/shop/KeelAndCharter.

Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.