About Excel Pivot Table Online
This page opens with products as rows and quarters as columns, summing Amount. Choose an XLSX, XLS or ODS file and the workbook is read in your browser; if it has several sheets, pick one. It is free, needs no sign-up and runs in your browser, so nothing you enter is uploaded.
On the sample, the product totals are Laptop 52800, Phone 38400, Tablet 23400. It does not need Excel, and it does not change your workbook. It also does not copy Excel features such as slicers or calculated fields.
How to use Excel Pivot Table Online
- Choose a file or paste your cells under Paste or upload data. The first row must hold the column names.
- Pick the Rows field: its values become the row labels.
- Pick the Columns field, or (none) for a single value column.
- Pick the aggregate and the Values field to summarise. Count does not need a values field.
- Read the table with its totals, then copy it or download it as CSV.
Features
- Sum, count, average, minimum and maximum.
- One row field and an optional column field, with a Total column and a Total row.
- CSV, TSV, XLSX, XLS and ODS input, read in a Web Worker.
- Labels sorted naturally, so 2 comes before 10 and (blank) is last.
- Totals computed from the source rows, not from the cell results.
- A count of rows skipped because the value was not a number.
- Copy as CSV or download.
Worked examples
Rows Product, columns Quarter, sum of Amount gives Laptop 52800, Phone 38400, Tablet 23400
Grand total 114600.
Privacy: how it works
- Your table is read and summarised by code running in this browser tab. It is not uploaded or stored.
Tips
- Pick fields with few distinct values for rows and columns. A column field with hundreds of values makes a very wide table.
- Use Count with a text field to see how often each value appears.
- Dates summarise better once they are grouped, for example as a month or quarter column added to the source data.
- Blank labels are grouped under (blank) so those rows are never dropped.
Frequently asked questions
Is it really free?
Yes. There is no price, no trial and no credit card. Ulkaa Tool does the work with your own device, so there is no server bill to pass on to you.
Do I need an account?
No. There is no sign-up and no login. Open the page and use it. An Ulkaa account is not needed for anything on this tool.
Does it run in my browser?
Yes. Your table are processed by code running in your browser tab, on your own device.
Is my data uploaded?
No. Your table are never sent to Ulkaa or to anyone else. You can check this yourself by watching the Network tab in your browser developer tools while you use the tool.
Will it keep my Excel formulas?
No. It reads the displayed values of the cells, so a formula cell is summarised by its result.
More Pivot Table Maker pages
- Pivot Table MakerSummarise a table by rows and columns with sums, counts and averages, totals included.
- Pivot Table From CSVTurn a flat CSV into a summary with rows, columns and totals.
- Count Pivot TableCount how many rows fall in each combination of two fields.
- Average Pivot TableShow the mean of a column for each group.
- Max Pivot TableShow the largest value of a column for each group.
- Min Pivot TableShow the smallest value of a column for each group.