A quick pivot table without opening Excel
"What are the total sales per region?" "How many tickets did each team close per month?" "What is the average order value by country?" These are pivot table questions. Excel and Google Sheets can answer them, but building a pivot table means dialogs, dragging fields and a new sheet, and many people never quite remember how.
Here you drop a file or paste a few columns, then finish one sentence: show the sum of Amount for each Region, split by Quarter. The summary table appears straight away with totals, and you can copy it or download it as Excel. The file is read in your browser and never uploaded.
How to use it
- Add your data. Drop an Excel or CSV file, or paste cells copied from a spreadsheet, including the heading row.
- Finish the sentence. Choose the calculation (sum, count, average, smallest, largest, or the number of different values), the column to calculate, the column to group by, and optionally a second column to split the results across.
- Read the table. Totals are shown for each row, each column and overall. Rows are ordered by their total, largest first, or A to Z.
- Take it with you. Copy for Excel pastes as cells. Download Excel or CSV saves the summary as a file.
Examples
| Question | Sentence |
|---|---|
| Sales per region per quarter | Sum of Amount for each Region, split by Quarter |
| How many orders each customer placed | Count of Order ID for each Customer |
| Average deal size by salesperson | Average of Value for each Owner |
| How many different products each store sold | Number of different Product for each Store |
| Largest single expense per category | Largest of Amount for each Category |
Good to know
- Numbers are read the way people write them. 1,250, $1,250.00, 12% and (40) for minus 40 are all understood. Cells that are not numbers are skipped by sum, average, smallest and largest, and the tool says how many were skipped.
- Count counts the rows that have something in the chosen column. Number of different counts distinct values, such as how many different customers bought something.
- Empty group names are collected under "(blank)" so no row is lost.
- Averages are exact. Totals and averages are worked out from the original rows, so the total of an average column is the true overall average, not an average of averages.
- One sheet at a time. For a workbook, the first sheet is used; save another sheet as its own file if you need it.
How this tool was tested
Before publishing, I ran 26 automated checks on the finished page in Microsoft Edge, which is built on Chromium like Chrome. Last full run: 15 November 2026.
- Numbers written with currency signs, thousands separators, percent signs and brackets for minus amounts, and words in a number column, which are skipped and counted.
- The summary: sums per cell, row, column and overall, count, average, smallest, largest and number of different values, and empty group names collected as "(blank)".
- Averages: the overall average is the true average of all rows, not an average of the group averages.
- 200 random tables compared with a plain sum written separately in the test: every cell, row total and grand total matched, and 100,000 rows were summarised in well under a second.
- Using the tool: the sample, ordering, percentages of the total, the Excel and CSV downloads (opened again to check them), an Excel file read and guessed correctly, and too little data.
What the tests did not cover: Safari and Firefox were not tested, and the downloads were read back with SheetJS rather than opened in Excel. Something not working? Tell me on the contact page.
FAQ
Is my data uploaded?
No. The file is read by your browser and the summary is made in this page.
Can I group by dates, such as by month?
Group by a column that already holds the month. If your data only has full dates, add a Month column in your spreadsheet first, for example with =TEXT(A2,"yyyy-mm").
How many rows can it handle?
Hundreds of thousands. 100,000 rows are summarised in well under a second on a normal laptop.