Mouse colony spreadsheet template
A clean starting point for tracking a mouse colony in Excel, Google Sheets or Numbers. It's laid out the way labs actually work, and it imports into CageCard in one step if you outgrow the spreadsheet.
Download
Free, no sign-up. Made in your browser; nothing is sent anywhere.
What's in the Excel template
- Lines
- One row per line (strain): its name, the prefix for its cage names, and its genes.
- Cages
- One row per cage: line, holding or breeding, set-up date, litter born, room, rack and owner.
- Mice
- One row per living mouse: cage, sex, date of birth, ear notch, sire and dam, and a genotype column per gene.
- Euthanized
- Optional: your euthanasia log, with dates, counts and reasons, for protocol counts.
The CSV's columns
| Cage | Line | Cage type | Set up | Room | Rack | Owner | Mouse ID | Sex | DOB | Ear notch | Sire | Dam | Parent cage | Marked for cull | Notes | Genotype: Aim2 | Genotype: CH25H |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example-1 | Example line | Breeding | 2026-01-10 | Room 210 | Rack A | EX-001 | M | 2025-10-01 | R | HET | HET | ||||||
| Example-1 | Example line | Breeding | 2026-01-10 | Room 210 | Rack A | EX-002 | F | 2025-10-03 | L | KO | KO |
Genotypes can be WT, HET or KO, +/+, +/− or −/−, or any call you use, like Cre+. Add a "Genotype: gene" column for each gene.