Build a pivot table from any CSV: choose a row field, a column field, a value field and sum, count, average, min or max.. Pivot Table Builder is a free online tool from the ToolsRift Charts & Data Tools collection. It runs entirely in your browser — nothing to install, no signup, and your data never leaves your device.
Loading Pivot Table Builder…
How to use Pivot Table Builder
Load your CSV, choose the row field, an optional column field, the value field and an aggregation, then read the cross-tab and copy or download it as CSV.
Frequently asked questions
How is this different from a spreadsheet pivot table?
It does the same cross-tabulation but with no setup, no file upload and no risk of the spreadsheet reformatting your data. Pick the fields from dropdowns and the table appears instantly, complete with row totals, column totals and a grand total.
Which aggregations are available?
Sum, count, average, minimum and maximum. Count works on any column including text, while the numeric aggregations skip cells that are not numbers so a few stray labels will not break the result or produce NaN.
Can I use only a row field with no column field?
Yes. Leave the column field set to none and you get a simple grouped summary — one line per distinct row value with its aggregate — which is often exactly the group-by report you were after.
ToolsRift processes your files in your browser. We use cookies only for basic analytics and to support ads that keep every tool free. See our Cookie Policy.