PrepFood storage inventory template
Download the spreadsheet, or fill in the list here and print it. Both work out how many days of food and water you have. There's no sign-up, and nothing you type leaves this browser.
Download it
Free, with no sign-up. Gallons, expiration dates and Letter printing.
Or fill it in here
Type over the examples, then print it, or leave it blank and print it to write on.
| Item | Pack | How many | Date | Where |
|---|---|---|---|---|
| 1 gallon | ||||
| 24 × 16.9 oz | ||||
| 16 oz can | ||||
| 5 oz can | ||||
| 15 oz can | ||||
| 2 lb bag | ||||
| 16 oz box | ||||
| 42 oz canister | ||||
| 16 oz jar | ||||
| 16 oz box | ||||
From preppantry.app. Checked 2 November 2026. Independent tool, not official advice.
How it works
The spreadsheet has two sheets. On Stock, type how many you have and the date on the package. Common items are already listed, and you can add your own. Days of supply does the math.
It starts from the same figures as the Prep app: an adult at 2,000 kcal and about 0.8 gallons a day, a child at 1,600 kcal and about 0.5 gallons, and a pet at about 0.3 gallons. You can change them. Ready.gov and the CDC say at least 1 gallon per person per day, so type 1 if you'd like to plan on that. The pet figure is an estimate, because no official source gives one.
Anything past its date counts for nothing, so old stock can't flatter your total. That's cautious, because most US dates are about quality, not safety. Infant formula is the exception: don't use it after its Use-By date.
Calories per pack are typical values, worked out from USDA figures and our own choice of pack sizes. Check your labels if you want to be exact.
Example: two adults need 4,000 kcal and about 1.6 gallons a day. Five gallon jugs is about 3.2 days of water. If they have 16,000 kcal of food, that's 4 days. Their days ready is the lower figure, about 3.2 days, and water is what's limiting them.
Common questions
Does it work in Excel, Numbers and Google Sheets?
It's a standard .xlsx file, so it should open in all three. The formulas are ordinary ones, such as SUM and IF. If a program doesn't work them out when it opens, recalculate or save it once.
What's the CSV file for?
It's the same list with no formulas, for anything that reads plain tables. The columns follow the CSV that the Prep app exports, with gallons in place of liters. The app doesn't import CSV files.
How much water should I plan on?
Ready.gov and the CDC say at least 1 gallon per person per day. The CDC says at least 3 days, and 2 weeks if possible.
Do you keep what I type on this page?
No. It stays in this browser, and is held in the page's address so you can bookmark it. Nothing is sent to us. The list clears if you open the page without that address.
How often should I update it?
Ready.gov says to replace expired items and rethink your needs every year, and to replace water you've bottled yourself every six months. Our rotation calendar can add that to your calendar.
Sources
- CDC: creating an emergency water supply
- Ready.gov: water
- Ready.gov: build a kit
- USDA FSIS: food product dating
- USDA FoodData Central (energy per 100 g)
Checked on 2 November 2026. This is an independent tool and not official advice. See sources and method.