CSV Pivot Table

rows × columns matrix · sum / count / avg / min / max · optional totals

Reshape a long CSV into a cross-tab: one row per value of the row field, one column per value of the column field, aggregated cells in between. Sales by region and quarter, signups by plan and month, errors by service and status code — the shape you'd build in Excel with a pivot table, produced as plain CSV you can pipe onward.

pivot rows columns values aggregate row & column totals

Or drop a .csv file here, or

ready

How to pivot a CSV

Paste the CSV or drop a file. The tool guesses sensible defaults: first column for rows, second for columns, and the first fully numeric column for values.
Set rows to the field you want down the side and columns to the field you want across the top.
Pick the values field and how to aggregate it. Use count when you're counting rows rather than summing a measure.
Tick totals if you want a TOTAL row and column, then copy or download.

Choosing the column field carefully

The column field becomes one output column per distinct value, so pick something with a small, bounded set: month, region, plan, status. Pointing it at a high-cardinality field like order_id or a raw timestamp produces thousands of columns and an unreadable file. If that's what you have, trim the value to a coarser grain first with Split column, or use Group & aggregate, which stays long and tidy no matter how many groups there are.

Empty cells mean "no rows"

A blank cell is not zero — it means no source row matched that row/column combination. That distinction matters when you're reading a pivot as a coverage check: blanks show you the gaps. If you need zeros for a downstream tool, run Fill blanks over the result with a constant of 0.

FAQ

How do I unpivot — turn a wide table back into long?

Use Unpivot / melt. It's the exact inverse: keep the ID columns, and collapse the rest into name/value pairs.

Can I pivot on two row fields at once?

Not here — one row field, one column field. For compound keys use Group & aggregate, which accepts any number of grouping columns.

Why is my sum empty?

The values column probably isn't numeric — currency symbols, percent signs, or spaces stop it parsing. Clean it with Find & replace first, or switch the aggregation to count.

Is anything uploaded?

No. The pivot is computed in your browser.

Privacy

100% client-side. No upload. See the privacy policy.