Pivot

Paste or load CSV/TSV, choose row/optional column grouping and an aggregate, then calculate. Input headers update the selectors immediately, including after a file load. The first appearance determines group order. CSV quotes and decimal commas are supported; choose a separator explicitly for ambiguous data.

Count rows counts every matching record and needs no value column. Count filled values counts nonblank values, including text; whitespace-only values are blank. Sum/mean/min/max skip blank values but reject invalid numbers. A group with no numeric values or no matching records is shown as a dash, not zero.

Row, column and grand totals apply the selected aggregate to original records. Means are weighted by their original nonblank value count, not means of displayed means. Compensated Binary64 summation reduces cancellation; overflow is rejected. This is not exact decimal financial arithmetic.

Download CSV preserves full numeric values, empty results and original group keys; the table uses localised formatting. Everything stays local, with no saved data. Input changes clear old output. Limits: 10000 records, 200 row groups, 50 column groups, 10000 result cells, 2000000 input characters; files up to 2 MB.

The display uses up to 12 significant digits; the hover text and CSV retain full numeric values.