How to Create a Price Book – Free Master Spreadsheet
This post may contain affiliate links. Read our disclosure policy.
Way back in the day (15 years ago!) I used to have a post on here about how I created a Price Book to keep track of the best deals at the grocery store. At some point I must have decided that it was in such need of updating that I deleted the post with an intention of starting over and never did! Now I’m finally getting this post back up for you. I hope this will help you save as much as you can on groceries!
What Is a Price Book?
A Price Book is a tool that you can use to track current pricing on groceries that you buy at the store in order to find the best deal. You can use a simple pen and paper or a spreadsheet.
A Look at My Price Book and How I Use It
Here’s a short video I put together for you to look at my price book with details on how I made it and how I use it.
How to Make a Price Book
- Make a list of all of the items you typically buy at the grocery store. You can dig through your pantry to figure this out.
- Add a list of stores that you typically shop at.
- Add in the prices per pound or per ounce of each item on your list from each store. You can do this by searching their website or by going into the store and writing things down.
- Highlight the best prices on the list so you can easily see them when you are searching.
- Update your Price Book often as pricing can change often.
How a Price Book Saves Money
A Price Book is an easy way for you to figure out what the lowest prices are so that when you need to add an item to your grocery list, you know where to buy it at.
It can also help you determine if a sale is really a sale or not by comparing a sale price to the prices you have in your book.
Can I Get a Copy of Your Price Book?
Yes! I’ve made a master copy of my price book that you can save and use to start your own. Just enter your email below and I’ll send you a link on where to get the spreadsheet as well as a how to video.
Do you use a Price Book? What questions do you have about using a Price Book? Post them in the comments or email them to me so that I can add to this blog post!
Merissa Alink
Merissa has been blogging about and living the simple and frugal life on Little House Living since 2009 and has internationally published 2 books on the topic. You can read about Merissa’s journey from penniless to freedom on the About Page. You can send her a message any time from the Contact Page.
This blog post on How to Make a Price Book was originally posted on Little House Living way back in 2009. It has been fully updated and redone in January 2025.
Can I get a copy of your price book please. Thank you for all your hard work and sharing.