Create a CSV Pivot Table

Choose one column for rows, one for columns, and one for the values to aggregate: instantly get a pivot table from your CSV.

Example:
Drag and drop a .csv here, or paste its content below. 25 MB max.

How it works

A pivot table summarizes a large data table by crossing two dimensions: for example, products in rows and months in columns, with the sum of sales at the intersection of each cell. Specify the column to use for rows, the one to use for columns, the value column to aggregate, and the desired aggregation function: the pivot table is generated automatically and downloadable as CSV.

What does a cell with no corresponding data contain?

If no row in the original CSV matches a given row/column combination, the corresponding cell remains empty in the pivot table, except for the “count” function, which would display 0 in that case (a cell with no data simply does not appear in the calculation).

How are the rows and columns of the result ordered?

The unique values found in the rows column and in the columns column are sorted in ascending alphabetical/numerical order in the generated table.

100% local processing: the pivot table is generated entirely in your browser; your CSV file is never sent to a server.