Skip to main content

locacsv.comGroup CSV Rows and Calculate Totals

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.

How to useSpecifications & limits

CSV processing stays in your browser

Your files are not uploaded to a server.

File selection

Choose 1 CSV file up to 50 MiB. Its name and contents are never sent outside your browser.

Drag and drop a CSV file here

1 CSV file, up to 50 MiB

How it works

Calculate sales totals for each store

Group rows with the same store and calculate the sum of the Amount column.

Input example

2 columns · 2 rows
Input example
StoreAmount
New York1200
New York640

Output example

2 columns · 1 row
Output example
StoreAmount_合計
New York1840
The left table shows the input, and the right table shows the output.

Equivalent to GROUP BY. The number of groups in the aggregated result is also shown.