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 browse from your device
Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.
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.
What is the difference between pivot and unpivot?
Pivot turns long data into a wide table, spreading one column’s values across the top and aggregating what falls into each cell. Unpivot does the reverse, collapsing many columns back into label and value pairs — which is the format most charting and database tools actually prefer.
Is my data private when pivoting CSV files?
The file is parsed and pivoted in your browser and its contents are not sent to the app server. As with any website, avoid opening highly sensitive files on a device or browser you do not trust.