Automated shopping list Excel Chi Tiết

Mẹo về Automated shopping list Excel 2022


Pro đang tìm kiếm từ khóa Automated shopping list Excel 2022-01-10 10:38:01 san sẻ Thủ Thuật Hướng dẫn trong nội dung bài viết một cách 2021.







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; Ive 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.




  • Lets take a closer look!

  • 1. FAVORITE RECIPES LIST

  • 2. MEAL PLANNER

  • 3. MEAL PLANNER DETAILED

  • 4. FOOD INVENTORY

  • 5. PRE-FILLED GROCERY LIST

  • 6. GROCERY LIST

  • 7. Price Comparison

  • How to use Excel spreadsheets in Google Sheets

  • Open in Google Sheets on your iPad or iPhone

  • Open in Google Sheets on your computer

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

  • More ideas for planning using Excel

  • You may also be interested in…

  • Share this:

  • Video tương quan


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 youd like a copy of the spreadsheets I made, theyre available in my shop (here) or my Etsy shop (here). They will work in Microsoft Excel, Google Sheets (không lấy phí trực tuyến tool) and Numbers for Mac.


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


Lets take a closer look!


Toenlarge the screenof 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 its stand and start cooking. I do still prefer recipes printed on paper so have been using this only for recipes Im 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 không lấy phí printable recipe binder


Ive labelled this spreadsheet Favorite Recipes List as everyone probably doesnt 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


Ive added some useful info to the spreadsheet:
Category (click the drop-down arrow to filter by category). E.g. if you havent 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. Ive 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, Ive 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.


Ive set the spreadsheet up so that when you enter the date in the first box, the rest of the months 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 wouldnt worry about keeping a detailed food inventory, however with supermarket shelves practically empty, Ive found I needed to start tracking what I do and dont 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 its 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


Ive pre-populated this grocery list with more than 220 common items. You can easily add your own grocery items, and delete any Ive already entered that arent 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 dont 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 youve 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 its 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 its 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 youd like a copy of the spreadsheets I made, theyre 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 havent done so already

  2. E-Mail 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 havent already, login to your Google Sheets account

  2. The file should automatically open. If you save the file in Google Sheets youll 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. E-Mail 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 havent 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, youll 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, quý khách sạn, tours, bookings, packing list etc.)

  • How to organize your life using 1 simple spreadsheet in Excel (plus không lấy phí tải về)

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…


  • Artful Agenda Digital Planner reviewArtful Agenda Digital Planner review

  • Plum Paper Planner Comparison: Colorful versus Neutral (Which is better?)Plum Paper Planner Comparison: Colorful versus Neutral (Which is better?)

  • FREE Digital PaperFREE Digital Paper

  • Day trip to Versailles from Paris (by train)Day trip to Versailles from Paris (by train)

  • May Designs Planner Review (Pros, Cons and Video Walkthrough)May Designs Planner Review (Pros, Cons and Video Walkthrough)

  • 130+ functional ideas to use blank notes pages of your planner or an empty notebook130+ functional ideas to use blank notes pages of your planner or an empty notebook





Share this:



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

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





Video tương quan













Video Automated shopping list Excel ?


Một số hướng dẫn một cách rõ ràng hơn về Review Automated shopping list Excel tiên tiến và phát triển nhất .


Chia Sẻ Link Cập nhật Automated shopping list Excel miễn phí


Pro đang tìm một số trong những Share Link Down Automated shopping list Excel miễn phí.

#Automated #shopping #list #Excel

Đăng nhận xét

Mới hơn Cũ hơn