Pivot CSV Online
Build a pivot table from CSV in your browser: group by a field, spread another across columns and aggregate. Nothing is uploaded.
如何使用 Pivot CSV
- 01
Paste your CSV into the left panel.
- 02
Choose the row field, an optional column field, the value field and the aggregation.
- 03
Copy the pivoted CSV from the right panel.
What it does
This tool turns a flat CSV into a pivot table. Pick a field for the rows, optionally a second field to spread across the columns, then choose which value to aggregate and how.
It is the fastest way to answer questions like sales per region per product without opening a spreadsheet, and the result is plain CSV you can copy straight out.
Rows, columns and aggregation
The row field lists each distinct value down the left. Add a column field to cross-tabulate: every distinct value becomes its own column. The chosen aggregation fills each cell.
Count tallies matching rows; sum, average, min and max operate on the numeric value field; first keeps the first value it sees. Averages are trimmed so you do not get long floating-point tails.
Private and unlimited
Every conversion happens locally in your browser, so your data is never uploaded, logged or stored on a server. You can use it on confidential exports without a second thought, and it keeps working offline once the page has loaded.
There is no sign-up, no watermark and no row limit: the only ceiling is your device's memory.
常見問題
What aggregations are supported?
Count, sum, average, minimum, maximum and first. Count works on any column; the numeric aggregations parse the value field and ignore cells that are not numbers.
Can I pivot without a column field?
Yes. Leave the column field empty and you get one aggregated value per group, which is a simple group-by summary.
Is there a row or file-size limit?
There is no fixed row cap or daily quota. Because everything runs locally the practical limit is your device's memory, which comfortably handles the tens of thousands of rows most exports contain.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser with client-side JavaScript, so nothing you paste or drop ever leaves your device. That makes it safe for spreadsheets that contain customer emails, financial figures or other sensitive data.
來源
嵌入此工具
將此工具加入你自己的網站。複製下方的程式碼片段,它會自動保持最新。
<iframe src="https://monu.tools/embed/zh-Hant/pivot-csv" width="100%" height="640" style="border:1px solid #e5e5e5;border-radius:12px;max-width:680px" loading="lazy" title="Monu Tools"></iframe>相關工具
CSV Editor
Edit CSV in a spreadsheet-style grid in your browser: add or remove rows and columns, rename headers, then export clean CSV. Nothing is uploaded.
Change delimiter
Change a file's delimiter: read CSV with one separator and write it with another, such as comma to tab (TSV) or pipe. Runs in your browser.
CSV / Excel
在瀏覽器中將 CSV 轉換為 Excel .xlsx 檔案,或將 Excel 轉換回 CSV,支援雙向轉換。
Query CSV (SQL)
Run SQL SELECT queries against a CSV in your browser: it loads into a table you can filter, group and join. Nothing is uploaded.