Summarise a column of a file
How many orders per region, how often each code comes back, the total per customer: instead of building a pivot table, choose a column and read its distinct values straight away, counted and sorted.
What this tool does
- The distinct values of a column, counted and sorted from the most frequent to the least.
- If needed, a total, average, minimum or maximum of another column per value.
- Empty values grouped separately.
- The summary saves to Excel, CSV or ODS.
- Everything happens in your browser, nothing is sent.
What it does not do: The tool groups on a single column. To cross two dimensions, or to get a chart and a native pivot table, see Automatic pivot table.
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.
- Automatic pivot table : Useful pivots suggested, dates grouped, the table and its chart.
- 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.