Can a diagnostic lab run on Excel?
A very small, non-accredited operation can. Once you need an audit trail, access control, traceability and defensible QC, spreadsheets stop being a sound basis.
Comparison
Spreadsheets vs a LIMS: when does Excel stop being enough?
Plenty of small labs run on spreadsheets, and for a while that works. This page sets out honestly where spreadsheets hold up, where they break, and how to tell which side of the line your lab is on.
Where spreadsheets are fine.
A spreadsheet is flexible, familiar and free. For a very small operation it can be the right tool:
- A handful of samples a day, one or two people, one test type.
- A research or non-accredited setting with no regulator asking for evidence.
- A short-lived project where nothing needs to be retained or defended later.
If that describes you, you may not need a LIMS yet, and we'd rather you knew that than bought something you don't need.
Side by side
Where spreadsheets start to break.
| What a diagnostic lab needs | Spreadsheets | A LIMS |
|---|---|---|
| Audit trail | None by default; a cell can be changed without a record | Every change recorded: who, what, when |
| Access control | File-level at best; anyone with the file can edit it | Individual logins and role-based permissions |
| Sample traceability | Manual; depends on everyone following the same convention | Barcoded lifecycle from receipt to report |
| QC and Westgard rules | Home-built formulas, checked after the run if at all | Rules evaluated as results arrive, with investigations recorded |
| Result authorisation | Informal | Review and release steps with e-signature |
| Reports | Copied into a document by hand | Generated and versioned |
| Errors | Transcription, formula and sort errors are easy to make and hard to see | Validated entry, reference ranges and flags |
| Clinic orders | Email, PDF or phone, then re-keyed | Clinics order directly into the lab's queue |
| Accreditation evidence | Assembled by hand before the assessment | A by-product of daily work |
Signs you've outgrown them.
- You're pursuing, or holding, ISO 15189 / UKAS accreditation and need a defensible audit trail and data-integrity controls.
- More than one person edits the same sheet, or you keep "the latest version" in an email.
- Someone has found a wrong formula or a sorted column that no longer matched, after the fact.
- Tracing one sample back through receipt, run, QC and report takes a search, not a click.
- Referring clinics are chasing you for results by phone.
- Preparing for an assessment means a month of collecting evidence from files.
One or two of these, and the cost of staying is mostly time. Several, and the risk is a reportable error or a finding at assessment.
Moving off spreadsheets without a big project.
The usual worry is the move itself. With a cloud LIMS it can be small: stand it up, load your test catalogue and reference ranges, and run new work in it while the spreadsheets stay your record until you trust it. FreshLIMS is set up the same day, the first month is free with no card, and the lab can export all of its data at any time. For a step-by-step approach, see switching your LIMS without downtime, which applies equally to moving off spreadsheets.
For what it costs, see our LIMS pricing guide; for how a hosted system works, what a cloud LIMS is.
FAQs
Spreadsheets vs LIMS questions.
Is a spreadsheet acceptable for ISO 15189?
Accreditation depends on whether you can show control of your records and data integrity. A spreadsheet can be used, but you must validate it and compensate for what it lacks, and that is often more work than a LIMS.
When should a small lab move to a LIMS?
When accreditation, volume, a second operator or clinic ordering make the manual work and the error risk more expensive than a subscription.
Will I lose my spreadsheet history?
No. Keep it as a read-only archive and run new work in the LIMS, or load what you need. You decide what moves.