aggregate
Perform aggregation with optional filters (8 operations).
How to use it
aggregate is exposed by the MCP Excel MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the aggregate tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Excel
pip install -e .Other tools in MCP Excel (24)
Venn diagram analysis - intersections, unions, exclusive zones.
Arithmetic expressions between columns.
Smoothing with specified window size.
Period-over-period growth analysis.
Cumulative sum with optional grouping.
Diff between two sheets using key column.
Correlation matrix between 2+ columns.
Anomaly detection using IQR or Z-score.
Count rows matching conditions with 14 operators.
Classify data into multiple categories in one call (6x faster).
Retrieve filtered rows with pagination.
Locate column across multiple sheets.
Detect duplicate rows by specified columns.
Find null/empty values with detailed statistics.
Quick column enumeration without loading full data.
Statistical summary - count, mean, median, std, quartiles.
Comprehensive column profiling - types, stats, nulls, top values.
Detailed sheet analysis with auto-header detection.
Extract unique values from a column.
Frequency analysis - top N most common values.
Pivot table with multi-column grouping.
Get file structure overview - sheets, dimensions, format.
Rank by column value with top-N filtering.
Search value across all sheets.