BYTETOOLS

CSV Pivot Table Generator

Build a pivot table from CSV online. Group by rows and columns, aggregate with sum, count, average, min, max or median, with totals and CSV or Markdown export.

Drop a .csv file here or click to browse

What is the CSV Pivot Table Generator?

The ByteTools CSV Pivot Table Generator does the one job people open a spreadsheet for: cross-tabulating a flat export.

  • Group by one row field and an optional column field
  • Seven aggregations including count distinct and median
  • Row totals, column totals and a grand total
  • Totals recomputed from raw values, not from the cells
  • Numeric-aware sorting of row and column labels
  • CSV and Markdown export — all computed in your browser

How to use the CSV Pivot Table Generator

  1. 1

    Paste your CSV, or drop a .csv file into the drop zone.

  2. 2

    Confirm the delimiter and whether the first row is a header.

  3. 3

    Choose the Rows field, optionally a Columns field, and the Values field.

  4. 4

    Pick the aggregation — sum, count, count distinct, average, min, max or median.

  5. 5

    Copy or download the crosstab as CSV or a Markdown table.

About the CSV Pivot Table Generator

The ByteTools CSV Pivot Table Generator does the one job people open a spreadsheet for: cross-tabulating a flat export. Paste your CSV, choose a field to group rows by, optionally a second field for the columns, then the field to aggregate and how — sum, count, count distinct, average, minimum, maximum or median.

The crosstab is built as you change the dropdowns, with empty intersections filled in, plus row totals, column totals and a grand total. Totals are recalculated from the underlying values rather than by adding up the cells, so an average-of-averages never sneaks into your report.

The finished table can be copied as CSV for a spreadsheet or as a Markdown table for a README, a ticket or a pull request description. Everything is computed in your browser, so sales figures, salary data or anything else confidential stays on your machine.

Frequently asked questions

How do I make a pivot table from a CSV?

Paste the CSV, choose the column to group rows by, pick the numeric column to summarise, and select an aggregation. The crosstab appears immediately with totals, ready to copy into a spreadsheet or a document.

What does count distinct do?

It counts how many different values appear in each group rather than how many rows. Use it to answer questions like 'how many unique customers ordered in each region' from a table with one row per order.

Why is a cell blank instead of zero?

Sum, count and count distinct fill empty intersections with 0 because that is the honest answer. Average, min, max and median leave them blank, because there is no meaningful average of no values.

Are the totals just the sum of the cells?

No. Each total is recalculated from all the underlying rows it covers, so an average total is the true overall average rather than the average of the cell averages — which would be wrong whenever the groups differ in size.

Can I pivot text columns?

Yes. Choose Count or Count distinct and any column works as the value field. The numeric aggregations ignore values that are not numbers, so a column mixing text and figures still produces a usable total.

Related tools