Almost every safety programme starts the same way: a paper incident form, an inspection checklist on a clipboard and a spreadsheet in the HSE office that turns it all into a monthly report. For one site with a careful HSE officer, that can work for years. For a group with many plants, contractors and countries, it usually stops working long before anyone decides to change it.
This guide compares paper, spreadsheets and dedicated safety software on the things that matter to a group HSE director: whether reports reach you, whether numbers can be trusted, whether actions get closed and whether an auditor can follow the trail. It is general information, not legal advice.
Why safety starts on paper and spreadsheets
Paper and spreadsheets are cheap, familiar and flexible. Anyone can add a column, print a form or change a checklist overnight. Nobody needs a project, a budget or training. That flexibility is also the problem: every site ends up with its own forms, its own definitions and its own file, and the group report becomes a monthly exercise of collecting, re-typing and reconciling.
Where spreadsheets break
Errors you cannot see. Spreadsheet research has found errors to be common. In a review of field audits presented to the European Spreadsheet Risks Interest Group, Raymond Panko reported that audits from 1997 onwards found errors in 91% of the 54 spreadsheets examined, and that the audits most likely to catch errors found them in roughly 1% to 2.5% of formula cells. A safety KPI file that is copied, extended and re-sorted every month is exactly the kind of sheet where such errors hide.
Manual steps at scale. The risk is not limited to small teams. JPMorgan Chase's own management task force report on its 2012 CIO losses found that a key risk model was run through a series of Excel spreadsheets that had to be completed by hand. Group safety reports built by copying site files into a master sheet have the same weakness: every manual step is a chance to drop a row or paste over a formula.
No single current version. Files are emailed, saved locally and renamed "final v3". When an auditor or a regional director asks for the incident register, there are often several, and none is clearly the official one.
No control over who sees what. A spreadsheet is usually all or nothing: whoever has the file sees every injury, name and medical note in it. That is hard to square with data protection rules on health data and with the simple need to show each site manager only their own site.
No audit trail. A spreadsheet rarely records who changed a severity rating, when, and why. For an incident that later becomes a legal or insurance matter, that history matters.
Actions that disappear. Corrective actions live in a column that nobody is reminded about. There is no owner notification, no due-date escalation and no evidence of closure attached to the action itself.
Reports that never leave the floor. Near misses and hazards are reported when it is easy and skipped when it is not. OSHA strongly encourages employers to investigate close calls as well as injuries, because they reveal hazards and weaknesses in the safety programme before someone is hurt. A paper form that has to reach the HSE office first makes that much harder.
Paper, spreadsheets and safety software side by side
| What you need | Paper forms | Spreadsheets | Safety software |
|---|---|---|---|
| Reporting from the floor | Form must be found, filled and carried to the office | Usually typed later by the HSE team | Reported on a phone with photos, at the point of work |
| One current version | Originals in binders, copies drift | Many copies by email and on laptops | One database, one current record |
| Who can see what | Whoever opens the binder | Whoever has the file | Access scoped by role and by site, region or country |
| History of changes | Crossed-out entries, if any | Rarely recorded | Audit trail of who changed what and when |
| Corrective actions | Lists in meeting minutes | A column with no reminders | Owners, due dates, reminders and closure evidence |
| Group KPIs | Counted by hand each month | Merged from site files by copy and paste | Live dashboards that drill back to source records |
| ISO audit evidence | Search binders before the audit | Search folders and files | Records organised by process or clause, ready to show |
| Backups and continuity | Fire, water and loss risk | Depends on where the file is saved | Hosted with backups by the provider |
What ISO 45001 and GDPR expect from records
ISO 45001 does not tell you to buy software. It does require documented information to be controlled: available where it is needed, protected from loss of confidentiality, improper use or loss of integrity, with control over distribution, access, storage, changes (including versions) and retention. Each of these is possible on paper or in spreadsheets, but every one of them depends on people following a manual procedure across every site. Our guide to ISO document control across many sites covers this in detail.
Where incident and health records include personal data of people in the EU, Article 32 of the GDPR asks for measures that ensure the ongoing confidentiality, integrity, availability and resilience of processing systems, the ability to restore access to data promptly after an incident, and regular testing of those measures. A shared spreadsheet of injuries on a laptop is hard to defend against that list.
When spreadsheets are still fine
Spreadsheets are not wrong in themselves. They can be enough when:
- you run one small site with a handful of reports a month;
- one trained person owns the file and nobody else edits it;
- no personal health data is stored in it, or access is tightly controlled;
- you only need a simple monthly count, not drill-down by site, contractor or cause.
Many groups also keep using spreadsheets for one-off analysis after moving to software. The difference is that the spreadsheet becomes an export from the system of record, not the system of record itself.
8 signs you have outgrown spreadsheets
- The group safety report takes days to compile and is out of date when it arrives.
- Two people give different numbers for the same month's injuries.
- Near-miss reports are rare, or arrive in batches at month end.
- Corrective actions are discussed at every meeting but nobody can say how many are overdue.
- Before each ISO audit, the team spends days collecting evidence from folders and binders.
- Site managers can see other sites' incidents, or the HSE team emails files containing names and injuries.
- Contractor and visitor records are kept in different files from incidents and inspections.
- Losing one laptop or one HSE officer would lose years of records.
If three or more apply, the cost of the spreadsheet is already higher than it looks. Our guide What is safety management software? explains which modules replace which files.
Moving without losing your history
The main fear in leaving spreadsheets is losing the history that trend charts, audits and insurers rely on. A move usually works best in this order:
- Agree definitions first. One meaning of "recordable injury", "near miss" and "lost day" across every site.
- Map the hierarchy. Group, region, country, cluster and site, so every record has a home and every user a scope.
- Migrate recent history. At least the last one to two years of incidents, actions, inspections and training, so trends do not restart at zero.
- Start with high-volume processes. Incident, near-miss and hazard reporting, inspections and actions, then audits, training and contractors.
- Retire the old files. Make them read-only so there is only one place to report.
For a multi-site plan, see From paper to digital HSE: a 6-step plan.
Checklist before you decide
| Question | Why it matters |
|---|---|
| Can a worker report a near miss from a phone in under two minutes? | Reporting volume follows ease of reporting |
| Does each user see only their own part of the organisation? | Protects health data and keeps site views clean |
| Is every change logged with user and time? | Needed for investigations, audits and disputes |
| Do group KPIs drill back to the original record? | Lets you trust and explain every number |
| Are actions assigned, reminded and closed with evidence? | Closes the loop that spreadsheets leave open |
| Can evidence be pulled by ISO clause? | Shortens audit preparation |
| Will your existing history be migrated? | Keeps trends and audit trails intact |
| Who handles hosting, backups and updates? | Avoids a new IT burden for the HSE team |
Frequently asked questions
Is Excel good enough for safety management?
For a single small site with one careful owner, often yes. For many sites, it becomes hard to keep one current version, control who sees health data, track changes and close actions on time. Spreadsheet audits have found errors in most of the spreadsheets examined, so group numbers built by merging files need extra checking.
What is the main difference between safety software and a spreadsheet?
A spreadsheet stores numbers; safety software runs the process. Reports, investigations, actions, approvals and evidence live in one system with owners, reminders, access rules and a history of changes, and dashboards are calculated from those records rather than typed in.
Does ISO 45001 require safety software?
No. ISO 45001 requires documented information to be controlled, including availability, protection, access, version control and retention. Paper or spreadsheets can meet that with strict procedures; software makes those controls part of the system instead of relying on people at every site.
Will we lose our old records if we move to software?
Not if they are migrated. Plan to bring across at least the last one to two years of incidents, actions, inspections and training so trends and audit evidence continue. AccelSafety migrates the last two years of a client's files as part of go-live.
How AccelSafety helps
AccelSafety replaces safety spreadsheets with one system for every site. Workers report incidents, near misses and hazards from the Android or iPhone app with photos. Every record sits in one hierarchy from group to site, each user sees only their part of it (enforced on the server), and a full audit trail records every change. Actions are tracked to closure, group KPIs such as lost days, near misses and recordable injuries drill back to the source records, and evidence can be worked by ISO 45001 clause. Accel takes care of migration, hosting with backups, updates, training and support: your last two years of files are migrated, your team works in the system from the day after installation, the full history is in within 7 days, guaranteed, and users are unlimited. Book a free demo with one of your own spreadsheets.
Sources
- Raymond R. Panko: Spreadsheet errors, what we know (EuSpRIG Spreadsheet Risk Symposium, 2000)
- Report of JPMorgan Chase & Co. Management Task Force regarding 2012 CIO losses (16 January 2013), Yale Program on Financial Stability library
- The Baseline Scenario: The importance of Excel (James Kwak, February 2013, quoting the task force report)
- OSHA: Incident investigation (investigating close calls)
- Presencis: ISO 45001 clause 7.5 documented information (summary of requirements)
- ISO: ISO 45001 Occupational health and safety management systems
- GDPR Article 32: Security of processing
Accel Safety
