Tool | What It Does | Example Use |
---|---|---|
Create Workbook | Create a new Excel workbook in OneDrive or SharePoint | ”Create a workbook named Marketing_Budget_2025.xlsx in my OneDrive Documents folder and return the workbook ID” |
List Worksheets | List all worksheets in a workbook | ”List worksheets in workbook ID abc123 and return worksheet names and IDs” |
Add Worksheet | Add a new worksheet to a workbook | ”In workbook ID abc123 add a worksheet called Summary and return the new worksheet ID” |
Read Worksheet | Read data from a worksheet | ”Read range A1:D50 from worksheet ID sheet789 and return the values” |
Update Cells | Update cell values in a worksheet | ”In worksheet ID sheet789 set range B2:D2 to ['North','South','East'] and return the updated range” |
Search Data | Get data from a specific range | ”From worksheet ID sheet789 get range A1:F100 and return the values” |
Add Row | Append a new row to a worksheet | ”Add row ['Acme Inc', 25000, 'Closed Won'] to worksheet ID sheet789 and return the new row number” |
Add Table | Create a table in a worksheet | ”Create a table named SalesData on worksheet ID sheet789 covering A1:D100 and return the table ID” |
Add Table Row | Add a row to an existing table | ”In table ID tbl456 add row ['West', 'Q2', 14000] and return the row index” |
Find Row | Locate a row by column value | ”Find the row in worksheet ID sheet789 where column B equals Acme Inc and return the row number” |
Find Or Create Row | Find a row or create it if missing | ”Find or create a row in worksheet ID sheet789 where column A equals Beta Corp and return the row number” |
Update Row | Update an existing row | ”In worksheet ID sheet789 update row 25 with ['Gamma Co', 32000, 'Negotiation'] and return the updated values” |
Delete Worksheet Row | Delete a row from a worksheet | ”Delete row 10 from worksheet ID sheet789 and confirm deletion” |
List Tables | List all tables in a workbook | ”List tables in workbook ID abc123 and return table names and IDs” |
Get Table | Get table metadata | ”Get table ID tbl456 metadata and return column names” |
List Table Rows | List rows in a table | ”List rows 1-20 in table ID tbl456 and return all cell values” |
Add Table Column | Add a column to a table | ”In table ID tbl456 add column Forecast and return the column index” |
Update Table Column | Update data in a table column | ”In table ID tbl456 update column Forecast rows 1-10 to 0 and return affected rows” |
Delete Table | Delete a table object (data stays) | “Delete table ID tbl456 and confirm deletion” |
Download Workbook | Get a download URL for the workbook | ”Generate a download link for workbook ID abc123 and return the URL” |
Search Workbooks | Search workbooks in OneDrive and SharePoint | ”Search my OneDrive for workbooks with name containing Q4_Report and return workbook links” |
Create Your Excel MCP Node
Add Your Prompt
Test Your Node
Save and Reuse
Step 1: Create Workbook
Step 2: Add Worksheet
Step 3: Add Table
Empty Outputs
Incorrect Results
Errors
Iterate with Request Changes