Excel is not the problem. The problem is that LOLER compliance has specific, non-negotiable requirements — automated interval tracking, complete Schedule 1 records, audit trails, Cat A defect notifications — that a general-purpose spreadsheet tool was never designed to handle. Here are the seven gaps that appear, reliably, in every spreadsheet-based inspection programme.
1
No automated alerts — things slip
Excel does not know that a chain sling was due for examination last Tuesday. It sits in a cell. If nobody checked that cell last week, the overdue examination happened silently. With a fleet of 200+ assets across multiple sites, something will always slip through. HSE does not accept "we forgot to check the spreadsheet" as a defence.
2
Schedule 1 fields rarely get filled completely
LOLER Schedule 1 requires 12 specific fields on every report — including the date of next examination, the competent person's name and address, and the specific SWL. Most spreadsheets capture 4 or 5 of these. The rest are assumed, omitted, or stored elsewhere. An incomplete Schedule 1 report is a non-compliant report.
3
Version control is a liability
Multiple engineers. Multiple devices. The spreadsheet gets emailed, edited locally, and re-uploaded. By the end of a quarter, nobody is certain which version is current. In an HSE audit, you need to produce the definitive record immediately. "Let me find the latest version" is not an answer that inspires confidence.
4
No audit trail
Excel does not record who changed what, when. If a cell gets overwritten — accidentally or deliberately — there is no way to know. For legally-required records that may be produced in evidence, the absence of an audit trail is a significant vulnerability.
5
Accessories get confused with equipment
A crane has a 12-month interval. Its chains have a 6-month interval. In a spreadsheet, these are often tracked together on a single row per asset — meaning the accessory intervals get missed, or the crane's certificate gets conflated with its accessories'. This is one of the most common LOLER gaps HSE identifies.
6
Cat A defect notification gets missed
When a Category A defect is found, the competent person must notify the relevant enforcing authority immediately. A spreadsheet has no mechanism to trigger this. The notification step depends entirely on the individual engineer remembering to act — and in a busy inspection programme, it gets skipped.
7
No client-facing records
If you inspect for clients, they need to see their certificates. With a spreadsheet system, you email PDFs manually, track who has received what, chase responses. Every certificate delivery is a manual task. At scale, this becomes a significant administrative overhead — and things get lost.
What HSE Expects
During an inspection, HSE will ask to see the Schedule 1 report for any asset they choose. They expect to receive it immediately. They expect it to contain all required fields. They expect to see that it was produced by a competent person. And they expect the next examination date to be visible and not yet lapsed.
A spreadsheet can satisfy some of these requirements some of the time. Purpose-built LOLER software satisfies all of them, every time, with no manual effort beyond completing the inspection itself.
Replace your spreadsheet with something built for LOLER
Lolerflow generates Schedule 1-compliant reports automatically, tracks every interval, and alerts you before anything falls due. £250/month flat. 30-day free trial.
Start free trial →Is Excel acceptable for LOLER record keeping?+
Technically, LOLER does not prescribe the format for records — only that examination reports contain the Schedule 1 fields and are kept. However, a spreadsheet tracking system is not the same as the examination report itself. The report must be produced by the competent person and contain specific data. Using Excel as a scheduling tracker is not illegal; using it as a substitute for compliant examination reports is non-compliance.
What does HSE expect for LOLER records?+
HSE expects that the full Schedule 1 report exists for every thorough examination carried out, that it is produced by a competent person, that it is retained for the required period (until next report or 2 years), and that it can be produced immediately on request during an inspection. A spreadsheet summary is not a substitute for the Schedule 1 report.
What is the main compliance risk with spreadsheet-based LOLER tracking?+
The main risks are: missed examination dates (no automated alerts), incomplete records (fields not filled), version control failures (multiple spreadsheets, inconsistent data), no audit trail (changes untracked), and inability to produce records quickly during an HSE inspection. Any one of these can constitute a compliance failure.