How to Track Excavation Inspections Without the Paperwork Headache

Introduction

Excavations are among the most hazardous activities on any construction site. Collapses can be sudden, catastrophic, and fatal. That is precisely why UK legislation requires a rigorous regime of inspections before and during excavation work — and why failing to document those inspections properly can lead to enforcement action, project delays, and, in the worst cases, criminal prosecution. Despite the seriousness of the requirement, many sites still rely on paper forms stuffed into lever-arch files, often completed inconsistently and rarely reviewed until an auditor or inspector comes knocking.

In this guide we look at the regulatory framework that governs excavation inspections, what information must be recorded and when, the practical problems caused by paper-based systems, and how a purpose-built Excel register can solve those problems while saving your site team significant time every week.

The Regulatory Framework

In the United Kingdom, the primary legislation governing excavation safety on construction sites is the Construction (Design and Management) Regulations 2015, commonly referred to as CDM 2015. Regulation 22 specifically addresses excavations, requiring that suitable and sufficient steps are taken to prevent danger from the collapse of an excavation, from material falling into an excavation, and from the fall of any person into an excavation. The regulation also requires that excavations are inspected by a competent person at prescribed intervals.

Supporting CDM 2015 is British Standard BS 6031, which provides a code of practice for earthworks. BS 6031 gives detailed guidance on how to assess ground conditions, design temporary support systems, and carry out inspections. It sets out the factors that a competent person should consider during an inspection, including the condition of the excavation sides, the effectiveness of any shoring or battering, the presence of water, and the proximity of adjacent structures or services.

Under CDM 2015, inspections must be carried out before any person carries out work at the start of every shift, after any event likely to have affected the strength or stability of the excavation (such as heavy rainfall, a nearby impact, or the removal of support), and after any accidental fall of rock, earth, or other material. The results of these inspections must be recorded and the reports kept on site and available for review by the enforcing authority. The person carrying out the inspection must be competent, meaning they have the training, experience, and knowledge to identify the relevant hazards and to determine whether the excavation is safe for work to continue.

What Needs to Be Recorded

A compliant excavation inspection record must capture several key pieces of information. These include the date and time of the inspection, the location and identification of the excavation, the name and signature of the competent person carrying out the inspection, the condition of the excavation at the time of inspection, any defects or hazards identified, the actions taken or required to address those defects, the outcome of the inspection (safe to work or not safe to work), and any relevant weather or ground conditions that may affect stability. Some sites also record the depth of the excavation, the type of support in place, the proximity of services or structures, and whether a permit to dig was in place.

The level of detail required means that a simple tick-box form is rarely sufficient. Inspectors need space to describe conditions in their own words, to note specific locations within larger excavations, and to flag items for follow-up. At the same time, the information needs to be structured enough that it can be reviewed, audited, and cross-referenced with other project records such as the permit-to-dig register, the temporary works register, and the risk assessment library.

Common Problems with Paper-Based Systems

Despite the legal requirements, many construction sites still manage excavation inspections using paper forms on a clipboard. While paper has the advantage of simplicity, it introduces a range of problems that can undermine compliance and create unnecessary administrative work.

The first problem is legibility. Inspection forms filled out on site, often in poor weather and in a hurry, can be difficult to read. When a health and safety inspector asks to review your records six months later, illegible handwriting is not a good look. The second problem is completeness. Paper forms rely on the inspector remembering to fill in every field. It is common to find forms with missing dates, unsigned entries, or blank sections where the outcome should have been recorded. A third problem is storage and retrieval. Paper forms need to be filed, and on a busy site the filing often falls behind. Finding a specific inspection record for a specific excavation on a specific date can involve searching through multiple folders. If forms go missing — which they do — there is no backup.

A fourth and significant problem is the lack of any automatic follow-up mechanism. When an inspector identifies a defect and records a required action, there is no system to ensure that the action is carried out and closed out. The form goes into the file and the action may or may not be picked up by whoever reviews the folder next. On a large site with dozens of open excavations, this creates genuine compliance risk. Finally, paper systems make it very difficult to generate summary reports. If the project manager asks how many inspections were carried out last month, or how many defects are currently outstanding, the only way to answer is to count forms manually.

How an Excel-Based Register Solves These Problems

A well-designed Excel register addresses every one of the problems described above while keeping the process simple enough for site teams to use without specialist training. The key is to build the register around a structured data table with the right combination of free-text fields and controlled dropdown lists.

Data validation dropdowns ensure that critical fields like inspection outcome, excavation ID, and inspector name are filled in consistently. Conditional formatting highlights overdue actions in red and upcoming inspections in amber, providing an automatic visual alert system. Formulas can calculate the number of days since the last inspection for each excavation, flagging any that have gone longer than the required interval. Sheet protection locks the structure and formulas while allowing inspectors to enter data in the designated fields, preventing accidental damage to the register.

Because the data is stored in a structured table, generating summary reports becomes trivial. A pivot table can show the number of inspections by excavation, by inspector, by outcome, or by week — exactly the kind of information you need for progress meetings and audit preparation. Filtering allows you to instantly see all open actions, all inspections for a specific excavation, or all records from a particular date range. And because the file is digital, it can be backed up automatically, shared across the site team via a network drive or cloud storage, and searched instantly.

Features to Look for in a Good Inspection Tracking System

Not all spreadsheets are created equal, and a hastily put-together register is only marginally better than paper. If you are building or buying an Excel-based excavation inspection register, here are the features that separate a good system from a mediocre one.

First, it should have a dedicated input sheet with a clean, intuitive layout that guides the user through each inspection record step by step. The input fields should be clearly marked, ideally with a distinct background colour, and the rest of the sheet should be protected. Second, it should use data validation extensively — not just for the obvious fields like outcome and inspector, but also for excavation IDs (drawn from a master list) and location codes. Third, it should include an automatic action tracker that links back to the inspection record, so that when a defect is identified the required corrective action is logged, assigned, and tracked through to close-out.

Fourth, the register should include a dashboard or summary sheet that provides at-a-glance metrics: total inspections this period, percentage of pass results, number of open actions, average time to close out defects, and any excavations that are overdue for inspection. Fifth, it should be printable. Despite the benefits of digital systems, there are times when you need to print an individual inspection record — for an audit, for a client review, or for display in the site office. The template should be formatted so that individual records print cleanly on a single page. Sixth and finally, the register should include clear instructions and a reference sheet that explains each field, lists the relevant regulatory requirements, and provides guidance on what constitutes a competent person for the purposes of the inspections.

How Automation Saves Time

One of the biggest advantages of an Excel-based system over paper is the opportunity for automation — not complex macros or VBA, but simple formula-driven automation that eliminates repetitive tasks and reduces the chance of human error. For example, the register can automatically populate the next inspection due date based on the last inspection date and the required frequency. It can automatically calculate the number of open actions and display a warning if any are overdue. It can use conditional formatting to change the colour of an entire row based on the inspection outcome, making it instantly obvious which records need attention.

For sites using the register on a shared drive, you can set up a simple email reminder system using Outlook rules triggered by a summary exported from the spreadsheet. Some teams go a step further and link the Excel register to a Power BI dashboard for real-time reporting across multiple sites, though this is entirely optional and the register works perfectly well as a standalone file.

The cumulative time saving is significant. On a typical site with ten to fifteen open excavations, a paper-based system might require two to three hours per week of administrative time for filing, chasing actions, and compiling summaries. An Excel-based register can reduce that to thirty minutes or less, while simultaneously improving the quality and completeness of the records. That is time your site team can spend on actual site management rather than paperwork.

Conclusion

Excavation inspections are not optional — they are a legal duty under CDM 2015 and a critical safety control on every construction site. But compliance does not have to mean drowning in paper. A well-designed Excel register gives you structured, legible, searchable records with built-in follow-up tracking and automatic summaries. It reduces administrative time, improves data quality, and ensures that when the inspector asks to see your excavation records, you can pull them up in seconds with confidence that they are complete and current. If your site is still relying on paper forms in a lever-arch file, it may be time to make the switch.