Skip to Content

How to Use Google Sheets for Grocery Shopping and Meal Planning

Friends, today I’m going to let you in on one of my best meal planning tips.

It’s Google Sheets! a.k.a. Google’s handy version of Microsoft Excel.

Google Sheets has been absolutely instrumental in helping me refine my grocery shopping process and ensuring I no longer buy ingredients I don’t need. As a result, we waste far less food in our home than before, and we are more likely to stick to our grocery budget. That’s a big win at my house!

Plus, the digital system syncs between my iPhone app and my desktop computer, so I always have my grocery list with me.

You can access my personal Grocery List and Meal Plan template right here! Simply make a copy, then use as you see fit.

Here’s how it works:

  • I use one spreadsheet to record my planned meals for the week – breakfast, lunch, dinner, and snacks
  • I use another spreadsheet to track the ingredients we need for the week, organized by aisle.

Simple right? Let’s dig a little deeper.


Setting Your Meal Plan in Google Sheets

First things first, you need to determine what you’re making for the week before you can start shopping. This planning will keep you from getting things you don’t need or won’t eat, thus helping prevent food waste. 

I prefer to plan everything out – breakfast, lunch, dinner, and snacks too! As you can see below, I’ve organized my meal plan by day and meal type. I’ve also included a column for the snacks I’ll be eating and another that tells me what I need to make ahead for the sake of convenience (for example, a batch of rice or muffins). 

It’s simple, it’s quick, and it works really well for me!


Deciding What to Eat with Pinterest

I am a huge fan of Pinterest (it always inspires me with new meal ideas and I rely on it greatly for my meal planning!).

Before I start working out my meal plan for the week, I typically pin meals that interest me to my “Meal Plan” board. Then, I transfer those ideas to my Google Sheet. This also comes in handy when it’s time to write out your grocery list!

Simply open up the recipe pin in one window, then record the ingredients you need in your Google Sheet. Super simple! Here’s what that looks like:

Feeling inspired? Follow @zerowastememoirs on Pinterest for tons of zero waste tips and yummy vegetarian & vegan recipes!


Tracking Grocery Items in Google Sheets

Once you have your meal plan in place, you can set your grocery list!

This Google sheet is where I record every food item I need for the week, including pantry staples. All the items we commonly purchase at the grocery store are listed and organized by aisle (i.e. vegetables in one column and baking goods in another). I operate best when I can see all the options in front of me, so I’ve organized myself this way. 

Another alternative would be to have columns like “Vegetables” and “Baking Goods” in place, and then type in the items you need for the week, as you think of them. Up to you!

Here’s what my grocery list looks like:

As you can see, I have all the most popular ingredients already listed. If I need an item, I highlight it in yellow, then add a quantity next to it if necessary.

If the item requires I keep in mind specific circumstances (such as recipe requirements), I make a note using the comment feature in Google Sheets.

You can see what this looks like below!

I love this system because it keeps me efficient and on track. When I go to the store, I know exactly what I need in each section, which keeps me from bouncing around the store, wasting time.


Why I Love This System

I’ve tried a lot of meal planning tools in my day, from pen and paper to digital notes, and more apps than you can imagine. The problem was, I always ended up with different lists in different places, and having to type in ingredients on my own was time-consuming and irritating to me.

With Google Sheets, everything I need is in one place. No switching between apps and lists! Plus, I love that I can discover ideas on Pinterest, work out my grocery list on my computer, then add to it throughout the week on my phone.

This system will work for you if:

  • You are comfortable working in a digital environment
  • You are a good list keeper
  • You always have your phone on you
  • You have a natural bent toward organization

Sound like something you’d enjoy? You can borrow my own personal spreadsheet here!

Just download your own copy and go for it!


Pin this for later!

Ashley

Sunday 15th of May 2022

Thank you so much for the Google sheet!

Diane

Wednesday 9th of February 2022

I love this. I am currently using 2 popular apps but I'm finding something in each of them that I'm not particularly fond of. Plus there is a yearly cost to use them.

So I went looking for how to set up menu planning with Google Sheets and was guided to your website. Your menu planning system works for me. I LOVE this. Simple and inexpensive.

Thank you so much for sharing!

Laura

Saturday 11th of September 2021

Thank you for creating this! The grocery list is easy to use. I love the idea of having everything in one place. I just didn't know how. I've tried organizing recipes in favorites bar folders, but it gets really full and hard to find the recipes. Linking the recipe website in the weekly planner is so much easier! I can just have that open every night and know exactly which recipe I'm cooking. I also shared it with my fiancé so he can highlight needs. This is perfect. Thank you again!

Brittany

Sunday 6th of June 2021

Listen, I never subscribe to blogs or anything. I have seven kids and meal plan as it is but I need to tighten up our spending. I've looked for apps and currently just work off of a white board but that always leads me to forgetting ingredients. This is by far the best. Thank you so much.

Nadine

Friday 19th of November 2021

So glad to hear it!

Jenny Hale

Saturday 30th of January 2021

Thanks Lauren. This is exactly what I have been searching for. I have paper lists, printed templates and recipes all over the place. This is a format I am well accustomed to and will really help with the meal planning for the week.