What aggregations are supported?

Sum, count, average, minimum, and maximum. Sum, average, min, and max parse the value field as numbers and ignore non-numeric cells, while count tallies how many rows fall into each cell regardless of the value.

Does it handle quoted CSV fields?

Yes. The parser respects double-quoted fields, so values containing commas, newlines, or escaped double quotes are read correctly rather than being split on every comma.

What if a value cell is not a number?

For numeric aggregations, non-numeric and empty cells are skipped, so they do not distort sums or averages. With the count aggregation, every row in the cell is tallied regardless of its value.

Can I leave the column field empty?

Yes. Set the column field to (none) to produce a single-column summary grouped only by the row field — effectively a group-by with one aggregated value per row key.

No. Parsing and aggregation run entirely in your browser in JavaScript. The data never leaves your device, so it is safe for confidential spreadsheets.

CSV Pivot Table Builder

CSV Pivot Table Builder summarises tabular data the way a spreadsheet pivot table does, but instantly and in your browser. Paste CSV with a header row, choose which field forms the rows, which forms the columns, and which numeric field to aggregate — then pick how to aggregate it. The result is a cross-tabulated grid with totals, no spreadsheet software required.

How it works

First the CSV is parsed into records. The parser is quote-aware: it tracks whether it is inside a double-quoted field, so embedded commas and newlines stay part of their cell, and a doubled quote ("") becomes a literal quote.

Then the pivot is computed. Every record is placed into a cell identified by its row-key value and column-key value. Within each cell the chosen aggregation runs:

count — number of records in the cell.
sum — total of the value field, skipping non-numeric cells.
avg — sum divided by the number of numeric values.
min / max — smallest or largest numeric value.

Finally, row totals (across all columns) and column totals (down all rows) are added so you can read marginal subtotals at a glance.

Tips and example

Use the bundled sales sample: set the row field to region, the column field to product, the value field to amount, and the aggregation to sum to see revenue per region per product with totals. Switch the aggregation to count to see how many orders fell into each cell instead. Set the column field to (none) for a simple grouped summary. Everything recomputes the moment you change a selection.