// MCP TOOL REFERENCE

EXCEL MCP SERVER TOOLS

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

// ALL 35 EXCEL MCP SERVER TOOLS

READ 23 tools

Read aggregate Perform aggregation operations on a column Read ai_provider_status Check status of available AI providers Read budget_variance_analysis Analyze budget vs actual performance with variance calculations Read bulk_aggregate_multi_files Aggregate same column across multiple files in parallel Read bulk_filter_multi_files Filter data across multiple files with optional export Read correlation_analysis Calculate correlation between two numeric columns Read data_profile Generate comprehensive data profiling report for all columns Read explain_formula Explain what an Excel formula does in plain English Read filter_rows Filter rows based on column values Read find_duplicates Find and manage duplicate rows in Excel/CSV files with multiple strategies Read get_cell Get the value of a specific cell using A1 notation Read get_file_info Analyze file size and get chunking recommendations Read get_headers Get the column headers (first row) of a file Read get_range Get values from a range of cells Read ratio_analysis Perform comprehensive financial ratio analysis with industry benchmarks Read read_file Read an entire CSV or Excel file with optional chunking for large files Read read_file_chunked Read large files in manageable chunks to avoid token limits Read search Search for cells containing a specific value Read smart_data_analysis AI-powered analysis suggestions for your data Read statistical_analysis Perform comprehensive statistical analysis on a column Read trend_analysis Analyze time series trends, growth rates, seasonality, and forecasting for sales and performance data Read validate_data_consistency Cross-validate data integrity across related files Read vlookup_helper Intelligent VLOOKUP setup and execution with error handling and fuzzy matching

WRITE 8 tools

Write auto_fit_columns Automatically adjust column widths to fit content in Excel files Write data_cleaner Batch data cleaning operations with intelligent detection of common data quality issues Write format_cells Apply formatting to Excel cells (fonts, colors, borders, alignment) Write add_sheet Add a new sheet to an existing Excel file Write export_analysis Export analysis results (pivot tables, statistics, etc.) to a new file Write pivot_table Create pivot table with grouping and aggregation Write write_file Write data to a new CSV or Excel file (supports multiple sheets for Excel) Write write_multi_sheet Create a complex Excel file with multiple sheets, formulas, and inter-sheet references

EXECUTE 3 tools

Execute parse_natural_language Convert natural language to Excel formula or command Execute evaluate_formula Evaluate an Excel formula with given context Execute scenario_modeling Perform what-if scenario analysis with multiple assumptions

FINANCIAL 1 tools

Financial dcf_analysis Perform Discounted Cash Flow (DCF) valuation analysis for investment evaluation

// FAQ

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

The Excel MCP Server MCP server exposes 35 tools across 4 categories: Read, Write, Execute, Financial.

How do I enforce policies on Excel MCP Server tools? +

Route the Excel MCP Server 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 Excel MCP Server tools fall into? +

Excel MCP Server tools are categorised as Read (23), Write (8), Execute (3), Financial (1). Each category has a recommended default policy.

Enforce policy on every Excel MCP Server tool call.

Start from Excel MCP Server, 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.