CSV pivot summary
Group CSV rows and columns into a cross-tab of numeric sums or record counts.
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Instructions and example
Sum adds numeric values for the same row-column key; count counts matching records. Group labels preserve case and spaces.
East has Pen 10 and Book 20, totaling 30. West has Pen 5 and Book 0, totaling 5. The grand total is 35.
Missing combinations show 0. Sums use IEEE 754 approximations; large integers and decimals may round. Blank/nonnumeric values are rejected. The body allows 10,000 cells, excluding headers and totals.
Frequently asked questions
What happens when multiple records share a group?
Sum adds numeric values for the same row-column key; count counts matching records. Group labels preserve case and spaces.
How are blank amounts and absent group combinations handled?
Missing combinations show 0. Sums use IEEE 754 approximations; large integers and decimals may round. Blank/nonnumeric values are rejected. The body allows 10,000 cells, excluding headers and totals.
Calculation criteria and reference materials
- RFC 4180 — CSV Format
Missing combinations show 0. Sums use IEEE 754 approximations; large integers and decimals may round. Blank/nonnumeric values are rejected. The body allows 10,000 cells, excluding headers and totals.
Verification of calculation criteria: · Calculation·verification principles · Report errors