How to use this office tool
- Select a compatible source file.
- Review the header or column setting and preview limit.
- Choose Create group summary, inspect the bounded preview, and download the newly generated result.
#085 · Table Analysis & Summaries Tool
Excel Group By Summary
Group spreadsheet rows by a category column and calculate counts plus numeric totals in a downloadable Excel summary.
Office File Tool
Local browser processingrow
rows
Ad space
What this tool does
Uses the first text-like column as the group key and the first numeric column as the value field, then creates a new workbook containing count, sum, and average by group.
Uses the first text-like column as the group key and the first numeric column as the value field, then creates a new workbook containing count, sum, and average by group.
Keep the original file until you have checked the downloaded result in your spreadsheet application.
Supported formats
Accepts XLSX, XLS, CSV, and TSV. Output fidelity depends on features supported by SheetJS CE.
| Format | Use |
|---|---|
| XLSX / XLS | Workbook data input where applicable |
| CSV / TSV / XML | Plain structured-data input where applicable |
| Output | A newly generated XLSX or CSV file |
Tips for better results
- Keep a backup before processing.
- Use a clear header row and consistent column types.
- Review IDs, dates, formulas, and leading zeros in the preview.
- For sensitive files, close the tab after downloading the result.
FAQ
Which columns are used for the Excel group summary?
The first column is used as the group key and the first column containing numeric cells becomes the value field.
What calculations are included for each group?
The output includes source row count, numeric sum, and numeric average.
How are blank group values handled?
Blank keys are collected into a group labeled (blank).
Are numeric-looking text values included?
Values that can be converted to finite numbers are included in the numeric calculation.
Does the summary change my original workbook?
No. It creates a separate XLSX workbook with a Group Summary sheet.
Related office tools
Processing summary
| Stage | Behavior |
|---|---|
| Read | Local browser memory |
| Transform | Uses the first text-like column as the group key and the first numeric column as the value field, then creates a new workbook containing count, sum, and average by group. |
| Export | New downloadable file |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all