Herply

Reptile breeding spreadsheet: a free template, and when to switch

Most breeders start with a spreadsheet, and for a small collection it works. Here is a free template to start from, what a breeding spreadsheet should track, and the signs it’s time for something else.

Free reptile collection template

  • One row per animal: code, name, species, sex, birth, origin, breeder, licence and chip numbers, notes.
  • Dropdowns for 55 species and every trait we know, with type (visual, het, super) and het percentage — up to 12 traits per animal.
  • A Traits Reference sheet and an Instructions sheet.
  • Works in Excel and Google Sheets. No sign-up.
Download the template (.xlsx)

It’s the same file Herply imports, so you can move to the app later without retyping anything.

What a breeding spreadsheet should track

Keep one sheet per kind of record and one row per event. Every sheet points back to the animal by its code, so you can filter one animal’s whole history.

Animals

ID or code, name, species, sex, date of birth (or hatch year), morph and hets, origin, breeder, where it's housed

Give every animal a short code and never reuse it. Every other sheet points at that code.

Feedings

Animal code, date, prey and size, accepted or refused, notes

Log refusals too. A run of refusals is the first thing you'll want to spot.

Weights

Animal code, date, weight in grams

Weigh on a fixed schedule. Trends matter more than single numbers.

Sheds and health

Animal code, date, shed quality or medication, notes

Keep one row per event so you can filter by animal later.

Pairings and clutches

Female, male (or males), pairing dates, lay date, eggs (good and bad), due date, hatch date

Write down every male that was with the female; multi-sire clutches happen.

Hatchlings and sales

Hatchling code, clutch, morph and possible hets, buyer, price, deposit, date

Record possible hets as a percentage (66%, 50%) rather than a guess at the genotype.

When a spreadsheet is enough

A handful of animals, no breeding, one person keeping the records: a spreadsheet is fine, and the template above is a good start.

Where spreadsheets start to break

  • Who’s due tonight. Working out feeding due dates needs formulas per animal, and they break when someone sorts the sheet.
  • Het math. Odds for a pairing with three or four genes are easy to get wrong by hand, and possible-het percentages (66%, 50%) are easy to lose track of across generations.
  • Lethal and welfare-risk pairings. A sheet won’t warn you that a pairing can produce non-viable babies, or that a trait carries a known welfare concern.
  • The tub, not the desk. Spreadsheets are awkward on a phone at the rack, and two people editing copies end up with two versions.

Moving to Herply

Herply keeps the same records as the sheets above, plus a nightly feeding run, racks whose tubs manage themselves, clutches with multiple sires, and a morph calculator that removes non-viable outcomes and flags welfare-risk traits. Upload the template under Animals → Import; the preview checks every row before anything is saved. And if you ever want your spreadsheet back, Settings → Export your data gives you every record as one Excel file.

Coming from another app? See Herply vs Husbandry.Pro and Herply vs MorphMarket Husbandry.

Frequently asked questions

Is there a free reptile breeding spreadsheet template?
Yes. The template on this page is free, needs no account, and works in Excel and Google Sheets. It has one row per animal, with dropdowns for 55 species and their traits, and up to 12 traits per animal with het percentages.
Can I track feedings in the template?
The template is a collection list: one row per animal. For feedings, weights and clutches, add a sheet for each with one row per event and the animal's code, as described above. Herply does this for you, and its Excel export comes out in exactly that shape.
How do I work out het percentages in a spreadsheet?
By hand, or with a calculator. Two hets for the same recessive gene give about 25% visuals; their normal-looking babies are 66% possible het, because carriers and non-carriers look the same. Herply's free genetics calculators do this for you, including multi-gene pairings and lethal combinations.
Can I move my spreadsheet into Herply?
Yes. Fill in the template — or copy your existing columns into it — and upload it in Herply under Animals → Import. The preview checks every row before anything is saved.
Can I get my records back into a spreadsheet later?
Yes. Settings → Export your data downloads everything — animals, feedings, weighings, sheds, medications, clutches and sales — as one Excel file, at any time.

Try Herply free

Free during the open beta, no animal limit, no credit card. Bring your spreadsheet with you.