Pivot tables transform long-format data into a structured summary by rotating row values into column headers. They're one of the most useful data operations you can perform on a spreadsheet — and they work just as well on CSV files as they do in Excel.
What Is a Pivot Table?
Imagine you have a sales dataset with thousands of rows where each row is one transaction: Date, Region, Product, and Revenue. A pivot table lets you restructure this into a summary where regions are rows and months are columns, with revenue totals in each cell — turning raw data into an actionable report.
Long Format vs Wide Format
Understanding the difference between these two data structures is key to understanding pivoting:
| Format | Structure | Best For |
|---|---|---|
| Long format (tidy) | One observation per row, one variable per column | Data storage, analysis, and import/export |
| Wide format (pivoted) | Values spread across multiple columns | Reporting, dashboards, and human reading |
Most data systems output long format because it's easier to query and analyse. Pivot tables convert long format into wide format for presentation.
Key Pivot Table Concepts
- Row dimension — the column whose values become row labels (e.g. Product Category)
- Column dimension — the column whose unique values become column headers (e.g. Month)
- Value column — the numeric column you want to aggregate (e.g. Revenue, Units Sold)
- Aggregation function — how to combine values when multiple rows map to the same cell (Sum, Count, Average, Min, Max)
Step-by-Step: Pivoting a CSV File
- Upload your CSV or Excel file to the Pivot tool
- Select your Row field — which column's values should become row labels
- Select your Column field — which column's values should become the new column headers
- Select your Value field — which column contains the numbers to summarise
- Choose your aggregation: Sum (total), Count (how many), Average, Min, or Max
- Click Pivot — the restructured table appears instantly
- Download the pivoted table as CSV
If your value column contains text rather than numbers, use Count as the aggregation — it counts occurrences instead of summing them.
Common Use Cases
- Summarising monthly sales by product or region
- Counting customer interactions by category and month
- Comparing metrics across teams, departments, or locations
- Transforming survey response data into a cross-tabulation
- Converting long-format export data into a readable report
Excel pivot tables are powerful but require Excel to be installed and can lose their structure when exported to CSV. Browser-based pivoting gives you a static, portable CSV output that works everywhere.
Upload a CSV or Excel file and create a pivot table in your browser — no Excel needed, no data sent to any server.
Try the Pivot Tool Free