CSV Pivot Table — Pivot & Unpivot Online
Create pivot tables from CSV data, or unpivot wide data back to long format
Build a pivot table from a CSV file without Excel or Google Sheets. Pick which column becomes the rows, which becomes the columns, and which values to aggregate — count, sum, average, min, or max — and get a summarized table instantly.
It also works in reverse: unpivot (melt) a wide table with one column per month, region, or category back into tidy long-format rows, ready for databases and analysis tools. Everything runs locally in your browser, so your data is never uploaded.
Drop your file here or click to upload
Supports CSV, TSV, TXT files up to 100MB
How to Use
- Upload your CSV file or paste CSV data
- Choose pivot or unpivot mode
- Select the row, column, and value fields (or the columns to unpivot)
- Preview the reshaped table and download it as CSV
Features
- Pivot long data to a wide summary table
- Aggregate with count, sum, average, min, or max
- Unpivot (melt) wide data back to long format
- Instant preview of the reshaped table
- Download the result as CSV
- Private by design — your file stays in your browser
Use Cases
- Summarize sales by region and month without a spreadsheet
- Count occurrences of category combinations in survey data
- Reshape exports into the layout a report template expects
- Convert a wide month-per-column sheet into tidy rows for a database import
Frequently Asked Questions
How do I create a pivot table from a CSV file without Excel?
Upload the CSV here, choose which column becomes the rows and which becomes the columns, pick a value column and an aggregation (count, sum, average, min, or max), and the pivot table is generated instantly in your browser.
What is the difference between pivot and transpose?
Transpose flips the whole table so rows become columns. Pivot summarizes data: it groups rows by one column, spreads another column across the top, and aggregates the values — like a spreadsheet pivot table. For a simple flip, use the CSV Transpose tool.
What does unpivot (melt) do?
Unpivot converts wide data to long format: columns you select are folded into two new columns — one holding the former column name, one holding the value. It is the inverse of a pivot and is ideal for preparing data for databases or analysis tools.
Which aggregations are supported?
Count, sum, average, min, and max. Non-numeric values are ignored by numeric aggregations, and empty cells are skipped.
Is CSV Pivot free to use?
Yes, completely free with no limits. No signup or download required.
Is my data private when pivoting CSV files?
Absolutely. All processing happens in your browser. Your data never leaves your device.