CSV Pivot Table
Summarize CSV data by row, column, and aggregation fields
CSV Pivot Table — what it does
Build a cross-tabulation from a flat CSV: choose a row field, a column field, a value field and an aggregation, and the tool produces the matrix that summarises them. It is the spreadsheet pivot most reports are built on — sales by product and month, hours by person and project — without opening a spreadsheet application.
When this tool helps
- Turning a transaction log into a product-by-month revenue grid for a management report.
- Cross-tabulating survey responses by segment to see how answers differ between groups.
- Summarising hours by employee and project code straight from a timesheet export.
How to use it
- Choose the CSV file.
- Select the row field and the column field.
- Select the value field and the aggregation.
- Process and download the pivot result.
Accuracy, limits, and good practice
- Pick a column field with few distinct values. A field with hundreds of values produces a table too wide to read or print.
- Count works on any field, but sum and average need numeric values — check the column first if totals look wrong.
- Empty cells mean no rows matched that combination, which is itself informative: a gap in coverage, not a zero.
Frequently asked questions
How is this different from group and aggregate?
Grouping summarises along one dimension. A pivot summarises along two at once, giving a grid rather than a list.
Can I add more than one value field?
One at a time. Run the tool per measure and place the results side by side in a spreadsheet if you need several.
Can I open the result in Excel?
Yes. Download the CSV and open it, or run it through the CSV to Excel tool for a formatted XLSX workbook.
Related tools on this site
- Excel Duplicate Remover — Remove duplicate spreadsheet rows using one or more selected columns
- HTML Table to Excel — Extract an HTML table and export it as a standard XLSX workbook
- CSV Column Reorder — Change CSV column order before downloading
Everything above runs inside this page. CSV Pivot Table needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 樞紐分析表能做什麼
把平面 CSV 做成交叉分析表：選定列欄位、欄欄位、數值欄位與彙總方式，工具就會產生對應的矩陣。多數報表底層用的正是這種樞紐分析——各產品各月份的業績、各成員各專案的工時——而且不必開試算表軟體。
什麼時候用得上
- 把交易紀錄整理成「產品 × 月份」的營收表格，供管理報告使用。
- 依分群交叉分析問卷結果，看不同族群的答案差異。
- 直接從工時匯出檔彙總「員工 × 專案代碼」的時數。
使用步驟
- 選擇 CSV 檔案。
- 選定列欄位與欄欄位。
- 選定數值欄位與彙總方式。
- 執行處理並下載樞紐結果。
精確度、限制與實務建議
- 欄欄位請挑不重複值較少的欄位，若有上百個值，表格會寬到既難讀也無法列印。
- 計數適用於任何欄位，但加總與平均需要數值；總計看起來不對時請先檢查該欄。
- 空格代表沒有任何列符合該組合，這本身就是資訊：那是缺口，而不是零。
常見問題
跟分組彙總差在哪？
分組只沿單一維度彙總；樞紐同時沿兩個維度彙總，輸出是矩陣而非清單。
可以放多個數值欄位嗎？
一次一個。需要多個指標時請分次執行，再於試算表中並排放置。
結果可以用 Excel 開嗎？
可以，下載 CSV 直接開啟即可；也可再用 CSV 轉 Excel 工具產生排版好的 XLSX。
本站相關工具
- Excel 重複資料清理 — 按照一個或多個欄位移除重複的試算表資料列
- HTML 表格轉 Excel — 提取 HTML 表格並匯出為標準 XLSX 活頁簿
- CSV 欄位重新排序 — 調整 CSV 欄位順序後下載
以上步驟全部在這個頁面內完成，CSV 樞紐分析表 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。