Skip to main content
Office

Excel Create Pivot

Create pivot tables to summarize and analyze your data.

  • Processed on the server
  • No sign-in needed

Excel file and pivot settings

Choose a file

XLSX

* marks required fields.

Result

Upload an Excel file, enter the field names and press [Create & Download] — the result file appears here and downloads automatically.

How to use Excel Create Pivot

When to use

Use to summarize raw data like transactions by item (sum/average/count) - a pivot-table result without pivot-table skills.

What to input

Upload an Excel file and choose the row key column, value column, and aggregation (sum/average/count).

Usage example

e.g. Build a "sales total by category" summary from a sales log and download it.

Things to check

Sum and average use only cells that contain numbers - blanks and text are skipped, and a cell with no numbers to average is left empty. Formula cells use their last saved result; formulas saved without a result (for example, files made by programs other than Excel) count as text and are skipped. Count counts one per row even when the value cell is blank or text. Merged cells in the source can skew results. The Total row and column follow the chosen aggregation. Only the sheet that was open when the file was saved is processed.

Related tools

  • Automatically create charts from your Excel data.

    No sign-in neededProcessed on the server

  • Search for values in an Excel file and find matching values from other columns.

    No sign-in neededProcessed on the server

  • Remove duplicates, empty rows/columns, and stray whitespace to get analysis-ready data.

    No sign-in neededProcessed on the server

Uploaded files are used only for the requested job, and temporary files are deleted automatically afterwards.