Microsoft Excel MCP Server
for AI Agents
Connect your AI agent to StackOne's Microsoft Excel MCP server and give it 102 MCP tools out of the box. Auth, tool execution, and security all managed.
StackOne 
Coverage
102 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 102 pre-built actions, fully extensible via the Connector Builder — plus managed authentication, prompt injection defense, observability, and agent execution runtime. Connect it from MCP clients like Claude Desktop, Claude Code, Cursor, Goose, and VS Code, or from agent frameworks like OpenAI Agents SDK, LangChain, and Vercel AI SDK.
All Microsoft Excel MCP Tools
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 (beta API — may not work on v1.0)
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 (46)
- Create Workbook Session
Create a persistent or non-persistent workbook session
- Add Named Item (Formula Local)
Add a named item using a locale-specific formula to an Excel workbook
- 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.
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>"
]
}
}
}Check More Data & Analytics MCP Servers
189+ actions
122+ actions
104+ actions
101+ actions
80+ actions
73+ actions
67+ actions
Platform 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
MCP vs A2A: Architecture, Security, and When to Use Each
MCP vs A2A: what each protocol standardizes, how they differ, their shared security risks including indirect prompt injection, and when to use one, both, or a hybrid architecture.
12 min
MCP vs API: What 200+ Connector Builds Taught Us
MCP wraps APIs, it doesn't replace them. After building 200+ connectors that serve both, here's when each approach wins.
14 min read
Microsoft Excel MCP Server FAQ
Does StackOne have a Microsoft Excel MCP server?
Microsoft Excel MCP server vs direct API integration — what's the difference?
How does Microsoft Excel authentication work for AI agents?
origin_owner_id.Are Microsoft Excel MCP tools vulnerable to prompt injection?
What is the context bloat of a Microsoft Excel agent and how do I avoid it?
Can I limit which actions my Microsoft Excel agent can access?
Can I create custom agent actions for my Microsoft Excel MCP server?
When should I NOT use a Microsoft Excel MCP server?
What AI frameworks and AI clients does the StackOne Microsoft Excel MCP server support?
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.