Pivot CSV for Reporting

Create a cross-tabulation of CSV data with aggregated metrics.

Intermediate~3 mincsvtransformanalytics

Use case

Use this to reshape flat CSV data into summary reports with rows, columns, and calculated aggregates.

Workflow overview1 steps0 / 1 completed~3 min

Follow the steps from left to right for a quick overview, then use the inline stepper below to run each tool.

Create a cross-tabulation of CSV data with aggregated metrics.

Current focusStep 1 · CSV Pivot

0% complete

Step 1csv-tools Waiting

CSV → CSV

Create pivot table

Cross-tabulated CSV with aggregated values.

Run this workflow inline

Work through each tool step here. Running a step automatically prepares the next step with the correct handoff value.

Workflow shortcut

Next unlocked step: Step 1 · CSV Pivot

Progress is stored locally in this browser.

Step 1Ready to runcsv-tools

Create a cross-tabulation (pivot table) from flat CSV data. Specify row key, column key, aggregation field, and function (count, sum, mean).

Provide { "csv": "...", "rowKey": "field", "colKey": "field", "value": "field", "agg": "count|sum|mean" }.

Cross-tabulated CSV with aggregated values.

Run this step to process the current input and prepare the next workflow stage.