This is my family’s Pantry Inventory Spreadsheet. It helps my family organize our food and kitchen inventory, and not over-buy.
Pantry Inventory Spreadsheet
What’s in my pantry? Need to know your 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! 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.
Don’t say I don’t love my readers. 🙂
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) 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.
If you’re looking to get more organized at YOUR house, check out my new course: The Organized Home: The realistic way to manage a home, reduce clutter & clean less. All from a mom who’s doing it all and shows ACTUAL pictures straight from her house.
It can really help you make the changes you’ve been WANTING to make. Check it out!
Ok, back to food….
If you’re looking to get groceries on the cheap, but don’t have the time/expertise to comb the ads — check out Deals to Meals!
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 lost 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}
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:
excellent idea
well use soon 🙂
Awesome! Thank you for sharing this!
Thanks for this. Going to try and get organized!
Hope it’s helpful!
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
You’re welcome, I hope it’s helpful!
Pantry Inventory Spreadsheet — Excel File
wont open
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!
That’s great! Thanks for sharing 🙂
Glad to help!
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 🙂
Haha, I am not sure it will change your WORLD… 😉
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!
Haha, the work is keeping up on it, this just helps a lot. Thanks for commenting! 🙂
Just curious as to the dimensions of your pantry? 😉
That last comment was kind of tongue in cheek but what is Roni?
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. 🙂
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!!!
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! 🙂
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).
Thank you very much! I got it this time! Yay! 🙂
Haha, sorry, I didn’t see this one. Good!
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. 🙂
Oh good, I hope it helps!
I tried with either of my email addresses and have not received it. Could you please send it to me??? Thanks!!
I am so sorry, it looks like my email provider was a little wacky yesterday — it does look like it was sent to you. Please let me know if you didn’t receive it.
I requested the file, but haven’t received it.
I am so sorry — it should be coming. I guess Amazon servers (who hosts my external attachments, like that) are down. 🙁 It should come SOON!
I think pantry inventory is the top problem of all small and large families 🙂
I even did some research of apps that could help me with this issue and didn’t find anything that would fit my needs. As a programmer, I decided to build my own app. Here’s several major key points I came up with:
– There should be categories and possibility to create as many categories as needed, as well as sub-categories.
– There should be a way to tell where those or these goods can be bought. I face situations sometimes that I can’t find certain products in some stores but can find in other stores even if those stores under the same name.
– There should be a way to set units for products. Say, I want to count potatoes in lbs but beans in cans.
– The app should notify the users about the fact that some of the products are about to expire or finish. Additionally, I think the user should be able to tell how long before the app should notify about that. So that, if for example, I want to be notified when I have 2 cans left of Coca-Cola, or when I have 2 lbs left of potatoes. So it depends kind of on the product.
– The other thing I think about is that the app should notify the users if he doesn’t change the quantity of the products for some period. Sometimes, you can forget to change the quantity of spending products so the app could remind you about updating your inventory.
– Finally, the app should have a so-called “Need To Buy” list. This is kind of shopping list where you add products that is about to expire of finish so that the next time you go to the store you know exactly what you need to buy.
What do you think, will this kind of app make the most of the families happy? 🙂
I think this is a great idea!
Thank you Hilary!
I’ve actually moved a bit further with this idea since then. I started the development of this app. You can find the key features here https://www.pikypak.com/#pikypak-key-features Please check it out. You should also follow us on Twitter https://twitter.com/PikyPak or like us on facebookhttps://www.facebook.com/pikypak to get the latest updates about the app. We are really excited to get this app as soon as possible 🙂
Huh, really interesting and cool!
Hi Hilary,
I thought that you may be interested in knowing that PikyPak went live for iPhone. You should try it out here https://itunes.apple.com/us/app/pikypak/id1292018000 – of course, if you are an iPhone user 😉
Darn that we are all android around here!
I subscribed to get the spreadsheet, and when I got the email, there was no mention of a spreadsheet and no link for me to get it.
If you’re no longer giving it away, please update your site as I was a bit disappointed.
I sent the spreadsheet at the same time as the other email — Dec 19 at 3:37pm. Maybe check your spam as it sometimes lands there?
Hilary