CSV GROUP · GROUP BY
Group CSV Rows and Calculate Totals
Group rows by store, department, or another field, then export counts, sums, averages, minimums, and maximums as a new CSV. All processing stays in your browser.
CSV processing stays in your browserYour files are not uploaded to a server.
Group and aggregate CSV rows
Group by up to three columns and calculate counts, sums, averages, minimums, or maximums.
How it works
- Choose a CSV and review category and numeric columns.
- Set up to three group columns and the aggregations.
- Run, review group and row counts, and download.
Before you start
- Sums and averages use JavaScript Number, not exact financial decimal arithmetic.
- Blanks are ignored and averages use the numeric count. All-blank groups stay blank; invalid numbers stop processing.
View FAQs for this tool