Skip to main content

locacsv.comGroup CSV Rows and Calculate Totals

Group rows and calculate totals

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

Import settings
Auto-detection covers only UTF-8 and Shift_JIS. For CSV files from mainland China, Korea, Taiwan, or Western Europe, select the matching encoding manually.

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_sum
New York1840
The left table shows the input, and the right table shows the output.

The number of groups in the summary is also shown.

Group and summarize CSV rows

Group by up to three columns and calculate counts, sums, averages, minimums, or maximums.

Features

  • Combine up to three grouping columns with up to ten calculations.
  • Check the input row count, number of groups, and output row count.

How it works

  1. Choose a CSV and review category and numeric columns.
  2. Set up to three grouping columns and the calculations you need.
  3. Run, review group and row counts, and download.

Before you start

  • Sums and averages can differ slightly because of decimal rounding. Double-check any total that must match exactly.
  • Blanks are ignored and averages use the numeric count. All-blank groups stay blank; invalid numbers stop processing.
View FAQs for this tool

Sort the summary or use Split by value to create a detail file for each group.

Related guide