Back to Free Tools
FREE TOOLS
CSV Numeric Pivot Table
Build a two-axis sum, mean, minimum or maximum matrix from selected CSV columns.
Pasted CSV, One UTF-8 CSV file
numeric-pivot.csv, numeric-pivot-report.json
Browser only
Runs locally in your browser. Your files, pasted content and generated output are not uploaded. Reset clears this tool’s working data.
This tool needs JavaScript. If it does not load, refresh the page and try again.
How to use this tool
- Enter CSV or select one UTF-8 file; the file takes precedence.
- Choose three distinct 1-based row category, column category and numeric columns, and one delimiter.
- Choose sum, mean, minimum or maximum. Mean precision is 0–12 decimal places; other modes ignore it.
- Select Build numeric pivot, then download both complete files.
Examples
North/A values 1.5 and 2.5 produce 4; an unobserved axis pair remains empty.
Limitations
- At most 1 MiB input, 10,000 data rows, 100 columns, 100,000 input cells, 100 values per axis, 5 MiB combined output and 30 seconds.
- Numeric fields allow an optional sign, 1–18 total digits and up to 6 fraction digits; no spaces or exponents. Means round half away from zero.
- CSV contains generated row/column IDs; exact labels and missing-versus-zero evidence are in JSON. No count-only mode, totals, charts or multiple measures.
Related tools
No items found.