Skip to main content

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

  1. Choose a CSV and review category and numeric columns.
  2. Set up to three group columns and the aggregations.
  3. 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.