Beekeeping Hive Inspection Log Spreadsheet

About this template

This hive inspection log is for beekeepers who look inside their colonies every week or two through the season and want a clear record of what they saw. One row per inspection, seven short entries, and the workbook keeps the season in order.

An inspection is a handful of quick observations made with the roof off and gloves on, and by evening most of them are gone. Typing them in takes about ninety seconds and keeps them for good.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

Seven observations, seven columns

• Queen seen: yes, no, or eggs only
• Brood frames and stores, side by side, which is how you spot a colony going backwards weeks before it is obvious
• Temper, scored one to five, because a bad-tempered hive is a fact worth recording and acting on
• Colony state, one of six, each with its own color
• Supers on and honey taken in kilos

What gets counted for you

Hives that are queenless or weak are counted on the summary strip, so the colony that needs attention is not buried in fifty rows of notes. Varroa treatments are counted too, which makes the log useful as a simple varroa tracker and queen record alongside your honey tracker.

Six connected tabs

• Start Here and Setup: a guided start and your hives
• Hives: room for 300 inspections across as many hives as you keep
• Tasks: jobs like ordering frames, making up syrup or booking a swarm collection
• Today: what the next ten days need
• Dashboard: reads every tab and fills itself

A full season to learn from

The worked example records 51 inspections across three hives in one season, from the first look in April to the September feed. It has brood against stores on every row, temper scores, 54.4 kg of honey taken, one varroa treatment and two hives flagged queenless or weak. A blank copy is ready for your own beekeeping log and apiary records.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice
• Google Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.
• No dynamic arrays, no macros, no add-ins and no subscription

What you download

• The Excel workbook filled with a worked example
• A blank Excel workbook ready for your own entries
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.

How many hives can I record?

As many as you like. The Hives tab has room for 300 inspections across all of them.

What do I record at each inspection?

Queen seen, brood frames, stores, temper from one to five, colony state, supers on and honey taken in kilos.

Can it track varroa treatments?

Yes. Varroa treatments are counted, and hives that are queenless or weak are counted on the summary strip.