Grocery List Planner

by Beth Montgomery on May 21, 2009 · 2 comments

in Coupons & Rebates

You can probably tell by my blog that I’m a big fan of computers and technology, so it shouldn’t suprise you that I have a spreadsheet I use each week to plan my shopping trips.

It’s a known fact that writing a list before you go to the store is a main factor in saving money. Not only does it help you avoid impulse buying, but it also helps you avoid buying items that aren’t really good deals. Also, taking the time to write out a list before you hit the store, saves you time in the store.

My spreadsheet, which is based on a spreadsheet I found on, is a bit intense and can sometimes look intimidating, because it does most of the work for you. However, I uploaded two versions to share with you. One, which you can view HERE, includes detailed instructions on each page, while the other, which you can find HERE includes my shopping list for this week already planned out as an example of how to use the spreadsheet!

First, note that there are multiple pages on each spreadsheet. You can view each page in Google Documents by clicking the links in the bottom left-hand of the page that say “Grocery”, “Misc. Stores”, “Drugstores”, and “Weekly Total”. You can also download these documents to your computer. When viewing the document, click on “File” in the top left-hand corner and select export from the drop-down menu. If you have Microsoft Office with Excel, export the document as a “.xls”. If not, you can export it as a “.cvs” to use with any spreadsheet program.

Second, when looking at my shopping plan for the week, keep in mind that my CVS plan is for Sunday/Monday and that I’ve over-estimated items I’m buying by the pound or don’t necessarily know the regular price for right off the top of my head. This way, I’m underbudget in the end. I also don’t assume I’ll get overage for any of my coupons, so basically, this is a worst-case scenario. When I end up spending less, I’m thrilled!

I love being able to see how much I’ll be saving before I hit the stores. It helps me cut my out-of-pocket spending down dramatically. With all the great savings this week at Meijer and CVS, this is a great time to figure out the perfect shopping trip. The only thing that would make this week better is a $/$$ coupon for Meijer, which I don’t have sadly. Hope these documents help you save loads of money too and remember to visit the individual grocery deal posts to see the coupon matchup for each deal.

As always, e-mail me if you have questions and I’ll be more than happy to help!

Visit on Saturday to find out how my shopping trip really went down and if I found some extra savings!

  • 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.


1 Anonymous May 21, 2009 at 6:19 PM

This shopping list is amazing. It is exactly what I would do if I was tech savvy enough to figure it out!!! I just have a quick question. I just did my Target trip for the week (my husband is in Fishers a lot and he does the trip for me). Everything worked great except the coupon total, grand total OOP and savings % didn’t calculate. The spend total did calculate. Do I need to do something when I am finished with the list to get the totals??? Pleas help!!!

By the way I am amazed at the difference in prices for your Kroger and ours in Terre Haute. Does it make your mom furious too??

2 IN Good "Cents" May 21, 2009 at 7:45 PM

Monica – I’m not sure why it’s not working for you. I just went to check and all the forumlas are there and correct. E-mail me at and I’ll send it to you directly! Also, my mom has never said anything about prices being different in Terre Haute. Usually they match! She does complain about not having a Meijer though.

Previous post:

Next post: