Make a Pivot Table Online
A pivot table without the dialog: group by one column, across another, and sum, count or average a third.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Make a Pivot Table Online
- 1Select your file, or drop it on the page
- 2Choose how, then run it
- 3Download pivot.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
How do I make a pivot table online?
Upload the file, name the column to group by (and one to spread across if you want a grid), the column to add up, and download the pivot table with totals.
Can it count rows instead of summing?
Yes. Choose Count and leave the value column empty to count rows in each group.
What if a value cell has text in it?
It is left out of the calculation instead of breaking it, so a stray "n/a" does not stop the table.
Is my original data kept?
Yes. The workbook has the pivot table and, on a second sheet, the rows it was made from.