Price Book Spreadsheet

Price Book Spreadsheet

File Type(s):Excel Spreadsheet (.xls); Excel 2007 Spreadsheet (.xlsx); OpenOffice Document (.ods)
File Size:216kb (.ZIP file)
Last Update:November, 2009
Current Version:       2.0
  • Pinterest

Those of you who want to keep a "price book" of grocery prices and such in Excel ... well, all I can say is, "You're nuts."

But regardless of that, you're still in luck!

Click here to see all my spreadsheets!

My Price Book spreadsheet has been around for a long time, but at a user's suggestion, I recently revamped it a bit. This version of the Price Book contains columns for "Group" and "Store" so that your data can be sorted by these variables, as well as by the more-common ones like price and size.

But most importantly, the Price Book can still serve as a database of sorts — one in which you can easily track prices of the things you most commonly purchase. And when you know products' prices from a variety of stores, you'll also know which store's sales are really a good deal! (You can also read my "Price Books and Lunches" article from 2005 if you'd like a little better picture of how such a price book might be used.)

The screenshot below shows the Price Book spreadsheet in all its glory (which, honestly, ain't much):

Price Book Spreadsheet - Click to Enlarge

There's a "Sample" page in the spreadsheet, complete with fictional data, so you can get a feel for what goes where. After that are three blank worksheets, just waiting for all the price and product data you can drag up. As always, the Price Book spreadsheet is NOT password-protected, so you can modify it to your shopping heart's content.

Download my Price Book Spreadsheet below:

Download Spreadsheet!

I tried to keep the spreadsheet as simple as possible. However, a few more words of guidance might be in order.

Spreadsheet Versions

When you extract the ZIP file, you'll actually find three spreadsheets. One is for Excel 2007 (.xlsx). Another is for Excel 97 through Excel 2003 (.xls). The third version is for OpenOffice (.ods).

Simply use the spreadsheet that's appropriate for the program you use.

Questions? Comments? Contact Me!

As always, if you've got a question or issue, don't hesitate to drop me a line. I'll get back to you as soon as possible!

RSS FeedWant to know when I add to and update my spreadsheets? Subscribe to IYM's feed!

Add to My Yahoo!

Make a Donation
If you're a user of my Excel spreadsheets and feel that they're worthy of a small donation ... well, that's extremely cool. And I'm truly honored that you'd think so.

The following button will allow you to make a donation (any amount) via Paypal. I would ask, though, that if you're someone who's in substantial debt, and working like crazy to get out, that you please refrain from making a donation to IYM.

Instead, use your intended donation amount as an extra contribution toward your highest-interest debt ... and then drop me an email to tell about how my site or my spreadsheets have helped in some way.

That, I assure you, is payment enough for me.

As always, I am truly grateful for your kindness and continued support!