When is this useful?
Think team × channel, product × store, or owner × status. It is a quick way to turn a long event list into a compact shape you can scan.
FREE WEB TOOL
Create a simple SUM or COUNT pivot table from row, column, and value fields.
A long CSV can hide patterns that become obvious in a cross-tab. Pick one row field, one column field, and one value field to build a small SUM or COUNT pivot without opening a spreadsheet.
Think team × channel, product × store, or owner × status. It is a quick way to turn a long event list into a compact shape you can scan.
SUM converts the value field to numbers and adds what can be parsed. COUNT ignores the value itself and counts rows in each row/column combination—even if the selected value cell is blank.
Rows and columns are not automatically sorted alphabetically. Keys stay in the order they first appeared in the source CSV. That can look different from a spreadsheet pivot, but it makes the transformation easier to trace back to the input.
Zero can mean there was no row for that combination, or that SUM saw values it could not use as numbers. If zero carries business meaning, sample the source rows before concluding that the actual amount was zero.
With COUNT, zero means the row/column combination did not occur. With SUM, zero can mean no matching rows, a genuine numeric zero, or values that could not be used as numbers. The display alone does not distinguish those cases.
One row field, one column field, one value field, SUM or COUNT. It does not try to reproduce every Excel pivot feature. The trade-off is a lighter tool for quick inspection.
The output is still CSV-shaped text, so you can use this as a quick reduction step before moving the smaller table into Excel, a charting tool, or a BI workflow.