Grocery Price Book Spreadsheet
Click here to download the Grocery Price Book Savings Spreadsheet
Keep track of what you pay for groceries (or practically anything you buy on a regular basis), so you can determine the best price and best time to buy for each item. This spreadsheet allows you to input lists of categories for use in drop-down menus. Also, when you click on “Category”, it automatically inserts the current date, which is a big help when you input a whole grocery receipt. Feel free to delete the “Sample” sheet when you learn how to use it.
Comments on Grocery Price Book Spreadsheet »
[...] When Dacyczyn first published this technique nearly twenty years ago, personal computers were not ubiquitous. But in the Internet Age, it seems a little old-fashioned to keep a paper-based price book. As much as I love notebooks, I'd rather keep my data in a spreadsheet where it's easy to search and sort. I found two Excel-based price books: one at Cheap Cooking and a more elaborate version at An Uncommon Way to Wealth. [...]
I just wanted to thank you for creating this spreadsheet. It is very helpful and I like the setup. I actually have two price-books that I use. One that I made to track lowest sale prices in conjunction with coupons. Then I use this one to track everyday prices for need items that either don't go on sale or I don't have stockpiled. I did however have one suggestion for improvement on the spreadsheet- is it possible to add a column after the product name for Brands? That is the only thing I wished this spreadsheet had. Thanks for creating such a helpful tool!