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; each period compared with the previous one, with its change as a percentage.
- The table and a bar chart on screen; in the workbook, the calculated table and its Excel chart, a real PivotTable that refreshes in Excel, and the data.
What it does not do: The calculated table is saved as values, to open anywhere; the PivotTable is the one that refreshes, in Excel (it builds itself on opening). The "distinct values" calculation does not exist in a classic PivotTable: it is delivered as values only.
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.
- Summarise a column : The distinct values of a column and their count, with a total or an average if needed.
- 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.