CSV Group & Aggregate
Group rows and calculate sum, average, count, min, or max
CSV Group & Aggregate — what it does
Group rows by one column and summarise another with count, sum, average, minimum or maximum. It is the single most common spreadsheet task — the pivot most people build to answer sales by region or hours by project — reduced to picking two columns and an operation.
When this tool helps
- Totalling revenue by region, month or sales rep from a flat transaction export.
- Counting how many records fall into each category to see how a dataset is distributed.
- Finding the maximum value per group, such as the largest order placed by each customer.
How to use it
- Choose the CSV file.
- Select the column to group by.
- Select the value column and the operation.
- Process and download the summary.
Accuracy, limits, and good practice
- Group labels are matched exactly, so North and north become two separate groups — normalise the column first if it was typed by hand.
- Non-numeric cells are skipped by sum and average, which can quietly change the denominator; check the column statistics first.
- Count answers how many rows, not how many distinct values. For distinct counts, deduplicate on that column before grouping.
Frequently asked questions
Can I group by two columns?
Use the pivot table tool, which takes a row field and a column field, or merge the two into one key first.
Are blank group values included?
Yes, they form their own group, which is often a useful signal that some rows are missing a category.
Can I apply several operations at once?
Run the tool once per operation and combine the outputs, or use the column statistics tool for a fuller numeric profile.
Related tools on this site
- JSON Flattener — Convert nested JSON into flat key-value paths
- CSV Date Normalizer — Convert one CSV date column to a consistent format
- CSV to Markdown Table — Convert a CSV file into a Markdown table
Everything above runs inside this page. CSV Group & Aggregate needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 分組彙總能做什麼
依某一欄分組，再對另一欄計算筆數、加總、平均、最小或最大值。這是最常見的試算表工作——多數人建樞紐分析表就是為了回答「各地區業績」或「各專案工時」——在這裡簡化成選兩個欄位加一個運算。
什麼時候用得上
- 從交易明細匯出檔中，統計各地區、各月份或各業務的營收合計。
- 計算每個分類各有多少筆資料，看清資料的分布狀況。
- 找出每組的最大值，例如每位客戶最大的一筆訂單。
使用步驟
- 選擇 CSV 檔案。
- 選定分組欄位。
- 選定數值欄位與運算方式。
- 執行處理並下載彙總結果。
精確度、限制與實務建議
- 分組標籤採完全相符比對，North 與 north 會變成兩組；若該欄為手動輸入，建議先統一格式。
- 加總與平均會略過非數值儲存格，可能悄悄改變分母，建議先看一次欄位統計。
- 「計數」算的是列數而非不重複值。需要不重複計數時，請先對該欄去重再分組。
常見問題
可以用兩個欄位分組嗎？
請改用樞紐分析表工具（可同時指定列欄位與欄欄位），或先把兩欄合併成單一鍵值。
分組值為空白的列會被計入嗎？
會，它們會自成一組，這通常也是個有用訊號，代表有些資料沒有分類。
可以一次算多種運算嗎？
請每種運算各跑一次再合併輸出，或改用欄位統計工具取得較完整的數值輪廓。
本站相關工具
- JSON 扁平化 — 將巢狀 JSON 轉換成扁平鍵值路徑
- CSV 日期格式統一 — 將指定日期欄位轉換成一致格式
- CSV 轉 Markdown 表格 — 將 CSV 檔案轉成 Markdown 表格
以上步驟全部在這個頁面內完成，CSV 分組彙總 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。