Microsoft Excel
List workbooks and worksheets, read or update ranges, and append table rows
Connect Microsoft Excel when a project needs structured cells from workbooks stored in the authorized account's OneDrive.
Available operations
| Operation | What it does | Permission | Limit per minute |
|---|---|---|---|
list_workbooks | Lists up to 50 .xlsx files | Read files | 30 |
list_worksheets | Lists worksheets in one workbook | Read files | 30 |
get_range | Reads one worksheet range | Read files | 30 |
update_range | Replaces values in one worksheet range | Manage files | 10 |
add_table_rows | Appends rows to one workbook table | Manage files | 10 |
A write accepts at most 100 rows, 50 columns per row, and 2,000 cells. Cells can contain a string, finite number, boolean, or null.
Connect Microsoft Excel
An administrator first configures Microsoft OAuth application and enables Microsoft Excel under Admin > Settings > Integrations.
Ask the AI for the exact workbook ownership and range behavior. Examples:
- “Read
Summary!A1:D20from our shared operations workbook.” - “Let each signed-in user append an expense row to a table in their own workbook.”
Choose Connect new, approve read or manage access, then select Continue. A published app-user connection also requires the app's final HTTPS origin.
Verify Microsoft Excel
- Create a disposable workbook with a worksheet named
Connector test. - List workbooks and worksheets, then record their IDs.
- Read
A1:B2and confirm the returned values. - Write a unique marker to a disposable range and confirm it in Excel.
- Restore the original cell values.
The connector writes cell values, not formulas, formatting, charts, macros, or workbook structure. Use a narrow range because update_range replaces the supplied cells. If Microsoft reports that a workbook is locked or throttled, close conflicting edit sessions and retry after the provider's retry period.