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.
How to use the 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.
Frequently asked questions
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.
Sources
Learn more
What Is a Pivot Table? Rows, Columns, Values, and Aggregation Explained
A pivot table turns a flat list of records into a cross-tab summary. Learn rows, columns, values, and aggregations with a worked CSV example.
Stop Excel Silently Changing Your CSV Data (Zeros, Dates, Big Numbers)
Excel quietly rewrites CSV data on open: dropped leading zeros, gene names turned into dates, IDs in scientific notation. Why it happens and how to stop it.
Comma, Semicolon, or Tab: Why Excel Writes CSV Files That Other Tools Reject
Why Excel exports semicolon CSVs in half of Europe, how the decimal comma causes it, and how to convert or import any delimiter cleanly.
ü Instead of ü: Fixing Broken Special Characters in CSV Files
Why ü, é, and € turn into ü, é, and € when Excel opens a CSV, what the UTF-8 byte order mark does, and how to save and repair files correctly.
Query a CSV with SQL, No Database Setup Required
Load a CSV as a SQL table in your browser and answer real questions with WHERE, ORDER BY, GROUP BY, and HAVING. A worked mini-tutorial on one dataset.
CSV Quoting Rules: Why Splitting on Commas Breaks Your Data
What RFC 4180 actually requires: when a CSV field must be quoted, how to escape a double quote, and why naive split-on-comma parsers corrupt rows.