Microsoft Excel MCP connector
Updated
Authentication type
- OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.
Uses
Use the Microsoft Excel MCP connector to perform the following actions:
- Track sales orders and inventory counts across shared Microsoft Excel workbooks
- Log new leads or support tickets directly into Microsoft Excel tables
- Update budget figures automatically as new expenses come in
- Sync project task lists between workflows and Microsoft Excel worksheets
- Pull financial figures from Microsoft Excel ranges for quick reviews
- Organize customer records into structured tables for easy lookup
- Automate recurring data entry into Microsoft Excel without manual copying
- Build and maintain multiple worksheets for different departments or projects
Example prompts
Use the following example prompts to invoke Microsoft Excel MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all open invoices from last month in Microsoft Excel.Add a new row for today's sales to my Microsoft Excel tracker.List all worksheets in my quarterly budget workbook.Create a new worksheet for Q3 expenses in Microsoft Excel.Pull the data from cells A1 to D20 in my Microsoft Excel sheet.Add a new customer to the contacts table in Microsoft Excel.Update the status column for row 5 in my project tracker.Delete the outdated worksheet from my Microsoft Excel workbook.Find the row for order number 1042 in my Microsoft Excel table.Create a table to track employee onboarding tasks in Microsoft Excel.
Microsoft Excel MCP connector tools
The Microsoft Excel MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| microsoftexcel_microsoftexcelcreaterow_invoke | Add a new row to an existing Microsoft Excel workbook |
| getWorkbook | Get workbook |
| listWorksheets | List worksheets |
| createWorksheet | Create worksheet |
| getWorksheet | Get worksheet |
| updateWorksheet | Update worksheet |
| deleteWorksheet | Delete worksheet |
| getRange | Get range |
| updateRange | Update range |
| listTables | List tables |
| createTable | Create table |
| getTable | Get table |
| updateTable | Update table |
| deleteTable | Delete table |
| listTableRows | List table rows |
| addTableRow | Add table row |
| getTableRow | Get table row |
| updateTableRow | Update table row |
| deleteTableRow | Delete table row |
