group_by
Pivot table with multi-column grouping.
How to use it
group_by is exposed by the MCP Excel MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the group_by 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)
Perform aggregation with optional filters (8 operations).
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.
Get file structure overview - sheets, dimensions, format.
Rank by column value with top-N filtering.
Search value across all sheets.