CSV Pivot Table
Build CSV pivot tables locally by grouping rows, optional columns, and count, sum, average, min, max, distinct, first, or last values.
Paste CSV or choose a local CSV file to summarize repeated rows into a compact pivot table. Group by one row field, optionally split by one column field, and calculate counts, totals, averages, minimums, maximums, distinct counts, first values, or last values without sending table content anywhere.
Selecting a file replaces the pasted input. Files are read by this page on your device only.
Use an exact header name or 1-based column number. This field creates the pivot table rows.
Optional. Leave blank for a one-way summary with only row groups.
Required for every aggregation except count. Numeric aggregations skip blank and non-numeric values.
How to use
Choose the delimiter and confirm whether the first row contains column names. Pick a row field, optionally pick a column field, and choose the value field plus aggregation. Count does not require a value field; sum, average, minimum, and maximum use numeric values; distinct count, first, and last use the value text as written.
Column names must match the header exactly. If a file has repeated or blank headers, use 1-based column numbers such as 2 or 5. Blank row or column groups use the label you provide, and totals can be included or removed from the output.
This pivot table is designed for quick browser-local summaries of practical CSV exports. It supports one row field and one optional column field, treats spreadsheet formulas as plain text, and skips blank or non-numeric values for numeric aggregations. Very large files may be slow in a browser tab, and private data should only be opened on devices and pages you trust.
