Pantry Inventory: Use a home spreadsheet to track groceries

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.

THIS JUST IN: My friend April has an awesome book for eating from your pantry. You can also use code CURLY to get the printables for free (add the book (e-book or printed) and the printables to your cart, and code CURLY will give you the printables for free!

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!

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

Putting this into 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}

If this doesn’t work — please let me know! 🙂

Pantry FAQ’s

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:

[pt_view id=”e6c66f5341″]

This was originally created in 2014 and has been updated.