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.