Aggregate Excel Files Online
Group and aggregate Excel files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
How to aggregate Excel files
- Drop your file onto the upload area. The first column is chosen as the Group by column, and every numeric column is set to Sum.
- Pick the Group by column. The dropdown shows each column's type. One column is used, and each distinct value becomes one output row.
- For each other column, click one function: Sum, Avg, Min, Max or Count. Click the dash to leave a column out.
- Click Run Aggregation. The result shows the number of groups, sorted by the group value.
- Download the summary table in the same format as your file.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A facilities team exports monthly electricity readings for three sites and wants one line per site for the quarterly report.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| site | month | kwh | cost |
|---|---|---|---|
| Depot North | 2026-01 | 1240.5 | 310.13 |
| Depot North | 2026-02 | 1102 | 275.5 |
| Head Office | 2026-01 | 860.25 | 215.06 |
| Head Office | 2026-02 | 912.75 | 228.19 |
| Depot South | 2026-01 | 640 | 160 |
Settings
- Group by: site
- month: Count
- kwh: Sum (the default for numeric columns)
- cost: Avg
Result
| site | month_count | kwh_sum | cost_avg |
|---|---|---|---|
| Depot North | 2 | 2342.5 | 292.815 |
| Depot South | 1 | 640 | 160 |
| Head Office | 2 | 1773 | 221.625 |
Five readings collapse to one row per site, sorted alphabetically. Each output column is named after its source and function, such as kwh_sum. Count on month counts the non-empty values, so Depot South shows one month of data. Avg is not rounded, so 292.815 keeps all its decimals. Run Round Numbers on the result if needed.
Working with Excel files
This covers the most common PivotTable layout: one field in Rows and several fields in Values. The first sheet is read as Excel displays it, and that matters for sums. A column formatted as currency or with thousands separators, such as $1,200.00, arrives as text and cannot be summed. A cell showing a rounded value, for example 12.5 for 12.4583, is summed as the displayed 12.5. Set those columns to General format in Excel before loading if you need exact totals.
Subtotal and total rows inside the sheet are treated as ordinary data. If your sheet has a "Total" line at the bottom, it becomes its own group and its values are counted again in the other columns. Delete it before loading. The summary is written to Sheet1 of a new workbook, with one row per group and no formulas, so it will not update if the source changes.
Frequently Asked Questions
Is this the same as an Excel PivotTable?
It covers a pivot with one Rows field and several Values fields, each with one function. It does not support column fields, filters or multiple grouping levels.
Why is my Excel total slightly different from the aggregated sum?
The tool reads the values as displayed. If cells are formatted to show fewer decimals than they store, the rounded display values are what get summed. Set the column to General format in Excel first.
Can I group by more than one column?
No. The tool groups by a single column. To group by two, combine them first with Combine Columns, then group by the new column. The SQL workspace supports any number of GROUP BY columns.
Can I apply more than one function to the same column?
No. Each column gets one function per run. To get both the sum and the average of a column, run the tool twice, or use the SQL workspace.
Does Count count rows or values?
Values. Count on a column counts the rows in each group where that column is not empty. Pick a column with no gaps, such as an ID, to get a row count.
Related Tools
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
Round Numbers in Excel Files Online
Round numeric columns in Excel files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Add Percent of Total to Excel Files Online
Add a percentage-of-total column to Excel files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Aggregate CSV Files Online
Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Aggregate Parquet Files Online
Group and aggregate Parquet files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Aggregate JSON Files Online
Group and aggregate JSON files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.