This is my family’s Pantry Inventory Spreadsheet (can be used in excel & google sheets). Use this to create a kitchen grocery inventory template so you don’t end up over-buying, and ultimately saving money. This home food inventory spreadsheet saved me from myself, for sure!
Pantry Food 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
Pantry Excel Spreadsheet
This pantry inventory spreadsheet will help you stay on top of what’s where.
And, if you’re feeling like a LOT of your house is out of control (or could just use some new tips) — check out The Organized Home. Stop stressing about your house, and let IT support YOU for once!
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.
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 — leave me a comment!
Notes about the spreadsheet:
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!
Ok, back to food….
Pantry Inventory in Google Sheets
This was initially made as an excel spreadsheet (this was when google was pretty young, and google sheets wasn’t as useable as it is now).
Just go to “import” on google sheets, then drag and drop it in there to upload.
That all needs to be done on a computer, as far as I know.
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.
Keep your pantry organized so you know what’s in it! {and what’s not, which is what I’m normally worried about}
And I mean it, if you’re looking to stop over-buying in general, and be able to easily access what you have — NOW is the time to jump in The Organized Home. Jump in for just a month (no obligation to stay) for the tips and then leave with your organized home! Use coupon code PC10 to save 10%
Pantry FAQ’s
Most people store food good and possibly small appliances in their pantry. The pantry I’m referring to would be food storage.
That is going to be up to each household. I like to keep on hand as much as we’ll likely use in the next six month or so (depending on the product, and how long it stays fresh).
I used to keep more on hand, but I found it was just too hard to rotate and sometimes we didn’t get to it when it was fresh.
I like to keep mine as cool and dark as possible. Of course, with kids that is hard….
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!
This was originally created in 2014 and has been updated.
Haley Saikkonen says
excellent idea
well use soon 🙂
TheFiveDays says
Awesome! Thank you for sharing this!
Suzzi says
Thanks for this. Going to try and get organized!
Hilary says
Hope it’s helpful!
Carol says
This 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
You’re welcome, I hope it’s helpful!
carolyn says
Pantry Inventory Spreadsheet — Excel File
wont open
Hilary says
Carolyn, 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
That’s great! Thanks for sharing 🙂
Hilary says
Glad to help!
Rachel says
And 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
Haha, I am not sure it will change your WORLD… 😉
Tina says
Thanks 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
Haha, the work is keeping up on it, this just helps a lot. Thanks for commenting! 🙂
Jennifer Ware says
Just curious as to the dimensions of your pantry? 😉
Jennifer Ware says
That last comment was kind of tongue in cheek but what is Roni?
Hilary says
Haha, 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
Hi! 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
I 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
DJ, 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
Thank you very much! I got it this time! Yay! 🙂
Hilary says
Haha, sorry, I didn’t see this one. Good!
Katrina says
Thank 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
Oh good, I hope it helps!