This is my family’s Pantry Inventory Spreadsheet. Use this to create a kitchen grocery inventory template so you don’t end up over-buying, and ultimately saving money.
Pantry Inventory
You know how it is, you think you have a can of beans, but then you go to grab it and it’s GONE. GRRR that totally gets my goat! It may also get a few other more colorful words thrown at it!
Creating a pantry inventory will help you know what you have so, you don’t end-up over-buying
This pantry inventory spreadsheet will help you stay on top of what’s where.
If you are on mobile and can’t see the form — click here.
Using a Pantry Inventory Spreadsheet
At the height of my use of this document, I was checking all of the items monthly, I’d then go into my computer and update the spreadsheet.
If I was feeling adventurous I’d ask a kid to yell out how many items were in the pantry and I’d update it as we went along. It didn’t take much time at all.
Lately, I’ve been buying less — and that helps our grocery budget a lot also. I just sometimes run out of stuff again.
Pantry Inventory Spreadsheet
Feel free to adjust and fix as needed.
Because I love you all that much.
I’d love to know if people have ideas to make it better.
FYI, the colors are for each shelf in my pantry. That, and the fact that I really like colors. 🙂
The columns will automatically update if you use a proper program (I use Excel, but it should also work in google sheets) that will execute equations. aka — if you want to have 6 and you have 3 — the third column will say 3, as you will want to have 3 more.
Feeling like not having enough or losing things is an issue? I’ve found the solution!
Do you…
- Can’t find what you need when you need it
- You feel like it takes hours and hours to clean you rhouse.
- Feel a rock in your stomach when you find out you’re having last minute guests.
This course helped me change my ways — you can even save 10% with code PC10.
Ok, back to food….
Pantry Inventory App
You can turn this into useable on you mobile phone by adjusting it to just 1 collumn and putting it in google sheets. That way it can easily be available on your phone.
It’s something I wanted for such a long time. I was running out of things that would leave my frustrated and wonder why I didn’t have a lot of the things I had on hand in my pantry inventory.
BTW — looking for groccery delivery? Check out my friend Katie’s Shipt grocery delivery review!
Keep your pantry organized so you know what’s in it! {and what’s not, which is what I’m normally worried about}
If this doesn’t work — please let me know! 🙂
Be sure to check out my more recent post on having an organized pantry. It can be really helpful too!
Some other posts about home organizing are my weekly cleaning schedule, and stocking up on canned goods. And if you’re on Pinterest, check out my organization board!
Check out my most recent Organization Posts:
This was originally created in 2014 and has been updated.
Haley Saikkonen says
March 26, 2014 at 10:34 pmexcellent idea
well use soon 🙂
TheFiveDays says
March 30, 2014 at 2:47 pmAwesome! Thank you for sharing this!
Suzzi says
July 4, 2014 at 7:20 amThanks for this. Going to try and get organized!
Hilary says
July 5, 2014 at 7:05 amHope it’s helpful!
Carol says
November 1, 2014 at 7:32 pmThis is a great idea and the spreadsheet so easy to use.. How nice of you to share your work with the rest of us. Thank you.
Carol
Hilary says
November 3, 2014 at 9:31 amYou’re welcome, I hope it’s helpful!
carolyn says
November 25, 2014 at 2:24 amPantry Inventory Spreadsheet — Excel File
wont open
Hilary says
November 25, 2014 at 7:38 amCarolyn, because this post is so popular, the google drive sometimes gets overwhelmed. There is also a link to box.com (at the bottom of the post) that will take you to it so you can download it. Hope that helps!
Faith W says
November 24, 2014 at 10:27 pmThat’s great! Thanks for sharing 🙂
Hilary says
November 25, 2014 at 7:32 amGlad to help!
Rachel says
December 3, 2014 at 8:47 pmAnd this is why I love Excel. Every day I find another way it changes my whole world! lol Thanks for doing all the work for me 🙂
Hilary says
December 4, 2014 at 9:12 pmHaha, I am not sure it will change your WORLD… 😉
Tina says
December 20, 2014 at 6:16 pmThanks for the free downloadable. Love the file and that most of the work has been done for me. Now to update it for what I have in My Pantry. Thanks again!
Hilary says
December 24, 2014 at 9:53 amHaha, the work is keeping up on it, this just helps a lot. Thanks for commenting! 🙂
Jennifer Ware says
August 17, 2015 at 5:59 amJust curious as to the dimensions of your pantry? 😉
Jennifer Ware says
August 17, 2015 at 6:20 amThat last comment was kind of tongue in cheek but what is Roni?
Hilary says
August 18, 2015 at 8:02 amHaha, I will admit I have a HUGE pantry. And if you check out my most recent meal plan post you’ll see that we’re eating a lot out of the pantry, not so much storing (my husband quit his job). Roni is rice a roni. It’s basically a preservative-laden emergency meal. 🙂
Emily says
September 4, 2015 at 3:42 pmHi! I realize this post is over a year old, so I’m not sure if it’s even worth my comment. Thanks for posting this! Super helpful! One small thing that I did to change my copy was edit the “what I need” column. I have a little bit of an excel obsession, and so this is probably just personal preference, but I don’t like the negative numbers, so here’s a formula to use if you just want it to say 0 if you have extras: =If(C2>B2,0,SUM(B2-C2))
This is totally personal preference though, if you like to see that you have X many extras of something, then the negative works better. Thanks again for posting!!!
D.J. says
February 6, 2016 at 11:49 amI left my e-mail address to get your Pantry Excel Spreadsheet but did not recieve anything from you and I even looked in my Spam folder. Maybe it was an oversight but I would love to recieve it.
Could you send me a copy please?
Thank you very much! 🙂
Hilary says
February 7, 2016 at 6:51 amDJ, I have that it was sent to you, and you clicked on it. When you click on it — it will automatically download to your computer. I can re-send it or you can re-sign up on this page (it all does the same thing).
D.J. says
February 6, 2016 at 11:54 amThank you very much! I got it this time! Yay! 🙂
Hilary says
February 7, 2016 at 6:51 amHaha, sorry, I didn’t see this one. Good!
Katrina says
August 23, 2016 at 9:51 amThank you thank you thank you!!!!!!! I don’t know a lot about Excel so I knew what I wanted, but wasn’t sure how to get started. … Your template was JUST the starting point I needed!!!! I changed a few things to make it more “me” friendly (i.e., how my brain works 😉 ) I’m so excited. Thank you so much. 🙂
Hilary says
August 29, 2016 at 3:01 pmOh good, I hope it helps!