LMS vs Spreadsheets: Why Nigerian Organisations Need Better Training Record Management

Almost every training function starts in a spreadsheet, and there is nothing wrong with that. A sheet with names down the side, courses across the top and a tick where someone has finished is quick to build, free to run and understood by everyone. The question this guide answers is not whether spreadsheets are bad. It is when the LMS vs spreadsheets decision tips, what to move first when it does, and how to tell honestly whether you should stay where you are.

It is written for HR, L&D and operations managers who suspect their training tracker is creaking but do not want to buy software they do not need. We sell an LMS, so you should weigh our view accordingly. For that reason, this guide starts with the cases where a spreadsheet is the right answer, and it points to a free tracker for people who decide to stay. It is a category comparison, not a comparison of named products. If your real question is about chat apps rather than spreadsheets, see our sibling article on LMS vs WhatsApp training.

When is a spreadsheet the right tool for training records?

A spreadsheet is a sensible choice when most of the following are true:

• You have a small, stable group. Roughly a few dozen people, with little turnover and few role changes.
• You track few courses. A handful of mandatory items, each with a clear completion date.
• One person owns the file. Nobody else edits it, and that person is not about to leave.
• The stakes are modest. No regulator, customer or auditor will ask you to prove who was trained on what, and no licence or contract depends on it.
• Training is delivered face to face. You are recording attendance at sessions, not delivering content or assessments.

If that describes you, a well-kept spreadsheet is cheaper and simpler than any platform, and our guide to whether a small business needs an LMS says the same. The related question of headcount is covered in how many employees you need before an LMS makes sense. The trouble starts when the conditions change and the sheet does not.

What are the five signs you have outgrown Excel?

Sign 1: More than one person edits the file. The moment a second person adds rows, you meet copies: “Training tracker FINAL”, “Training tracker FINAL v2”, and a version on someone’s phone. Nobody knows which is current, and the audit trail is whoever remembers.

Sign 2: You are asked to prove, not just report. A tick in a cell says someone claims a person was trained. It does not show who ticked it, when, or whether the file was changed afterwards. When a regulator, client or auditor asks for evidence, a spreadsheet is a summary, not a record. Our guide to audit-ready training records sets out the difference.

Sign 3: Chasing takes more time than training. If the training coordinator spends days each month sending messages to people who have not finished, the sheet is doing the recording while a human does everything else. Reminders and escalations are the first thing most teams want to automate, as we describe in our article on automated training reminders and escalations.

Sign 4: The sheet cannot answer a simple question quickly. Who is overdue? Which site is behind? Who is authorised to do this task today? If answering requires filters, lookups and a long afternoon, the structure has outgrown the tool.

Sign 5: The data has become sensitive or large. Training sheets often hold names, phone numbers, staff IDs, performance notes and sometimes health or disciplinary information. A file emailed between managers is difficult to protect and difficult to account for. See our guide to NDPA data protection training for HR teams for why this matters.

If two or more of these are true, the cost of staying is usually higher than the cost of moving, even if it does not show up on an invoice.

What do spreadsheets do well, and where do they fall short?

Need	Spreadsheet	LMS (in general)
Cost to start	Free or already licensed	Subscription and setup cost
Flexibility of layout	Very high	Structured by design
Recording attendance	Easy, manual	Easy, can be automatic
Single current version	Depends on discipline	Normally one live record
Who changed what, and when	Limited unless carefully set up	Usually a log, but check
Automatic reminders	Needs manual work or add-ons	Typically built in, but check
Delivering the course itself	No	Yes
Assessments and scores	Manual entry	Captured with the course
Reporting across sites	Manual consolidation	Typically filtered views
Access control by role	Weak	Typically stronger

Treat the right-hand column as questions to put to any vendor, not promises. Features vary, and we encourage you to ask for a live demonstration of each one against your own data.

What does a real spreadsheet failure look like?

The most widely reported recent example involved public health data, not training, but the failure mode is the same. In October 2020, Public Health England announced that 15,841 positive COVID-19 cases recorded between 25 September and 2 October had not been included in daily totals. Its interim chief executive, Michael Brodie, said in a statement: “15,841 cases between 25 September and 2 October were not included.” According to The Register’s report, citing the BBC’s explanation, test results from commercial laboratories had been stored in the older .XLS format, which caps a sheet at 65,536 rows.

Each test result took several rows, so the practical limit was about 1,400 cases per sheet, and anything beyond that was left out when the data was imported. The report says contact-tracing alerts were not sent for those cases, and estimates that as many as 48,000 people had not been told they had been in close contact with an infected person.

Nobody tracking forklift certificates has that problem. The lesson is smaller and more useful. A spreadsheet can quietly drop information without any visible error, because it does exactly what it is told. The tool works until it reaches a limit nobody remembered, and the person using it sees a tidy sheet and assumes it is complete. A training record that silently omits people is the same risk on a smaller scale: an expired certificate that never shows up on the overdue list.

How common are errors in spreadsheets?

Researchers have studied this for decades. Raymond Panko of the University of Hawaii compiled field audits of real organisational spreadsheets in a paper for the European Spreadsheet Risks Interest Group (EuSpRIG) in 2000. Across all seven audits he reviewed, covering 367 spreadsheets, 24% contained errors, but he noted that older audits used methods unlikely to catch most errors.

The audits from 1997 onward, covering 54 spreadsheets, found errors in 91% of them on a weighted average, and he concluded that “most large spreadsheets probably do contain significant errors.” Those spreadsheets were mostly financial and decision models, and many were far more complex than a training tracker, so the percentages should not be applied to your file. The point is narrower: when people look carefully, errors are usually found, and a training tracker with a hundred rows and a dozen formulas is not exempt from the way spreadsheets fail.

What should you move first?

You do not have to move everything at once. A sensible order is to move the parts where the sheet is weakest:

1. Mandatory and regulated training. These are the records you may have to prove. Move them first so that the evidence is a system record, not a summary.
2. Anything with an expiry date. Licences, certificates and periodic refreshers fail silently in a sheet. Our guide to LMS for certification and credentialing explains expiry tracking.
3. Training that needs reminders. If someone spends their week chasing, automate that first.
4. Training with assessments. If scores are typed in by hand, move them so they are captured at source.
5. Everything else. Optional or one-off sessions can stay in the sheet for longer, or move last.

For a regulated plant, the same logic applies at a deeper level, as described in our article on LMS for pharmaceutical and life sciences companies.

How do you migrate without losing your history?

Moving from a spreadsheet to a platform is usually a data-cleaning job more than a technical one. A practical sequence:

• Freeze and copy the current sheet. Keep an unaltered archive of the old records, dated, for reference.
• Clean the people list. Agree one identifier per person (staff ID is better than name), remove leavers and fix duplicates.
• Standardise course names and dates. Different spellings of the same course will become different courses in the new system.
• Decide how far back to import. Importing everything is rarely necessary. Import current status and anything you are required to retain, and keep the archive for the rest.
• Run both for a short period. Compare the new records with the sheet for a month, and investigate differences before switching off the old one.
• Name an owner. Someone must be accountable for the data after launch.

Ask any vendor what help they provide with this step and what it costs, since it is often where projects stall. For the money side, our LMS cost and payback calculator lets you compare the cost of staying with the cost of moving using your own numbers.

What are the common pitfalls when comparing an LMS vs spreadsheets?

Pitfall 1: Comparing software cost with zero. A spreadsheet is not free. It costs the hours spent updating, chasing, reconciling and answering questions. Measure those hours before you compare.

Pitfall 2: Buying a platform to fix a process problem. If nobody agrees who is responsible for training, or deadlines are not enforced, software will record the problem faster. Fix ownership first.

Pitfall 3: Moving everything at once. A big-bang migration of every course and every person invites errors and resistance. Start with the highest-risk training.

Pitfall 4: Importing dirty data. Duplicates, misspelled names and inconsistent dates become permanent faults in a new system. Clean first.

Pitfall 5: Assuming a platform automatically gives you audit evidence. Evidence depends on what the system records and how you use it. Check what is logged and how records are protected from alteration.

Pitfall 6: Ignoring adoption. A platform nobody uses is a more expensive spreadsheet. Plan communication, manager involvement and a launch, and see our guide to LMS adoption when it is available.

Pitfall 7: Dismissing staying put out of habit. If your situation fits the first list in this article, staying on a spreadsheet is a legitimate decision. Make it deliberately and review it when headcount, risk or regulation changes.

Pitfall 8: Forgetting data protection. Whichever tool you choose, decide who can see personal data, where it is stored and how long you keep it.

What if you decide to stay on a spreadsheet?

Then do it well. Use one shared master file rather than copies, lock the structure, record who made each change and when, keep a dated backup, give each person a unique ID, and review the file monthly against HR records. We plan to publish a free training tracker template in our template library, which will include these controls. Until it is available, you can build your own along those lines, and you are welcome to ask us for guidance even if you never buy from us.

What should you ask an LMS vendor to show you?

Bring a real extract of your tracker, with names removed, and ask the vendor to show you in the demo:

• How your current data would be imported and cleaned, and who does the work.
• How you would see who is overdue, by team and by site, in one screen.
• What is recorded when a person completes a course, and whether a record can be changed afterwards.
• How reminders and manager escalations are set up and stopped.
• How you would export your data if you left.
• What it would cost for your headcount in naira, including setup and support.

Our wider checklist of questions to ask in an LMS demo goes further. If you would like to test your own tracker against our platform, you can book a demo with Learnep and bring the file. We will tell you honestly if a spreadsheet is still the right answer for you.

Frequently asked questions

Can Excel be used as an LMS? Excel can record training status, but it cannot deliver courses, run assessments or enforce deadlines by itself. It works as a tracker for small, low-risk training, and it stops being enough when you need evidence, reminders and reporting across teams.

How many employees before a spreadsheet stops working? There is no fixed number. The better test is the five signs above: multiple editors, a need for proof, heavy chasing, slow answers and sensitive data. A small regulated company can outgrow a sheet sooner than a large unregulated one.

Is a spreadsheet acceptable evidence for an auditor? It depends on the auditor and the standard. Many will accept a well-controlled spreadsheet with supporting records, and some will not. Ask the auditor or regulator what they expect before you decide, and see our guide to audit-ready records.

Is moving to an LMS expensive? Costs vary widely by vendor, headcount and how much content you need. Use quotes, not averages, and test the numbers with our cost and payback calculator before you decide.