List workbooks, worksheets, and tables in OneDrive, read cell ranges, and write ranges or append rows.
| Category | โ Productivity |
| Connection | โก OAuth 2.0 one-click |
| Actions | 21 total โ 15 read, 6 write |
Once connected, Microsoft Excel exposes the following actions. The AI can call them with #-mentions in chat, an agent can be granted a subset as tools, and a workflow can run them in an integration-action node.
| Action | Type | What it does | Proxy |
|---|---|---|---|
Add Defined Nameadd-defined-name | Write | Create a workbook-level defined name (named range or formula). | Yes |
Add Tableadd-table | Write | Create a table from an existing range. | Yes |
Append Rowappend-row | Write | Append a row to a workbook table. | Yes |
Delete Defined Namedelete-defined-name | Write | Delete a workbook-level defined name. | Yes |
Delete Workbookdelete-workbook | Write | Delete a workbook file. | Yes |
Describe Workbookdescribe-workbook | Read | Read a workbook file's name, link, size and type, and the kind of drive it is stored in (a personal OneDrive, a OneDrive for work or school, or a SharePoint library). | Yes |
Get Chart Pictureget-range-chart-image | Read | Draw a chart over a range of a worksheet and keep its picture as a PNG document, without adding the chart to the workbook. Answers with the stored picture, never its bytes. | Yes |
Get Site Driveget-site-drive | Read | Get the default document library (drive) for a SharePoint site. | Yes |
Get Used Rangeget-used-range | Read | Read every filled cell of a worksheet in one go โ the smallest range that holds all of its data โ with its values, displayed text, formulas and number formats, and the address it spans. | Yes |
Get User Driveget-user-drive | Read | Get a user's personal OneDrive (drive). | Yes |
Get Workbookget-workbook | Read | Retrieve driveItem metadata for a workbook. | Yes |
List Defined Nameslist-defined-names | Read | List workbook-level defined names. | Yes |
List Driveslist-drives | Read | List the drives you can reach: your own OneDrive and drives shared with you, or the document libraries of a SharePoint site. | Yes |
List Siteslist-sites | Read | List the SharePoint sites you can open, to find a workbook stored on one. | Yes |
List Table Rowslist-table-rows | Read | Read the rows of a workbook table, with the table's column names, a page at a time. | Yes |
List Tableslist-tables | Read | List defined tables in a workbook. | Yes |
List Workbookslist-workbooks | Read | List .xlsx workbooks in your OneDrive, in another drive you can reach, or in a SharePoint document library. | Yes |
List Worksheetslist-worksheets | Read | List worksheets in a workbook. | Yes |
Read Rangeread-range | Read | Read a cell range from a worksheet: its values, its displayed text, its formulas and its number formats. | Yes |
Try Values Without Savingwhat-if | Read | Write values or formulas into a temporary copy of a workbook that Excel never saves, let Excel recalculate, and read the results. The workbook itself does not change. | Yes |
Write Rangewrite-range | Write | Write a 2D array of values or formulas into a worksheet range. Excel recalculates the workbook. | Yes |
Actions tagged Write create, update, or delete data. In chat and agent paths they pause for your confirmation before running; workflows treat their deterministic wiring as implicit consent. Agent tools covers how to scope which actions an agent may use.
Microsoft Excel is governed per organization: an admin sets a monetary spend cap and a monthly call quota. A quota of 0 disables the integration โ it never means unlimited. See the Integrations overview for the full governance model.