How to use Pivot Table Builder
- Choose a CSV, TSV or XLSX file and select its worksheet if needed.
- Use the column buttons or field boxes to choose rows, columns and up to eight measures.
- Choose totals, percentage view and an optional filter, then build the pivot.
- Review the preview and download the complete CSV or XLSX result.
Example: Pivot Table Builder
Total the amount per team for each month.
Options
- Worksheet name or number
- Choose the worksheet used for pivot grouping. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
- Row field
- The column whose values become the rows.
- Column field
- Optional. The column whose values become the columns. Leave empty for a single column.
- Value field
- The number to add up. Not needed for Count of rows.
- Value fields for several figures (optional)
- One field per line as field or field:aggregate, such as amount:sum then amount:average, or count on its own to count rows. Up to 8 fields. This replaces the single value field and aggregate when it is filled in.
- Show each figure as
- A share is a percentage of the plain figure, worked out from the raw values before any rounding. An empty base leaves the cell empty.
- Add a totals row
- Adds a Total row whose sums, counts and averages are worked out from the raw values.
- Add a totals column
- Adds a Total column with the same rules as the totals row.
- Filter field
- Optional. Keep only the rows whose value in this column matches the filter value.
- Filter value
- The exact text to keep in the filter field, without regard to case.
Supported inputs and limits
- One CSV/TSV/XLSX file up to 5 MiB, 50,000 rows, 60 columns and 4,096 characters per cell.
- Up to eight measures; pivot shape up to 200 rows and 60 columns.
- Sum, average, min and max require supported plain decimal numbers; count does not read a numeric measure.
- Standard double precision and six-decimal output rounding apply.
- Totals use source values rather than summing displayed averages.
More details
Percentages can use grand, row or column totals.
CSV guards protect risky text;
XLSX stores inert text.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
What a pivot does to your column names
The row field becomes the first column of the result and each distinct value of the column field becomes its own column heading. A combination with no rows is left empty rather than filled with a zero, so a missing group is visible at a glance. If you need a blank shown as 0, replace it in the spreadsheet after the download.
Questions about Pivot Table Builder
Why is a cell in the value column refused?
Sum, average, min and max need a plain decimal number in every row that survives the filter. A value such as 1,200, 12 kg or 2026-09-30 is not one, so the tool names the row and column instead of dropping the cell or reading part of it. Totals are rounded to six decimals, and a whole number past 9,007,199,254,740,991 is refused because JavaScript cannot hold it exactly.
How do I count rows instead of adding a value up?
Choose Count of rows and leave the value field as it is. Count does not read the value column, so a text column still works, and each cell shows how many rows fall in that group.
What order do the rows and columns come out in?
They keep the order the values first appear in the file, so the same CSV always produces the same table. Re-sort the input if you want a different order; the tool does not sort keys for you.
Will my spreadsheet run a value as a formula?
The CSV export prefixes formula-like text, including after leading whitespace, and quotes cells containing commas or line breaks. A prefix can change the stored value, and spreadsheet import behavior varies. Inspect the downloaded cells in the application where you will use them.
Does pivot grouping change formula-like text in Excel output?
The pivot grouping XLSX download stores each value as inert text, preserving a leading equals or minus sign. CSV formula protection can instead add a prefix. Neither format recalculates saved workbook formulas.