Food Storage Calculator Spreadsheet – Free Download

25
2697
Free food storage calculator spreadsheet
Print Friendly, PDF & Email

If you have been interested in Prepping for more than two minutes, you have heard that you need to have a plan for food storage in case of disaster. Food is one of the most important items preppers can obtain that will keep them alive but so many people do not have more than a few days of food in their pantries at home. We shop for food often and buying extra food isn’t viewed as odd or deviant (yet?) like some prepper purchases but for one reason or another most people only keep the basics on hand and believe that if needed they will just run to the grocery store to pick up last minute items. Unfortunately, you have all seen photos of shelves stripped bare at the first mention of an approaching storm. What if your city was impacted by the recent earthquake? This one was relatively minor, but if there had been more damage, would you have enough food to last until service was restored and the grocery store replenished? What if there was an Ebola outbreak and you were forced to stay in your home for a month. Would you have enough food to last or would you travel out possibly risking exposure?

Ensuring you have a food storage plan is one way to prevent your family from being the ones running down the grocery store isles searching for anything still left. Actually, when we have inclement weather it never fails that my wife will ask me to stop by the store on my way home. It isn’t that we need any food because we have stocked up plenty to last several months at a minimum. No, she wants me to get single items for a recipe or one ingredient that she might need in a few days. I swear it’s just to hear me complain about the lines in the stores of all the panicked people looking to stock up before whatever event we have coming (usually a snow storm) hits us.

Free food storage calculator spreadsheet.
Click on the image of the spreadsheet to download.

You shouldn’t need to go to the store for last minute food items because you too should have several months of food that your family will eat stored already. A good food storage plan will help you figure out what you need and inventory those supplies. The first step is to understand what you need in terms of the specific foods and there are lots of websites with a food storage calculator out there that will help but you can’t really customize them. You are forced into taking their food recommendations. I have taken the liberty of creating my own food storage calculator spreadsheet for the readers of the prepper journal. The advantage of this one is that you can play around with the quantities and even add new items to your list and adjust the numbers of people and duration you want to have food stored for. The spreadsheet is open and free for you to use. If you don’t want to store Pearled Barley, just change the food storage spreadsheet to something you do like to eat. Want to keep track of your canned spaghetti sauce? Just add it to the sheet! The only requirement is that you need to be able to open and manipulate an Excel file.

All you have to do is to enter the number of people you are stocking up food for, then the number of months you want to have stored. It isn’t fancy, but it is a simple tool you can download and use to calculate your own food storage in your home. The spreadsheet will give you the average recommended quantities of food and you can add how much you have on-hand. Once that is done, the spreadsheet will let you know how much of any particular item you still need to purchase. You can use this to generate your shopping list and Boom! You will be on your way to securing your families food needs for the next disaster. You can download the free food storage calculator spreadsheet right here.

If this is helpful, we also have a free Ammo Inventory spreadsheet that you can download, add to this one and keep track of multiple supplies on one spreadsheet.

I hope this helps. If you see anything I missed or have questions/comments/recommendations please let me know.

Leave a Reply

25 Comments on "Food Storage Calculator Spreadsheet – Free Download"

Notify of
avatar
Sort by:   newest | oldest | most voted
Khaz
Guest

Unable to Read Document.

An error occurred while reading the document.

Pat Henry
Guest

Khaz,

Have you tried downloading the file first or are you trying to open it? The file name is FoodStoragePlanner.xlsx but I see sometimes it tries to change it to FoodStoragePlanner.xlsx.xls. If you can save it to your computer and rename it to remove the last .xls it should open fine. I have tested this and it works.

Pat

JayJay
Guest

Nice–but I can’t use it. I let the food storage get away from me years ago.
No way can I get a grip on stock now.

JJ
Guest

My browser goes to price grabber–bummer!!

henry_hill
Guest

Same here

Pat Henry
Guest

Can you please try it again? I changed the file type to a .xls.

Pat

JJ
Guest

Now, it won’t open, hey, I have an idea!!
Why don’t we just print from the page printed here??

Pat Henry
Guest

JJ, please send me an email through our contact form (link at top of page) and I will email you the file directly.

Pat

Scott Carver
Guest

try clicking on the image of the spreadsheet instead of the download button. The download button is in an ad box. The image in the article is a direct link to the document.

Pat Henry
Guest

Thank you so much Scott! You helped me to realize what the problem was. The text under the image is automatically converted to an add by software I have. I have revised the text so that shouldn’t happen anymore.

Pat

Tanya
Guest

When I open it like that it shows up a bunch of weird symbols.I tried opening it with several different programs. Any suggestions?

trackback

[…] your food stockpiles, check the serving size and calorie amounts. You can get really detailed and put this into a food storage spreadsheet if you like, but that will give you a true picture of the amount of time your food will last the […]

trackback

[…] variety that as you go out to 6 months or 1 year or 2 will be important. My own personal goal is 2 years’ worth of food stockpiled for my family but that isn’t made up of only food from our grocery store. That can certainly be done though […]

trackback

[…] variety that as you go out to 6 months or 1 year or 2 will be important. My own personal goal is 2 years’ worth of food stockpiled for my family but that isn’t made up of only food from our grocery store. That can certainly be done though […]

trackback

[…] variety that as you go out to 6 months or 1 year or 2 will be important. My own personal goal is 2 years’ worth of food stockpiled for my family but that isn’t made up of only food from our grocery store. That can certainly be done though […]

trackback

[…] your food stockpiles, check the serving size and calorie amounts. You can get really detailed and put this into a food storage spreadsheet if you like, but that will give you a true picture of the amount of time your food will last the […]

trackback

[…] that note, here’s a good website for calculating how much food to stock up […]

trackback

[…] is a lot of advice out there to store food for uncertain times, but how much? How much food to store depends on how long the difficult times last, and only you can decide how long you want to prepare for. […]

trackback

[…] Food Storage Calculator Spreadsheet, The Prepper Journal (en Inglés) […]

trackback

[…] I do always consider a fully stocked pantry and a large producing garden, complimented with other sources of protein the absolute best way to […]

trackback

[…] I do always consider a fully stocked pantry and a large producing garden, complimented with other sources of protein the absolute best way to […]

trackback

[…] If you’re interested in having a free downloadable spreadsheet, we found a useful resource at The Prepper Journal worth checking […]

trackback

[…] Food Storage Calculator Spreadsheet, The Prepper Journal (en Inglés) […]

wpDiscuz