Food Storage Calculator Spreadsheet – Free Download

Print Friendly

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.


  1. Khaz

    August 27, 2014 at 9:06 am

    Unable to Read Document.

    An error occurred while reading the document.

    • Pat Henry

      August 27, 2014 at 10:12 am


      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.


  2. JayJay

    August 27, 2014 at 6:01 pm

    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.

  3. JJ

    August 27, 2014 at 6:03 pm

    My browser goes to price grabber–bummer!!

    • henry_hill

      August 28, 2014 at 3:29 pm

      Same here

      • Pat Henry

        August 28, 2014 at 3:57 pm

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


  4. JJ

    August 27, 2014 at 6:08 pm

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

    • Pat Henry

      August 28, 2014 at 8:21 am

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


  5. Scott Carver

    August 30, 2014 at 9:59 am

    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

      August 30, 2014 at 10:56 am

      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.


      • Tanya

        October 19, 2014 at 7:56 pm

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

        • Pat Henry

          October 20, 2014 at 9:18 am


          I just emailed you the file, but you do have to have Microsoft Excel to use it. Hopefully that works for you.


  6. Pingback: How Long Will Your Food Last After SHTF? - US Crisis PreppersUS Crisis Preppers

  7. Pingback: Back to Basics: How to Stockpile Food for Emergencies | Freedom Newz

  8. Pingback: Do It Yourself Back to Basics: How to Stockpile Food for Emergencies - Do It Yourself

  9. Pingback: Back to Basics: How to Stockpile Food for Emergencies – The Prepper Dome

  10. Pingback: How Long Will Your Food Last After SHTF? – The Prepper Dome

  11. Pingback: The Difference between a Divinely-Revealed Economic Programme and a Man-Made one: How Islamic Economic Theory Can Prevent the Looming Global Recession | Religion and other things

  12. Pingback: Can Islamic Economic Theory Prevent the Looming Global Recession? | The Muslim Times

  13. Pingback: Real Food Storage Ideas for Real Preppers – The Prepper Dome

  14. Pingback: Fechas de caducidad y rotacion de comida | Prepper en Español

  15. Pingback: What Plants are Safe to Eat in the Wilderness – The Prepper Dome

  16. Pingback: What Plants are Safe to Eat in the Wilderness – Prepper Ways

  17. Pingback: Essentials of Survival Food Storage – HOME GROWN PREPPER

  18. Pingback: Alimentos que no caducan – Survival Ros

Leave a Reply

Your email address will not be published. Required fields are marked *