Food Storage 101: Spreadsheets + Sources + Everything You Need to Make Food Storage Easy and Doable {Long Term and Short Term}
Food Storage 101! Spreadsheets, sources and tons of other tips to make planning and building up long term and short term food storage easy, affordable, and doable.
The words “food storage” can feel overwhelming, totally foreign, straight up boring, no-idea-where-to-start…or if you’re like me…totally fun. Haha. Yes, I’m a food storage nerd!
And today, I’m excited to (finally!) share with you all of the tips and resources and spreadsheets (!!) I’ve utilized over the last almost 20 years to create a food storage plan for my family that actually works. Plus, it’s easy, affordable, and totally doable.
Why food storage?
After this post a few months ago and hundreds and hundreds of comments and emails and questions later, it’s clear that a lot of us have food storage (and other preparedness principles on our minds, especially considering the circumstances we’ve all lived through the last few months).
Beth left this comment on that post: Not being of the Mormon faith, I always just assumed that the storage of extra food was a religious thing but a quick google search thing tells me it is just based on prudent living. I would be interested in the details of how you manage to keep stuff current, etc. Those of us with small basement pantries often find them out of date and useless. Any further info would be appreciated! Stay safe…..and healthy.
Beth is right! Building up a doable food storage in your home is exactly that: prudent living. It may be a pandemic, job loss, natural disaster, desire to simplify a grocery budget…or a variety of other reasons that would benefit from an intentionally built food supply.
5 foundational principles for building your food storage
- There is not a one size fits all approach to food storage.
- Don’t store (or even think about storing) food that you or your family doesn’t like or doesn’t eat. Just don’t do it, even if 1,000 sources online tell you that you should. It’s a waste of time and money. (Lima beans, I’m looking at you.)
- Don’t go to extremes or go into debt to build a food supply or a Pinterest-worthy food storage (is there such a thing)?
- If you are starting from scratch, start with a one day supply (yes, one day!) and build up from there gradually. When you know how much you need for one day, build up to planning and buying a one week supply and so on.
- Abandon the idea of a stockpile of food hidden in the basement that can last 30 years untouched and move toward a LIVING food storage. Sounds weird, but it works, and I’ll show you how a) this changed my life and b) how I implement it.
Let me reiterate
I can’t say this enough: what works for me MAY NOT WORK FOR YOU. The ideas and resources and spreadsheets I’m sharing in this post are tailored to my family and what works for us.
Take the ideas, or just bits and pieces of them, tweak them for YOU, and above all, please don’t get overwhelmed.
I’m sharing a lot of information. It might be easy to get stressed or even irritated – that’s the opposite of my purpose today! I really do just want to help.
What is a living food storage?
I grew up with parents who had a lot of food storage. In boxes. Cans. Buckets. It was all tucked away in the dark recesses of cellars and closets. And I literally never saw any of those boxes, cans or buckets get opened.
I legit think my mom threw it all away a couple years ago because it was long expired and never used (after it had been dutifully gathered and stored and moved from house to house – over 20 times and over 40 years!).
When I was first married 18 years ago, I figured I’d channel my parents and eventually start gathering wheat in buckets and powdered milk in cans and stuff it under the bed. Until I realized a) I didn’t have a wheat grinder, b) ew, powdered milk, and c) my husband was like, “heck no, we can’t afford any of that.”
So I did nothing. And quite honestly, I was fine with it. Until five or so years later (2007-ish) when I started getting these internal nudges that I needed to start thinking more about food storage. We were moving a lot. I was having a lot of babies. I had stopped working outside of the home. And I liked the idea of having food we could use in an emergency or if something happened.
After a lot of research and talking to people and starting to buy and build up our food storage, I realized I wanted a living food storage. Not necessarily a short term food supply and not a long term food supply.
Just an intentionally planned and built food storage that I could use every day and replenish as needed.
Diane left this comment on an earlier post: Food storage doesn’t have to be a huge initial investment like some people think! I’m constantly restocking my pantry. It’s never an all-at-once thing. I watch for sales and that’s when I stock up. Or buy 2-3 items instead of just one (for example, if I’m getting low on soy sauce, I buy a couple extras to store in the pantry). If you have the mentality that you’re saving some for later, you can stock up a little at a time and it doesn’t add a lot of expense. Like you, I’ve learned to store what we eat and eat what we store. I have powdered eggs and milk and there have been multiple times where I started making something assuming I had eggs (or milk) because I always have those things, but realized I was down to my last egg or ran out of milk. The powdered varieties might not be good by themselves, but they work great for cooking!
I couldn’t agree more!
How to start planning a food storage
Plan out your meals for one day (or even better, for one month) and take a good look at what your family eats.
Grains. Dairy. Sweets. Snacks. Fruits and veggies. All of it.
Make a list of the foods and quantities and then…multiply by three months. You can see where I’m going with this. Gradually start building up that 1-month or 3-month supply by picking up 1-2 extra things each time you go to the store. You don’t have to buy it all at once!
Most importantly, do not shove those foods to the back of your pantry or cupboards! Rotate through them so the foods stay fresh, and replenish as needed.
And do not, whatever you do, forget to include the chocolate chips. (Yes, that is an open package of Ghirardelli 60% bittersweet chocolate chips on top, because, hello, coping skills, and also, they are the best things in the history of ever.)
As you start small and then build as budget allows, you’ll be able to see what size packages you need to buy (based on how fast you eat through a box or can of something). Eventually as you build out more months of food storage, you may decide to enhance your pantry storage with a few larger buckets of staple ingredients (I’ll show you how I use those as part of my living food storage below).
Food Storage Tracking Sheet
This might seem overkill to some people, but I keep a food storage tracking sheet close to my pantry (I used to hang it on a clipboard with a pen inside the pantry until it got knocked down too many times by anxious hands sneakily grabbing Oreos without me noticing).
It’s not complicated. It’s a blank table. When I open up a new package or ingredient (anything from a bag of quinoa to a new bottle of BBQ sauce), I quickly write it down on the tracking list. I put a check when it’s gone (my mind is already used to knowing when an empty package or bottle of something gets thrown away, I go straight to my sheet for that check mark). And then I add it to my next grocery list.
It keeps the system running, and it keeps us in a well-stocked supply for at least three months.
My food storage spreadsheet
Ok, now for the nitty gritty of how I put all this into action.
Disclaimer: I am not a casual food storage lady. I’m a true blue through and through die hard food storage fan. I love it. I believe in it. I use it. And I have a testimony (no really, I do) about how important it is.
You don’t have to be like me. Haha. In fact, don’t be like me! Take all this with a couple grains of salt and make it work for you.
That was my way of gently easing us all toward The Great and Nerdy Food Storage Spreadsheet.
You guys, I admit, this spreadsheet is a little intense, especially for someone who wants a slow and easy approach. It has formulas. It’s taken me years and more hours than I care to admit to put it together (and even more hours to fine tune it to post here).
If you are looking to play around with numbers and amounts and pounds, this spreadsheet is for you.
But guess what?? It’s also a good starting place for someone who wants to take things slow and easy and work into food storage gradually! You don’t have to dive headfirst like a kid free falling into a vat of chocolate pudding. Don’t let the spreadsheet turn you off from food storage as a whole. 🙂
The main page of this spreadsheet is meant to detail foods that can be stored for a long amount of time – kind of food storage “staples” so to speak. I’ll show you some examples below.
The second sheet on the spreadsheet is for pantry goods. It’s a much simpler spreadsheet that tallies how many of each item you have in your pantry and how much you still might need (after you set a goal amount and what you currently have). If the main page/long term aspect of the spreadsheet stresses you out, START WITH THIS pantry storage checklist.
It’s simple and straightforward.
BOTH SPREADSHEETS are meant to be used on a computer or tablet or device that you can plug in numbers and calculate totals (they haven’t been formatted to print well).
On the main food storage spreadsheet, you can edit the # of months and # of family members in the green rows. When you do, all of the amounts in the following categories will change based on the information you enter:
- Goal amount for each food category in pounds
- Amount you still need to buy/acquire (in two formats: pounds and also in # of cans/buckets/bags or however else you store it)
Additionally, you can (and should!) go into the spreadsheet and tailor the Units and % columns to fit your needs
- Units: is how many of each item you have already – when you edit the number in the units column, it will automatically change the amount in pounds right next to it
- % of Total Weight: Stick with me here!! There are main categories on the spreadsheet like Grains, Legumes, Dairy, etc. Changing the # of months and # of family members changes the total goal amount for each of those main categories. The goal amounts are largely based on this food storage calculator (and you can totally change them!). Within each of the main categories, different food items make up the total. So for instance, in the Grains category, I store: wheat berries, white flour, corn meal, rolled oats, steel cut oats, white rice, brown rice, etc. And based on how much of each of those we use, I assign a % in that last column. We grind a lot of wheat and make a lot of bread, so wheat makes up 48% or so of our grains category. If your family doesn’t have a wheat grinder (or is gluten free!) you’ll want to change that % to zero, or better yet, plug in a food that you DO eat and that you DO want to store.
Did that make sense? Are you still here? Tap, tap, is this thing on????
Play around with it. Change up the numbers. And the foods. And just make it your own. There’s no copyrights or infringements. I’m providing it to you as a resource in case you love spreadsheets as much as I do.
Don’t get overwhelmed at what the spreadsheet screams you need to buy or what you might be lacking! Have fun with it. My advice is to start with a big fat THREE in the # of months box and go from there.
Mel’s Food Storage Spreadsheet – EXCEL (includes both the longterm food storage and the pantry food storage) – UPDATED 5/16/20 to correct the “goal” formula
Mel’s Food Storage Spreadsheet – NUMBERS (includes both the longterm food storage and the pantry food storage) – UPDATED 5/16/20 to correct the “goal” formula
How this looks in my real life
As I mentioned at the onset of this post, my food storage is living and breathing and being used all.the.time.
Yes, I have a several buckets of natural rolled oats and granulated sugar and hard white wheat stacked up in one of our Hobbit Holes, but they will all eventually be rotated into the Currently Being Used status.
I try to keep about a 6-9 month supply of these staples, and because I rotate them through when one bucket is empty, they are used up long before they expire.
When I’ve used up a bucket or can, I write it down on my food storage tracking sheet so I can replenish (I usually order or buy these larger staple items once or twice a year – I don’t buy a new bucket or can immediately).
I know it isn’t feasible for everyone to store 5 gallon buckets of food. If not, you can do the same thing with #10 cans or smaller packages.
Because my pantry shelves sit at just the right level, I keep those 5 gallon buckets at the ready by putting on handy twist lids.
My wheat berries, sugar, and oats are all stored in these buckets (and my white flour is in that huge rectangular container – sadly, I don’t know where to get one like it anymore – I picked it up at Sam’s Club probably eight years ago). When I need oats for a recipe, I go straight to the bucket. And many times, if I see a bag of wheat berries on sale (or like lately, I’ve been really into Einkhorn wheat berries), I’ll fill up the existing bucket with bags of wheat (or sugar or whatever) before opening up a new bucket since the bags expire before the sealed buckets do.
Along with the staple ingredients, I try to keep a 3-month supply of canned goods that we eat frequently.
I don’t always religiously track these items on the Pantry Spreadsheet (included with the large and in charge spreadsheet linked above), but you can if you want. I usually just eyeball the emptying spot on the pantry shelf and know that I probably better pick up some diced tomatoes at Costco the next time I’m there.
Again what canned and dry goods you store on your pantry shelves will be absolutely dependent on how you cook, what you eat, and how many people are living in your house.
Space for Food Storage
Finding space for food storage can be tricky! I’m sure many of you don’t even have pantries to speak of – while others may have a pantry + a cold storage + 5 1/2 closets dedicated to food storage.
This is exactly why the amount of food storage you build up and store is 100% completely dependent on your personal circumstances. Do what you can!
If food storage is a priority to you, get creative with where to store food even if it is outside of the kitchen! Over the years (before I hired someone last year to knock out the wall between our kitchen and garage and expand my minuscule pantry), we stored canned goods and other food storage items everywhere from under beds to bedroom closet shelves to under stairs (affectionately called our Hobbit Holes) to in the garage (yes, even though it isn’t always recommended because of the heat).
We have one rolling food storage shelf that sits smack dab in the corner of one of our bedrooms. It’s not classy, but it works.
Food storage Resources
First and foremost, if you’re storing practical, every day foods, your every day grocery store might be the best place to start. Especially if you’re building up a one to three month supply. Look at expiration dates and be thoughtful about how quickly you’ll eat through different foods (and how quickly they’ll expire).
*UPDATED with links included in the comments!*
- The Church of Jesus Christ of Latter-Day Saints Online Store: a great, inexpensive option for the basics stored in #10 cans. Can be purchased online.
- Rainy Day Foods: this is probably my favorite place to stock up. They sell almost all their foods in bags, buckets, super pails, cans, you name it. They also have a great variety of gluten free, non-GMO and natural foods. If you put in group orders, you can get a huge discount on shipping. It kind of changed my life when I realized I could get a few sealed cans of brown sugar (I always run out of this and have opened more cans to save a recipe than I care to admit).
- Emergency Essentials: I’ve ordered a lot of food from here over the years. They have a really good variety of freeze-dried fruits and vegetables, but they also carry the basics.
- Azure Standard: I forgot about these guys when I originally posted this! I used to get a lot from them and then kind of forgot, so thanks for reminding me in the comments! GREAT resource!
- Country Life Natural Foods: this is a new one to me (thanks for mentioning it in the comments!), but it sounds like they offer a lot of quality health foods/natural ingredients at wholesale prices and in bulk, if you need it. Excited to check it out!
- Amazon: good ol’ Amazon. This is where I buy a few favorites like Honeyville Steel Cut Oats and a few other staple ingredients.
- Costco: don’t forget the power of a good bulk foods store, like Costco or Sam’s. This is where I usually stock up on baking soda and baking powder (I dip into the big bag of baking soda and fill a small container for my spice cupboard – we go through it pretty fast just with baking, but I also use baking soda for cleaning and other things, so a big bag makes sense for us – it may not for someone who won’t use it as quickly!)
- Thrive Life: I used to order a lot of freeze-dried fruits and veggies from here, but I have to be honest, I have hardly used them, and I regret some of those impulsive stock-up purchases. Don’t be like me! I think you either have a talent for using freeze dried food in recipes or you don’t. I don’t. We snack on the freeze-dried fruit a lot (and use it for school lunches), so we’re slowly using it up, but I’ve decided to try to store fruits other ways since freeze-dried isn’t really working for me in the long term. This company also used to package other cool ingredients like quinoa and whole wheat pasta, but unfortunately, I think they’ve stopped doing those basics and have gone exclusively to the freeze-dried sector.
- YOU: yes, you can be a great resource for your own food storage. Gardening and canning (or freezing fruits and veggies)! And not to get all becky-home-ecky on you, but canning simple things like peaches or jams and jellies is a great (and fun) way to include fruits and vegetables into your longer term food storage. Just like everything else (I know, I know, I sound like a broken record), we eat through our home canned goods all year and replenish during canning season. And if you think you can only can a gazillion jars at once, read this post on small batch canning.
- Local Resources: farmers, co-ops, and even grocery stores can be great resources for food storage or bulk items. For instance, my local Winco sells 25 pound bags of wheat berries (over by the coffee and peanut butter). I’ve found a few local farmers here in southwest Idaho that sell buckets and bags of wheat, oats, etc. When I lived in Minnesota, there was this amazing Amish granary about an hour away that would sell bags of just about anything you can imagine. Ask around and you might be surprised what you find!
Addressing a few questions + lingering thoughts
- Do I store powdered milk? Well, I have to be honest, other than using it in some pretty fabulous cookies, I kind of gag at the thought of mixing it up and drinking it (I’m sorry, every generation of grandmother I’ve ever had is rolling in their grave right now). Could we do it if we had to? I’m sure we could. But I prefer to store our longer term dairy needs in the form of shelf-stable almond milk (like everything else, we use and rotate through it so it doesn’t expire), freeze-dried yogurt bites (the one freeze-dried food we really, really love), evaporated milk, etc.
- Do I have a recipe book of exclusive “food storage recipes”? No. As I’ve mentioned several times, my life is my food storage and food storage is my life. I’m making all the recipes on my site every day with my food storage staples. That’s how I rotate through them. If we are ever “forced” to rely on our food storage, I don’t want to pull a random book off the shelf and hope the “food storage” recipes work. I’ll use the ingredients and recipes I’ve already been using for years (and tailor them as needed based on emergencies or finances or the current situation).
- Why do I store dry beans? Do I honestly cook with them? You betcha! Thanks to the electric pressure cooker, it is super easy to transition dry beans into cooked beans ready for use. I think I would be fine using them exclusively for these pressure cooker refried beans (soooooo goood – and delicious with pinto, black OR white beans).
- How do I store meat for food storage? This is a good question! We have a freezer full of beef from raising our cows that is kind of our main meat food storage plan; however, I actually don’t hate freeze-dried meat. It seems a little questionable, but it works great in casseroles or skillet recipes. So I also have a couple #10 cans of freeze-dried chicken hanging around, too. Thrive Life and Emergency Essentials sell freeze-dried meat.
- Storing water + other necessities: I won’t go into much detail about this (at least in this post), but storing water is an important component of food storage and emergency preparedness. Even just having a case of bottled water is better than nothing. We don’t have huge barrels of water stored, but I did invest in two amazing little water filters {aff. link} for drinking water. I also try to keep a reserve of medications, band aids, toilet paper (!!), flashlights, batteries, and other necessities outside of food. This could be a whole other post, but I wanted to at least mention the importance here for now.
A few extra resources and links
- Gamma Seal Lids: the twist/Gamma seal lids for 5 gallon buckets can be found online (Amazon – aff link); I’ve also seen them at Home Depot and Winco (a local grocery store)
- 5 gallon buckets: can also be found at places like Home Depot, sometimes Walmart (just double check to make sure they are food grade) or on Amazon (aff. link) or Rainy Day Foods – other people mentioning in the comments to look at places like Tractor Supply, farm implement stores, etc.
- Wheat grinder: I have a series of posts on wheat grinding at home. Here’s a post on different types of wheat grinders and another on different types of wheat. As a quick summary, I almost exclusively use hard white wheat (and lately I’ve started using more Kamut and Einkhorn wheat berries, although they are more expensive than traditional white wheat). Wheat that is less than 3-5 years old (and well sealed) will work a lot better than 30-40 year old wheat (even if it has stayed well sealed). Also, I’ve had this KoMo Fidibus grain mill for a decade; I use it every day and can’t say enough good about it. It’s amazing; I use it mostly to grind wheat, although occasionally I throw rice in there to clean it out.
We don’t know what the future holds. But it’s also exhausting and a waste of time to live in fear.
The antidote to not living in fear? Be prepared.
Food storage doesn’t have to look like #10 cans and big white pails like I have in my house. It doesn’t have to last a year or taste gross. It doesn’t have to be 100% organic. And it absolutely positively can include chocolate chips and fruit snacks.
Food storage is what YOU make it. It works for YOU.
I know this post is lengthy and a bit much, but all I really want is for there to be some tidbit that helps someone out in their food storage journey. And as always, I very much welcome YOUR ideas, thoughts, feedback on everything food storage related.
I LOVE learning from you!
Ok, bye now.
I have been logging in my food storage for 1 1/2 hours and saved it and then I went back to add some more on the excel spread sheet and it went back to the original sheet you posted and didn’t keep mine. What am I doing wrong? I don’t want this to happen again.
Please help.
Thanks
On no that’s the pits! Make sure you click “save as” and save your file under a new name. Also make sure you save to a folder you can find (i.e. “desktop”, or “documents”). Otherwise your file will be saved under “downloads” which Excel will not automatically look in in the future. Good luck!
Thanks for sharing your knowledge and resources! Honestly, I’m intimidated by spreadsheets (ha ha!) but I may try it. One of the things I’ve definitely learned in the past decade or so that I’ve been dabbling in food storage is that it’s useless to store food that we don’t normally eat. Like you said, waste of money.
Love you. Love this blog. Love this post. Would also love to know what you’re keeping for food in your 72-hour kit?? Or what you used to keep for food when you had toddlers/preschoolers around? I’m finally getting organized on this front! Thank you again!
So… the pantry staples aren’t figured into the long term storage, right? Or are they? Like is your cooking oil counted on both…or do you have cooking oil packaged differently for longer term? Thanks. Trying not to get overwhelmed…but it’s been a few years since I’ve done an inventory and I’d love to use your system this time. However, I might need to take an Excel class (or ask my teenager for help!) to learn how to do the formulas since I want to add in some rows that aren’t there. Thank you for sharing.
Hey Kami! the pantry staples are separate from the long term storage BUT you could easily add them in to make one comprehensive list. I tend to think of the long term food storage with foods like grains (wheat/flour), etc and the pantry storage as canned/boxed goods.
Just wanted to thank you for the very approachable tutorial and the encouraging tone you used. I’ve been wanting to start a long-term pantry for our family of 5, but had no idea where to begin. It’s, uh, daunting. Your guidance on “one day/one week/one month x 3” is hugely helpful! I really appreciate you sharing your knowledge with all of us — very kind of you to do — and quite the public service!
P.S……LUV gamma lids and have one for every type basic dry food I store. Then always have one bucket with each item easily accessible for daily use. For me, that is white wheat, red wheat, rye, pearled barley, white rice, quick oatmeal, dry corn, unbleached flour in tall buckets that hold up to 45 lb.. And black beans, red lentils, pinto beans, white beans, red beans, green lentils, baby lima beans, dark red kidney beans, garbanzos in smaller buckets that hold 25 lb.
And YES, I use them all in daily meals.
Here’s my formula for menu each day……
One meal based on grains
One meal based on dry beans/lentils
One meal based on vegetables
…..and in one of those meals per day I might add meat….
Interpreted, it’s easy, here’s example:
Grains:
oatmeal with fruit
blender wheat pancakes
golden wheat patties
wheat sausage patties
Dry beans/lentils:
chili and cornbread
red lentil tomato soup
lentil tacos
black beans n’ sausage over rice
Vegetables:
broccoli/chicken/pasta alfredo
veggie noodle stir fry
roast with extra sides of veggies and salads
mexican coleslaw and burritos
A great post, thank you, Mel….very informative and helpful. I like your spreadsheets. My food storage and storing it is similar to yours,
but I don’t have the #10 shelf. Where do you get that baby??
I have a double shelf that I keep opened #10 cans stacked 2 high…not very convenient but works ok. Been using/storing/rotating my food storage for years. And teaching classes, wrote a cookbook on how to use the basics (wheat, grains, dried beans, lentils, dry milk) in daily meals. Recently ordered a Komo hand grinder. But think I’ll also order their regular one after I sell the 2 grinders I have (40 year old stone grinder I love and it works great, plus a newer model grinder not stone). The Komo looks like it’d be easier to use than the ones I have.
The only tolerable way to use powdered milk, IMHO, is for yogurt. You don’t have to preheat/boil powdered milk. Just mix with warm water, add your starter yogurt, and off you go!
Do you pour your sugar, flour, etc directly into the food grade buckets? I tried that and it tasted so off…
I use the buckets that the food is sealed in (usually has a mylar liner).
Oh, My. Gosh. You’re a brilliant guardian angel, Mel! I used to be SO on the ball with our long and short term food storage. Then we had a billion children (OK, 9) in not too many years and all of a sudden I can’t seem to keep up on it since we go through everything so fast. This spreadsheet is heaven sent. THANK YOU for sharing it and doing all the hard work for us! I’m super excited to personalize it and put it in action.
Times and seasons, totally! You’re amazing, Bonnie – you’ll get a plan together in no time, I know it. 🙂
Thanks for the post! I am totally new to food storage and yes the pandemic has really brought food storage and emergency preparedness to th forefront. I may have missed it in your post but where did you getyour storage things for cans (looks like they roll down as you take one out)? Those look super handy.
Hi Kelly – I bought the rolling shelves from shelf reliance a long time ago – the company is now called thrivelife.com – I don’t know if they sell the rolling shelves anymore, but if you google “rolling food storage shelves” you can find some good options!
Do you have any recommendations for recipes that include canned chicken? My mom just panic-shopped at Costco and now she has tons and doesn’t like the taste. Help?
We like it best in things like chicken salad (with plenty of chopped veggies: celery, crisp lettuce or cabbage, pickles), gravies – like for Hawaiian haystacks & stuffed chicken rolls/chicken pillows… You can even make a good patty with it (my family made them most with tuna or salmon when I was little, but we’ve branched out!) – most any recipe with canned fish subs well with this chicken! Good luck!
Buffalo chicken dip!
I don’t use canned chicken very often, but it usually can be subbed pretty well for any recipe that calls for already cooked chicken. Here’s a few favorites:
https://www.melskitchencafe.com/crispy-southwest-chicken-wraps/
https://www.melskitchencafe.com/chicken-banh-mi-flatbread/
https://www.melskitchencafe.com/avocado-chicken-salad/
https://www.melskitchencafe.com/creamy-white-chili/
Your food storage sheets look very much like my budget spreadsheets and I am inspired to follow suit! Also, have you ever bought bulk from Honeyville? They have excellent food storage foods and typically cheaper than Amazon. Thank you, Mel!
I actually usually buy Honeyville ON Amazon but maybe I need to go straight to their website. Thanks for the recommendation!
Wow, I feel famous, haha! Great post!!!
🙂
You could help a lot of homeless, unemployed and disenfranchised people right now. Your bounty could really bring peace to so many.
I think you are right, Miranda! A blessing of having so much right now. We’ve been able to find local ways to help those in need. Thanks for that reminder. 🙂
Mel thank you so much! I am very excited for these spreadsheets! As I was looking over the calculations for the total amount of pounds needed for each food group on the excel spreadsheet, I think there may be a mistake in the formulas. In the formulas, it shows that you are only multiplying the adults by the number of months that the food storage is needed and not the kids [i.e. for the goal pounds of grain, the formula is B5*(B6*36)+(B7*24)]. I think there needs to be an extra set of parentheses so that the kids are included in being multiplied by the amount of months that the food storage is needed [i.e. B5*((B6*36)+(B7*24))].
You’re right, Jessica! I’m kicking myself for messing that up. So glad there are smarter people out there! I just uploaded updated files in the post. Thanks for the catch!
I totally giggled to myself when I read, “And not to get all becky-home-ecky on you, but…” I’ll take all the help I can get, especially if it’s coming from you. You’re a gem for sharing your enthusiasm, knowledge, tools, and resources. This truly has been an answer to my 3+ year dilemma, so thank you from the bottom of my heart! My husband and I have felt the need to track our food storage and we decided I should put together a system since I do the grocery shopping and the cooking, but I have had such a hard time visualizing what I want and making up a document. I saved your sheets to our laptop and showed them to my husband (who is naturally pretty skeptical-bless his heart ) and he was probably more impressed than I was, checking your excel formulas. Haha. I’ve already edited them to fit our family size and have started adding to them. Thank you again! I am really looking forward to working on organizing and growing our food storage.
Thanks, Nicole! Phew! Glad your husband didn’t think I was ridiculous! 🙂 FYI, apparently I did have an error in one of the formulas. I edited it and included an updated spreadsheet in the post. Sorry about that! Hope I didn’t lose your husband’s trust. Haha.
I am loving the spreadsheet!! I have one of my own, but this one makes so much more sense and I think I’m going to convert. Question, is there a reason you have totaled the goal a second time (column E, i.e. E32) on each area of food storage instead of totaling the actual. I feel like I’m missing something important here. Thank you for all you do, love everything that comes from you!
I don’t have the spreadsheet handy right now but I’ll take a look tomorrow!
Ok, sorry for the delay. So that column (E) isn’t totaling the goal amount again – it’s actually allowing you to set sub-category goals within the total goal. So for “Grains” you can go in column E and set a sub goal for “wheat” and “cornmeal” and “oats” and the total at the bottom of column E will help keep track of how close you’re getting to the total goal for that area (grains in this case). Does that make any sense at all?
I love this! Very doable. I am really good at keeping a stocked pantry, so I already feel like a superstar! LOL.
I do have a request because I have never tried one of your recipes that I didn’t love and move into my permanent meal rotation. Would you think about doing a serious of recipes that use what I consider to be necessary but not every day use food storage items? For example, I buy canned chicken because I often think of needing some kind of meat in an emergency but the only thing I use canned chicken for is sandwiches. Are there real dinner worthy ideas for canned chicken? I think maybe soup, but beyond that I am stumped and would love your magical touch for some recipes.
I’ll def add that to my list of posts to compile!
You made my geeky heart flutter and jump with this spreadsheet. I’ve been working on one but yours is better and further along and I can’t wait to put the kids in bed and play with it. I didn’t even finish reading the post first. I’ll finish in a minute, I just had to jump ahead tell you I’m in love with your spreadsheet. THANK YOU!
Haha, thank you! Turns out I had a mistake in one of the formulas (even after triple checking it), so be sure to download the updated spreadsheet in the formula (chances are you probably spotted and fixed the formula in the spreadsheet already!)
What rotators do you prefer for cans of typical pantry staples? 15 oz cans of beans and tomatoes, 8 oz cans of tomato sauce, 6 oz cans of tomato paste, and also larger 30 oz cans? Is there a product you use that can accommodate different sizes?
I know they have rotator-type shelves like that, but I don’t have any and haven’t used any to recommend – I just stack in my pantry.
Mel, you are best! Thank you so much for the time and energy you put into sharing all this great information! I’ve used some of this “extra” time to organize my food storage and take inventory. Your spreadsheets will be so helpful! Thank you! I’ve figured out a few of my holes. One of which is fruits and veggies. We mostly eat fresh or frozen. Love gardening and do some canning, but have felt maybe freeze dried was the way to fill those holes (especially if it wasn’t growing season and the power went out and freezer food got spoiled). However I haven’t really used freeze dried before and sounds like its not a favorite for you. I’d love to hear what you are doing to fill those longer term fruit/veggie needs. I’ve wanted to look into einkhorn. Do you have a good source for that? Again,, thanks a million times over and I’m totally with you on the necessity of LOTS of chocolate chips on hand at ALL times!
Hey Natalie – so far I’ve bought einkhorn flour from einkhorn.com…it’s pricey, and I’m trying to find a few other sources (I’ve heard there might be some other farms in Washington I’m looking into – I’ll keep you posted!). As for fruits/veggies, I’m mostly relying on canned, frozen and home canned. It’s not a perfect system, and I’m definitely identifying my own holes, too! Don’t discount freeze dried just by my account. I know a lot of people love them, and maybe buying a bag or can might help you decide if it’s something that would work for you? I’ve found my favorite way to use freeze dried is to pulverize to dust and add to frosting…which, yeah…isn’t exactly healthy, nutritious, prudent living food. 🙂
Lynn, I love this idea, and it feels like a good place to start. Any chance you are willing to share some of your meal ideas?
This is great information. My family sometimes makes fun of my “Y2K” closet of food items. The pandemic has been a real eye opener on changing how we shop and using what is on hand and will make the most out of a meal to include left overs. Your flour bin in your pantry reminds me of my dog food storage container. I got it at Tractor Supply. Thank you for all the great information and tips.
Who knew that all this time I was actually using a pet food container for flour?? 🙂
I use the pet food containers from The Container Store for flour, rice, and sugar. I love that they have wheels and can roll around the kitchen!
This was just awesome. Thank you very, very much!!!! You are truly a rock star!
Thank you, Jen!
Thanks for all of this. I am a big fan of preparedness too and have built a storage. You gave great tips and insights. I want to make one tip about powdered milk. I learned this from a wonderful catholic woman when I was at a bishops storehouse doing some canning. She taught me that powdered milk is a great way to stretch what milk you have. I ended up needing this tip a few years later when we were financially VERY tight. When my gallon of milk got 1/2 way down I would mix up the powdered milk and add it to the existing milk. It would chill overnight and the next day you couldn’t really tell a difference. We even got to the point of just using powdered milk a couple times. It is MUCH better cold. Also the Bishops storehouse milk is way better than the store ones I have tried. One other tip, my uncle did this when his kids were young. He would put a drop of food coloring in the container and then add the milk and stir it and it would change colors. The kids all thought it was magic and that made them drink it, even if they didn’t like it. Sometimes you gotta do what you gotta do. Thankfully, like you mentioned there are lots of options. Just wanted to throw this option out there too.
Appreciate these tips SO much, Elizabeth!
Great post!! Can you share the brand name of the freeze dried yogurt bites?
They are the ones from thrivelife.com 🙂
thanks so much for this post– I’ve been feeling this nudge since the begining of this year but really didn’t know where to start…I’ve just picked up a few things each time I shop but your spreadsheets are really going to help me be more organized with it all. I would love a post on storage of non food stuff– tp, cleaning stuff etc
Thanks, Rebecca!
Eek! You had me at “spreadsheet”, ha-ha. Thank you for taking the time to put this all together. I can’t wait to “plug and play” with my family’s information.
You’re the best – thanks, Sharon!
Thanks so much for sharing Mel! I had a lady in my ward share storing flour, sugar, rice etc in 5 gallon buckets with the gamma lids a few years ago when I had a run in with bugs getting into the bins I was using to store those in and I love these buckets SO much!!! I’m very much becoming a bit of a nerd about it all myself! But seeing those buckets full of the foods we use so often and knowing nothing can get in and ruin them just makes me so happy!! I love your spreadsheets and all your resource links, this post is a gold mine! Thanks for putting it together to help better our living storage! Especially in these crazy times, home/online schooling the kiddos is no walk in the park!
Ain’t that the truth – not a walk in the park at all! But we’re all in it together. 🙂
This is amazing! Thank you so so much!
🙂 Thanks, Chrissy!
My husband and I were just talking about expanding our food storage again since we added another kid. I know some people think it’s crazy, but especially if you have children it’s important to be at least somewhat prepared. Thanks for the resources and the spreadsheet! We were going to inventory and reorganize our food storage this weekend so it’s perfect timing!
Good for you for thinking ahead, Jennifer! 🙂
Very helpful post, thank you so much.
I would love to know where you purchased the rolling food storage shelf, that would be so handy!
Hi Mary – I bought it a long time ago from Shelf Reliance (which is now called Thrive Life). They are pretty pricey, but I think if you do a quick google search for “rolling food storage shelves” there’s a pretty good market of competitor products now.
Thank you so much for sharing these amazing ideas and for all the hard work you put in to create these! I really appreciate your thoughts, ideas, and resources! I will definitely be using them.
Thanks, Ashlee!
What exactly are you preparing for? This sounds like preppier madness. You might have lost me on this one….
Definitely ok to have a different opinion (this “system” isn’t for everyone), but in terms of preparedness, I don’t see it as prepper madness at all. If you look at the circumstances surrounding the world, it’s clear that natural disasters, pandemics, etc, happen everywhere. Not only that, job security isn’t a given. So I’m preparing for unknowns that could catch my family off guard. By doing so, it prevents me from living in a stress or fear cycle. I know not everyone feels the same, and that’s ok! But stocking up on a reasonable supply of food and essentials certainly helps us to live a provident, prudent, prepared lifestyle! (I’m not perfect at it, this post alone exposed some holes I need to fill in my own system, but I think it’s sensible to be prepared, so to speak, for a future “rainy day”). I would rather be prepared to help take care of my family (and help others) rather than drain someone else’s resources when hard times hit. 🙂
Gracious answer, as always, Mel. Kudos to you.
Sorry, I honestly don’t get this, either…
Scroll by, then?
I guess “living food storage” is an accurate description of what I do too. If any of my basics is getting low I add it to the list, or if I see one of our staples on sale I buy a few extra. It’s constantly cycling out (first in, first out or FIFO) and usually my only spreadsheet is for the freezer where things can get buried, so I update it occasionally with things that need to be used up sooner rather than later. I tend to be a spreadsheet person too, but as long as I add things to my grocery list as they’re used I find I can avoid maintaining a spreadsheet for food storage.
I *almost* bought a Komo grinder after you posted about it; I should’ve gone for it since it’s getting hard to find my usual whole-wheat flour! We bake a loaf daily so it would throw our routine to start buying loaves of bread.
We have a hall-closet-as-pantry beside our kitchen because there’s not much storage in the kitchen itself, and then I have a metal restaurant-style shelving unit from Costco in the laundry room that holds the extras (next bottle of ketchup, the bags of steel-cut oats, the ice cream maker ;), the flat of water bottles) that feels a bit like my personal grocery store.
We don’t use disposable water bottles generally, but I always have a few in the van. I know it’s bad for them to get hot, but in a pinch I’d much rather have plastic-leached water than no drinking water! I’d like to start having a 5L jug down there too. We live in earthquake country so water and power being cut off is something to consider, and having food that doesn’t require using much water/fuel before eating it is valuable as is an emergency kit in your car in case you’re not at home if a large one happens. My husband is a camel and laughs at me, but if I leave the house I have a water bottle and granola bar in my purse haha. That makes me sound paranoid, but I’m not a useful person on low blood sugar (and neither are my kids) so it comes in handy a lot.
I don’t think it makes you sound paranoid at all – just prepared! I don’t do well when I’m thirsty or hungry either! Loved your comment and the details of your “system” – I also love how the ice cream maker has a pretty prized spot on the shelves. 🙂
Love this post! Thank you so much for taking the time to compile all these resources! I love the spreadsheets – I have started with an app, but may switch back now.
Thanks, April!
For simple pantry items such as canned goods I’ve found the easiest way for me to stay on top of what I need to replace is to link my shopping list to our Google Home. When I use up a can of tuna or canned tomatoes from our store I simply ask Google to add it to my shopping list. I do this with a lot of groceries and it’s great because I am one to forget if I’m busy in the kitchen but it helps me keep our rotating pantry storage stocked up. Just an idea for anyone who may have a Google Home or Alexa.
Super advanced way of tracking – I love technology! Thanks for sharing!
Wow! You are incredible Mel. Thank you so much for sharing! This post and spreadsheets were a labor of love! I was just telling my daughter (who jokes about you being my “bestie you’ve never met”) that as if I couldn’t love you more, here you are posting about chickens (which I’m just learning about) and food storage (which I’m passionate about and trying to fill some holes). Love your insights and resources. Thank you! Now I want to look into Einkhorn (Do tell more!) and am trying to figure out what to do with fruits and veggies (which is a hole). We eat so many fresh, we can and freeze but felt like freeze dried may be the way to go… now I’m rethinking that. Excited to plug my food into your spreadsheet tomorrow! Thanks a million.
Thanks, Natalie! You are so sweet. 🙂 In doing this post, it totally exposed some holes for me, too, and I’m excited to dive into some of the resources other people have shared in these comments to figure out the best way forward! Einkhorn wheat is amazing. It’s hard to use “regular” white wheat after using Einkhorn because Einkhorn is so…different. It produces a softer, lighter bread that rises amazingly well (without any added gluten). It’s an ancient grain that hasn’t been modified over the years like conventional wheat. The drawback? It’s pretty expensive. I keep a bag or two on hand and have started mixing it half and half with my regular wheat.
You are amazing. This post is amazing. I love that your husband also commented. haha. Thank you so much for taking the time and effort to provide this very valuable and informative read. While we have a bunch of food in our makeshift pantry, I couldn’t tell you how long it would last or how to even organize it properly. I’ve been wondering how to go about starting an organized food storage so this is an exciting starting point. Great tips and resources! Also, powdered milk. My very frugal parents only served us powdered milk in the 80s and 90s and my siblings and i still talk about the dreaded bottom milk (the dredges of the unmixed powder that sank to the bottom of the milk pitcher). My parents started getting store bought milk when I was 16 and the last kid in the house, what a miracle! haha. I will never drink powdered milk again, not even in an emergency, but i do have some in my storage for cooking purposes.
Isn’t it funny how those, sometimes scarring, experiences in childhood trickle into adulthood? There are a few things I won’t eat for the same reasons. 🙂
To the comment above about storing fat/oil: I have this wonderful book called Preparedness Principles by Barbara Salsbury, and in it she said that coconut oil stays good for 5 years.
That’s good to know – thanks for sharing, Jessica!
Thank you so much for this post. I am a food storage nerd. I love your spreadsheets.
You bless the lives of many.
Fellow food storage nerds unite! We should start a conference or something. 🙂
You rock! Food storage has been on my mind a lot lately. I think this post is going to help me out a lot! I looove that you included your blank spreadsheet for us to use. Thank you!!
I hope it is helpful, Trish! Thank you!
Oh Mel! You inspire me!
Love your guts, Cass.
Wow! I’m definitely not as passionate about food storage as you are, but I am thankful for my local grocery store and their bi-annual caselot sales (thank you, southeast Idaho!). You must have spent hours and hours preparing this post and you’re helping SO many people with your knowledge! Thanks for all you do! And I especially loved the picture of your wheat grinder showing how much you love it!
Yes, those caselot sales are pretty awesome! Thank you, Cara! (and yes, I do severely love that little wheat grinder!)
Mel, can I just say I love you. Thank you for spending hours and hours and HOURS putting this post together. And I’m with Joan – your tap tap Is this thing on made me smile too. You are amazing and I appreciate your tips and hints and recipes and pretty much everything you do. Keep up the good work!
I just love those of you who “get me” (ahem, and my weird sense of humor). And thanks for acknowledging the time spent on this. I was so desperate to get the info out to everyone…but the last weeks/months have been really difficult for me for so many reasons and I was struggling to find the time (but feeling anxiety because of it). The post isn’t perfect, but I felt such relief and peace when I finally got it posted!
Thank you for all the time and effort you have put into this post. It is a great resource for me as I get more organized and prepared. I think the flour bucket you mentioned can be purchased on Amazon (but it is found as a pet food storage container) There are different sizes and one with wheels. Also, Alison’s Pantry (alisonspantry.com) is another resource for purchasing pantry staples. You purchase through reps food is delivered once a month. There are a lot of shelf-stable items and freezer items you can buy in bulk. They service many states in the West.
Thanks for the tip on Alisons pantry AND on the flour bucket (mine has a severely cracked lid and I’ve been needing to find a replacement).
Yes…this is your husband commenting. I do read your blog!!
You said living food storage and I was immediately expecting to see pictures of our chickens, cows, and those little Kunekune pigs we are bringing home next month. Those are kinda food storage too, so I guess am not completely aloof…right?! Love you!
Um, hi, Brian. I’m glad you read my blog. Now get back to work. 🙂
I’ve always told my mom I was NOT stocking lentils because my family hates them but I will have a good supply of chocolate chips and the supplies to make cookies. If you are going thru a tough time, eating gross food does not help but a warm chocolate chip cookie can change your entire attitude. I’m so happy to see that other people have a working food storage similar to mine. Thank you!
Amen to the chocolate chip philosophy!
Thank you so much for your generosity. Your willingness to share resources and knowledge inspires me. I have recently started canning because of the information on your site and I am LOVING it! What a satisfying project! I’m not very craft-y, but I felt very accomplished When I canned my first natch of mango salsa last month. Thank you again! Question: I am not LDS. I have tried to order on the LDS food storage site and I can’t get it to work. It seems I have to be a church member to order? I have shopped at the food storage centers in person before and have always been welcomed. Is there a work-around for ordering online?
PS The spreadsheets get 5 starts!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Hey Ronnie! That’s odd about the food storage site not working. Let me check into that for you! That would be super weird (and I’d be disappointed) but I’m hoping it’s some kind of glitch.
Also, sorry, my comment made it sound like I have some sort of “in” to the LDS food storage site which I do not. Haha. But basically, I’ll do some digging to see if I can come up with a solution.
Mel, I would really appreciate you checking. Thank you!
Thanks so much for this post!
I’ve always tried to buy one for now and one to three for later- especially if it’s something on sale, that we actually eat, or if I only go to that store occasionally (looking at the asian market here). This helps me SLOWLY build my food storage and lets me spread the cost out wide. This has helped so much lately when my favorites are not in stock at the grocery store. .
One question though, do you have different food storage for your 72 hour kits or do you have other food ready to “bug out” with? I’ve been curious about how to feed my family if we have to leave our house for 72 hours. Especially since the recent Utah earthquake quite literally rocked my world. 🙂
I love that – buy one now and a couple for later! Gah, I have complicated feelings about 72 hour kits and it would take too long to go into it right now. I mostly have dehydrated and snacky food for our 72 hour kits, but I’m probably not the one to be trusted with 72 hour kit info because the last time we went through them my 10 year old still had diapers in his. Whoops!