CSV Pivot Table

How to use

1. 1Paste the CSV into the input box, click Open CSV file to load a .csv or .tsv from your computer, or click Load sample to try the tool with example sales data.
2. 2Confirm whether the first row is a header and pick the input delimiter (Auto detects comma, tab, semicolon, and pipe).
3. 3Pick the Rows column (labels down the left), the Columns column (labels across the top), and the Values column to aggregate.
4. 4Choose the aggregation: Sum, Average, Count, Count distinct, Minimum, or Maximum. Adjust decimal places and the blank placeholder if needed.
5. 5Toggle Row totals, Column totals, and Grand total. Reorder rows or columns alphabetically or by total to push the biggest contributors to the top.
6. 6Switch the output format between CSV, Markdown, and HTML, then click Copy output or Download to save the pivot.

About this tool

CSV Pivot Table turns any long CSV into a wider summary table directly in your browser, the same way Excel and Google Sheets pivot tables do. Pick three columns from the input: a row column whose unique values become the row headers, a column column whose unique values spread across the top, and a value column to aggregate inside each cell. Then choose an aggregation: Sum adds the numeric values inside each bucket, Average takes their arithmetic mean, Count returns the number of matching rows, Count distinct returns the number of unique value-column entries, Minimum returns the smallest numeric value, and Maximum returns the largest. The CSV parser follows RFC 4180 (quoted fields, escaped double quotes, embedded newlines, CRLF or LF terminators) and the delimiter auto-detector scores comma, tab, semicolon, and pipe against the first thirty lines so files exported from US, European, and tab-separated sources all work without manual configuration. Optional row totals, column totals, and a grand total cell extend the summary the way a real spreadsheet pivot would. Row and column order can stay in input order, be sorted alphabetically (with locale-aware numeric ordering), or be sorted by the aggregated total so the biggest contributors float to the top. Numeric cells tolerate currency symbols, percent signs, and thousands separators, and decimal precision is configurable. Blank labels are grouped under a configurable placeholder so a stray empty cell does not split a row into two. Output can be copied or downloaded as CSV, TSV, a Markdown table for documentation and pull requests, or a plain HTML table for embedding in a page or email. Useful for analysts summarising sales by product and region, marketers rolling up campaign spend by channel and month, product teams counting events by feature and platform, ops teams tracking ticket volume by team and status, finance breaking transactions down by category and quarter, and anyone who would otherwise open the file in a spreadsheet just to build a quick pivot. The CSV stays entirely in your browser; nothing is uploaded.

Free to use. Works in your browser. No signup, no login.