# Excel workbooks for qPCR plates and master mixes

> Excel workbooks for qPCR: 96- and 384-well plate layouts, a master mix calculator, an experiment template, and a restyle for your own. Free, no account.

Source: https://clarida.bio/tools/lab-workbooks
Updated: 2026-10-29

[Free tools](https://clarida.bio/tools)

Plate layouts, a master mix calculator and an experiment template to download, plus a tidy-up for a workbook of your own.

Free, no account

[Open the tool](https://app.clarida.bio/lab-workbooks)

- **You start with**: Nothing, or a workbook of your own
- **You end with**: A template, or your workbook restyled

Video: The Excel workbooks tool in the browser: the Download a workbook tab lists the starting templates (Styled blank, Quick start, qPCR experiment) and the interactive tools (Plate & mix tools, 96-well and 384-well plate tools). In the Enhance a workbook tab, the qPCR experiment template is loaded and its four sheets, Overview, Setup, Data and Analysis, appear as a tree. The Setup sheet is opened to its seven sections, each with its type; Assay info is dragged above Sample info; Setup notes is renamed Run notes; and in the settings the conversion mode goes from None to Full, complete styling. The tree now reads modified, with Restore to original and Download file below it. [Watch full size · 0:34](https://clarida.bio/videos/lab-workbooks-hero.mp4)

Figure: Download a ready-made workbook, or load one and give its sheets and sections the order, names and styling you want.

## What it saves you

- Plate layouts for 96 and 384 wells, and a master mix calculator, ready in Excel
- No macros to allow: every workbook is an `.xlsx` file
- Your own workbook reordered, renamed and restyled, with the original left as it was

## How it works

01 In the tool: Excel workbooks › Download a workbook

### Start from a template

Starting templates are laid out in Clarida’s sections and styling: Styled blank, Quick start, and qPCR experiment, with its sheets Overview, Setup, Data and Analysis. The interactive tools calculate as you type: the 96-well and 384-well plate tools take sample and assay names as a list and show them on the plate, and read a filled-in plate back as a list. A 384-well plate fills whole, quadrant by quadrant if you like.

02 In the tool: Excel workbooks › Download a workbook

### Master mix calculator for the whole plate

Enter the samples, assays and replicates, the volume of each component and a surplus. Mix tools gives the reactions and plates you need, the material per sample and assay, and pipetting instructions three ways: 3-step, 2-step with a sample mix, 2-step with an assay mix. It flags a pipetting volume below 2 µL or above 1000 µL, and assumes every sample is measured for every assay. Plate & mix tools holds both plate sizes and the calculator in one workbook.

03 In the tool: Excel workbooks › Enhance a workbook

### Tidy a workbook of your own

Upload an `.xlsx` workbook, or load a template, and its sheets and sections show as a tree. Drag them into a new order, rename them, change a section’s type, add new ones and delete the rest. Download file gives you a new workbook; the one you uploaded is not changed, and Restore to original undoes every change to the structure.

- **Styling:** none by default, minimal, or full
- **Added on every sheet:** an Overview, an Experiment info section, a Sheet info section, if you tick them

## What the workbooks don’t do

- **ΔΔCt analysis**: [Gene expression in Clarida](https://clarida.bio/qpcr/gene-expression), inside an experiment
- **Check a layout for missing controls**: The [Plate editor](https://clarida.bio/tools/plate-editor), in the browser
- **Put the plate tools into your own workbook**: Not here: they are download only; Plate & mix tools is the one that loads into Enhance

## Frequently asked questions

### Are the Excel workbooks free?

Yes, with no account: downloading a workbook and tidying your own are both free.

### Do the workbooks use macros?

No. Every workbook is an `.xlsx` file, which cannot hold macros; the interactive tools calculate with formulas.

### Is there a 96-well plate template you can print?

Yes. Download the 96-well plate tools, fill in your names, and print the plate from Excel.

### Which files can you upload?

Enhance takes an `.xlsx` workbook, and every template downloads as one.

### Why does the citation say Lab workbooks?

That is the tool’s name in the app; this site calls it Excel workbooks.

## Cite this tool

Interactive on the page: Format: APA, Vancouver, BibTeX; Copy.

Clarida. (2026). Lab workbooks (Version 2026.11.0) \[Web application\]. Retrieved November 18, 2026, from https://app.clarida.bio/lab-workbooks

Updated October 29, 2026

## Open your next plate in a workbook that is already laid out.

Download the plate tools, fill in your names, and the mix follows.

[Open the tool](https://app.clarida.bio/lab-workbooks) · [Talk to a founder](https://clarida.bio/talk-to-us?topic=help)
