Pivot Table Generator
Build a CSV pivot table with independent row and column fields. Count records or summarize decimal values with sum, average, minimum or maximum. Preview and export the grouped table locally.
Build a Pivot Table From CSV Sales
Pivot Table Generator: how to use it
- Paste or open a delimited table with a header row, choose its separator, and read the fields. The example selects region, quarter and amount for you.
- Choose row and column fields. Count records or select a numeric value field for sum, average, minimum or maximum.
- Build the pivot, check blank and missing intersections, and download the complete CSV.
Limits and notes
Uses up to 2,097,152 decoded UTF-16 code units, 128 source columns, 500 groups per axis and 20,000 output cells. Numeric values allow up to 80 integer digits and 18 fractional places. Averages round once at the chosen precision, from 0 to 18 places.
How your privacy works →Pivot Table Generator: common questions
How are blank numeric values handled?
Numeric aggregations skip empty or whitespace-only values and report their count. An intersection without numeric values stays empty. Count records includes every record and shows zero for an unoccupied intersection.
How are group labels compared?
Groups use exact text, including case, spaces and leading zeros. Row and column groups appear in the order their values first occur.
How does an average round when the result is halfway?
The fixed decimal result rounds halfway away from zero. For example, to two places, 2.345 becomes 2.35 and -1.005 becomes -1.01.