Free prepper inventory spreadsheet

XLSX · CSV · PRINTABLE SHEET

A simple template for tracking food storage, water, medical supplies, and gear: one row per item, with columns for quantity, location, purchase date, expiration date, and calories. It comes with five example rows so you can see how we fill it in.

No email signup, no unlock. It's just a file.

The XLSX opens in Excel, Google Sheets, LibreOffice, and Numbers. The printable sheet is a blank paper version for a binder or the inside of a pantry door.

How the template works

• One row per item. "White rice, 20 lbs, basement shelf, expires 2030." That's a row.
• Categories: Food, Water, Medical, Tools, Fuel, Shelter, Hygiene, and a few more. Sorting by category shows you which shelf you've neglected.
• The Expiration Date column is the whole system. Sort by it every few months and eat what's coming due. Stockpiles don't go bad all at once; they go bad one forgotten jar at a time.
• Calories are your scoreboard. Quantity times calories per unit, summed over the food rows, against your target: 2,000 per adult per day, 1,500 per child. The food storage calculator gives you the target number for your household.
• The headers aren't decoration. Keep the header row as-is and the CSV imports straight into BeaglePrep, so a spreadsheet you keep for a year still moves over in one tap.

Where a spreadsheet stops working

We ran our pantry on a spreadsheet for years, so this is said with respect: the spreadsheet is great on day one and worse every day after. It doesn't remind you when the canned stew hits its date. It isn't on your phone at the store when you can't remember if you have pinto beans. And nobody totals the calories column after a grocery run.

That maintenance is the part BeaglePrep automates: scan a barcode and the item fills itself in, expiration reminders fire before food ages out, and the Prep Score keeps a running days-of-supply count per category. If you start with this template and outgrow it, Pro imports this exact CSV (that's why the headers are what they are), so nothing gets retyped. Get BeaglePrep free on Android whenever the spreadsheet starts feeling like a chore.