Pivot Table Builder

Group CSV or Excel data with several measures, totals and percentage views.

On-device No sign-up Free to use

Build pivot controls

  1. 1 Add files
  2. 2 Arrange/Options
  3. 3 Download

Drop your table file here

or choose one from your device

One CSV, TSV or XLSX file, up to 5 MB, 50,000 rows and 60 columns. The first row is the column names.

    ?

    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.

    ?

    Only for a workbook. Leave empty to read the first visible worksheet, or name one, such as Sheet1, or give its 1-based number.

    ?

    The column whose values become the rows.

    ?

    Optional. The column whose values become the columns. Leave empty for a single column.

    ?

    The number to add up. Not needed for Count of rows.

    ?

    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.

    ?

    Adds a Total row whose sums, counts and averages are worked out from the raw values.

    ?

    Adds a Total column with the same rules as the totals row.

    ?

    Optional. Keep only the rows whose value in this column matches the filter value.

    ?

    The exact text to keep in the filter field, without regard to case.

    ?

    The workbook stores the pivot as text, so a heading such as 0012 keeps its leading zeroes and a value that begins with = is not run.

    Result

    Showing an example.

    Total the amount per team for each month.

    With the single amount sum measure, team A has Jan 10 and Feb 30; team B has Jan 20 and an empty Feb cell. The complete download retains the team labels and both month columns.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/pivot-table-builder · 20 November 2026

    Was this helpful?

    How to use Pivot Table Builder

    1. Choose a CSV, TSV or XLSX file and select its worksheet if needed.
    2. Use the column buttons or field boxes to choose rows, columns and up to eight measures.
    3. Choose totals, percentage view and an optional filter, then build the pivot.
    4. Review the preview and download the complete CSV or XLSX result.

    Example: Pivot Table Builder

    Total the amount per team for each month.

    You add
    CSV file: team,month,amount with rows A/Jan/10, B/Jan/20, A/Feb/30. Row field: team. Column field: month. Value field: amount. Aggregate: Sum. Filter field: empty.
    You get
    With the single amount sum measure, team A has Jan 10 and Feb 30; team B has Jan 20 and an empty Feb cell. The complete download retains the team labels and both month columns.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Pivot Table Builder

    Related reading

    All guides