How to integrate Excel MCP with Hermes

Add a chart to a worksheet using Microsoft Graph API.

Add Named Item

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

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 folder under a parent Microsoft Graph drive item.

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

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.

Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion.

Get Excel Application

Get chart

Tool to retrieve a specific axis from a chart.

Get chart component

Tool to retrieve the data labels object of a chart.

Get chart 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.

Get Named Item Range

Get Excel Operation Status

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 a SharePoint Excel workbook using Microsoft Graph Sites API.

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.

Tool to retrieve the properties and relationships of a workbook.

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

Get Worksheet Protection

Read a zero-based worksheet row bounded to columns containing values.

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.

Tool to list all data series in a chart.

List replies to one workbook comment.

Tool to list comments in an Excel workbook.

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 API.

List Pivot Tables

List tables in a SharePoint worksheet using Microsoft Graph Sites API.

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 worksheet using Microsoft Graph API.

Tool to list permissions set on the workbook file.

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

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.

Tool to search OneDrive drive items by query to discover Excel workbook IDs.

Search OneDrive and SharePoint content using Microsoft Search.

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

Set chart data

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 chart component

Tool to update formatting or position of a chart legend.

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 a range in a worksheet using Microsoft Graph API.

Update exactly one formatting component on a workbook range.

Update a range in a SharePoint worksheet using Microsoft Graph Sites API.

Update a table in a workbook using Microsoft Graph API.

Update 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.