Excel MCP Server
The Excel MCP Server provides Claude with comprehensive read, write, and analysis capabilities for Excel and CSV files through 37 specialized tools.
Read & Navigate: Read entire files or specific cells/ranges, get headers, search values, filter rows by conditions, and aggregate columns (sum, average, count, min, max).
Large File Handling: Stream large files (100MB+) in chunks and get file analysis with chunking recommendations.
Write & Format: Create new Excel/CSV files (single or multi-sheet with formulas and inter-sheet references), add sheets to existing files, export analysis results, apply cell formatting (fonts, colors, borders, alignment, number formats), and auto-fit columns.
Analytics: Perform statistical analysis, correlation analysis, data profiling, and create pivot tables.
Financial Modeling: Conduct DCF valuation, budget vs. actual variance analysis, financial ratio analysis with industry benchmarks, scenario/what-if modeling, and trend analysis with forecasting.
Data Cleaning: Find/manage duplicates, batch clean data (trim whitespace, fix dates/phones/names/currency, remove empty rows), and perform intelligent VLOOKUP with fuzzy matching and error handling.
Bulk Operations: Aggregate and filter data across multiple files in parallel.
Validation: Cross-validate data integrity across related files (referential integrity, data completeness, value ranges).
AI-Powered: Evaluate Excel formulas, convert natural language to formulas/commands, explain formulas in plain English, get AI-powered analysis suggestions, and check AI provider status (Anthropic, OpenAI, DeepSeek, Gemini, or local fallback).
Enables AI-powered natural language data queries and formula generation through OpenAI's API for intelligent spreadsheet analysis.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Excel MCP Serversum all sales where region is 'North'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Excel MCP Server
MCP server that gives Claude full read/write/analyze power over Excel and CSV files. 37 tools — from basic cell reads to financial modeling.
Install
Option 1: npm (Recommended)
npm install -g excel-csv-mcp-serverThen add to your MCP client:
Claude Code:
claude mcp remove excel-csv # if previously added
claude mcp add excel-csv --transport stdio excel-csv-mcp-serverClaude Desktop / Cursor — add to your MCP config (claude_desktop_config.json or Cursor's mcp.json):
{
"mcpServers": {
"excel-csv": {
"command": "excel-csv-mcp-server"
}
}
}Option 2: npx (No Install)
No global install needed — runs directly:
Claude Code:
claude mcp add excel-csv stdio npx -- excel-csv-mcp-serverClaude Desktop / Cursor:
{
"mcpServers": {
"excel-csv": {
"command": "npx",
"args": ["-y", "excel-csv-mcp-server"]
}
}
}Option 3: From Source
git clone https://github.com/ishayoyo/excel-mcp.git
cd excel-mcp
npm install
npm run buildClaude Code:
claude mcp add excel-csv stdio node /path/to/excel-mcp/dist/index.jsClaude Desktop / Cursor:
{
"mcpServers": {
"excel-csv": {
"command": "node",
"args": ["/path/to/excel-mcp/dist/index.js"]
}
}
}Related MCP server: mcp-data-lens
What It Can Do
Category | Tools | Examples |
Read & Navigate |
| Read files, search values, filter rows, sum columns |
Large Files |
| Stream 100MB+ files in chunks |
Write & Format |
| Create Excel/CSV, multi-sheet with formulas, style cells |
Analytics |
| Stats, correlations, profiling, pivot tables |
Financial |
| DCF valuation, budget vs actual, financial ratios, what-if scenarios |
Data Cleaning |
| Remove duplicates, fix dates/phones/names, cross-file lookups |
Bulk Ops |
| Aggregate/filter across multiple files |
Validation |
| Cross-file referential integrity checks |
AI-Powered |
| Evaluate formulas, natural language to formula, AI analysis |
AI Providers (Optional)
For AI-powered tools (parse_natural_language, explain_formula, smart_data_analysis), create a .env file:
cp .env.example .envANTHROPIC_API_KEY=your-key
OPENAI_API_KEY=your-key
DEEPSEEK_API_KEY=your-key
GEMINI_API_KEY=your-keyAny single provider is enough. A local fallback works without any keys.
Data leaves your machine when a provider key is set. The AI tools send the spreadsheet content they are analysing to whichever provider you configured (Anthropic, OpenAI, DeepSeek, or Gemini). Leave the keys unset to keep every operation local -- the built-in fallback provider makes no network calls.
Security
The server reads and writes only .csv, .xlsx, and .xls files, and runs over
stdio as a local process with your own user's permissions.
Restricting file access
By default any path you name is allowed, because opening a spreadsheet anywhere on your disk is the point of the tool. If you expose the server to callers you do not fully trust -- or want a guardrail against a malicious spreadsheet talking the model into writing somewhere unexpected -- confine it to one directory:
EXCEL_MCP_WORKSPACE_ROOT=/path/to/your/dataEvery read and write then resolves inside that directory, and anything escaping it is rejected. Unset the variable to restore the default behaviour.
Note that containment is checked after the path is resolved, so .. traversal is
handled, but symlinks are not followed: a symlink inside the root that points
outside it will still resolve. Avoid placing untrusted symlinks in the workspace.
CSV formula injection
Spreadsheet applications evaluate a cell beginning with =, +, -, @, tab, or
carriage return as a formula. When writing CSV, this server prefixes such values
with a single quote so they stay literal text (CWE-1236). Plain numbers like -5
and +1.5 are recognised and left alone, so numeric data round-trips unchanged.
This guard is on by default. To emit raw values instead:
EXCEL_MCP_CSV_FORMULA_GUARD=offExcel output is unaffected -- .xlsx cells are written as typed strings, which are
never evaluated as formulas.
License
MIT
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceEnables conversational analysis of CSV and Parquet files through natural language, providing statistics, summaries, data type information, and comprehensive multi-step data analysis.
- AlicenseNot gradedqualityCmaintenanceEnables users to ask questions about their spreadsheets in plain English and receive instant answers using DuckDB-powered analytics, supporting multiple file formats like Excel, CSV, and Parquet.2MIT
- FlicenseNot gradedqualityDmaintenanceAI-first CSV analysis tool that enables AI agents to analyze, query, and audit large CSV files directly within conversations, turning raw data into actionable insights.2
- AlicenseNot gradedqualityDmaintenanceEnables querying Excel and CSV files using SQL via natural language, allowing AI assistants to analyze data without manual SQL writing.1MIT
Related MCP Connectors
AI-native team workspace — tables, documents, workflow automation, live dashboards & analytics
AI workspace for you, your team, and every agent. Tables, docs (images, 4K video), formulas.
The statistical analyst in your AI chat — validated, citable, re-runnable analysis of your data.
Appeared in Searches
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/ishayoyo/excel-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server