Home/Docs/Microsoft Excel
โœ…Productivity

Microsoft Excel

List workbooks, worksheets, and tables in OneDrive, read cell ranges, and write ranges or append rows.

Categoryโœ… Productivity
Connectionโšก OAuth 2.0 one-click
Actions21 total โ€” 15 read, 6 write
๐Ÿ”ŒConnectFind it in the catalogue
๐Ÿ”AuthorizeOne-click OAuth
โœจUse actionsChat ยท agents ยท workflows
How Microsoft Excel fits into Your Office AI

Actions

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.

ActionTypeWhat it doesProxy
Add Defined Name
add-defined-name
WriteCreate a workbook-level defined name (named range or formula).Yes
Add Table
add-table
WriteCreate a table from an existing range.Yes
Append Row
append-row
WriteAppend a row to a workbook table.Yes
Delete Defined Name
delete-defined-name
WriteDelete a workbook-level defined name.Yes
Delete Workbook
delete-workbook
WriteDelete a workbook file.Yes
Describe Workbook
describe-workbook
ReadRead 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 Picture
get-range-chart-image
ReadDraw 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 Drive
get-site-drive
ReadGet the default document library (drive) for a SharePoint site.Yes
Get Used Range
get-used-range
ReadRead 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 Drive
get-user-drive
ReadGet a user's personal OneDrive (drive).Yes
Get Workbook
get-workbook
ReadRetrieve driveItem metadata for a workbook.Yes
List Defined Names
list-defined-names
ReadList workbook-level defined names.Yes
List Drives
list-drives
ReadList the drives you can reach: your own OneDrive and drives shared with you, or the document libraries of a SharePoint site.Yes
List Sites
list-sites
ReadList the SharePoint sites you can open, to find a workbook stored on one.Yes
List Table Rows
list-table-rows
ReadRead the rows of a workbook table, with the table's column names, a page at a time.Yes
List Tables
list-tables
ReadList defined tables in a workbook.Yes
List Workbooks
list-workbooks
ReadList .xlsx workbooks in your OneDrive, in another drive you can reach, or in a SharePoint document library.Yes
List Worksheets
list-worksheets
ReadList worksheets in a workbook.Yes
Read Range
read-range
ReadRead a cell range from a worksheet: its values, its displayed text, its formulas and its number formats.Yes
Try Values Without Saving
what-if
ReadWrite 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 Range
write-range
WriteWrite a 2D array of values or formulas into a worksheet range. Excel recalculates the workbook.Yes
โ„น๏ธ
Write actions are confirmation-gated

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.

Spend & quota

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.