Excel MCP Server
Connect to the Excel MCP server to find workbooks, read and write cells, and manage rows and tables across OneDrive and SharePoint using AI agents on Gumloop, Claude, or Cursor.
Try Excel now
Type what you want done. Sign in and run it live with an AI agent.
|
Excel
Installation
Get StartedCreate a Gumloop Account
To use this MCP, you need a Gumloop account. If you don't have one yet, you can create one for free.
Copy Your Server URL
Copy your MCP server URL and add it to your client. You'll be prompted to authorize on first use.
Tools (21)
Create Workbook
Create a new Excel workbook in OneDrive or SharePoint
List Worksheets
List all worksheets in an Excel workbook
Add Worksheet
Add a new worksheet to an Excel workbook
Read Worksheet
Read data from a worksheet
Update Cells
Update cell values in a worksheet
Search Data
Get data from a specific range in Excel worksheet (e.g., A1:D10)
Add Row
Add a row to the end of a worksheet
Add Table
Create a new table in a worksheet
Add Table Row
Add a row to a table
Find Row
Find a row by column value
Find Or Create Row
Find a row by column value or create it if not found
Update Row
Update a specific row in a worksheet
What is Excel MCP?
The Excel MCP server gives AI agents read and write access to your Microsoft Excel workbooks in OneDrive and SharePoint. That means agents can search for workbooks, read a range of cells, write values back, append and update rows, and build structured tables, all through the Microsoft Graph API. It connects to the spreadsheets your team already keeps in Microsoft 365, so an agent can update a tracker or pull numbers out of a report instead of waiting on someone to open the file.
Anyone who lives in spreadsheets knows the busywork: opening a workbook to paste in this week’s numbers, hunting for the right row to update, and re-keying data from one tool into another. The Excel MCP server hands those tasks to an AI agent that can find the workbook, read the range, write the values, and add the row. Describe what you need, and your AI agent will update the spreadsheet for you.
MCP stands for Model Context Protocol, an open standard that lets AI agents call external tools. Normally, working with Excel through the Microsoft Graph API means registering an Entra ID app, requesting the right scopes, and refreshing access tokens on your own. Gumloop wraps all of that behind a hosted server: authorize your Microsoft account once. After that, you can read cells, write rows, and manage tables just by asking your AI agent to do it for you, in plain language.
Related MCP servers
Google Sheets MCP Server
Read, write and update your Google Sheets
Airtable MCP Server
Interact with Airtable bases and records
Word MCP Server
Interact with Microsoft Word documents stored in OneDrive
Google Docs MCP Server
Create and manage Google Docs documents
Google Drive MCP Server
Search and access files in Google Drive
Notion MCP Server
Server for interacting with Notion
What you can do with Excel MCP on Gumloop
Find workbooks across OneDrive and SharePoint
Search for .xlsx workbooks by keyword, so an agent can locate the right file without needing a file ID up front.
Create workbooks and worksheets
Create a new workbook in a OneDrive or SharePoint folder, and add worksheets to an existing workbook.
Read any range of cells
Pull the values from a worksheet’s used range or a specific range such as A1:D10.
Write values to cells
Update any cell range with a grid of values, so an agent can populate a report or fill in results.
Work with rows
Append a row, find a row by a column value, update a row by its index, or delete a row. A find-or-create option inserts a row only when a matching one does not already exist, which is handy for deduplication.
Build and manage tables
Turn a range into a structured Excel table, list tables and their rows, add a column, and remove a table when it is no longer needed.
Download a workbook
Get a download URL for any workbook in your Microsoft storage.
Work across OneDrive and SharePoint
The server detects whether your files live in OneDrive or SharePoint and adapts automatically.
How to connect the Gumloop Excel MCP Server
- 1
Create a free Gumloop account
Sign up at gumloop.com. No credit card required.
- 2
Add the Excel MCP server
Copy your MCP server URL from Gumloop and add it to your preferred client (Claude, Cursor, or Gumloop workflows). You'll authorize on first use.
- 3
Start using Excel in your AI workflows
That's it. Your AI agent can now find workbooks, read and write cells, and manage rows and tables. Use it inside a Gumloop automation, in Claude Desktop, or in Cursor.
Excel MCP use cases
Populate recurring reports for ops teams
An agent pulls this period’s numbers from another system, writes them into the right range, and appends a summary row, so the weekly workbook updates itself.
Deduplicate records for RevOps
Using find-or-create, an agent looks up a row by email or account ID and inserts it only if it is missing, keeping a tracker clean without manual checks.
Extract spreadsheet data for analysts
An agent reads a range from a workbook, summarizes the figures, and posts the recap to Slack or a Google Doc, chaining Excel with the rest of your stack.
Log intake into a worksheet
When a request arrives by email or form, an agent appends a row with the details, so every submission lands in the spreadsheet automatically.
Stand up a tracker for project managers
An agent creates a workbook, adds a worksheet, and builds a structured table with headers, so a new tracker is ready to fill in one run.
Why use Gumloop for Excel MCP
Connect once, no code
Working with Excel through the Microsoft Graph API directly means registering an Entra ID app, requesting scopes, and refreshing tokens yourself. With Gumloop you authorize your Microsoft account one time and your access refreshes automatically. No app registration, API key, or code required.
Works with multiple MCP clients
Use the same hosted Excel MCP server in Gumloop, Claude, Cursor, and other MCP-compatible clients. Same server URL, works with any MCP client.
Chain Excel with 100+ integrations
An agent can read a record from your CRM, write it into a workbook, and post a confirmation to Slack, all in a single run.
Enterprise-grade hosting
Gumloop hosts the server for you, and your files stay in your own OneDrive or SharePoint while the server respects your existing Microsoft permissions. See trust.gumloop.com for security details.
Free to start
Gumloop has a free tier so you can try the Excel MCP server at no cost. Paid plans start at $37/month.
Frequently asked questions
Ship Excel agents in minutes
Connect any AI agent to 100+ MCP servers, fully hosted, zero setup.