Cent Saving Tools: Grocery List Creator

by Beth Montgomery on January 6, 2010 · 9 comments

in Coupons & Rebates, Tips & Basics

Hi. I’m Beth. And I am addicted to spreadsheets.

Yeah.   It’s sad but true. I think it’s fun to make spreadsheets. Creating complicated spreadsheets, like the one I designed for my husband to use to track his NCAA Tournament picks that automatically moves teams over to the next round, is my idea of a good time.   In fact, I’m so bad, that I sometimes spend 5 hours trying to figure out how to use a spreadsheet to do something that would have taken me only 5 minutes if I had just done it manually.   But, everyone allowed to be crazy in their own special way, right?

With that in mind, I figured now was the perfect time to once again share my shopping list creator.   However, for those of you who don’t get a kick out of spreadsheets, I’ve make a simplified version with instructions for you!

It’s a new year. You have a clean slate. So now is the time to create a budget and stick to it. Seeing how much you are going to spend before you head to the grocery store will help. All you do is enter in what you plan to buy, the price, any rewards you’ll earn, any coupons you’ll be using, and the coupon value. The spreadsheet will automatically double coupons for particular stores, plus figure out your grand total, coupon total, rewards total, final out-of-pocket, your total after rewards, and your percent saved after coupons and rewards.

Plus, when you are all done, you can highlight your list, then print it to take to the grocery store with you as a detailed shopping list. You’ll be armed and ready to save money, because you’ll know exactly what you are buying, how much it should cost, and what coupons you should be using.

If you’d like the simplified version, which includes 3 spreadsheets – one for standard stores (e.g. Walmart), one with stores that double coupons up to $0.50, (e.g. Kroger or Marsh), and one that offers rewards (e.g. CVS or Walgreens). It also comes with instructions for use and is filled in with examples (which you can delete easily). You can download it below:

- – Simple Grocery List Creator – -

Available in Excel Format from Google Docs

To download: Follow the link, select “File”, and select “Download As”.
Note: Other download formats are available, but I recommend downloading it as an Excel document, because you will lose formatting (including the formulas) in CVS and other file formats.

If you’d like to get high tech, you can also download mine. You can use it to create multiple lists if you plan to hit multiple stores. It’s set up for Meijer, Kroger, Marsh, Target, Walmart, CVS, and Walgreens, but you could easily change the store column name to match stores near you. It also has a sheet that calculates your grand total for all stores.

- – Advanced Grocery List Creator – -

Available in Excel Format from Google Docs

To download: Follow the link, select “File”, and select “Download As”.
Note: Other download formats are available, but I recommend downloading it as an Excel document, because you will lose formatting (including the formulas) in CVS and other file formats.


Now you’re armed to save your cents… Start checking out the latest store deals!   Happy shopping.

  • Like on FaceBook
  • Pin It
  • Print Friendly and PDF

Enjoy this deal? Sign up for more!


Subscribe to our FREE deals newsletter to get great deals by email daily and never miss a deal!
More Options

Comments on this entry are closed.

{ 9 comments }

Previous post:

Next post: