Pivot Table
Groups rows by one or two columns and aggregates with count, sum, average, min, max or distinct.
Group rows by one column, optionally spread a second across the top, and aggregate a third. It is the pivot table without the spreadsheet, on a file that would take a minute to open in one.
Drop a CSV or TSV
Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.
How to use it
Choose the row grouping
The column whose distinct values become the rows of the summary: region, month, salesperson.
Optionally spread a second column across
Region down and month across gives the cross-tab. Leave it as None for a plain grouped total.
Pick the measure and how to aggregate it
Sum and average need a numeric column; count works on anything. The measure defaults to the first numeric column, because pivoting a text column by sum gives a grid of blanks and reads as a broken tool.
Common questions
Are non-numeric cells counted as zero?
No, they are skipped. A column with three blanks and two values has an average over the two, not over five. Counting blanks as zero would quietly halve every average in a file with gaps.
Why are there so many columns?
The column you spread across has that many distinct values. Spreading on a date rather than on a month gives one column per day. Group the dates first, or spread on something coarser.
Can I have two measures at once?
Not in one pass. Run it twice and join the results on the group column, or use the SQL tool where a single SELECT can carry a COUNT and a SUM side by side.
Feed it from
Quick Chart
Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Report Sheet Tidier
Unmerges cells, fills the gaps left behind, drops decoration rows and turns a report into a flat table.
Timezone Converter
Converts a moment across timezones and shows a shared-hours grid for scheduling across regions.
Next
These accept what this tool produces, so the result can go straight in.
Quick Chart
Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.
SQL over CSV
Runs SQL against dropped CSV or TSV files in the browser — SELECT, WHERE, GROUP BY/HAVING, ORDER BY, LIMIT, CASE and a two-table JOIN — with the grammar on the page.
Column Statistics
Profiles each column with count, nulls, unique values, min, max, mean, median and distribution.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.