Grocery List
Posted on August 7, 2009
Filed Under Other |
Based on several online dictionaries, a grocery list is defined as a list of heterogenous items that someone wants. Grocery list become popular because it is very rare that somebody can remember many items that he/she has to buy while shopping in a store or a mart. And usually, this list is important while people do their weekly or monthly shopping for their family/household needs.
If you search “grocery list” term in google, you will find many website offering ready made or printable grocery lists. And there are some websites offering you how to create your grocery list online.
This excel file is basically a grocery list maker, where you can put all of your grocery item in one worksheet, select items that you want to buy, and the other worksheet will adjust your selection into a printable grocery list.
Guidance on how to use this grocery list template is as follow :
1. Go into “Item pool” worksheet. I already put many grocery item inside for your reference. You can click the picture below to enlarge it.
2. Put all of your grocery item in Item list column, and if you have category for your item, put your item category in the same column and put word “Cat” next to the item category name in Cat column and all the color in corresponding row will reveal automatically to differentiate between item category name and item name.
3. If you have price references for your item, you can put your item price in five available shopping mart price column, and the unit reference in price reference column. There is extra column at the right side of the item table that will find the cheapest item price and a shopping mart reference where you can shop that item. And also there is a color guidance in those five columns which will mark the cheapest item price.
4. If you have fill all of your item information, you can create your grocery list by selecting your item by filling “v” character in Checklist column. Once you finished filling Checklist column, watch Checklist Item box at the right side, next to the grocery table. You will see number there where you can use as your guidance to print the correct grocery list worksheet. You can see in my example that the number show 174, which mean you should use the worksheet “Grocery List 199″ as your grocery list. The number 199, 144 and 84 is the maximum item that will be revealed in the grocery list.
5. I put additional box in those grocery lists worksheet as an empty rows to put your replacement item, if you cannot find your item, or if you want to add other item that you might remember or your kids and husbands wants you to buy something for them while you are already on the way there or already in the store.
You can download the file here.
You can read and download my other templates below :
Comments
17 Responses to “Grocery List”
Leave a Reply
[...] excel template is a complete version of my previous grocery list template where in this template I put price and shopping mart consideration in the list to ease you finding [...]
‘would love to use your template but when I inserted lines in item pool to add more items, the information didn’t translate to the list sheets in the workbook. Not sure what I did wrong but the formulas seem to have gone awry. Any suggestions? ‘thanks tons.
@Sue: Thank you for using my template. The worksheet consist of row-related formula, so when you insert a new row, the formula is broken. You can link back the row by revealing the column B and copy the formula in corresponding cell to your inserted rows.
Or, you can create a new list by copy all item in the column to other worksheet, modify the list, and copy it back to the column.
Regards
Great, and simple.
Just copy the row abobe, insert new line and paste, update item easy
Thanks
Formulas, i have no idea what this means because i do not work with excel. looks like a great way to make grocery list, but the learning curve for the jargon is a little tough. can anyone help??????????
I made my own in excel. I listed everything we buy, by the types of categories (refrigeration, Breads, beverages, etc). I have a “coupon” column if you take a coupon. I have an “ok” column once you put the grocery in your basket. Works out great.
This is AWESOME! I can’t wait to try it!
How do you “fill” the checklist field?
Thanks,
Aileen
Thanks. This is very useful. Ok, I guess I’m a little clumsy but I’m having a hard time creating a new category. How is this different from simply adding a new item?
When in the item pool tab, I added the quantity I wanted to buy, this quantity was not updated in the shopping list. Am I doing something wrong? Thanks
heyy, went to enter/change some products to suit my needs in excel but it wont let me saying i need a password to unprotect it as it is read only????
How can I make the quantity listed on “Item Pool” carry over to the quantity column on the shopping list?
I tried to make my own formula but it’s way beyond me! Do you have a formula I can copy/paste into the cell to make it carry over for the right rows?
thanks
[...] Excel Template Three printable spreadsheets of varying sizes, for general-to-specific shopping. [...]
I would like to know how to make it so from the item pool you have entered prices for each item at each store and so it knows which store is cheapest and adds the item to a list for that store only. So if you put in milk, egg, cheese you could get 3 different shopping lists if milk is cheaper at store 1, egg is cheapest at store 2 and cheese is cheapest at store 3. See what I mean?
[...] Excel Template Three printable spreadsheets of varying sizes, for general-to-specific shopping. [...]
[...] Excel Template Three printable spreadsheets of varying sizes, for general-to-specific shopping. [...]
[...] Excel Template Three printable spreadsheets of varying sizes, for general-to-specific shopping. [...]