Free template · Excel & Google Sheets
Free Emergency Kit Checklist Spreadsheet with Contacts (Excel & Google Sheets)
Most kit checklists are a list of nouns. This one does the arithmetic for your household and tells you what's about to expire.
No sign-up, no email. Opens in Excel, Google Sheets, Apple Numbers and LibreOffice.What's inside
- 20-item starter list based on Ready.gov and Get Prepared (Canada)
- Water and food quantities scale with people and days
- Ready / Partly / Missing status in colour
- Expiry warnings 60 days ahead
- Printable emergency contacts with an out-of-area contact
Preview
Yellow cells are the ones you type in. Everything else calculates.
| Item | Needed | Have | Short by | Status | Expires |
|---|---|---|---|---|---|
| Water (gallons) | 9 | 4 | 5 | Partly | Jun 2027 |
| Flashlight | 1 | 1 | 0 | Ready | — |
How to use it
- In Settings, type how many people and pets, and how many days to cover.
- Walk through the house and type what you already have.
- Add expiry dates for water, food, batteries and medicines.
- Print the Contacts page and keep a copy in the kit and the car.
Using Google Sheets?
Upload the file to Google Drive, then open it with Google Sheets. Formulas, drop-downs and colour rules carry over.
Checklist items follow general public guidance from Ready.gov and Get Prepared Canada. Add what your local emergency agency recommends for your area.
Family Ready: Emergency Plan
Family Ready keeps a free offline Emergency Card on your iPhone — contacts, allergies and medications in a large-text Emergency Mode.
Get it on the App StoreQuestions people ask
- How much water should an emergency kit have?
- Ready.gov recommends one gallon of water per person per day for several days. The sheet multiplies it for you.
- How many days should a kit cover?
- Plan for at least three days (Get Prepared Canada says 72 hours); many families keep more.
- What is an out-of-area contact?
- Someone outside your region everyone can text. Long-distance texts often get through when local lines are busy.
Share or reuse
This template is free to use, share and adapt under CC BY 4.0. If you post it on your site, please link back to this page.