DataToolsLab
CSV Tools

CSV Pivot Table

Build a pivot table from CSV with row/column/value fields and aggregation.

Loading tool…

What is Pivot?

A spreadsheet-style pivot builder: distinct values of the row field become rows, column-field values become columns, and cells aggregate the value field.

How it works

The CSV parses with the shared parser, rows group by the row/column keys, and each cell aggregates with count/sum/avg/min/max.

  1. Enter your input. Type or paste your input into the field above — the tool responds instantly.
  2. Review the result. Output updates live as you type. Everything runs entirely in your browser.
  3. Copy or download. Use the Copy button to grab the result, or Download to save it as a file.

Examples

Sales rollup

Pivot a sales log into a matrix of product × month with sums, averages, or counts — the classic spreadsheet pivot in a paste-and-go tool.

Common mistakes

Ambiguous aggregations

Two different value columns can't share one aggregate. Pick the value column and function (sum, count, avg) explicitly.

Frequently asked questions

Which aggregations are supported?

Sum, count, average, min, and max, applied to the value column you choose.

Can the result be re-pivoted?

Yes — the output is plain CSV, so you can pivot it again with different dimensions.

Online