#181 · Table Analysis & Summaries Tool

Spreadsheet Sum by Category

Group spreadsheet rows by a category column and total a numeric column without sending the workbook anywhere.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Upload a workbook or delimited file.
  2. Choose the sheet and enter the header row.
  3. The first column is used as the category and the second as the amount.
  4. Review the grouped totals, then download the summary.

What this tool does

Groups nonblank category values, adds valid numeric values, and exports a new summary workbook.

Groups nonblank category values, adds valid numeric values, and exports a new summary workbook.

Text, blanks, and nonnumeric amount cells are excluded from the total and counted in the on-screen report.

Supported formats

Reads XLSX, XLS, CSV, and TSV in the browser. The exact output format is shown in the tool controls.

FormatSupport
XLSX / XLSCell data; advanced objects may not be preserved
CSV / TSVUTF-8 delimited data; one table per file

Tips for better results

  • Put category names in the first selected column and amounts in the second.
  • Use a single header row and avoid merged cells in the source table.
  • Check currency symbols stored as text before relying on totals.

FAQ

Can this sum repeated category names in Excel?

Yes. Matching category text is grouped and its numeric values are added into one summary row.

What happens to blank category cells?

Rows with a blank category are skipped so they do not create an ambiguous summary group.

Will currency-formatted cells be included?

Numeric Excel cells are included. Currency text containing symbols may need cleaning before it can be summed.

Does the tool change my original workbook?

No. It reads the selected sheet and creates a separate summary workbook.

Can I choose columns other than the first two?

This browser-safe version uses the first column for categories and the second for amounts; arrange or copy those columns before processing.

Processing notes

AreaBehavior
PrivacyLocal browser processing
SourceNever overwritten
PreviewLimited to selected rows

Browse more office tools

Office tool hubs