When is your spreadsheet enough?
qBase, the method behind Clarida’s normalization, began as an Excel tool.
| You trust your plate and mix template | Instrument makers build on it: CFX Maestro reads a plate template back from Excel, QuantStudio a plate setup from text |
|---|---|
| You run one plate with a validated reference gene | A quick check before the real experiment needs no more |
| You need a calculation of your own | A spreadsheet takes any formula; Clarida runs set methods |
| You share data with a collaborator | MIQE 2.0 names Excel among the formats to share qPCR data in |
| You make the figures and run the tests | Prism: many tests, curve fitting and publication figures, with Info sheets for the experiment’s details |
| You work offline | A spreadsheet needs no connection |
Is your spreadsheet doing too many jobs?
- If the plate map, the mix sheet and the analysis are three files, two new samples change the plate at once, the mix volumes only when someone edits them.
- If your template uses 2−ΔΔCq, it assumes 100% efficiency. MIQE 2.0 recommends against relying on ΔΔCq and asks for efficiency-corrected quantities.
- A one-column template normalizes on one reference gene. One gene gave errors of up to 3.0-fold in a quarter of the cases studied (Vandesompele 2002). Published studies use 1.2 on average, and 15% tested their stability (Chapman 2015).
- If three people have edited the template, which copy is right?
- Gene names turned into dates. It affected 30.9% of papers with Excel gene lists (Abeysooriya 2021); Microsoft 365 and the 2024 edition of Excel can switch that off, though a name with a space or hyphen may still convert.
- A reviewer asks which reference genes you checked, and how. The answer sits in someone’s copy of the template.
Side by side
| What you need | Excel or Google Sheets | GraphPad Prism | Clarida |
|---|---|---|---|
| Define | |||
Goal, background and papersDetails | A notes sheetWherever you write it: beside the data, or in another file | Info sheetsExperimental details and notes, in the project file | In the experimentGoal, background and linked papers, carried into the notebook export |
| Design | |||
Plate layoutDetails | TemplatesPlate maps drawn by hand; CFX Maestro and QuantStudio read a plate setup from a spreadsheet file | Not documentedPrism starts after the run | Stronger: GeneratedLaid out by your lab’s rules, in blocks for a multichannel pipette, with the reason for each automatic choice, then saved as your cycler’s plate setup file |
| Execute | |||
Mix volumesDetails | CalculatorsMix calculators are common, some published; you keep the reaction count in step with the plate | Not documentedPrism starts after the run | Stronger: From the plateA recipe per mix with its surplus, worked out again whenever the design changes, until the runs are ready |
At the benchDetails | A printoutThe plate map on paper; notes go wherever you put them | Not documentedPrism starts after the run | Stronger: GuidedWhat to collect, then the plate one stage at a time; a note on a well comes back beside its measurement |
| Import | |||
Your original dataDetails | EditablePasted over as easily as any other cell | In the fileKept in the project file | Stronger: KeptImported Cq values are never overwritten, and the raw curves are kept |
| Analyze | |||
Efficiency and its errorDetails | By handPossible; a 2^−ΔΔCq template assumes 100% and carries no error | Not documentedGraphPad’s qPCR tutorial computes fold change as 2^−ΔΔCt, which assumes 100%; efficiency and its error are not mentioned | Stronger: Built inPer target, from your dilution series; the error is carried through to the normalized result |
Reference genesDetails | By handAs many columns as the template has | OneIn GraphPad’s tutorial | Stronger: SeveralCombined by geometric mean, or the global mean; geNorm and NormFinder show which are stable |
Your own calculationsDetails | Stronger: Any formulaWrite whatever calculation you need | ManyTransforms and calculated variables | Set methodsThe published methods and their settings; no free formulas |
Statistics and figuresDetails | BasicA few tests; charts by hand | Stronger: ExtensiveMany tests, curve fitting, publication figures | Common testst-tests, one-way ANOVA with post-hoc comparisons, rank-based methods and correlation; adjusted p-values |
| Report | |||
Sharing the dataDetails | The file itselfMIQE 2.0 names Excel among the formats to share data in | Project fileThe .prism file holds raw data, settings and results in an open format | Stronger: Report, notebook, RDMLA PDF or HTML report with every table as CSV; an Excel notebook; RDML 1.3 with the raw curves, checked against its schema |
| Throughout | |||
Who changed whatDetails | Cell editsExcel 365 and Sheets record them, but not formatting or changes made by formulas, and copying the file can lose the record | NoneNo audit trail, says GraphPad | Decisions storedSetting changes, automatic exclusions and accepted QC deviations, with who and when |
One method for the whole labDetails | Per copyEach copy of a template can drift; sheet protection is not a security feature | Per fileOne analysis per project file | Stronger: SharedA preset brings the lab’s settings set, which freezes once used; each experiment keeps its own copy; on a paid plan |
A year laterDetails | If you kept itAs the file was saved, if you still have the right copy | LiveAnalyses update when the data change; results can be frozen | Stronger: FrozenA saved analysis never changes, even after an update; earlier versions of the design and settings can be restored |
marks the stronger tool for that need.
In short
| Stronger in a spreadsheet | Your own calculations |
|---|---|
| Stronger in Prism | Statistics and figures |
| Stronger in Clarida | Plate layout · Mix volumes · At the bench · Your original data · Efficiency and its error · Reference genes · Sharing the data · One method for the whole lab · A year later |
| A draw | Goal, background and papers · Who changed what |
How do you check it against your template?
- Import the Cq table your template already uses. Excel, CSV and text come in, and you map the columns before anything is saved.
- Match your template first. With one reference gene and every efficiency at 100%, Clarida should give your template’s ΔΔCq.
- Then switch on what it skipped. Your measured efficiencies and a second reference gene, and see how far the result moves.
Can you keep your spreadsheet?
| Attach your lab’s workbook | Your own Excel notebook: samples, assays and Cq are read from it, and the experiment is written back into it |
|---|---|
| Paste the lists you keep | Sample and assay lists go into Design; an extra column, such as treatment, becomes a property to group by |
| Keep Prism for figures | From the normalized results in the Excel export |
| Keep planning in Excel | The free Excel workbooks hold plate layout and master mix templates |
| What the export shows | Each step in its own section with every intermediate value, and the settings it started from |
Frequently asked questions
Isn’t ΔΔCq good enough?
For one reference gene and every efficiency at exactly 100%, yes: ΔΔCq is a special case of what Clarida computes, and the two agree. When efficiencies differ or you use several reference genes, they don’t. That is why MIQE 2.0 recommends against relying on ΔΔCq.
Is there a free qPCR Excel template?
Yes. The free Excel workbooks hold plate layout and master mix templates, with no account. For the analysis itself, Clarida imports the Cq table you already have.
Does Clarida make a lab compliant with 21 CFR Part 11?
No, not on its own, and neither does a spreadsheet: Excel, Prism and Clarida alike need validating, together with the way your lab uses them. Excel and Sheets keep cell edits; Clarida stores each setting change, each automatic exclusion and each accepted QC deviation with who and when, keeps imported data unchanged and freezes saved analyses.
Is it free?
Yes, to start. Clarida’s free plan: 4 experiments in your first month, then 2 a month. No card. The Excel workbooks cost nothing either. For comparison, GraphPad lists Prism Personal Standard at $265 a year, with no free plan.
Sources
Each source with the day we last checked it. Something out of date? Tell us.
- Bustin et al. (2025), MIQE 2.0, Clinical Chemistry 71:634Against relying on ΔΔCq; efficiency-corrected quantities; Excel among the formats to share data inChecked October 26, 2026
- Vandesompele et al. (2002), normalization with multiple reference genes, Genome Biology 3:research0034One reference gene: errors of up to 3.0-fold in 25% of the cases studiedChecked October 26, 2026
- Chapman and Waldenström (2015), reference genes in published qPCR studies, PLoS One 10:e01418531.2 reference genes on average; 15% of studies tested their stabilityChecked October 26, 2026
- Abeysooriya et al. (2021), gene name errors in spreadsheets, PLoS Computational Biology 17:e1008984Gene names turned into dates in 30.9% of papers with Excel gene listsChecked October 26, 2026
- Microsoft, automatic data conversions in ExcelMicrosoft 365 and the 2024 edition can switch date conversion off; some text may still become a dateChecked October 29, 2026
- Microsoft, Show Changes in ExcelWho changed which cell, over the past 365 daysChecked October 26, 2026
- Microsoft, help with Show ChangesFormatting is left out; copying or uploading the file can empty the recordChecked October 26, 2026
- Google, find what’s changed in a fileChanges made by formulas are left out; restoring a version clears the historyChecked November 10, 2026
- Microsoft, protect a worksheetWorksheet protection is not a security featureChecked October 26, 2026
- Google, protected ranges in SheetsProtected ranges are not a security measureChecked October 26, 2026
- GraphPad, Prism and 21 CFR Part 11Prism does not keep an audit trailChecked October 26, 2026
- GraphPad, qPCR in a multiple variables tableOne reference gene, fold change as 2^−ΔΔCtChecked October 26, 2026
- GraphPad, how analyses stay linked in PrismAnalyses update when the data change; results can be frozenChecked October 26, 2026
- GraphPad, Info sheets in PrismExperimental details, constants and notes kept in the project fileChecked October 26, 2026
- Dotmatics, GraphPad Prism 10 and the .prism file formatThe .prism file stores raw data, analysis settings and results in an open formatChecked October 26, 2026
- GraphPad, how to buy PrismPublic prices: Personal Standard $265 a year; no free planChecked November 10, 2026
- Hellemans et al. (2007), qBase, Genome Biology 8:R19qBase began as an Excel-based tool, with several reference genes and error propagationChecked October 26, 2026
- Bio-Rad, CFX Maestro user guide, version 2.3A plate template exported to Excel, filled in and read back (p. 137)Checked October 26, 2026
- Thermo Fisher, QuantStudio Design and Analysis 2 user guideA plate setup imported from a text or CSV fileChecked October 26, 2026
- Gallup and Ackermann (2006), an Excel tool for qPCR set-up, Biological Procedures Online 8:87A published Excel tool for qPCR set-up, master mixes and dilutions includedChecked October 26, 2026