Microsoft Excel MCP Server - Barndoor Documentation
Microsoft Excel
SecureBarndoor Managed Microsoft 365
Summary: Access and update Excel Online workbooks, worksheets, and ranges in OneDrive via Microsoft Graph.
How Teams Use It: The Barndoor-managed Microsoft Excel MCP server enables agents to read and update worksheet data, manage workbooks and tabs in OneDrive, and automate spreadsheet workflows via Microsoft Graph.
Tools
| Tool Name | Tool Description | Tool Type |
|---|---|---|
| add_workbook_worksheet | Add a new worksheet tab to an Excel workbook. | create |
| create_child_item | Create a child folder under a parent OneDrive folder. | create |
| delete_drive_item | Delete a OneDrive file or folder by ID. | delete |
| get_drive_item | Retrieve a OneDrive item by drive and item ID. | read |
| get_drive_root | Retrieve root folder metadata for a Microsoft Graph drive. | read |
| get_my_drive | Retrieve the signed-in user's default OneDrive metadata. | read |
| get_workbook_worksheet | Retrieve worksheet details by worksheet ID or name. | read |
| get_worksheet_range | Retrieve cell values from an A1-style worksheet range. | read |
| get_worksheet_used_range | Retrieve the used range for a worksheet. | read |
| list_item_children | List child files and folders under a parent OneDrive folder. | read |
| list_workbook_worksheets | List worksheets in an Excel workbook stored in OneDrive. | read |
| update_worksheet_range | Update values or formulas in a worksheet range. | update |