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.
Jak používat nástroj 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.
Často kladené otázky
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.
Zdroje
Vložit tento nástroj
Přidejte tento nástroj na svůj web. Zkopírujte úryvek níže, automaticky zůstává aktuální.
<iframe src="https://monu.tools/embed/cs/pivot-csv" width="100%" height="640" style="border:1px solid #e5e5e5;border-radius:12px;max-width:680px" loading="lazy" title="Monu Tools"></iframe>Související nástroje
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
Převeďte CSV na soubor Excel .xlsx a Excel zpět na CSV, zcela ve vašem prohlížeči. Funguje v obou směrech.
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.