Can AI agents automate Microsoft Excel?
Microsoft · hybrid · productivityspreadsheetsoffice-suite
Excel has broad, maintained automation paths, but no single path spans every edition. Microsoft Graph provides REST create, read, update, and delete operations for tables, ranges, charts, and other objects in OOXML workbooks stored on business OneDrive, SharePoint, or Group drives. Office Scripts, Office.js add-ins, VBA, the Excel Online (Business) connector, and Power Automate for desktop cover cloud workflow and local application automation. The Graph path is preferred for agents because it avoids a desktop session; consumer OneDrive and legacy .xls workbooks are outside its documented coverage. MCP and computer-use paths remain unassessed.
Best path today: api · Overall automatability: 7/10
Modalities
| Modality | Status | Detail |
|---|---|---|
| API | yes | restmicrosoft-identity-platform coverage: partial · docs |
| SDK | yes | javascript official: yes |
| MCP | unknown | verdict: unknown |
| Integrations | yes | power_automate |
| CLI | unknown | |
| Extensibility | yes | office-scriptsoffice-js-add-insvba webhooks: unknown |
| Data access | export: graph-workbook-json · import: graph-workbook-json | |
| RPA / UI automation | good | compower-automate-desktop Power Automate for desktop has first-party actions to launch or attach to Excel, read and write worksheets, manipulate tables, run macros, and save workbooks. Desktop automation requires a local Excel session, and Microsoft warns against concurrent modification and direct automation of cloud-synchronised files.
|
| Computer use | unknown | measured verdicts only — "unknown" means not yet probed by us |
Scores
| api | mcp | integrations | cli | rpa | computer use | overall |
|---|---|---|---|---|---|---|
| 7 | — | 6 | — | 7 | — | 7 |
Evidence
| Fact | Tier | Source | Date |
|---|---|---|---|
homepage | declared | source | 2026-08-16 |
platforms | declared | source | 2026-08-16 |
license | declared | source | 2026-08-16 |
modalities.api.exists | declared | source | 2026-08-16 |
modalities.api.kinds[0] | declared | source | 2026-08-16 |
modalities.api.auth[0] | declared | source | 2026-08-16 |
modalities.api.coverage | declared | source | 2026-08-16 |
modalities.sdk.exists | declared | source | 2026-08-16 |
modalities.sdk.languages[0] | declared | source | 2026-08-16 |
modalities.sdk.official | declared | source | 2026-08-16 |
modalities.integrations.power_automate | declared | source | 2026-08-16 |
modalities.extensibility.scripting[0] | declared | source | 2026-08-16 |
modalities.extensibility.scripting[1] | declared | source | 2026-08-16 |
modalities.extensibility.scripting[2] | declared | source | 2026-08-16 |
modalities.data_access.export[0] | declared | source | 2026-08-16 |
modalities.data_access.import[0] | declared | source | 2026-08-16 |
modalities.rpa.ui_stack[0] | declared | source | 2026-08-16 |
modalities.rpa.drivability | declared | source | 2026-08-16 |
modalities.rpa.vendor_support[0] | declared | source | 2026-08-16 |
verdict.scores.api | declared | source | 2026-08-16 |
verdict.scores.integrations | declared | source | 2026-08-16 |
verdict.scores.rpa | declared | source | 2026-08-16 |
freshness.watch[0].url | declared | source | 2026-08-16 |
freshness.watch[1].url | declared | source | 2026-08-16 |
freshness.watch[2].url | declared | source | 2026-08-16 |
Last verified 2026-08-16 · volatility medium · JSON record