Spreadsheets vs. EDC: the real cost of running a clinical study on paper and Excel

Every year, medical device teams make the same calculation. They know a purpose-built electronic data capture (EDC) system exists. They have seen the demos. They understand the concept. And then someone looks at the budget and says: "We can manage this in Excel for now."

It is a reasonable-sounding decision. Excel is already licensed. The team knows how to use it. Paper case report forms (CRFs) have been a clinical staple for decades. The calculation seems simple: skip the EDC cost, run the study the traditional way, and revisit later.

What the calculation misses is everything that happens after you make that choice.

What EDC is, and why the comparison matters

Electronic data capture (EDC) is a software system designed to collect, store, and manage clinical trial data in a structured digital format. Purpose-built EDC platforms for medical devices replace paper CRFs and general-purpose spreadsheets with validated electronic case report forms (eCRFs), built-in audit trails, role-based access controls, and real-time data visibility for sponsors and monitors.

The comparison between EDC and paper or Excel is not primarily a technology question. It is a cost, risk, and timeline question. For any medical device team planning a clinical investigation (whether a first-in-human feasibility study, a pivotal trial, or a post-market clinical follow-up (PMCF) study) under EU MDR, understanding the full cost of each approach determines whether the "cheaper" choice actually saves money.

The direct costs are higher than they appear

The most cited data point in this comparison comes from a costs simulation study published in BMC Medical Research Methodology, which found that switching from paper-based collection to an EDC system reduced data collection costs by 55%. That figure is frequently misread as a software licensing comparison. In practice, most of those savings came from eliminating physical site overhead: travel, onsite monitoring visits, printing, binding, and shipping paper CRFs between investigative sites and sponsors.

Paper-based data collection embeds costs that are easy to overlook because they appear across multiple budget lines rather than one. Monitoring visits that would happen remotely in an EDC environment require travel. Data entry teams that would be unnecessary with eCRFs become a fixed staffing cost. Storage for physical CRF binders is billed by volume and duration. None of these show up in the "EDC license vs. zero" comparison that teams often make.

Excel adds its own layer. Spreadsheet-based collection requires someone to transfer handwritten data into a digital format, and that transcription step is where errors concentrate. A second independent study found that EDC-based collection reduced time to a locked database by 43%, with queries down 86% compared to paper equivalents. The query reduction matters because every query is a back-and-forth between the sponsor and site that consumes monitor and investigator time. Fewer queries means shorter studies, which compounds into cost savings across the entire study period.

ISO 14155 requirements that paper and Excel cannot meet

ISO 14155, the international standard for Good Clinical Practice (GCP) in medical device clinical investigations, is specific about what clinical data systems must provide. Section 7.8.3 requires that any electronic system used as the primary location for document storage and filing must be validated. That validation requirement is not a formality. Section 7.8.2 goes further, requiring that every change or correction to CRF data be dated, initialed, and explained without obscuring the original entry, so the full history of any data point is always recoverable.

Excel cannot meet either requirement. It is a general-purpose spreadsheet application with no built-in validation framework, no audit trail that logs individual cell-level changes with timestamps and user identity, and no role-based access controls restricting who can modify what. Organizations using Excel as their primary clinical data repository are operating outside the requirements of the standard they need to comply with, often without realizing it.

The cost of that gap surfaces at the worst possible time. A regulatory submission built on Excel-managed data can draw a request for additional validation evidence. A notified body review or FDA inspection that uncovers undocumented changes to source data generates a data integrity finding that can require extensive remediation work, none of which is recoverable once the study data is in question.

Paper introduces a different risk profile. Physical CRFs can be damaged, lost, or misfiled. There is no automatic backup. In multi-site studies, paper creates fragmentation by default: each site maintains its own physical records with no centralized visibility into completeness or data quality across the whole study. Protocol deviations at one site are invisible to the sponsor until the monitoring visit occurs.

How paper and Excel extend study timelines

Clinical study timelines are expensive. Every week a study runs longer than planned is a week of site maintenance costs, investigator payments, and monitor availability costs. The timeline effect of paper and Excel-based collection is systematic, not incidental.

One study tracking clinical trial performance metrics found that EDC-based studies ran 30% faster than paper-based equivalents across comparable therapy areas. The mechanism is direct: eCRFs eliminate the delay between data entry at a site and data availability to the sponsor. In paper-based studies, that gap is filled by physical transport, manual entry, and batch data cleaning. In an EDC system, data entered at a site is visible to the sponsor in near real time.

That real-time visibility changes how monitoring works. Remote data monitoring becomes viable when data is accessible without a site visit. Protocol deviations, missing data points, and out-of-range values can be flagged and queried the day they occur rather than weeks later during an onsite review. Shorter query turnaround times accelerate database lock, the final gating event before analysis can begin.

For medical device companies on a defined path to submission, the difference in time-to-database-lock often matters more than the direct cost comparison.

Project management limits of Excel in clinical studies

Excel is a calculation tool. It was not designed to manage the operational complexity of a multi-site clinical investigation. A functioning study requires task sequencing, milestone tracking, version control across multiple document types, and role-based accountability for every action taken on source data.

Excel provides none of these natively. Version control means saving files with sequential names and relying on discipline to ensure the right person opens the right version. Milestone tracking requires a separate project management layer that must be manually synchronized with the actual data. Accountability for data changes requires a logging protocol that must be designed, enforced, and audited entirely by the study team.

In a single-site feasibility study with a small number of subjects, these limitations are manageable. In any study with multiple sites, a meaningful subject count, or a complex protocol, the administrative overhead of maintaining control in Excel is significant. Studies go over budget not because the clinical work itself was underestimated but because the overhead of managing data manually was not.

What purpose-built EDC provides for medical device studies

A purpose-built EDC for medical device clinical investigations is not a premium version of Excel. The architecture is different from the ground up.

Built-in eCRF validation flags inconsistent or out-of-range entries at the point of data input, before errors propagate across the dataset. Role-based permissions mean that site coordinators, investigators, monitors, and data managers each see and can act on exactly the data their role requires, with every action recorded automatically. Electronic signatures meet 21 CFR Part 11 and EU GDPR requirements without additional validation effort from the study team.

Critically, the platform itself is pre-validated to ISO 14155 standards. The regulatory compliance question is answered by the system rather than the study team on a study-by-study basis.

For teams collecting data in eCRFs, purpose-built eCRF design is another factor that paper-based methods cannot replicate. Conditional logic, required field enforcement, and real-time range checks catch errors at entry rather than during data cleaning months later.

For teams conducting PMCF under EU MDR, the regulatory stakes are particularly high. PMCF data feeds directly into periodic safety update reports (PSURs) and post-market surveillance (PMS) reports, and both require data fully traceable to source. A spreadsheet-based PMCF program is a compliance liability, not a cost saving.

How to evaluate EDC vendors for medical device studies

The right question is not "should we use EDC instead of paper?" The regulatory requirements and cost evidence settle that. The practical question is which EDC platform is suited to medical device clinical investigations specifically.

Most EDC platforms were built for pharmaceutical trials and adapted afterward for devices. That matters because ISO 14155 is not ISO 14971: the risk management philosophy, the study design norms, the CRF structure, and the data ownership model all differ between pharma and device contexts. A detailed breakdown of what to look for is in our EDC evaluation guide for medical device teams.

Key criteria worth evaluating in any vendor conversation: whether the platform is pre-validated to ISO 14155:2020 (not just "compliant," but validated); whether data can be exported in standard formats without additional fees; whether the sponsor retains full data ownership or is dependent on the vendor for access; and whether the eCRF builder can accommodate the variability of device study designs without requiring custom development for each protocol.

The decision is rarely just about software cost

The teams that use spreadsheets and paper for clinical data collection are not making a bad decision for bad reasons. They are making a reasonable decision with incomplete information. The direct software cost is visible and easy to compare. The monitoring travel savings are not. Neither is the query reduction timeline benefit, nor the risk of a data integrity finding at submission.

Run the full cost comparison and the calculation changes. The break-even point between a fit-for-purpose EDC and a self-managed spreadsheet approach is reached faster than most teams expect, often before database lock on the first study.

Running clinical evidence on tools that were not built for it is a choice that compounds over time. Purpose-built Greenlight Guru Clinical handles compliance, auditability, and data quality as built-in properties, so the study team can focus on the clinical work itself.

Keep reading

If you are building out your clinical data collection process, these guides go deeper on specific components:

• EDC systems for clinical trials: the definitive guide for medical device manufacturers
• ISO 14155:2020 guide for medical device clinical investigations
• eCRF design best practices for medical device clinical investigations
• How to choose an EDC system for medical device clinical investigations
• eCRF completion guidelines
• Post-market clinical follow-up (PMCF) under EU MDR

Request a demo to see how it works for a medical device clinical investigation.

Frequently asked questions

Can Excel be used for clinical trial data collection?

Excel does not meet the requirements of ISO 14155 for electronic systems used as primary clinical data storage. Section 7.8.3 of the standard requires that such systems be validated. Excel is a general-purpose tool with no validated audit trail, no role-based access controls, and no built-in error-checking at the field level. Regulatory bodies in both the US and EU expect clinical investigations to be conducted in accordance with ISO 14155 or equivalent GCP standards.

What is the difference between EDC and paper CRFs in clinical trials?

Paper CRFs are completed by hand at the investigative site and must be physically transported to the sponsor for manual data entry and cleaning. EDC systems use electronic case report forms (eCRFs) that capture data digitally at the point of entry, validate it in real time, and make it immediately accessible to authorized users. Published studies show EDC-based studies achieve 30% shorter durations and 43% faster database lock compared to paper equivalents, with query volume reduced by 86%.

Does EDC software need to comply with ISO 14155?

For medical device clinical investigations, yes. ISO 14155:2020 section 7.8.3 requires that any electronic system used as the primary document storage location be validated. A purpose-built EDC platform for medical devices should be pre-validated to this standard out of the box, so the sponsor does not need to perform an independent system validation before each study.

What is the cost of using spreadsheets instead of EDC for clinical studies?

One published cost simulation study found that paper-based data collection costs 55% more than EDC-based collection when all costs are included: site travel, monitoring visits, printing, data entry, and data cleaning. Timeline extensions add further cost: paper-based studies run 30% longer on average. The break-even point between a purpose-built EDC license and a spreadsheet-based approach is typically reached before database lock on the first study.

How does Greenlight Guru Clinical compare to Excel or paper for medical device studies?

Greenlight Guru Clinical is pre-validated to ISO 14155:2020, includes built-in eCRF validation and audit trails, supports 21 CFR Part 11 electronic signatures, and gives sponsors real-time data access without requiring a site visit. It is purpose-built for medical device clinical investigations, not adapted from pharmaceutical EDC platforms, which means the eCRF builder, study setup, and compliance documentation are all designed around ISO 14155 and device-specific study designs.