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/he/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.