Pivot Table Tool
Upload CSV, pick rows/columns/values, and pivot — no spreadsheet needed.
Your data stays in this tab — nothing uploadedBuild a pivot table from CSV data in your browser
About this pivot table tool
Upload or paste a CSV file and the tool detects columns and data types automatically. Select a row field (the categories down the left side), an optional column field (the categories across the top), a value field (the numbers to aggregate), and an aggregation function (sum, count, average, min, max, or median). The pivot table builds instantly with grand totals for rows and columns.
This is the same analysis you would do with a PivotTable in Excel or the QUERY function in Google Sheets, but without opening a spreadsheet or uploading your data anywhere. It handles datasets with thousands of rows in your browser, and you can copy the result or download it as a CSV for further analysis. SQL equivalents using GROUP BY and CASE-based pivoting are included.
FAQ
How large a dataset can this handle?
The tool runs in your browser’s JavaScript engine, so it depends on your device’s memory. Datasets with tens of thousands of rows and dozens of columns work well on modern devices. For million-row files, a desktop application or database would be more appropriate.
What is the difference between sum and count?
Sum adds up the numeric values in the value field. Count counts how many rows exist for each combination of row and column values — it ignores the value field entirely. Use count when you want frequencies, sum when you want totals.
Can I pivot without a column field?
Yes. If you leave the column field empty, the pivot table shows one aggregated value per row category — essentially a GROUP BY with a single aggregate. This is useful for simple summaries like total sales by region.