Excel MCP server
41 operations0 webhooks
Read and write Excel workbooks in OneDrive for Business or SharePoint through Microsoft Graph.
Try Excel with your agent
Connect Excel, then paste this into Claude, ChatGPT or Cursor. For ideas from other apps, see the use cases.
Using Corsair, show me what you can do in Excel on my account, then run one read-only example and show me the result.
Excel tools and triggers
Tools are what your agent can do in Excel through Corsair's MCP server. Triggers are the Excel events a routine can start from.
Tables
- AddWrite
Create a table from a range
tables.add
- Add ColumnWrite
Insert a column into a table
tables.addColumn
- Add RowsWrite
Insert one or more rows into a table
tables.addRows
- DeleteDestructive
Delete a table
tables.delete
- Delete ColumnDestructive
Delete a table column
tables.deleteColumn
- Delete RowDestructive
Delete a table row by index
tables.deleteRow
- GetRead-only
Get one table by name or id
tables.get
- ListRead-only
List tables in a workbook or worksheet
tables.list
- List ColumnsRead-only
List columns in a table
tables.listColumns
- List RowsRead-only
List rows in a table
tables.listRows
- UpdateWrite
Rename a table or change its header, total, or style
tables.update
Charts
- AddWrite
Add a chart from a cell range
charts.add
- DeleteDestructive
Delete a chart
charts.delete
- GetRead-only
Get one chart by name or id
charts.get
- ListRead-only
List charts on a worksheet
charts.list
- Set DataWrite
Point a chart at a different cell range
charts.setData
- UpdateWrite
Rename a chart or move and resize it
charts.update
Names
- AddWrite
Define a named range
names.add
- GetRead-only
Get one named range
names.get
- ListRead-only
List named ranges in a workbook or worksheet
names.list
- RangeRead-only
Read the cells a named range points at
names.range
- UpdateWrite
Change a named range comment or visibility
names.update
Worksheets
- AddWrite
Add a worksheet
worksheets.add
- DeleteDestructive
Delete a worksheet
worksheets.delete
- GetRead-only
Get one worksheet by name or id
worksheets.get
- ListRead-only
List worksheets in a workbook
worksheets.list
- UpdateWrite
Rename a worksheet or change its position
worksheets.update
Comments
- GetRead-only
Get one comment
comments.get
- ListRead-only
List comments in a workbook
comments.list
- List RepliesRead-only
List replies on a comment
comments.listReplies
- ReplyWrite
Reply to a comment
comments.reply
Ranges
- ClearWrite
Clear values or formatting in a range
ranges.clear
- GetRead-only
Read a cell range
ranges.get
- UpdateWrite
Write values, formulas, or number formats into a range
ranges.update
- Used RangeRead-only
Read the used range of a worksheet
ranges.usedRange
Sessions
- CloseWrite
Close an Excel workbook session
sessions.close
- CreateWrite
Open a persistent or temporary Excel workbook session
sessions.create
- RefreshWrite
Keep an Excel workbook session alive
sessions.refresh
Files
- CreateWrite
Upload a blank .xlsx workbook to OneDrive or SharePoint
files.create
- FindRead-only
Search OneDrive or SharePoint for .xlsx files
files.find
Functions
- CalculateRead-only
Run an Excel worksheet function such as SUM or VLOOKUP
functions.calculate
Connect Excel to Claude, ChatGPT or Cursor
- 1
Connect Excel in Corsair
Sign in to Excel once in Corsair. Corsair stores the credential encrypted and makes the Excel API calls for your agent, so it never goes into a prompt or a config file. Connect Excel
If your link lets the agent add apps, you can skip this: it gives you a sign-in link the first time it needs Excel. On a ChatGPT personal plan, connect Excel here first.
- 2
Add Corsair's MCP server to your agent
Every client uses the same address:
https://mcp.corsair.dev/mcpOpen Customize → Connectors → Add custom connector, paste the address, then select Connect.Add a custom MCP server with the address and choose OAuth. Personal plans get read tools only.Add to CursorOr add this to~/.cursor/mcp.json. Cursor opens Corsair to sign in the first time it connects.{ "mcpServers": { "corsair": { "url": "https://mcp.corsair.dev/mcp" } } }Run this, then run/mcpin Claude Code to sign in.claude mcp add --transport http corsair https://mcp.corsair.dev/mcpCodex, Gemini CLI, VS Code, Zed and other clients with OAuth sign-in work the same way. Clients without it, such as GitHub Copilot's coding agent, use a link's own address and an API key. Setup for every client
- 3
Sign in and choose what needs your approval
Your client opens Corsair to sign in. Pick a link: the apps your agent can use and a mode that decides what it may do without asking. In the default Cautious mode, Excel's read and write operations run right away and its 5 destructive operations wait for your approval. Strict mode asks before every write and refuses destructive operations, and Read mode allows reads only.
FAQ
Install corsair and @corsair-dev/excel, add the Excel plugin, and connect with OAuth. Then call methods like corsair.excel.api.charts.add() from your app. Corsair stores tokens, and keeps each tenant isolated.
Yes. Excel needs an OAuth app with scopes that match what you automate. Register the app in Excel, configure redirect URLs, then connect through Corsair or managed OAuth in Hub.
Yes. One Corsair client can hit Excel, GitHub, Notion, Stripe, and the rest. Trigger Excel from a webhook, push updates to Slack, or chain actions across plugins. Same tenant context across integrations, plain TypeScript.
Teams use Corsair for read and write Excel workbooks in OneDrive for Business or SharePoint through Microsoft Graph. Common builds include sync jobs, admin tooling, and agents that call Excel APIs from your backend.
The SDK is open source. Self-host and you pay Corsair nothing for the integration layer. Hub bills for hosted auth and execution, not per Excel API call. Hub has a generous free tier. For hobby projects you can probably run the whole thing on free. Paid plans start to matter with more tenants or heavier traffic.
We maintain @corsair-dev/excel in the open repo. When Excel ships API changes, upgrade the package. Your call sites stay typed. You should not need to rewrite the integration layer each time.
No. Corsair does not read your Excel data or hold individual access credentials. Credentials stay in your database. API calls run on your instance. We do not store Excel data on your behalf.
Yes. Add https://mcp.corsair.dev/mcp as a custom connector or MCP server in Claude, ChatGPT, Cursor, VS Code, Claude Code, Codex or any client that supports remote MCP servers with OAuth sign-in, then sign in to Corsair. On ChatGPT personal plans, custom servers currently get read tools only.
Yes. Put Excel on a link in Strict mode and every write waits for your approval, while destructive actions are refused. The default Cautious mode asks only before the 5 destructive Excel operations. You can change a link's mode at hub.corsair.dev/me.