Skip to main content

Spreadsheet flexibility, wired into your lab

The spreadsheet your results land in.

Scientists reach for a spreadsheet because it bends to any experiment: no schema, no rules, every value in plain sight and under your control. Data Tables keeps all of that, the familiar cells, formulas, and fill, and connects it to the rest of your project.

Here a row can point at a real sample, and gated statistics from a flow run land in a table automatically. From there the table becomes a chart panel in a figure, so the number you computed and the figure you publish always stay in sync.

Run the qPCR and ELISA math on the sheet itself

Three guided fits sit in the Analyze menu: qPCR ΔΔCt, an ELISA standard curve, and a dose-response IC50. ΔΔCt normalizes target Ct values to your housekeeping genes and a calibrator group, writing ΔCt, ΔΔCt, and fold-change columns. The two 4PL fits interpolate unknown concentrations and report the potency. An assay table draws its fitted curve over a scatter of the same data, so the fit and the points it came from are one picture.

Compare groups without leaving the grid

Analyze runs a named operation over the rows: summarize by group, reshape between wide and long, normalize to a reference, express a percent change against a baseline, correlate two columns with Pearson or Spearman, or compare groups with a t-test or ANOVA. Pick one, fill in which columns it should use, and press Run. Derived columns land beside your data and recompute when it changes, and anything that is not a column arrives as a card saved with the table.

Pull a whole workspace in as rows, and keep it current

Embed data pulls Samples, Inventory, Orders, Tasks, Locations, Genetics, or image analysis in as columns that refresh from their source, one row per item. Or point at one thing: a plate becomes a row per well, a sample set a row per member, and several analysis runs arrive with a Group column naming each row's source. Your own columns sit beside the pulled ones, and a record deleted upstream keeps its row with the values you last pulled, flagged so you can see the source has gone.

Chart it here, publish it in a figure

The Chart drawer under the grid takes four settings: chart type, the x axis, which columns are values, and what to group by. A rail beside it lists every figure already built from this table, each one a link. Export the preview as PNG, SVG, or TIFF at a printed width in mm and up to 600 DPI, or send it to a figure where the full styling controls live.

More in the Data tables workspace

Working in the grid

  • Three kinds of column

    Raw columns you type, derived columns an Analyze action recomputes, and linked columns that refresh from their source, with an amber dot when a refresh is waiting.

  • 36 spreadsheet functions

    SUM through STDEV, IF through IFERROR, LEFT through TEXT. Each one returns the same answer for everyone who opens the table, so a shared sheet stays reproducible.

  • Search, group by, and freeze

    Filter rows by anything in any column, open find and replace from the search field, fold rows into groups, and freeze the identifying columns while you scroll right.

  • Sorting and filtering stay a view

    They change what you see while what is stored holds still, and the footer says so.

  • Number formats everyone reads alike

    Plain, fixed decimals, percent, scientific, or a date style, applied to the display while sorting, charts, and exports keep reading the underlying value.

Getting data in

  • CSV, Excel, BIOM, and QIIME2

    Import CSV, TSV, XLSX, and XLS, plus BIOM files and QIIME2 visualizations with a column per taxon and the sample IDs down the left. Up to 512 columns a table.

  • Ten starter structures

    Dose-response, timecourse, qPCR results, standard curve, plate readings, cell counts, band quantification and more, seeded with the columns the job needs.

  • Results land here on their own

    Every image analysis run and every set of flow statistics you send onward becomes a table here, ready to summarize and chart.

Sharing and export

  • Live co-editing

    Two people work in the same shared grid with presence avatars in the toolbar. Past about 50,000 cells a table stays fully editable one person at a time.

  • Excel export keeps the formulas

    Export as Excel is lossless: formulas, number types, and formatting all survive. Export as CSV writes the values.

  • Status, comments, and sign-off

    Draft through Approved or Archived, with an Activity panel carrying the conversation and the approvals.

  • Private or shared, your call

    Choose at creation and change it later. Project members with view-only access can read and export any table.

Learn more: Data tables·Customize a chart·Send stats to a data table

Start your first data table

Bring your data into a grid that stays linked to your samples and figures. Free for you and one collaborator.