A Small Spreadsheet That Makes Habitat Notes Easier to Revisit

Caius Duthie — Thu, 12 Nov 2026 07:12:18 +0000

After a wet afternoon outdoors, field notes can look more like a puzzle than a record. One person writes a bird name, another records a sound, and somebody photographs the same corner three times. I would rather keep those observations useful than ask volunteers to learn a complicated new system.

My starting point is a small spreadsheet. Each row holds one observation. The columns answer ordinary questions: when, where, what, who recorded it, and how certain are we? A separate notes column gives people room to explain an uncertainty without squeezing it into an identification field.

Why use a spreadsheet at all? It is easy to share, easy to export and familiar enough that another person can take over. A clever database can wait. The first test is whether someone returning from a walk can add a row without calling the person who built the file.

I would give each observation a simple reference number. A photograph can use the same reference in its filename. That small habit saves a surprising amount of searching later. It also lets the record point to an image without putting a large photograph inside every spreadsheet cell.

A short script can handle the dull checks. It can flag an empty date, a repeated reference number or a location that has been typed three different ways. The script should produce a review list and leave the original rows alone. A warning is an invitation to look again, not permission to rewrite somebody’s observation.

Uncertainty deserves its own place. A drop-down with options such as certain, likely and unknown can help, provided everyone understands what those words mean. I would keep the original description too. Software cannot turn a hurried glimpse of a brown bird into a reliable species record.

For community projects, a useful summary might be a monthly list of places visited and questions still open. It does not need an impressive dashboard. A filter showing records that need a second look may do more for the next walk than a colourful chart of uncertain sightings.

Before sharing the file, check what it reveals. Volunteer contact details belong elsewhere. Exact locations for sensitive wildlife may also need a different approach from a public map. Ask the organisation managing the records how it wants those details handled, rather than building assumptions into the export.

The handover matters as much as the script. Put a short explanation beside the file: what each column means, how to add a record, how to run the checks and where the backup lives. Then ask someone else to try it while you keep quiet.

I like tools that make the next conversation easier. If a spreadsheet helps a group remember what it noticed, admit what it does not know and choose a useful question for another walk, it has earned its place.

The best first version is often deliberately small: one file, a handful of clear checks and a colleague who can explain the result without needing its original author.

DEV Community: Caius Duthie

A Small Spreadsheet That Makes Habitat Notes Easier to Revisit