Are you looking for a Google Sheets grocery list template to help you organize your shopping?
Look no further!
In this article, I will share a free google sheets grocery list template that will make your life easier.
This template includes all the common foods categorized by the main macronutrient – protein, carbohydrates, fats, and more…
Plus, it’s easy to use!
GET THE TEMPLATE
Grocery list template – just click on the link to make your own editable copy in Google Sheets.
Here’s what we will discuss in this article:
- Why Use Google Sheets For Grocery Shopping?
- How To Make a Grocery List in Google Sheets?
- Get Free Google Sheets Grocery List Template
- How to Use Google Sheets Grocery List Template
Why Use Google Sheets For Grocery Shopping?
If you’re anything like me, then you probably find yourself forgetting to buy certain items at the grocery store each week. This can be frustrating, especially if you have a specific list of things that you need.
That’s where Google Sheets comes in!
Google Sheets is a free online spreadsheet application that you can use to organize your grocery list and more.
Here are some benefits of using Google Sheets for your grocery list:
- You can add items to your grocery list from anywhere – from your computer, phone, or tablet.
- You can share your grocery list with others and they can add items to the list.
- You can add items to your grocery list at any time – before you go to the store, or while you’re at the store.
- You can easily see what items you need to buy, and what items you already have or put in your shopping cart.
- You can also serve as a printable grocery list template if you just print it out.
- Best of all, as mentioned before, you can use Google Sheets for FREE.
I personally, for the last five years, have been using various Google Docs, and especially, Google Sheets to help me with my grocery shopping and workouts.
Speaking of the latter, if you’re interested in learning more about how I use Google Sheets for my workouts, check out this article on the Google Sheets workout template.
How To Make a Grocery List in Google Sheets?
Now that we know the benefits of using Google Sheets for grocery shopping, let’s take a look at how to make a grocery list in Google Sheets, on your own:
- Open up Google Sheets and create a new spreadsheet.
- Rename your spreadsheet to something like “Grocery List” or “Weekly Grocery List”.
- In the first row of each column, you’ll want to add the following headers, representing the category of food items. You could categorize foods by food groups, such as fruits, vegetables, meat & poultry, fish & seafood, dairy & eggs, etc. As a fitness enthusiast, I prefer to categorize foods by macronutrients – protein, carbs and fats.
- Then you will want to add the food items that you typically buy, under each respective category. This is the most important and time-consuming part.
- Add a column for “Quantity”, next to each column header, and then add the quantities next to each food item.
- You can then use the list as it is when going to the store, and then simply delete the quantity of each food item once you have put it in the shopping cart. Moreover, you can use Notes or Comments or features to keep track of specific notes, such as “buy organic”, or “on-sale”.
- Alternatively, you can create a separate tab in your spreadsheet and then create dropdowns and a Data Validation option for selecting the food items from a specific food category. This is what I did in my Google Sheets grocery list template.
As you can see, making a grocery list in Google Sheets takes time, so I made a free grocery list template for you that has all the common food items organized by the main macronutrients – protein, carbs, fats as well as some other categories.
Get Free Google Sheets Grocery List Template
GET THE TEMPLATE
Grocery list template for free – just click on the link to make your own editable copy in Google Sheets.
Once you click on the link, a new tab will open where you will have to click on the “Make a copy” button.
A copy of the Google Sheets Grocery List Template will be automatically created and stored in your Google Drive.
Thereafter, the spreadsheet document should open up automatically.
Once you have the template, you can edit it to your liking, add or delete food items, and use it for your grocery shopping needs.
We will discuss this in more detail below but feel free to experiment with the template on your own.
How to Use Google Sheets Grocery List Template
Using the Google Sheets grocery list template is pretty straightforward.
But first, let’s get familiar with the template itself.
The grocery list spreadsheet has just two tabs:
- DATA Tab: Here you will find all the food items categorized in their own category.
- Grocery List Tab: Here is where you will be able to input all the food items you would like to buy in the grocery store.
Now let’s discuss how to set up your grocery list using the template.
Adding and Deleting Food Items
The first thing you need to do is go to the DATA tab and see if you would like to add more food items in their own category.
To add a new food item, type in the name of the food in the next empty cell under its respective category.
You can also remove specific food items if you do not eat them or if you would never want to buy them.
To remove a food item, simply delete/empty the cell that contains that food item.
Note that the DATA Tab is protected, which means that every time you edit something, a pop-up will appear asking whether you want to edit it.
To edit the cells, simply click “OK”.
If you are going to edit multiple cells then you can tick the box “Don’t show this again for 5 minutes”.
Selecting Food Items for the Grocery List
To know which food to include in your grocery list you will need to plan out your meals for the week.
You will need to know how much of each food item you need in order to make those specific meals.
It’s important to have a balanced diet where most meals have a sufficient amount of each macronutrient – protein, carbs, and fats.
This will help you hit your daily caloric and macronutrient targets.
So, how do you select which food items to include in your grocery list?
It’s quite simple, actually.
I prefer to think of which food item I would like to eat from each of the macronutrients.
Then I form meals around those food items.
For example, when coming up with dinner, I might want to eat salmon as the source of protein and healthy fats, and rice as a carbohydrate source, when it comes to veggies, I could choose broccoli.
You can use this method for each meal of the day until you have a list of meals with all the ingredients you need.
Here are a few more examples:
|Meal||Protein Source||Carb Source||Fat Source||Fruits & Veggies|
|Meal #1||Whey Protein Powder||Oatmeal||Peanut Butter||Berries|
|Meal #2||Chicken||Pasta||Olive Oil||Broccoli|
|Meal #3||Lean Deli Meat||Whole-Wheat Bread||Low-Fat Mayonnaise||Lettuce and Tomato|
|Meal #4||Salmon||Rice||Olive Oil||Vegetable Mix|
|Meal #5||Greek Yoghurt||Granola||Mixed Nuts||Mixed Berries|
Once you have planned your meals, go to the grocery list tab and start selecting food items from the drop-down menus.
First of all, you will need to choose the “Food Source/Category”. Let’s say – Protein.
Then, you will select the specific “Food Item”. For example – Salmon Fillet. Note that you can either find and select the food item from the list or just type in the name of the food item and it will appear in the drop-down menu.
In the “Quantity” column you can input the quantity of a given food item. For example – 440 grams.
Tracking Grocery Items in Google Sheets
Once you have added all the food items you need to buy in the grocery store, it’s time to go shopping!
As you’re buying each food item, simply tick the checkbox in the “Check?” column.
This way you will be able to track which food items you have already put in your shopping cart (or have bought in another grocery store) and which ones are still missing.
Lastly, I have included a column for “Notes” in case you want to write down anything specific about the food item you selected. For instance, I could say “Wild Salmon”.
Alternatively, you can print out the grocery list, take it with you to the store and use your pen or pencil to tick the checkboxes.
To print, go to File -> Print or use the keyboard shortcut Ctrl + P.
In the print settings, make sure to deselect “fit to page”.
This way the grocery list will print on one page.
Aslo, feel free to change anything in the Grocery template (after column B – “Food Item”) to better suit your needs.
If you still did not get the free grocery list template. (Click here to make your own editable copy in Google Sheets.)
Google Sheets is a great way to keep track of your groceries and make sure you’re not forgetting anything while you shop.
I hope you find this grocery list template helpful!
If you are a fitness enthusiast like me and are currently in one of the following phases – bulking or cutting, I recommend you check out grocery lists, also made using Google Sheets, for each of those as well.
You can find them here:
- Bulking Grocery List For Any Budget (With Template)
- Cutting Grocery List For Any Budget (With Template)
Also, if you would like to learn how I use Google Sheets to track my workouts in the gym, check out my workout spreadsheets made in Google Sheets.
What other ways do you use Google sheets?
Let me know in the comments below.