F
license-
qualityD
maintenanceEnables conversational analysis of CSV and Parquet files through natural language, providing statistics, summaries, data type information, and comprehensive multi-step data analysis.
Last updated
Excel MCP Server
by ishayoyo
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.
License
MIT
Maintenance
–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity
Issues opened vs closed
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
- Alicense-qualityCmaintenanceEnables 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.Last updated2MIT
- Flicense-qualityDmaintenanceAI-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.Last updated1
- Alicense-qualityDmaintenanceEnables querying Excel and CSV files using SQL via natural language, allowing AI assistants to analyze data without manual SQL writing.Last updated1MIT
Related MCP Connectors
The statistical analyst in your AI chat — validated, citable, re-runnable analysis of your data.
Vector RAG store for Word/Excel/PDF/PowerPoint. Break-even pricing, $5 per 5,700 pages.
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over 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