Is It Time to Retire Spreadsheets in HR?

For years, the spreadsheet was the quiet workhorse of HR. Holiday balances, sickness logs, probation dates, contractor records, all of it lived in a workbook on someone's drive. It was cheap, familiar, and good enough. Driving licence compliance is the clearest example of how persistent the habit is. Even the businesses we speak to that have already invested in an HR tool still track licence checks, points and renewals on a separate spreadsheet. The question is not whether that spreadsheet is tidy or well built. It is whether a spreadsheet was ever the right tool for the job.

Excel Is Not a Database

Start with what Excel actually is. It is a calculation tool, and a superb one: ad hoc analysis, modelling, quick sums, a blank grid that will do almost anything you ask of it. What it is not is a system of record.

A database enforces structure. Every field has a defined type, every record follows the same rules, values are validated as they are entered, and access is controlled per user. A spreadsheet enforces none of that by default. Any cell can hold anything. A date can quietly become text. A formula can be overwritten with a typed-in number and nobody notices. There is no built-in record of who changed what, or when.

For compliance data, that is not a detail. Right to Work status, licence checks, document expiry dates, these have to be correct, consistent and trustworthy, because the business is accountable for them. This is data you may be required to retain for years, six years for holiday pay records and two years for Right to Work records after someone leaves, and to produce on demand. A tool where any value can be silently changed is the wrong place to hold it.

A System Built on Excel Is Always Clunky

Here is the part that surprises people. The quality of the spreadsheet does not save you. Plenty of HR teams have a genuine spreadsheet superstar, someone who has built something clever with macros, lookups, conditional formatting and tabs that cross-reference each other. It works. It can be impressive. And it is still a problem.

A spreadsheet system lives in one person's head. When that person is on leave, leaves the business, or simply forgets why a formula behaves the way it does, the whole thing becomes fragile. Bringing a colleague up to speed on it takes weeks. A small change risks breaking three things downstream that no one spots until later. That is key-person risk wearing the costume of efficiency.

None of it scales. Every new starter, every licence renewal, every report is a manual action: chase the document, update the cell, copy it to the master, set a reminder to check again in three months. At ten people it is tedious. At a few hundred, across multiple sites and engagement types, it stops working. The volume does not just get heavier, it exposes every weak point at once: version conflicts, duplicate files, out-of-date copies, and checks that quietly slip. A spreadsheet does not fail loudly. It fails quietly, between the cracks, which is the most expensive way for a compliance process to fail.

What Replaces the Spreadsheet

The fix is not a better-built spreadsheet. It is the right category of tool: a system designed to hold this data, where structure is enforced, access is controlled, and the work does not depend on one person or grow with headcount. Xertilox HR was built for exactly this. Employee records, employment history, a policy library with acknowledgement tracking, holiday and absence with Bradford Factor monitoring, onboarding, performance and reporting all sit in one platform, with compliance built in as standard rather than bolted on.

Every action against a record is a timestamped, auditable workflow. Right to Work, identity and DVLA status are visible on each employee and held to the proper standard. The system does the chasing, the renewals and the reminders, so the process runs the same whether you have ten people or a few hundred. The platform is £10 per user per month, the compliance wallet included, billed monthly with no lock-in.

Two Products, One Connected Platform

Xertilox is built as two products that work seamlessly as one. The first is a standalone compliance platform. It verifies a digital Right to Work by simply requesting a worker's wallet ID, with no HR system required. The worker approves the request on their phone, and the result, including the share code and the statutory excuse, is stored in our compliance platform, always audit ready.

The second is the HR platform, with that same compliance included as standard. The verified record powers everything else, so Right to Work, identity and licence status sit on the employee record alongside onboarding, absence, performance and reporting. Use the compliance platform on its own, run the full HR system, or connect the two. The verification is the same either way.

Spreadsheets did not fail HR. They were simply never built to be the system of record a compliant, growing business needs. Retiring them is not about the tool being bad. It is about using the right one for the job.