Connect
Optimize
Secure
Microsoft Excel MCP Server
for AI Agents
Production-ready Microsoft Excel MCP server with 101 extensible actions — plus built-in authentication, security, and optimized execution.
Microsoft Excel MCP Server
Built by 
StackOne
StackOne 
Coverage
101 Agent Actions
Create, read, update, and delete across Microsoft Excel — and extend your agent's capabilities with custom actions.
Authentication
Agent Tool Authentication
Per-user OAuth in one call. Your Microsoft Excel MCP server gets session-scoped tokens with zero credentials stored on your infra.
Agent Auth →
Security
Agent Protection
Every Microsoft Excel tool response scanned for prompt injection in milliseconds — 88.7% accuracy, all running on CPU.
Prompt Injection Defense →
Performance
Max Agent Context. Min Cost.
Free up to 96% of your agent's context window to enhance reasoning and reduce cost, on every Microsoft Excel call.
Tools Discovery →What is the Microsoft Excel MCP Server?
A Microsoft Excel MCP server lets AI agents read and write Microsoft Excel data through the Model Context Protocol — Anthropic's open standard for connecting LLMs to external tools. StackOne's Microsoft Excel MCP server ships with 101 pre-built actions, fully extensible via the Connector Builder — plus managed authentication, prompt injection defense, and optimized agent context. Connect it from MCP clients like Claude Desktop, Cursor, and VS Code, or from agent frameworks like OpenAI Agents SDK, LangChain, and Vercel AI SDK.
All Microsoft Excel MCP Tools and Actions
Every action from Microsoft Excel's API, ready for your agent. Create, read, update, and delete — scoped to exactly what you need.
Excel Files
- List Excel Files
Search for Excel (.xlsx) files in the user's OneDrive or across all accessible drives
- Get Excel File
Get metadata for a specific Excel workbook DriveItem by ID
Worksheets
- Create Worksheet
Create a new worksheet in an Excel workbook
- List Worksheets
Retrieve the list of worksheets in an Excel workbook
- Get Worksheet
Retrieve a specific worksheet by ID or name
- Update Worksheet
Update properties of a worksheet (name, position, visibility)
- Delete Worksheet
Delete a worksheet from an Excel workbook
Tables
- Create Table
Create a new table in an Excel workbook
- List Tables
Retrieve the list of tables in an Excel workbook
- Get Table
Retrieve a specific table by ID or name
- Update Table
Update properties of a table (name, headers, totals, style)
- Delete Table
Delete a table from an Excel workbook
Table Rows
- Add Table Row
Add a new row to a table in an Excel workbook
- List Table Rows
Retrieve the rows of a table in an Excel workbook
- Delete Table Row
Delete a row from a table by its zero-based index
Table Columns
- Add Table Column
Add a new column to a table in an Excel workbook
- List Table Columns
Retrieve the columns of a table in an Excel workbook
- Delete Table Column
Delete a column from a table by its ID
Table Sort Icons
- Get Table Sort Icon
Retrieve the icon used in a table sort field
- Update Table Sort Icon
Update the icon used in a table sort field
Named Items
- Add Named Item
Add a new named item (named range or constant) to an Excel workbook
- List Named Items
Retrieve the named items (named ranges and constants) in an Excel workbook
- Get Named Item
Retrieve the properties and relationships of a named item in an Excel workbook
- Update Named Item
Update the properties of a named item in an Excel workbook
- Delete Named Item
Delete a named item from an Excel workbook
Charts
- Create Chart
Create a new chart in a worksheet
- List Charts
Retrieve the list of charts in a worksheet
- Get Chart
Retrieve a specific chart by ID or name
- Update Chart
Update properties of a chart (name, dimensions, position)
- Delete Chart
Delete a chart from a worksheet
Chart Series
- Create Chart Series
Add a new series to a chart
- List Chart Series
Retrieve the list of series in a chart
- Get Chart Series
Retrieve a specific series from a chart by its zero-based index
- Update Chart Series
Update the name of a chart series by its zero-based index
Chart Axis
- Get Chart Axis
Retrieve the properties of a chart axis
- Update Chart Axis
Update properties of a chart axis (min, max, units)
Chart Axis Titles
- Get Chart Axis Title
Retrieve the title of a chart axis
- Update Chart Axis Title
Update the title of a chart axis
Chart Data Labels
- Get Chart Data Labels
Retrieve the data labels configuration of a chart
- Update Chart Data Labels
Update the data labels configuration of a chart
Chart Fonts
- Get Chart Font
Retrieve the font properties of a chart axis
- Update Chart Font
Update the font properties of a chart axis
Chart Gridlines
- Get Chart Gridlines
Retrieve the gridlines configuration of a chart axis
- Update Chart Gridlines
Update the visibility of chart axis gridlines
Chart Legends
- Get Chart Legend
Retrieve the legend properties of a chart
- Update Chart Legend
Update the legend properties of a chart
Chart Line Formats
- Get Chart Line Format
Retrieve the line format properties of a chart axis or gridlines
- Update Chart Line Format
Update the line color of a chart axis or gridlines
Chart Points
- List Chart Points
Retrieve the list of data points in a chart series
- Get Chart Point
Retrieve a specific data point in a chart series by ID
Chart Titles
- Get Chart Title
Retrieve the title properties of a chart
- Update Chart Title
Update the title properties of a chart
Comments
- List Comments
Retrieve the list of comments in an Excel workbook
- Get Comment
Retrieve a specific comment in an Excel workbook by ID
Comment Replys
- Create Comment Reply
Create a new reply to a workbook comment
- Get Comment Reply
Retrieve a specific reply to a workbook comment by ID
Other (45)
- Create Workbook Session
Create a persistent or non-persistent workbook session
- Get Worksheet Protection
Retrieve the protection properties of a worksheet
- Get Table Data Body Range
Retrieve the range associated with the data body of a table
- Get Table Header Row Range
Retrieve the range associated with the header row of a table
- Get Table Range
Retrieve the range associated with the entire table
- Get Table Total Row Range
Retrieve the range associated with the totals row of a table
- Get Table Sort
Retrieve the sort configuration of a table
- Get Range
Retrieve the properties and relationships of a cell range
- Get Used Range
Retrieve the used range of a worksheet
- Get Cell
Retrieve a single cell based on row and column numbers within a range
- Get Range Column
Retrieve a column contained in a range
- Get Columns After
Get a certain number of columns to the right of a given range
- Get Columns Before
Get a certain number of columns to the left of a given range
- Get Entire Column
Get the entire column of a range
- Get Entire Row
Get the entire row of a range
- Get Range Intersection
Get the rectangular intersection of two ranges
- Get Last Cell
Get the last cell within a range
- Get Last Column
Get the last column within a range
- Get Last Row
Get the last row within a range
- Get Offset Range
Get a range offset from the specified range by a number of rows and columns
- Get Resized Range
Get a range expanded or contracted from the current range
- Get Range Row
Get a row contained in a range
- Get Rows Above
Get a certain number of rows above a given range
- Get Rows Below
Get a certain number of rows below a given range
- Get Named Item Range
Retrieve the range object associated with a named item
- Get Chart At Index
Get a chart based on its zero-based position in the worksheet
- Get Chart Image
Render a chart as a base64-encoded image
- Get Chart Point At Index
Retrieve a data point by its zero-based index within a chart series
- List Comment Replies
Retrieve the list of replies for a workbook comment
- Set Chart Position
Position a chart relative to cells on the worksheet
- Set Chart Data
Reset the source data for a chart
- Set Chart Fill Solid Color
Set the fill of a chart, title, or legend element to a solid color
- Protect Worksheet
Protect a worksheet with optional protection options
- Unprotect Worksheet
Unprotect a protected worksheet
- Convert Table To Range
Convert a table to a normal range of cells
- Clear Table Filters
Clear all filters currently applied on a table
- Apply Table Sort
Apply a sort operation on a table
- Clear Table Sort
Clear the current sort state of a table
- Reapply Table Sort
Reapply the current sort parameters to a table
- Apply Column Filter
Apply filter criteria to a specific column in a table
- Clear Column Filter
Clear the filter on a specific column in a table
- Merge Range
Merge the range cells into one region in the worksheet
- Unmerge Range
Unmerge the range cells into separate cells
- Clear Chart Fill
Clear the fill color of a chart, title, or legend element
- Clear Chart Line Format
Clear the line format of a chart axis or gridlines
Set Up Your Microsoft Excel MCP Server in Minutes
One endpoint. Any framework. Your agent is talking to Microsoft Excel in under 10 lines of code.
MCP Clients
Agent Frameworks
JSON{
"mcpServers": {
"stackone": {
"command": "npx",
"args": [
"-y",
"mcp-remote@latest",
"https://api.stackone.com/mcp?x-account-id=<account_id>",
"--header",
"Authorization: Basic <YOUR_BASE64_TOKEN>"
]
}
}
}Microsoft Excel MCP Server Resources
MCP Code Mode: Keeping Tool Responses Out of Agent Context
Anthropic's code_execution processes data already in context. Custom MCP code mode keeps raw tool responses in a sandbox. 14K tokens vs 500.
11 min
Comparing BM25, TF-IDF, and Hybrid Search for MCP Tool Discovery
Benchmarking BM25, TF-IDF, and hybrid search for MCP tool discovery across 916 tools. The 80/20 TF-IDF/BM25 hybrid hits 21% Top-1 accuracy in under 1ms.
10 min
Indirect Prompt Injection Defense for MCP Tools: A Technical Guide
MCP tools that read emails, CRM records, and tickets are indirect prompt injection vectors. Here's how we built a two-tier defense that scans tool results in ~11ms.
12 min
Microsoft Excel MCP Server FAQ
Microsoft Excel MCP server vs direct API integration — what's the difference?
A Microsoft Excel MCP server and direct API integration serve different use cases. Direct API integration is for software-to-software — backend code calling Microsoft Excel. A Microsoft Excel MCP server is for AI agents — MCP clients like Claude and Cursor, plus framework agents built with OpenAI, LangChain, or Vercel AI — discovering and calling Microsoft Excel at runtime. StackOne provides both.
How does Microsoft Excel authentication work for AI agents?
Microsoft Excel authentication for AI agents works through a StackOne Connect Session. Create one via the dashboard or the SDK — you get an auth link and ready-to-paste config for Claude Desktop, Cursor, and other MCP clients. Your user authenticates their own Microsoft Excel account; StackOne handles token exchange, storage, and refresh. Credentials never reach the LLM, and each user is isolated via
origin_owner_id.Are Microsoft Excel MCP tools vulnerable to prompt injection?
Yes — Microsoft Excel MCP tools can be vulnerable to indirect prompt injection. Any tool that reads user-written content — documents, messages, tickets, records, or free-text fields — is a potential vector. StackOne Defender scans every tool response before it enters the agent's context — regex patterns in ~1ms, then a MiniLM classifier in ~4ms. 88.7% accuracy, CPU-only.
What is the context bloat of a Microsoft Excel agent and how do I avoid it?
Context bloat happens when Microsoft Excel tool schemas and API responses eat your Microsoft Excel agent's memory, preventing it from reasoning effectively. A single Microsoft Excel query can return a massive JSON response, and connecting multiple tools compounds the problem. Tools Discovery and Code Mode reduce context bloat — loading only relevant tools per query and keeping raw responses out of the agent's context.
Can I limit which actions my Microsoft Excel agent can access?
Yes — you can limit which actions your Microsoft Excel agent can access directly from the StackOne dashboard. Toggle actions on or off, or restrict them to specific accounts, with no code changes to your agent. Session tokens can be scoped to exact actions so if one leaks, exposure stays contained.
Can I create custom agent actions for my Microsoft Excel MCP server?
Yes — you can create custom agent actions for your Microsoft Excel MCP server using Connector Builder. It's an integration agent your coding assistant (Claude Code, Cursor, or Copilot) can invoke to research Microsoft Excel's API, generate production-ready connector YAML, test against the live API, and validate before you ship.
When should I NOT use a Microsoft Excel MCP server?
Skip a Microsoft Excel MCP server if your integration is purely software-to-software — direct Microsoft Excel API integration is simpler when no AI agent is involved. For deterministic, compliance-critical operations (financial transactions, regulatory reporting), direct API gives you predictable behavior without agent-driven decision-making. MCP shines when AI agents need to dynamically discover and call Microsoft Excel actions at runtime.
What AI frameworks and AI clients does the StackOne Microsoft Excel MCP server support?
The StackOne Microsoft Excel MCP server supports both. MCP clients (paste-and-go apps): Claude Desktop, Claude Code, Cursor, VS Code, Goose. Agent frameworks (code SDKs you build with): OpenAI Agents SDK, Anthropic, Vercel AI, Google ADK, CrewAI, Pydantic AI, LangChain, LangGraph, Azure AI Foundry.
Put your AI agents to work
All the tools you need to build and scale AI agent integrations, with best-in-class connectivity, execution, and security.