Data & CSV

CSV crosstab

Cross-tabulate categories with counts, sums or averages.

CSV crosstab
Esc to restore

Your inputs

First row contains unique column headings. Files stay on this device; maximum 25 MB.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Groups exact text values from your chosen columns. Count includes every row. Sum and mean ignore blank numeric cells and reject other non-numeric values. Missing groups show zero for counts/sums and blank for means. Limits keep processing practical in your browser.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data
Category,Department,Amount
Design,Studio,120
Writing,Studio,80
Design,Marketing,150
Writing,Marketing,100
Design,Studio,60
Column separator
Comma
Rows
Category
Columns
Department
Summarise by
Count rows
Value column (sum or mean)
Amount

Example result

Example result
Category / DepartmentStudioMarketing
Design21
Writing11

All rows counted. CSV downloads protect potentially active spreadsheet cells.

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile