Excel
Excel manipulation including data reading/writing, worksheet management, formatting, charts, and pivot table
https://excel.run.tools
How to connect
-
Smithery (hosted)
1. Open https://smithery.ai/servers/excel 2. Click Connect and complete OAuth in your MCP client (Claude, Cursor, VS Code, etc.) 3. MCP endpoint: https://excel.run.tools
Tools (49)
-
EXCEL_ADD_CHARTAdd a chart to a worksheet using Microsoft Graph API.
-
EXCEL_ADD_SHAREPOINT_WORKSHEETAdd a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.
-
EXCEL_ADD_TABLECreate a new table in a worksheet using the Microsoft Graph API.
-
EXCEL_ADD_TABLE_COLUMNAdd a column to a table using Microsoft Graph API.
-
EXCEL_ADD_TABLE_ROWAdd a row to a table using Microsoft Graph API.
-
EXCEL_ADD_WORKBOOK_PERMISSIONTool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.
-
EXCEL_ADD_WORKSHEETAdd a new worksheet to an Excel workbook using Microsoft Graph API.
-
EXCEL_APPLY_TABLE_FILTERApply a filter to a table column using Microsoft Graph API.
-
EXCEL_APPLY_TABLE_SORTApply a sort to a table using Microsoft Graph API.
-
EXCEL_CLEAR_RANGETool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.
-
EXCEL_CLEAR_TABLE_FILTERClear a filter from a table column using Microsoft Graph API.
-
EXCEL_CLOSE_SESSIONTool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks.
-
EXCEL_CONVERT_TABLE_TO_RANGEConvert a table to a range using Microsoft Graph API.
-
EXCEL_CREATE_WORKBOOKTool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.
-
EXCEL_DELETE_TABLE_COLUMNDelete a column from a table using Microsoft Graph API.
-
EXCEL_DELETE_TABLE_ROWDelete a row from a table using Microsoft Graph API.
-
EXCEL_DELETE_WORKSHEETTool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: "Delete 'Sheet2' after review."
-
EXCEL_GET_CHART_AXISTool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.
-
EXCEL_GET_CHART_DATA_LABELSTool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
-
EXCEL_GET_CHART_LEGENDTool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.
-
EXCEL_GET_RANGEGet a range from a worksheet using Microsoft Graph API.
-
EXCEL_GET_SESSIONCreate a session for an Excel workbook using Microsoft Graph API.
-
EXCEL_GET_SHAREPOINT_RANGEGet a range from a worksheet in SharePoint using Microsoft Graph Sites API.
-
EXCEL_GET_SHAREPOINT_WORKSHEETGet a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.
-
EXCEL_GET_TABLE_COLUMNTool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.
-
EXCEL_GET_WORKBOOKTool to retrieve the properties and relationships of a workbook. Use when you need to inspect comments, names, tables, or worksheets.
-
EXCEL_GET_WORKSHEETGet a worksheet by name or ID from an Excel workbook using Microsoft Graph API.
-
EXCEL_INSERT_RANGETool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting.
-
EXCEL_LIST_CHARTSList charts in a worksheet using Microsoft Graph API.
-
EXCEL_LIST_CHART_SERIESTool to list all data series in a chart. Use when you need to enumerate chart series for further analysis.
-
EXCEL_LIST_COMMENTSTool to list comments in an Excel workbook. Use when you need to retrieve all workbook comments via Microsoft Graph API.
-
EXCEL_LIST_FILESList files and folders in a drive root or specified path.
-
EXCEL_LIST_NAMED_ITEMSList named items in a workbook using Microsoft Graph API.
-
EXCEL_LIST_SHAREPOINT_TABLESList tables in a SharePoint worksheet using Microsoft Graph Sites API.
-
EXCEL_LIST_SHAREPOINT_WORKSHEETSList worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.
-
EXCEL_LIST_TABLE_COLUMNSList columns in a table using Microsoft Graph API.
-
EXCEL_LIST_TABLE_ROWSList rows in a table using Microsoft Graph API.
-
EXCEL_LIST_TABLESList tables in a worksheet using Microsoft Graph API. This action retrieves information about all tables present in a specified worksheet of an Excel file. It requires the file ID and worksheet name or ID, and can optionally use a session ID for workbook operations.
-
EXCEL_LIST_WORKBOOK_PERMISSIONSTool to list permissions set on the workbook file. Use when you need to see which users or links have access to a specific Excel file by supplying its drive and item IDs. Example: "List permissions for workbook with drive_id 'b!abc123' and item_id '0123456789abcdef'."
-
EXCEL_LIST_WORKSHEETSList worksheets in an Excel workbook using Microsoft Graph API.
-
EXCEL_MERGE_CELLSMerge cells in a worksheet range using Microsoft Graph API.
-
EXCEL_PROTECT_WORKSHEETTool to protect a worksheet using optional protection options. Use when you need to prevent editing certain parts of a sheet before sharing. Example: "Protect 'Sheet1' to lock formatting and sorting."
-
EXCEL_SORT_RANGESort a range in a worksheet using Microsoft Graph API.
-
EXCEL_UPDATE_CHARTUpdate a chart in a worksheet using Microsoft Graph API.
-
EXCEL_UPDATE_CHART_LEGENDTool to update formatting or position of a chart legend. Use when adjusting legend settings after confirming chart and worksheet exist.
-
EXCEL_UPDATE_RANGEUpdate a range in a worksheet using Microsoft Graph API.
-
EXCEL_UPDATE_SHAREPOINT_RANGEUpdate a range in a SharePoint worksheet using Microsoft Graph Sites API.
-
EXCEL_UPDATE_TABLEUpdate a table in a workbook using Microsoft Graph API.
-
EXCEL_UPDATE_WORKSHEETUpdate worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.