CSV Pivot / Group-By - Summaries Without a Spreadsheet
Total sales per city, signups per month, average score per class: the questions are always group-by questions. Paste the raw rows, get the summary.
How to use the CSV Pivot / Group-By
- Paste your CSV with a header row.
- Name the column to group by and the numeric value column.
- Pick the aggregation: sum, count, average, min or max.
- Read the summary table, or download it as CSV.
How it works
Grouping is exact-text: 'Lahore' and 'lahore' are different groups, so clean casing first (our CSV Dedupe & Cleaner trims stray spaces). Non-numeric values in the value column are skipped for sum/average/min/max rather than poisoning the result, and Count always counts rows. Sums and averages are rounded to 2 decimal places to hide floating-point noise like 0.30000000000000004.
Frequently Asked Questions
Is this tool free?
Yes - completely free, no sign-up.
Is this a full pivot table?
It is the group-by core of one: one grouping column and one aggregation. Cross-tab pivots with row and column dimensions belong in a spreadsheet.
What happens to non-numeric values?
They are skipped for numeric aggregations. Count rows still counts them.
Is my data uploaded?
No. Aggregation runs in your browser.
Related Developer Tools
CSV to JSON Converter
Convert CSV to a JSON array of objects - a real parser that handles quoted commas and escaped quotes.
CSV Viewer & Editor
Load CSV into an editable table grid - edit cells, sort columns, add rows and download.
CSV Dedupe & Cleaner
Remove duplicate CSV rows by whole row or key columns, with before/after counts.