Sign in Book a demo
Back to Tools
Productivity & Docs OAuth
Build Your Agent View Excel Documentation
microsoft-excel logo

Microsoft Excel MCP Tools for AI Agents

Let an agent find workbooks, read and aggregate worksheet data, flag data issues, update cells, and manage worksheets in OneDrive.

Available Tools

17 tools available in this integration

MicrosoftExcel.AddWorksheet

Add a new worksheet to the workbook.

MicrosoftExcel.AggregateWorksheet

Summarize a worksheet by grouping rows and computing per-group aggregates in one call.

MicrosoftExcel.CreateOrEditWorkbook

Create a new .xlsx workbook or edit an existing one in OneDrive for Business.

MicrosoftExcel.CreateWorkbook

Create a new Excel workbook (.xlsx) in OneDrive for Business.

MicrosoftExcel.DeleteWorksheet

Delete a worksheet from the workbook.

MicrosoftExcel.GetWorkbookMetadata

Get a workbook's structure: worksheets, named ranges, and optionally extents and objects.

MicrosoftExcel.GetWorksheetData

Read cell values from a worksheet.

MicrosoftExcel.ListWorkbookComments

List a workbook's comments, or the replies on a specific comment thread.

MicrosoftExcel.ReadWorksheet

Read a worksheet range with the detail you choose, with guardrails for large sheets.

MicrosoftExcel.RenameWorksheet

Rename an existing worksheet in the workbook.

MicrosoftExcel.ReplyToWorkbookComment

Post a plain-text reply to an existing comment thread on a workbook.

MicrosoftExcel.ScanForDataIssues

Scan a worksheet (or the whole workbook) for data-quality problems as a structured list.

MicrosoftExcel.SearchWorkbooks

Find Excel workbooks in OneDrive by keyword or folder, returning their item_ids.

MicrosoftExcel.UpdateCell

Update a single cell value in an Excel workbook.

MicrosoftExcel.UpdateRange

Update multiple cells in a worksheet using sparse dict format.

MicrosoftExcel.UploadWorkbook

Upload a complete .xlsx file into OneDrive for Business, preserving it byte-for-byte.

MicrosoftExcel.WhoAmI

Get information about the current user and their Microsoft Excel environment.

Why agent-optimized tools matter

Built for intent, not API schemas

Ask the agent to "find the workbook for this quarter, inspect its structure, and update the forecast tab." Arcade helps it use the right Microsoft Excel actions without guessing workbook IDs, worksheet names or cell ranges.

Up to 100x fewer tokens

Microsoft Excel reads return workbook structure, matching files, or scoped worksheet ranges instead of forcing the agent to load an entire workbook. It gets the context needed to act without filling the model with unrelated cells.

Complete the workflow end to end

Find the workbook, inspect its worksheets, read the relevant range, update the necessary cells, and review the result through one toolkit designed around the complete spreadsheet task.

Make actions predictable and controlled

Arcade tools return structured results and useful errors across users and runs. Teams can apply scope restrictions, redaction, and approval policies so agents follow the same controls every time.

Securing Microsoft Excel

The more capabilities agents get, the more useful they are. However, more capabilities bring more risks of undesired effects such as data loss and exfiltration.

This is why Arcade provides you with contextual rules that dictate how and when a tool is allowed to run. Arcade’s contextual access lets you govern tool visibility and behavior at every stage of execution and control who can see a tool, what inputs are allowed, and what comes back.

Learn about Contextual Access Policies

For Microsoft Excel, you can implement some of these policies:

Access when tools are listed for a user
  • Hide MicrosoftExcel.CreateOrEditWorkbook from agents unless the roles your IDP marks as workbook owners are active, so unapproved automation cannot alter shared financial models.
  • Restrict MicrosoftExcel.DeleteWorksheet to agents operating under your spreadsheet-admin role, so a regular user cannot remove a worksheet and its formulas from a shared workbook.
  • Deny MicrosoftExcel.UploadWorkbook to agents outside your approved data-operations roles, so an unreviewed file cannot replace a trusted workbook in OneDrive for Business.
Pre-execution before each tool call
  • Require human approval before MicrosoftExcel.UpdateRange changes cells in workbooks marked as approved budgets, so an agent cannot overwrite committed figures without review.
  • Block MicrosoftExcel.ReplyToWorkbookComment when the reply contains customer records, credentials, or confidential project details, so an agent cannot publish private data to a shared comment thread.
  • Require human approval before MicrosoftExcel.RenameWorksheet changes a worksheet named for a reporting period or external deliverable, so linked processes do not break silently.
Post-execution after the tool returns
  • Redact MicrosoftExcel.ReadWorksheet results for columns matching your payroll, bank-account, tax-ID, or employee-personal-data patterns before they reach the model.
  • Strip cell values from MicrosoftExcel.GetWorksheetData when the requested range is in a workbook labeled Confidential, returning only the sheet and range metadata to the model.
  • Redact comment text and reply bodies from MicrosoftExcel.ListWorkbookComments, removing email addresses, phone numbers, and customer identifiers before the model sees the discussion.

How to use Microsoft Excel with your agent

Connect Microsoft Excel to an MCP client with Arcade's guided setup. Each end user authorizes their own Microsoft account, so the agent works with the workbooks that user can access.

Your questions, answered

A Microsoft Excel MCP server exposes Excel capabilities as structured actions an AI agent can call through the Model Context Protocol. After a user authorizes their Microsoft account, the agent can inspect workbooks, read worksheet data, update cells, and manage supported workbook content.

Arcade provides the MCP runtime for Microsoft Excel with per-user OAuth, approval policies, response redaction, and tool visibility controls. It gives agents a governed path to search OneDrive for workbooks, inspect sheets, read ranges, and make authorized changes from supported clients.

Arcade agents can find workbooks in OneDrive for Business, inspect workbook structure, read worksheet ranges, aggregate rows, scan for data issues, create or upload workbooks, add or rename worksheets, update cells and ranges, manage worksheets, and reply to workbook comments. They do not cover every Excel feature, such as arbitrary formula editing or full workbook automation.

Permissions depend on the actions your workflow enables. Read-only workflows need Microsoft permissions to find and read the user's OneDrive workbooks and Excel data; creating, uploading, editing, deleting worksheets, or replying to comments requires the corresponding write permissions. Grant the narrowest permissions that support the workflow.

Yes. Each user authorizes their own Microsoft account through OAuth. Excel actions run under that user's authorization, so the agent can access only the workbooks and permissions that user has approved.

Yes. Contextual Access policies can require human approval before consequential Microsoft Excel actions such as changing cell values, uploading or replacing a workbook, deleting a worksheet, or replying to a comment. The call proceeds only after the policy's conditions are satisfied.

Arcade proxies Microsoft Excel and OneDrive API calls and does not persist your workbook content as part of normal tool execution. OAuth credentials are brokered and stored encrypted at rest, and the model never receives raw credentials.

Any framework or client that can connect to Arcade's MCP gateway or tool APIs works, including LangChain, OpenAI Agents, CrewAI, Claude Desktop, Claude Code, Cursor, Visual Studio Code, Microsoft Copilot Studio, and GitHub Copilot.

Arcade refreshes access while the user's Microsoft authorization remains valid. If access is revoked, rotated, or can no longer be refreshed, Excel actions stop until the user reconnects the account.

Microsoft Graph, OneDrive, and Excel API rate limits and service quotas still apply to actions performed through Arcade. The available details do not specify a separate Microsoft Excel call quota or per-action limit.

Ready to actually ship your agent?

Connect your agent to Microsoft Excel with managed OAuth, agent-optimized tools and approval controls for consequential actions.

Build Your Agent Read the Microsoft Excel Quickstart