pivot_table
Create pivot tables
How to use it
pivot_table is exposed by the MCP Excel Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the pivot_table tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Excel Server
$
uv pip install -e .Other tools in MCP Excel Server (9)
analyze_excel
Perform statistical analysis
data_summary
Generate comprehensive data summary
export_chart
Generate charts
filter_excel
Filter data by conditions
get_excel_info
Get file details
get_sheet_names
List worksheet names
read_excel
Read Excel files
update_excel
Update existing Excel files
write_excel
Write new Excel files