How to use
- Open data.
- Choose row fields, an optional column field, a value field and an aggregation.
- Export the pivot or send it to the chart maker.
Worked example
Region and Revenue rows North 10, North 20, South 30, plus a South row left blank and one reading n/a. Average of Revenue gives North 15, South 30 and a Total of 20: the mean of the three numeric records, not 22.5, the mean of the two group results. The blank is ignored and n/a is reported as 1 skipped value.
Supported formats and limits
| Input | CSV, TSV, XLSX, XLS, ODS |
|---|---|
| Output | CSV, XLSX |
| Engine | Hash-grouped aggregation with totals |
Limitations
- Numbers formatted with thousands separators are parsed using the chosen decimal style.
- Totals aggregate the underlying records, so an average total is not the average of the cells above it.
Questions
How are blanks or nonnumeric values handled?
Blank values are left out of every summary, including counts. For sum, average, median, minimum and maximum, values that are not numbers (such as n/a) are skipped and their number is shown. Count and count distinct include them.
Why is the average total not the average of the group averages?
Totals are calculated from the records themselves. North 10 and 20 with South 30 give a total average of 20, while averaging the group results 15 and 30 would give 22.5.
What does the export contain?
A flat table with the row labels, one column per column-group value and, when shown, a Total column and Total row. It downloads as CSV or XLSX.
Guides
Privacy
Runs on your device. Files and text are processed in this browser tab and are not uploaded.
See the privacy policy for how toolsdocks handles data.