# Your plate map, mixes and analysis, kept in step

> When Excel, Google Sheets and Prism are enough for qPCR, from plate map to ΔΔCq, and where Clarida links the steps. Each fact dated and linked.

Source: https://clarida.bio/compare/spreadsheets
Updated: 2026-11-10

[Compared with spreadsheets](https://clarida.bio/compare)

Keep your formulas and your Prism figures. Clarida works the mixes out from the plate and carries efficiency and several reference genes into the result.

[Start free](https://app.clarida.bio/login) · [Side by side](https://clarida.bio/compare/spreadsheets#side-by-side)

4 [experiments](https://clarida.bio/pricing#whats-an-experiment) in your first month, then 2 a month. No card.

> **experiments**: The runs and analysis behind one scientific question. Counted once, when you create it. Re-analyzing, reporting and exporting are free, with no limit on samples, assays or runs. [How pricing counts experiments](https://clarida.bio/pricing#whats-an-experiment)

- **You keep**: Your own formulas, Prism for figures
- **You add**: Plate, mixes and analysis, linked

## When is your spreadsheet enough?

qBase, the method behind Clarida’s normalization, [began as an Excel tool](https://doi.org/10.1186/gb-2007-8-2-r19).

- **You trust your plate and mix template**: Instrument makers build on it: [CFX Maestro](https://www.bio-rad.com/webroot/web/pdf/lsr/literature/10000126764.pdf) reads a plate template back from Excel, [QuantStudio](https://documents.thermofisher.com/TFS-Assets/LSG/manuals/MAN0018200_QuantStDesgnAnalysisSW_v2_Desktop_UG.pdf) 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](https://doi.org/10.1093/clinchem/hvaf043) 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](https://www.graphpad.com/guides/prism/latest/user-guide/creating_an_info_sheet.htm) 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](https://doi.org/10.1093/clinchem/hvaf043) 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](https://doi.org/10.1186/gb-2002-3-7-research0034)). Published studies use 1.2 on average, and 15% tested their stability ([Chapman 2015](https://doi.org/10.1371/journal.pone.0141853)).
- **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](https://doi.org/10.1371/journal.pcbi.1008984)); Microsoft 365 and the 2024 edition of Excel can [switch that off](https://support.microsoft.com/en-us/excel/set-automatic-data-conversions), 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 papers | **A notes sheet** Wherever you write it: beside the data, or in another file | **Info sheets** [Experimental details and notes](https://www.graphpad.com/guides/prism/latest/user-guide/creating_an_info_sheet.htm), in the project file | **In the experiment** Goal, background and linked papers, carried into the notebook export |
| Design |  |  |  |
| Plate layout | **Templates** Plate maps drawn by hand; [CFX Maestro](https://www.bio-rad.com/webroot/web/pdf/lsr/literature/10000126764.pdf) and [QuantStudio](https://documents.thermofisher.com/TFS-Assets/LSG/manuals/MAN0018200_QuantStDesgnAnalysisSW_v2_Desktop_UG.pdf) read a plate setup from a spreadsheet file | **Not documented** Prism starts after the run | Stronger: **Generated** Laid 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 volumes | **Calculators** Mix calculators are common, some [published](https://doi.org/10.1251/bpo122); you keep the reaction count in step with the plate | **Not documented** Prism starts after the run | Stronger: **From the plate** A recipe per mix with its surplus, worked out again whenever the design changes, until the runs are ready |
| At the bench | **A printout** The plate map on paper; notes go wherever you put them | **Not documented** Prism starts after the run | Stronger: **Guided** What to collect, then the plate one stage at a time; a note on a well comes back beside its measurement |
| Import |  |  |  |
| Your original data | **Editable** Pasted over as easily as any other cell | **In the file** Kept in the project file | Stronger: **Kept** Imported Cq values are never overwritten, and the raw curves are kept |
| Analyze |  |  |  |
| Efficiency and its error | **By hand** Possible; a 2^−ΔΔCq template assumes 100% and carries no error | **Not documented** GraphPad’s [qPCR tutorial](https://www.graphpad.com/guides/how-to-analyze-data-using-prisms-multiple-variables-data-table) computes fold change as 2^−ΔΔCt, which assumes 100%; efficiency and its error are not mentioned | Stronger: **Built in** Per target, from your dilution series; the error is carried through to the normalized result |
| Reference genes | **By hand** As many columns as the template has | **One** In GraphPad’s tutorial | Stronger: **Several** Combined by geometric mean, or the global mean; geNorm and NormFinder show which are stable |
| Your own calculations | Stronger: **Any formula** Write whatever calculation you need | **Many** Transforms and calculated variables | **Set methods** The published methods and their settings; no free formulas |
| Statistics and figures | **Basic** A few tests; charts by hand | Stronger: **Extensive** Many tests, curve fitting, publication figures | **Common tests** t-tests, one-way ANOVA with post-hoc comparisons, rank-based methods and correlation; adjusted p-values |
| Report |  |  |  |
| Sharing the data | **The file itself** [MIQE 2.0](https://doi.org/10.1093/clinchem/hvaf043) names Excel among the formats to share data in | **Project file** The [.prism file](https://dotmatics.com/news/dotmatics-launches-graphpad-prism-10-with-a-more-open-file-format-plus-new-integration-capabilities) holds raw data, settings and results in an open format | Stronger: **Report, notebook, RDML** A 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 what | **Cell edits** Excel 365 and Sheets record them, but [not formatting](https://support.microsoft.com/en-us/office/get-help-with-show-changes-in-excel-a1493bf9-25c3-470a-b970-60eceb0136e5) or [changes made by formulas](https://support.google.com/docs/answer/190843), and copying the file can lose the record | **None** [No audit trail](https://www.graphpad.com/support/faq/has-prismandnbspbeen-validated-does-it-comply-with-the-fda-regulation-21-cfr-part-11/), says GraphPad | **Decisions stored** Setting changes, automatic exclusions and accepted QC deviations, with who and when |
| One method for the whole lab | **Per copy** Each copy of a template can drift; sheet protection is [not a security feature](https://support.microsoft.com/en-us/excel/protect-a-worksheet) | **Per file** One analysis per project file | Stronger: **Shared** A preset brings the lab’s settings set, which freezes once used; each experiment keeps its own copy; on a paid plan |
| A year later | **If you kept it** As the file was saved, if you still have the right copy | **Live** Analyses [update when the data change](https://www.graphpad.com/guides/prism/latest/user-guide/what_analyze_means_in_prism.htm); results can be frozen | Stronger: **Frozen** A 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](https://clarida.bio/qpcr/define#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](https://clarida.bio/qpcr/design#sample-prep); an extra column, such as treatment, becomes a property to group by
- **Keep Prism for figures**: From the normalized results in the [Excel export](https://clarida.bio/qpcr/report#export-eln)
- **Keep planning in Excel**: The free [Excel workbooks](https://clarida.bio/tools/lab-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](https://clarida.bio/tools/lab-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](https://www.graphpad.com/how-to-buy/), with no free plan.

## Sources

Each source with the day we last checked it. Something out of date? [Tell us](https://clarida.bio/talk-to-us?topic=help).

- [Bustin et al. (2025), MIQE 2.0, Clinical Chemistry 71:634](https://doi.org/10.1093/clinchem/hvaf043) Against relying on ΔΔCq; efficiency-corrected quantities; Excel among the formats to share data in Checked October 26, 2026
- [Vandesompele et al. (2002), normalization with multiple reference genes, Genome Biology 3:research0034](https://doi.org/10.1186/gb-2002-3-7-research0034) One reference gene: errors of up to 3.0-fold in 25% of the cases studied Checked October 26, 2026
- [Chapman and Waldenström (2015), reference genes in published qPCR studies, PLoS One 10:e0141853](https://doi.org/10.1371/journal.pone.0141853) 1.2 reference genes on average; 15% of studies tested their stability Checked October 26, 2026
- [Abeysooriya et al. (2021), gene name errors in spreadsheets, PLoS Computational Biology 17:e1008984](https://doi.org/10.1371/journal.pcbi.1008984) Gene names turned into dates in 30.9% of papers with Excel gene lists Checked October 26, 2026
- [Microsoft, automatic data conversions in Excel](https://support.microsoft.com/en-us/excel/set-automatic-data-conversions) Microsoft 365 and the 2024 edition can switch date conversion off; some text may still become a date Checked October 29, 2026
- [Microsoft, Show Changes in Excel](https://support.microsoft.com/en-us/excel/show-changes-that-were-made-in-a-workbook) Who changed which cell, over the past 365 days Checked October 26, 2026
- [Microsoft, help with Show Changes](https://support.microsoft.com/en-us/office/get-help-with-show-changes-in-excel-a1493bf9-25c3-470a-b970-60eceb0136e5) Formatting is left out; copying or uploading the file can empty the record Checked October 26, 2026
- [Google, find what’s changed in a file](https://support.google.com/docs/answer/190843) Changes made by formulas are left out; restoring a version clears the history Checked November 10, 2026
- [Microsoft, protect a worksheet](https://support.microsoft.com/en-us/excel/protect-a-worksheet) Worksheet protection is not a security feature Checked October 26, 2026
- [Google, protected ranges in Sheets](https://support.google.com/docs/answer/1218656) Protected ranges are not a security measure Checked October 26, 2026
- [GraphPad, Prism and 21 CFR Part 11](https://www.graphpad.com/support/faq/has-prismandnbspbeen-validated-does-it-comply-with-the-fda-regulation-21-cfr-part-11/) Prism does not keep an audit trail Checked October 26, 2026
- [GraphPad, qPCR in a multiple variables table](https://www.graphpad.com/guides/how-to-analyze-data-using-prisms-multiple-variables-data-table) One reference gene, fold change as 2^−ΔΔCt Checked October 26, 2026
- [GraphPad, how analyses stay linked in Prism](https://www.graphpad.com/guides/prism/latest/user-guide/what_analyze_means_in_prism.htm) Analyses update when the data change; results can be frozen Checked October 26, 2026
- [GraphPad, Info sheets in Prism](https://www.graphpad.com/guides/prism/latest/user-guide/creating_an_info_sheet.htm) Experimental details, constants and notes kept in the project file Checked October 26, 2026
- [Dotmatics, GraphPad Prism 10 and the .prism file format](https://dotmatics.com/news/dotmatics-launches-graphpad-prism-10-with-a-more-open-file-format-plus-new-integration-capabilities) The .prism file stores raw data, analysis settings and results in an open format Checked October 26, 2026
- [GraphPad, how to buy Prism](https://www.graphpad.com/how-to-buy/) Public prices: Personal Standard $265 a year; no free plan Checked November 10, 2026
- [Hellemans et al. (2007), qBase, Genome Biology 8:R19](https://doi.org/10.1186/gb-2007-8-2-r19) qBase began as an Excel-based tool, with several reference genes and error propagation Checked October 26, 2026
- [Bio-Rad, CFX Maestro user guide, version 2.3](https://www.bio-rad.com/webroot/web/pdf/lsr/literature/10000126764.pdf) A plate template exported to Excel, filled in and read back (p. 137) Checked October 26, 2026
- [Thermo Fisher, QuantStudio Design and Analysis 2 user guide](https://documents.thermofisher.com/TFS-Assets/LSG/manuals/MAN0018200_QuantStDesgnAnalysisSW_v2_Desktop_UG.pdf) A plate setup imported from a text or CSV file Checked October 26, 2026
- [Gallup and Ackermann (2006), an Excel tool for qPCR set-up, Biological Procedures Online 8:87](https://doi.org/10.1251/bpo122) A published Excel tool for qPCR set-up, master mixes and dilutions included Checked October 26, 2026

Checked November 10, 2026

## Bring last month’s spreadsheet.

Paste its sample list to lay out the next plate, or import its Cq table and see the result corrected for efficiency. The file itself stays untouched. 4 experiments in your first month, then 2 a month. No card.

[Start free](https://app.clarida.bio/login) · [Talk to a founder](https://clarida.bio/talk-to-us?topic=demo)
