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
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.