Meal planning excel spreadsheets grocery list food inventory favorite recipes menu plan monthly family google docs home planner

Product Info

Organize meal planning from start to finish with these easy to use spreadsheets!

>>>> 7 Spreadsheets included <<<<

1. FAVORITE RECIPES LIST
Keep track of your family's favorite recipes along with useful info:
- Category (click the drop-down arrow to filter by category). E.g. if you haven't eaten pork in a while, filter to only see pork recipes
- Recipe name
- Source (URL of the website, or if you have a lot of recipes in binders, the binder reference e.g.#4). By storing the URL link you can directly click from the spreadsheet to the recipe page - handy if you use an iPad for cooking
- Staple ingredients (that you already have on hand)
- Other ingredients (need to buy)
- Prep + cooking time
- Optional: add a photo
- Family rating

2. MEAL PLANNER
Monthly meal planner. I use this for dinner planning only, but you could add lunch and other meals as well.

Enter the date in the first box and the rest of the month's dates will automatically pre-fill.

If you prefer to do weekly meal planner, just use the first row of this spreadsheet.

3. MEAL PLANNER - DETAILED
If you want to plan out every meal, use this monthly meal planner instead.

There are sections for breakfast, lunch, dinner and snacks.

4. FOOD INVENTORY
The cells will automatically turn blue when the quantity drops to 0 or 1 signalling it's time to restock and you should add this item to your grocery list.

Enter food by location: pantry, freezer or fridge then use the dropdown arrow to filter food by location. You can also use CTRL + F keyboard shortcut to find the food item quickly.

5. PRE-FILLED GROCERY LIST
Pre-populated with more than 220 common items. You can easily add your own grocery items, and delete any I've already entered that aren't relevant to you.

Enter the quantity required and the price you typically pay and the spreadsheet will automatically calculate the expected total cost for that shop.

You can use this for any duration you like. Weekly shop, fortnightly, monthly etc.

Right click on the tab and select 'duplicate' to save a copy of that grocery list. You can also save a copy of the meal plans in the same way, so everything is in the one place for future reference.

6. GROCERY LIST
Same as above only it's blank so you can build your own grocery list from scratch.

7. PRICE COMPARISON
Enter the prices for up to 3 shops (grocery items are pre-filled same as the grocery list, but you can delete and add your own as well) and the spreadsheet will automatically highlight which shop is the cheapest for that item, as well as the average price for that item.

If you take this with you to the shops you can see if it's worthwhile waiting to go to a shop that has the product cheaper, or if the price is close to the average for that item, it might be worthwhile to just get it.

To see all of the items that are the cheapest at one store, click the dropdown arrow at the top of the column and choose 'filter by color' then select the blue that will appear. Now you can either print the spreadsheet and take it with you to that shop or write out your shopping list by store based on what products are cheaper.
______________________________________

For more tips / details on how I use the spreadsheets, see this post from my blog: https://bit.ly/2x9IG6x
______________________________________
ABOUT THE SPREADSHEETS
- Instant download - start using it straight away!
- Excel file format (can also be used in Google Sheets and Numbers for Mac)
- Can be used for any number of people (if you're cooking for yourself, a couple, a family etc.)
- Purchase once and these can be re-used again and again
- If you store the spreadsheet on your iPad, you can directly click the URL links for the recipes, place your iPad on a stand and cook!
______________________________________
SPREADSHEET FEATURES
- Simple, clean design
- Formulas automatically calculate
- Tips and examples are in the spreadsheets to help guide you/recommended use (hover your mouse over cells that have a red triangle in the corner)
- You can type over the pre-filled items & add extra lines to customise the spreadsheets to suit your needs
- Currency can be changed from $ to pounds, Yen or any other currency you like
______________________________________

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for the link to the download page.
______________________________________
YOU MAY ALSO BE INTERESTED IN:
- Budget binder EDITABLE http://etsy.me/1NbYBhS
- Get it all printable planners: http://etsy.me/2cJWKVi
- Get it all build your own planner: https://etsy.me/39NkJPs
- Family budgeting spreadsheets: https://etsy.me/325GpDc
______________________________________
TERMS OF USE/USER AGREEMENT

I am unfortunately unable to provide after sales advice/troubleshooting on how to use Microsoft Excel or Google Sheets. Basic excel skills are required. There are no refunds under any circumstances, including if you do not have basic excel skills.

These templates are strictly for your personal use only. They are © All About Planners – you may not modify, reproduce or alter the templates, share with others or sell in original and/or modified format. I will not hesitate to proceed with legal action for violation of these terms of use.

By purchasing you accept and agree to the above terms of use.
______________________________________
PLEASE READ

>>>> Software requirements

- These spreadsheets were made in Excel 2016
- They should also work with earlier and later versions of Excel although I cannot guarantee this
- They should also work with earlier version of Excel although I cannot guarantee this
- They will work in numbers on a MAC
- They will work in Google Sheet which is free online: https://www.google.com/sheets/about/

I am not responsible if you are using a different software program and the files do not work. There are no refunds if these files will not work with your PC/laptop, or if you do not have basic excel skills and have problems formatting and/or using the spreadsheets.

The spreadsheets are intending for using on your computer or laptop (digital files to be used digitally). You can print the spreadsheets but please check the print margins before doing so, especially if you have inserted additional rows into the spreadsheet.

Most instant download items (and all sets) come in zipped folders. Please ensure your computer can open zipped folders.

Colours may vary depending on your monitor and printer.

There are no refunds on digital items.
______________________________________
DOWNLOADING THE FILES
Please note that this is a digital product and no physical product will be sent.

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for an automatic email containing the link to the download page. If you have changed email addresses or cannot locate the email which may go to your spam/junk folder, instructions for accessing the download page are included in the 'notes from seller' on your order receipt.
______________________________________
(c) All About Planners https://www.etsy.com/au/shop/AllAboutPlannersShop

Blog: https://allaboutplanners.com.au/
Digital graphics store: https://www.etsy.com/au/shop/PaperCravings
Online store: http://www.allaboutthehouseprintables.com.au/