CSV pivot and aggregation
Group CSV records and calculate counts, sums, averages, minimums or maximums.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
Processed on your device
How to use this tool
- Select a grouping column and aggregation.
- For numeric operations, select a value column containing finite numbers.
- One output record is produced for each distinct group. Decimal sums retain precision; averages are rounded to 30 significant digits.
Things to know
- Processing happens on your device. Check the result before replacing your original data.
- Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
- Generated CSV text is limited to 25 MiB in total, including all split files.
You might also need
More in data & csvCSV and JSON converter
Convert CSV records to JSON and JSON records to quoted CSV.
CSV deduplicator
Remove duplicate CSV records using all columns or selected key columns.
CSV row filter
Keep CSV records matching text or numeric conditions in a selected column.
CSV sorter
Sort CSV records by a named column while retaining all row values.
CSV column organiser
Select, reorder and rename CSV columns.
CSV joiner
Join two CSV tables on a shared key using inner or left joins.
CSV merger
Combine two CSV tables, aligning columns by their headings.
CSV splitter
Split CSV data into smaller files while repeating the original headings.
CSV transpose
Swap the rows and columns of a CSV table, including its heading row.