How to Use Google Sheets for Grocery Shopping and Meal Planning

google sheets meal planning and grocery shopping

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 download your own 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!

14 thoughts on “How to Use Google Sheets for Grocery Shopping and Meal Planning

  1. Mags McCool says:

    Heya,
    I love your method. I’m going to give it a try after yet another morning of throwing out wasted food (what a terrible shame). I needed some way of linking my meal planning with what I buy. So lets try out your style and see what happens.

    Alongside that do you repeat meals weekly or monthly depending on their success. Or do you just keep trying new things? I need to be much more efficient in the kitchen 🙁

    • Lauren says:

      Yes! I’ve found that the Pinterest-board-meal-planning combo helps me buy only what I need for cooking that week.

      As for meal repeats, I have a few go-to recipes that I know I can rely on when I’m not feeling very creative or I’m pressed for time. For us, that’s spaghetti with truffle oil red sauce, tofu teriyaki stir fry with broccoli, onions, and carrots, and sweet potato, black bean quesadillas. They’re healthy, quick to make, and I almost always have the ingredients.

      That said, I am big on experimentation, so I’m constantly pulling new recipes into my Pinterest collection. I have boards for every meal, then when it comes time to design my meal plan for the week I just reference those boards — say, VEG // Dinner — and add what sounds good to my MEAL PLAN board.

      I hope that’s helpful!

  2. Deanna says:

    Very helpful, simple format. Only complaint is I wish there was a column for meat other than fish. If it’s because you’re vegan/vegetaria n that makes sense, but it would have been helpful for the sample version. But still very helpful and not difficult to add it myself. Thanks for sharing!

    • Lauren says:

      I’m glad you’ve found it useful! We were pescatarian when I made this spreadsheet, which is why meat wasn’t included, and this is the version I use myself. Either way, it sounds like you were able to make it work!

  3. Tricia says:

    I love this! I wanted to start meal planning and the apps and paper planners I have are just too much at one time! I’m a major Google Docs user at work, so this is PERFECT! Thank you!!

  4. jenny says:

    Thank you for sharing the google documents. this saved me lots of time! i shared your link on facebook too, so hopefully others can benefit too.

  5. Anchla Joshi says:

    Thank you for sharing, I am going to give it a try.
    I find the same thing, I make my lists at home and meal plan and I can’t remember anything when around town.

Leave a Reply

Your email address will not be published. Required fields are marked *