Make a pivot table without Excel
Revenue by sales rep and by month, number of orders by region: the tool recognises what can be pivoted, suggests useful pivots in one click, and calculates the table with its totals.
What this tool does
- Dimensions (categories, dates) and measures (amounts, quantities) recognised automatically.
- One or two dimensions in rows, one in columns; sum, count, average, minimum, maximum, distinct values.
- Dates grouped by day, month, quarter or year; percentages of the total.
- The table and a bar chart on screen; the table and the data in a workbook.
What it does not do: The table is saved as values, not as an Excel PivotTable: it does not refresh when the data changes. Make it again in a few seconds.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Open a large file : Over a million rows, several gigabytes: browse, filter, sort, export.
- SQL queries : SELECT, JOIN, GROUP BY on your files, with no database.
- Unpivot or pivot : One column per month becomes one row per month, and the reverse.
- Convert a spreadsheet : XLSX, CSV, ODS, JSON, in every direction, sheet by sheet.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.