Report this item to Etsy

Meal Planner Spreadsheet with Auto Grocery List, Weekly Meal Plan for Google Sheets and Excel

Price:$7.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by InkAndIndexShop
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Pick a recipe for each meal and the grocery list writes itself: the Grocery List tab adds up every ingredient you planned and scales the quantities to the number of people. A weekly meal planner for Google Sheets and Excel.

WHAT YOU GET (3 files)
- Meal-Planner_Blank.xlsx: your own copy
- Meal-Planner_Example-Filled.xlsx: the same workbook with eight invented recipes and two invented weeks for a household of two, so you can see the grocery list work
- T6-Read-Me-First.pdf: a 4-page guide for Excel and Google Sheets

HOW IT WORKS
- Setup: how many people you cook for, the date Week 1 starts, and the aisle order of your shopping list (rename or reorder the aisles to match your shop)
- Recipes: a recipe store with up to 40 recipes. Type a name and how many servings the ingredients make.
- Ingredients: one line per ingredient for each recipe, with quantity, unit and aisle (up to 400 lines)
- Week 1 and Week 2: a planner with seven days and Breakfast, Lunch, Dinner and Snack. Choose a recipe in a dropdown, or type your own words such as Leftovers or Eating out.
- Grocery List: pick Week 1 only, Week 2 only or Both weeks. The list fills itself with the item, the total quantity, the unit and the aisle, up to 80 different items. Type x in Got it as you shop.

HOW THE LIST IS WORKED OUT
Each recipe line is multiplied by the number of people you cook for, divided by the recipe's servings, for every time the recipe is planned. Lines with the same ingredient name and unit are added together (capital letters and extra spaces do not matter). Units are not converted, so 200 g and 1 cup of flour stay as two lines.

EXCEL AND GOOGLE SHEETS
It uses ordinary formulas and no macros. In Google Sheets, use the link in the PDF guide to make your own copy, or upload the .xlsx to Google Drive, open it, then choose File, Save as Google Sheets. Formulas, dropdowns and colors usually carry across. Chart and color styling can change a little, so check the Grocery List after you import.

LIMITS
40 recipes, 400 ingredient lines, two weeks and 80 different items on the grocery list.

WHAT IS NOT INCLUDED
No recipe import from websites, no nutrition or calorie counting, no prices or budget, no pantry stock tracking, no unit conversion, no macros. The workbook gives no dietary, medical or nutrition advice. Check allergens and food safety yourself.

FILES AND LICENSE
Digital files only. Personal use. Please do not resell, share or upload the files.

Designed by a seller. AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The workbook's results were checked against an independent calculation of the example data.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 18, 2026