Excel MCP server for AI agents and assistants

Add a chart to a worksheet using Microsoft Graph API.

Add a workbook- or worksheet-scoped named item using an invariant reference or a local formula.

Add a new worksheet to an Excel workbook in a SharePoint site's default drive using Microsoft Graph.

Create a new table in a worksheet using the Microsoft Graph API.

Add a column to a table using Microsoft Graph API.

Add a row to a table using Microsoft Graph API.

Tool to grant access to a workbook via invite.

Add a new worksheet to an Excel workbook using Microsoft Graph API.

Apply a filter to a table column using Microsoft Graph API.

Apply a sort to a table using Microsoft Graph API.

Autofit columns or rows intersecting a workbook range.

Run one allowlisted Microsoft Graph v1.

Calculate Excel Workbook

Tool to clear values, formats, or contents in a specified worksheet range.

Clear a filter from a table column using Microsoft Graph API.

Clear All Table Filters

Clear Table Sort

Tool to close an existing Excel workbook session.

Convert a table to a range using Microsoft Graph API.

Create a non-destructive asynchronous copy of a file or folder.

Create a plain-text Excel cell comment through Microsoft Graph beta.

Create a folder under a parent Microsoft Graph drive item.

Create a resumable upload session at a drive-root path.

Tool to create a new Excel workbook file at a specified drive path.

Create or retrieve an application-owned sharing link for a workbook.

Move a OneDrive or SharePoint drive item to the recycle bin by item ID.

Permanently delete a workbook-scoped named item; this cannot be undone.

Delete worksheet cells and shift the remaining cells up or left.

Permanently delete an Excel table by its ID or name.

Delete a column from a table using Microsoft Graph API.

Delete a row from a table using Microsoft Graph API.

Tool to delete a worksheet from the workbook.

Download an Excel workbook in its original file format.

Export an Excel workbook to PDF using Microsoft Graph format conversion, returning a download URL.

Get Excel Application

Get chart

Tool to retrieve a specific axis from a chart.

Retrieve one Excel chart component: chart title, axis title, supported gridlines, axis font, or supported line format.

Tool to retrieve the data labels object of a chart.

Render an Excel chart as a base64-encoded image.

Tool to retrieve the legend object of a chart.

Get chart point

Get chart series

Retrieve one workbook comment by its exact ID.

Retrieve one reply to a workbook comment by its exact ID.

Return a range derived from another range by navigation or geometry.

Retrieve OneDrive or SharePoint drive item metadata by exact ID or path.

Retrieve a workbook-scoped named item by exact name.

Retrieve the Excel range of a range-valued workbook-scoped named item.

Get the status of an asynchronous Excel workbook operation by its operation ID.

Get Pivot Table

Read selected properties from a worksheet range, its used range, or worksheet protection.

Get a range from a worksheet using Microsoft Graph API.

Read one formatting component from a workbook range.

Create a session for an Excel workbook using Microsoft Graph API.

Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.

Get a worksheet by name or ID from an Excel workbook in a SharePoint site's default drive using Microsoft Graph.

Retrieve one workbook- or worksheet-addressed table by ID or exact name.

Tool to retrieve a specific column from a workbook table.

Read one cell by row within a selected table column's data body.

Get Table Column Range

Get Table Range

Get Table Row

Get Table Row Range

Get Table Sort

Read cells visible after worksheet filtering.

Retrieve a workbook's relationships, including comments, named items, operations, tables, and worksheets, with optional relationship expansion.

Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.

Get Worksheet Protection

Read a zero-based worksheet row across the column bounds of the worksheet's values-only used range.

Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address.

Tool to insert a new cell range into a worksheet, shifting existing cells down or right.

List chart points

List charts in a worksheet using Microsoft Graph API.

List a page of data series names in a chart, with a next-page link when more results are available.

List replies to one workbook comment.

List a page of comments in an Excel workbook using Microsoft Graph.

Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId.

List retained versions of a OneDrive or SharePoint workbook file.

List files and folders in a drive root or specified path.

List named items in a workbook using Microsoft Graph.

List Pivot Tables

List tables in a worksheet of an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.

List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.

List SharePoint lists in a known Microsoft Graph site.

List columns in a table using Microsoft Graph API.

List rows in a table using Microsoft Graph API.

List tables in a specified Excel worksheet using Microsoft Graph API.

Tool to list permissions set on the workbook file.

List tables across a workbook without requiring a worksheet identifier.

List worksheets in an Excel workbook using Microsoft Graph API.

Merge cells in a worksheet range using Microsoft Graph API.

Tool to protect a worksheet using optional protection options.

Reapply All Table Filters

Reapply Table Sort

Refresh Pivot Tables

Refresh Excel Session

Resolve a Microsoft Graph share token, shareId, or raw sharing URL to DriveItem metadata.

Remove a non-inherited sharing permission from a workbook.

Create, update, or delete drive or workbook resources in up to 20 requests; inspect every subresponse status because individual mutations can fail.

Read drive or workbook data in up to 20 GET requests; inspect every subresponse status because individual requests can fail.

Search OneDrive drive items by query and return files, optionally filtered by extension, to discover Excel workbook IDs.

Search OneDrive and SharePoint content using Microsoft Search.

Search SharePoint sites by free-text query for workbook discovery.

Replace an Excel chart's source range and optionally choose whether rows or columns define its series.

Set chart position

Sort a range in a worksheet using Microsoft Graph API.

Split a merged worksheet range back into separate cells.

Remove protection from a worksheet so it can be edited again.

Update a chart in a worksheet using Microsoft Graph API.

Update one Excel chart component: an axis, data labels, chart title, axis title, supported gridlines, axis font, fill, or supported line format.

Update a chart legend's visibility, position, or overlay setting.

Rename one Excel chart series by ID or zero-based collection position.

Rename, move within the same drive, or update client timestamps for a DriveItem by stable ID.

Update a workbook named item's visibility or comment.

Update cell values in a specified worksheet range using Microsoft Graph API.

Update exactly one formatting component on a workbook range.

Update values in a worksheet range in an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.

Update an Excel workbook table's name, header visibility, totals visibility, or style using Microsoft Graph.

Update the name or values of an Excel table column.

Update raw values in a table column's data-body cells by zero-based index.

Update Table Row

Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

Tool to upload an external Excel file from a URL into OneDrive/SharePoint.

Return the identity (email, name) of the connected Excel (Microsoft) account.