Data & Tables
Group By Tool
Group table data online by selected columns. Count, sum, average, and summarize records locally in your browser.
Tool
Group table data online by selected columns. Count, sum, average, and summarize records locally in your browser.
This tool runs in your browser. Your input is processed locally and is not uploaded.
About this Tool
Use this Group By Tool to summarize records by one or more columns. The tool groups rows by selected fields, counts records, sums numeric values, averages metrics, and shows grouped output as a new table. It is simpler than a pivot table because it produces one grouped result table instead of a cross-tab layout.
Examples
- month,region,channel,revenue 2026-01,North,Online,1200 2026-01,North,Retail,750 2026-01,South,Online,980 2026-02,North,Online,1340 2026-02,South,Retail,860
Frequently Asked Questions
Is my table data uploaded to a server?
No. The tool parses, transforms, previews, and exports data locally in your browser without uploading your input.
How are data types detected?
Values can be inspected as strings first, then optionally detected as numbers, booleans, dates, or empty values. You can keep text mode when exact formatting matters.
How is this different from a pivot table?
Group by creates a straightforward grouped summary table. A pivot table can place one grouping dimension across columns for a cross-tab view.
What happens to non-numeric values in numeric summaries?
They are ignored with a visible warning or treated according to a clear option, never silently counted as zero.
What file sizes are practical in the browser?
Small and medium tables are the best fit. Very large files can use a lot of memory because parsing, previews, and exported results all live inside the browser tab.