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.

Result

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

Verification of calculation criteria: · Calculation·verification principles · Report errors