Kennel booking spreadsheet: free Excel template
Plenty of kennels run well on a spreadsheet. If you're moving off a paper diary, or starting out, here's a free one built around the licence register – and an honest look at what a spreadsheet can't do.
Updated October 2026. An Excel (.xlsx) file – also opens in Google Sheets, Numbers and LibreOffice.
Outgrowing the spreadsheet?
Kennel Booking does what the spreadsheet can't: stops double bookings, checks vaccinations and your licence number, and keeps the register for you. We'll bring your spreadsheet across free.
Download the free template
Download the spreadsheet (.xlsx)
No sign-up, no email needed. The example rows use made-up names – delete them before you start.
What's in it
- Bookings – one row per stay. Type the dates, kennel, owner and price per night; the nights, total and balance after the deposit work themselves out.
- A vaccination check – type the date the earliest vaccination runs out, and the row shows CHECK if it runs out before the dogs go home.
- Dogs – one row per dog, with every field the licence register asks for: household, emergency and local contacts, vet, insurance, microchip, vaccination, kennel cough, titre, worming and flea dates, behaviour, diet and consents.
- A kennel chart – kennels down the side, days across. Type the month once and the days fill themselves in; copy the sheet for each month.
Tips for running bookings on a spreadsheet
- One file, one place. Keep it somewhere shared, like OneDrive or Google Drive, so there's only ever one up-to-date copy.
- Check the kennel chart for every night before you say yes. The bookings list won't warn you about a clash.
- Sharing is same household only. Use the household column to make sure two dogs in one kennel really are from one home, with signed permission.
- Back it up. Your licence needs records kept for three years, and electronic records backed up.
- Don't email it around. It holds personal details – share access, not copies, and protect it with a password.
What a spreadsheet can't do
| The problem | Why a spreadsheet struggles |
|---|---|
| Double bookings | Nothing stops two rows putting two dogs in the same kennel on the same night |
| Your licensed number | It won't warn you when a night goes over the number of dogs on your licence |
| Sharing | It can't tell whether two dogs in a kennel are from one household |
| Moving a stay | Change the bookings list, the chart and the price, by hand |
| Reminders and deposits | Every reminder is a call or text you send yourself |
| Online bookings | Owners have to ring or email, and you check availability yourself |
| Two people at once | Two people editing one file is how changes get lost |
For a small kennel with one person taking bookings, that may be fine. When you find yourself checking the same things over and over, it's time to look at booking software – see choosing kennel booking software and free options.
When you outgrow it
Send us your spreadsheet and we'll move it into Kennel Booking for you, free – checked with you before you switch.
The template is free, as is, as a starting point. Check its sums and adapt it to how you charge. You're responsible for keeping your customers' details safe and for meeting your licence conditions.