Excel MCP Server

Read an entire CSV or Excel file with optional chunking for large files

Get the value of a specific cell using A1 notation

Get values from a range of cells

Get the column headers (first row) of a file

Search for cells containing a specific value

Filter rows based on column values

Perform aggregation operations on a column

Read large files in manageable chunks to avoid token limits

Analyze file size and get chunking recommendations

Perform comprehensive statistical analysis on a column

Calculate correlation between two numeric columns

Generate comprehensive data profiling report for all columns

Create pivot table with grouping and aggregation

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

Analyze budget vs actual performance with variance calculations

Perform comprehensive financial ratio analysis with industry benchmarks

Perform what-if scenario analysis with multiple assumptions

Analyze time series trends, growth rates, seasonality, and forecasting for sales and performance data

Write data to a new CSV or Excel file (supports multiple sheets for Excel)

Add a new sheet to an existing Excel file

Create a complex Excel file with multiple sheets, formulas, and inter-sheet references

Export analysis results (pivot tables, statistics, etc.) to a new file

Apply formatting to Excel cells (fonts, colors, borders, alignment)

Automatically adjust column widths to fit content in Excel files

Evaluate an Excel formula with given context

Convert natural language to Excel formula or command

Explain what an Excel formula does in plain English

Check status of available AI providers

AI-powered analysis suggestions for your data

Cross-validate data integrity across related files

Aggregate same column across multiple files in parallel

Filter data across multiple files with optional export

Find and manage duplicate rows in Excel/CSV files with multiple strategies

Batch data cleaning operations with intelligent detection of common data quality issues

Intelligent VLOOKUP setup and execution with error handling and fuzzy matching