Build pivot tables from CSV online: group by columns, aggregate with sum, count, average, min, and max.
Free for files up to 5 MB and 10,000 rows. Files are processed in your
browser — nothing is uploaded to a server. No account required.
About Pivot Table
Group rows by one column and aggregate another. Count, sum, average, min and max are available, and the output is a two-column summary sorted from the largest value down.
A Shopify order export answers "revenue by country" this way: group by shipping_country, take the sum of total_price. A support ticket export answers "tickets per agent" with a count. Groups are computed from the whole file, not only the rows currently on screen.
Pick the group-by column, the value column and the aggregation. If the group-by column holds more than 5,000 distinct values the tool says so instead of drawing a summary as long as the original file, which usually means an ID column got selected by mistake.
Related tools
CSV Viewer — Free online CSV viewer to open, search, sort, and paginate large CSV files instantly in your browser — no upload required.
CSV Editor — Free online CSV editor to edit cells, add or delete rows and columns, with undo/redo and instant export back to CSV.
CSV Validator — Validate CSV files online — find missing values, cells that break their column's type, duplicate headers, and mojibake left by a bad export.
CSV Cleaner — Clean messy CSV files online: trim whitespace from every cell, drop rows that are entirely empty, and tidy header names — in one pass, in your browser.
CSV Deduplicator — Find and remove duplicate rows in CSV files online — match across selected columns and export a clean, unique dataset.
CSV Sorter — Sort CSV files online by one or multiple columns, ascending or descending, with stable multi-key ordering and instant export.