// MCP TOOL REFERENCE

MCP EXCEL TOOLS

25 tools from the Mcp Excel MCP Server, categorised by risk level.

// ALL 25 MCP EXCEL TOOLS

READ 24 tools

Read aggregate Perform aggregation (sum, mean, count, etc.) on a column with optional filters. Returns aggregated value an... Read analyze_overlap Analyze overlap between multiple filter sets (Venn diagram analysis). Returns intersection counts, union, a... Read calculate_moving_average Calculate moving average with specified window size. Useful for trend analysis and smoothing data. Returns ... Read calculate_period_change Calculate period-over-period change (month/quarter/year). Returns periods with values, absolute changes, an... Read calculate_running_total Calculate running total (cumulative sum) ordered by a column. Supports grouping for per-category totals. Re... Read compare_sheets Compare data between two sheets using a key column. Returns rows with differences and status (only_in_sheet... Read correlate Calculate correlation matrix between multiple columns (supports 2+ columns). Supports pearson (linear), spe... Read detect_outliers Detect outliers in a column using IQR or Z-score method. Returns outlier rows with indices and method used.... Read filter_and_count Count rows matching filter conditions. Returns count and Excel formula for dynamic updates. Use for: classi... Read filter_and_count_batch Count rows for multiple filter sets in a single call. Optimized for classification, segmentation, and multi... Read filter_and_get_rows Get rows matching filter conditions with pagination support. Returns filtered data for analysis, export, or... Read find_column Find a column across all sheets or in the first sheet. Returns list of sheets where the column was found wi... Read find_duplicates Find duplicate rows based on specified columns. Returns all duplicate rows including first occurrence with ... Read find_nulls Find null/empty values in specified columns. Returns statistics (count, percentage) and row indices for eac... Read get_column_names Get list of column names from a sheet. Quick operation for schema discovery without loading full data. Use ... Read get_column_stats Get statistical summary of a column (count, mean, median, std, min, max, quartiles, null count). Returns co... Read get_data_profile Get comprehensive data profile for columns including type, statistics, null counts, and top values. Combine... Read get_sheet_info Get detailed information about a specific sheet including column names, types, sample data, and row count. ... Read get_unique_values Get unique values from a column. Essential for understanding data distribution and building accurate filter... Read get_value_counts Get frequency counts for values in a column (top N most common values). Shows distribution and prevalence o... Read group_by Group data by columns and perform aggregation (like Excel Pivot Table). Returns grouped results with aggreg... Read inspect_file Inspect Excel file structure and get basic information about all sheets. Returns sheet names, dimensions, a... Read rank_rows Rank rows by column value (ascending or descending). Supports top-N filtering and ranking within groups. Re... Read search_across_sheets Search for a value across all sheets in the file. Returns list of sheets with match counts and locations. U...

EXECUTE 1 tools

Execute calculate_expression Calculate expression between columns (e.g.,

// FAQ

How many tools does the Mcp Excel MCP server have? +

The Mcp Excel MCP server exposes 25 tools across 2 categories: Read, Execute.

How do I enforce policies on Mcp Excel tools? +

Route the Mcp Excel server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Mcp Excel tools fall into? +

Mcp Excel tools are categorised as Read (24), Execute (1). Each category has a recommended default policy.

Enforce policy on every Mcp Excel tool call.

Start from Mcp Excel, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Free to start. No card required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.