• HOME
  • Planning
    • Planner Newbie
      • New to planning? Start here
    • Planning Tips & Inspiration
    • 52 Planning Systems in 52 Weeks
      • My weekly spreads
    • Planner Index
    • Planner Reviews
      • Horizontal Weekly
      • Horizontal 1 Page Weekly + Notes
      • Vertical Weekly
      • Hourly Planners
      • Categories Weekly
      • Daily Planners
      • Discbound Planners
      • Teacher Planners
      • Planner Roundups
      • Happy Planner (MAMBI)
      • Budget Planners
    • Planner Comparisons
    • Bullet Journal
      • Bullet Journal Reviews
      • Bullet Journal Spreads
      • Bullet Journal Tips
    • Planner pens
    • Highlighters
    • Planner Stickers
    • Digital Planning
    • Household Binder
    • Stationery Shopping
    • Rachael’s Favorites
    • Blogging & Online Business
  • Graphic Design
    • Photoshop Tutorials
    • Microsoft Word
    • Microsoft Excel
    • Canva
    • Silhouette Studio
    • PicMonkey
  • SHOP
    • Shop at Etsy
    • Online Store
    • Graphic Design Resources
    • ECOURSES
    • Ebooks
      • 54 Mistakes Etsy Sellers Make (And How to Fix Them)
      • 1200 Blog Post Ideas
        • 1200 Blog Post Ideas (Exclusive Download Content)
      • 200 Blog Post Title Prompts (For Any Type of Blog)
        • 200 Blog Post Title Prompts (Exclusive Download Content)
    • Feedback & Testimonials
    • Planner Supplies (my sister’s shop!)
    • Shop my favorite planner supplies on Amazon
  • Learn
    • ECOURSES
      • Free Graphic Design Video Tutorials Library
      • How to Make Planner Stickers
      • How to Make Printables in Photoshop
      • How to Make Printables in Microsoft Word
      • How to Make Printables in Microsoft Excel
      • How to make digital planners and notebooks in Microsoft PowerPoint
      • How to Make Labels in Photoshop
      • How to Make Patterns in Photoshop
      • How to Make Party Printables
      • How to Write Product Descriptions
    • Ebooks
      • 54 Mistakes Etsy Sellers Make (And How to Fix Them)
      • 200 Blog Post Title Prompts (For Any Type of Blog)
      • 1200 Blog Post Ideas
  • FREE
    • FREE Printables
    • Free Printables Library – Subscribers Login
  • Travel
    • Travel Planning
    • Europe
    • Australia & New Zealand
  • About
    • Browse All Posts
    • FAQ
      • What is a Printable? What happens when I purchase a printable from you?
      • Printing Tips
      • Printable Planner Stickers
      • Downloading Files
      • How to Open Zipped File Folders
      • What does EDITABLE mean?
      • Monogram Etiquette

All About Planners

Printable planners to organize your home, business and life!

April 9, 2020

How I use Excel for organizing recipes, meal planning, food inventory and grocery lists

I live just down the road from 3 supermarkets so have always been a basket shopper. However, due to Coronavirus, people hoarding groceries leaving empty shelves and sometimes having to queue due to limits on the number of people allowed in a shop at one time; I’ve had to be a bit more organized with my meal planning and grocery shopping beyond just the week ahead. Since Excel has proven so useful for budgeting and organizing all my brain dumping tasks, I decided to create some spreadsheets for meal planning, food inventory and grocery shopping.

I hope you find this post helpful and that it gives you some ideas for tweaking your current meal planning method (or starting one!).

If you’d like a copy of the spreadsheets I made, they’re available in my shop (here) or my Etsy shop (here). They will work in Microsoft Excel, Google Sheets (free online tool) and Numbers for Mac.

recipe organizing menu planning food inventory and grocery spreadsheets for excel or google sheets numbers for mac

Let’s take a closer look!

To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon).

Subscribe to my YouTube channel for more planning videos!

1. FAVORITE RECIPES LIST

I made this spreadsheet a few months ago now, and have been using it in Google Sheets on my iPad. I click the URL recipe link, place my iPad on it’s stand and start cooking. I do still prefer recipes printed on paper so have been using this only for recipes I’m trying for the first time. If I like the recipe, then I print and add it to one of my recipe binders.

Read more: How to organize recipes plus a free printable recipe binder

I’ve labelled this spreadsheet ‘Favorite Recipes List’ as everyone probably doesn’t organize their recipes the same way I do. You can rename the spreadsheet as ‘Recipes to Try’ instead if you like.

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)

our favorite recipes index excel spreadsheet organizer meal planning google sheets organisation grocery list food inventory

I’ve added some useful info to the spreadsheet:
– 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

Next is a monthly meal planner. I’ve tried various methods of meal planning including printables, notepads, sticky notes, whiteboards etc. and do still use those methods but if you want to keep everything in the one place, I’ve added a spreadsheet for that.

I really only meal plan dinner (and then eat the leftovers for lunch the next day), but you could add lunch and other meals as well. If you prefer to do weekly meal planning, just use the first row of this spreadsheet.

I’ve set the spreadsheet up so that when you enter the date in the first box, the rest of the month’s dates will automatically pre-fill 🙂

meal planning breakfast lunch dinner snacks family menu plan monthly editable customisable excel spreadsheet template google sheets mac

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.

If you want to write multiple lines of text, press Alt + Enter on your keyboard for a new line.

meal planning breakfast lunch dinner snacks family menu plan monthly editable customisable excel spreadsheet template google sheets mac

4. FOOD INVENTORY

I normally wouldn’t worry about keeping a detailed food inventory, however with supermarket shelves practically empty, I’ve found I needed to start tracking what I do and don’t have, not only for creating a grocery list (feels more like a wish list these days..), but also for figuring out what to cook using what I already have on hand.

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 each location. You can also use CTRL + F keyboard shortcut to find the food item quickly as well.

food inventory excel spreadsheet template automatically notify if inventory level drops low pantry freezer fridge editable

5. PRE-FILLED GROCERY LIST

I’ve pre-populated this grocery list 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.

Formulas automatically calculate so you don’t need to waste time totalling up how much the shop is going to cost, just scroll to the bottom of the spreadsheet. Currency can be changed from $ to pounds, Yen or any other currency you like.

You can print the grocery list by going to file > print (just make sure you’ve checked the ‘fit all columns to one page’ option otherwise the spreadsheets might not print correctly). If you use the spreadsheets in Google Sheets, you can open the grocery list spreadsheet from the app on your iPhone.

grocery list template excel editable template instant download categorised grocery list shopping template google sheets

6. GROCERY LIST

Same as above only it’s blank so you can build your own grocery list from scratch.

grocery list excel template spreadsheet blank categorised by store section simple minimalist all about planners meal planning system

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.

grocery list price comparison automatically find the cheapest price shopping list couponing excel template automatic formulas meal planning

If you’d like a copy of the spreadsheets I made, they’re available in my shop (here) or my Etsy shop (here).

recipe organizing menu planning food inventory and grocery spreadsheets for excel or google sheets numbers for mac

How to use Excel spreadsheets in Google Sheets

Open in Google Sheets on your iPad or iPhone

  1. Download Google Sheets app to your iPhone or iPad if you haven’t done so already
  2. Email the file to yourself and click on the attachment
  3. Press the box with the arrow pointing upwards and select ‘copy to sheets’

how to open an excel file on your mobile phone using google sheets apple iphone email attachment free version of excel

  1. If you haven’t already, login to your Google Sheets account
  2. The file should automatically open. If you save the file in Google Sheets you’ll be able to see those changes when you login to Google Sheets on your computer, iPad etc.

how to open an excel file on your mobile phone using google sheets apple iphone

Open in Google Sheets on your computer

  1. Go to Google Sheets and login (or create a login)
  2. Click the + sign to make a new spreadsheet
  3. Go to ‘file’ and then ‘open’
  4. Choose upload, then navigate to where you saved the file on your computer

how to upload an excel spreadsheet to google sheets

5. Now you can use the spreadsheet just like you would in Excel

how to upload an excel spreadsheet to google sheets tutorial all about planners

If you want to use an Excel file in Numbers on your iPad or iPhone

  1. Email the file to yourself and click on the attachment
  2. Press the box with the arrow pointing upwards and select ‘copy to numbers’

how to add an excel spreadsheet into numbers on ipad apple device alternative to microsoft excel

  1. If you haven’t already, login to your Numbers account
  2. The file should automatically open
  3. Now you can use it just like you would in Excel (except the tabs are at the top not the bottom because Apple has to be different…). Also, if you want to type text in a cell, you’ll need to double tap the box to bring up the on-screen keyboard.

 

how to use an excel spreadsheet in numbers for ipad mac apple

More ideas for planning using Excel

  • Week 41: Weekly planning using Microsoft Excel
  • How I use Excel to organize all my travel plans (research, itinerary, hotel, tours, bookings, packing list etc.)
  • How to organize your life using 1 simple spreadsheet in Excel (plus free download)

Found this post helpful? Pin it!

How i use excel for meal planning grocery lists food inventory and organizing recipes tips inspiration ideas editable spreadsheet templates microsoft excel google sheets numbers for mac

You may also be interested in...

  • How I use Excel to Organize a Home Renovation (budget, spending, program, paint colors, contacts, quotes)How I use Excel to Organize a Home Renovation (budget, spending, program, paint colors, contacts, quotes)
  • Why I Use Microsoft PowerPoint for making digital planners and notebooksWhy I Use Microsoft PowerPoint for making digital planners and notebooks
  • How to use Microsoft Programs online and if you don’t have a PC (i.e. if you have a Mac)How to use Microsoft Programs online and if you don’t have a PC (i.e. if you have a Mac)
  • Quick and easy weekly meal planning using sticky notesQuick and easy weekly meal planning using sticky notes
  • My weekly planning setup while working from homeMy weekly planning setup while working from home
  • How to make a weekly planner using Google Sheets (free online tool)How to make a weekly planner using Google Sheets (free online tool)

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Posted In: Digital Planning, Planning Tips & Inspiration, Planning Using Excel · Tagged: digital calendar, digital grocery list, digital meal planning, digital monthly calendar, digital planning using excel, excel meal planning spreadsheets, food inventory in excel, grocery list excel template, grocery list for excel, meal planning in excel, meal planning spreadsheets excel

Welcome

Welcome to All About Planners! I’m Rachael, a 20-something Aussie addicted to graphic design and all things planning. On the blog you’ll find more than 1,000 posts about all things planning including planner reviews, tips, favorite supplies and some of my past weekly spreads.

Subscribe and join 60,000+ others on the quest to find planner peace!

Follow Me

  • Instagram
  • Pinterest
  • YouTube

Search

Subscribe

free printables library sign up all about planners blog image graphic subscribe

Shop At Etsy

The photos and content on this site are the property of All About Planners. They are not allowed to be used without permission from All About Planners.

Categories

Recent Posts

  • ARC Punch versus Happy Planner versus the Levenger 1-2-3 Punch: Which is better?
  • Clever Fox Planner Pro Weekly Review
  • Simple Christmas themed weekly spread with washi tape and stencils
  • 10 Useful printables to add to your planner or bullet journal
  • Bullet journal stencils weekly spread in the Archer and Olive Notebook

Disclaimer

All About Planners is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

Popular Posts

  • 130+ functional ideas to use blank notes pages of your planner or an empty notebook
  • Setting up a new planner: 70 Tasks to add
  • Planner Organization: How to color-code your planner so you’ll actually use it effectively
  • Clever Fox Planner Pro Weekly Review
  • 10 Useful printables to add to your planner or bullet journal

Printables

  • Learn How to Make Printables
  • How to Make Planner Stickers
  • Resources & Tools I Recommend

Subscribe to access the free Printables library

Follow Me

  • Instagram
  • Pinterest
  • YouTube
Privacy

Copyright © 2021 All About Planners · Theme by 17th Avenue