< Back to all integrations

Microsoft Excel 365

Project Management & Productivity

Connect AI agents and workflows to Excel 365: tables, rows, ranges, worksheets, charts and named items in workbooks on OneDrive and SharePoint.

Book a demo
[ Microsoft Excel 365 + engini ]

Microsoft Excel 365 for AI agents and workflows.

engini lets your AI agents and workflows work in Excel 365 workbooks on OneDrive and SharePoint: read and update ranges, add and delete table rows and columns, create tables and worksheets, filter and sort, add and update charts and read them as images, and work with named items. Finance still runs on spreadsheets; engini connects them to the systems of record behind them. Connect from Claude, ChatGPT or Cursor over MCP, from your code, or build in Workflow Studio.

MCPPython and TypeScript SDKCLIREST APIWorkflow Studio
Read the Microsoft Excel 365 guide →
ReachWorkbooks, worksheets, tables, ranges, charts and named items
WhereWorkbooks in OneDrive and SharePoint drives
SessionsWorkbook sessions for many changes in one go
[ 01 / What agents can do ]

What your agent can do in Microsoft Excel 365. Every tool is one you allow or leave out.

The Microsoft Excel 365 tools in engini, grouped by what they change. Read tools are safe to hand out widely. Write and delete tools go only to the agents that need them.

Read

Get Range, Get Table Rows, Get Table Columns, Get Tables

Read the data.

Read
Get Workbooks, Get Workbook, Get Worksheets, Get Worksheet, Get Named Items

Find workbooks and sheets.

Read
Get Charts, Get Chart Image

Read charts, as data or as an image.

Read
Get Groups, Get Group's Drive Id, Get Site's Drives

Find the drive that holds a workbook.

Read

Write

Update Range, Add Table Row, Add Table Column, Update Table

Write data.

Write
Create Table, Add Worksheet, Update Worksheet, Add Named Item

Build structure.

Write
Sort Range, Sort Table, Filter Table Column, Clear Table Filter

Sort and filter.

Write
Add Chart, Update Chart

Chart the data.

Write
Create Workbook Session, Close Workbook Session

Group many changes in one session.

Write

Delete

Delete Table Row, Delete Table Column, Delete Worksheet

Remove rows, columns or sheets.

Delete

Any endpoint

Send API Request

Call the Microsoft Graph Excel API, with the sign-in added for you.

Any call

Triggers

There are no Excel triggers. Start the workflow on a schedule, or when a file changes in OneDrive.

[ 02 / Connect your agent ]

Connect your AI agent to Microsoft Excel 365. Four ways in, one set of permissions.

MCP

Claude, ChatGPT, Cursor

Create an MCP server in engini with your Microsoft Excel 365 connection and only the tools you choose. Add its address to your client and sign in through engini. There is no key to copy.

MCP client setup →
SDK

Python and TypeScript

Hand your agent a toolset of Microsoft Excel 365 tools. The SDK gives OpenAI and Anthropic models the tools in the format they expect and runs the ones they pick.

SDK guide →
CLI

For coding agents

The engini CLI connects Microsoft Excel 365 and runs its tools from a terminal, with machine-readable output, so an AI coding agent can drive it without getting stuck.

CLI guide →
REST API

Any language

Every Microsoft Excel 365 tool is an endpoint. Call it with exact inputs from a scheduled job or a sync, with no model in the loop.

API reference →
MCP in four steps
In engini, connect Microsoft Excel 365 and create an MCP server with that connection and the tools this agent may use.
Claude: Settings, Connectors, Add custom connector, then paste the server address.
Cursor: add the address to .cursor/mcp.json. Claude Code: claude mcp add.
Sign in through engini when the client asks. The agent sees only the tools you chose.
Cursor, connected to Microsoft Excel 365 through engini
// .cursor/mcp.json: Cursor, connected to Microsoft Excel 365 through engini
{
"mcpServers": {
"engini-microsoft-excel-365": {
"url": "<your engini MCP server address>"
}
}
}

Create the MCP server in engini with your Microsoft Excel 365 connection and the tools this agent may use, then paste its address. The client signs in through engini on first use. Claude, VS Code and other clients take the same address: see the MCP client setup guide.

Try asking your agent
“Add yesterday's invoices from NetSuite to the AR tracker.”
“What is the total in the Q3 forecast table by region?”
“Sort the vendor list by spend.”
“Update the FX rates range with today's rates.”
“Send me the revenue chart as an image.”
“Which rows in the budget table are over plan?”

Each request runs through the Microsoft Excel 365 tools in the agent's toolset or MCP server. If a tool is not allowed, the agent cannot call it.

[ 03 / What teams build ]

What teams build on Microsoft Excel 365. Agents and workflows, across systems.

Finance

Trackers that fill themselves

Every morning, add yesterday's invoices and payments from the ERP to the team's Excel tracker.

NetSuiteMicrosoft Excel 365
FP&A

Actuals into the model

Actuals from SAP or Dynamics 365 update the forecast workbook, and the chart goes to Teams.

SAP S/4HANAMicrosoft Excel 365Microsoft Teams
Operations

A workbook as the input

Rows added to a shared workbook become records in the ERP, and the row gets the record number.

Microsoft Excel 365NetSuite
Analytics

Questions about a workbook

An agent in Claude reads a workbook and answers questions. Its toolset holds read tools only.

Microsoft Excel 365Claude

Every integration runs both ways, so any of these flows can also run in reverse. These are examples, not the limit: any flow between Microsoft Excel 365 and another system engini connects is available.

[ 04 / Agent Policy ]

You decide what each agent may do in Microsoft Excel 365. engini enforces it on every call.

Toolsets

Only the tools you allow

A toolset lists the Microsoft Excel 365 tools an agent may call and the connection each one uses. Give one agent read tools only and another the write it needs. engini refuses any call outside the toolset.

MCP servers

Scoped when you set them up

An MCP server exposes only the connections and tools chosen when it is created, and engini shows who uses each server.

Identity

Whose permissions apply

Connect a person's own Microsoft Excel 365 account and engini acts as that person, with their Microsoft Excel 365 permissions. Use a shared integration account and it acts as that account. Every run is recorded under the user who started it.

Credentials

Kept out of prompts

Your agent never needs your credentials: engini stores them and adds them when it runs each call, so keys stay out of prompts and tool inputs.

Audit

Every call on record

Every call lands in History and the audit log, which you can export or stream to your SIEM.

Environments

Test before production

Workspaces keep teams apart, and development, staging and production environments keep a test agent away from live data.

SOC 2 Type IIISO 27001GDPRSecurity at engini →
[ 05 / Set up ]

Connect Microsoft Excel 365 in three steps. Then decide what each agent may do.

Step 01

Sign in to Microsoft Excel 365

Add an Excel 365 connection and sign in with your Microsoft account, then point the tools at a workbook in OneDrive or SharePoint.

Step 02

Choose the tools

Add the connection to an MCP server or a toolset with only the tools each agent needs.

Step 03

Build or ask

Use the connection as a step in a workflow, or ask your agent to work in Microsoft Excel 365 from Claude, ChatGPT, Cursor or your own code.

Full Microsoft Excel 365 setup guide →
[ 06 / Questions ]

Microsoft Excel 365 and engini. Straight answers.

Can an AI agent write to Microsoft Excel 365, or only read?

Both. engini has tools to update ranges, add and delete rows and columns, create tables and worksheets, sort, filter and chart. Whether a given agent may use them is up to you: give it a toolset or an MCP server with read tools only, and it cannot call the rest.

Does the agent act as me in Microsoft Excel 365?

It acts as the Microsoft account behind the connection, with that account's access to workbooks. Every run is recorded under the person who started it.

What if the tool I need is not listed?

Use Send API Request to call any Microsoft Excel 365 API endpoint through the same connection, and give it only to the agents that need it.