# Excel for AI agents. Managed auth, ready-made tools.

> Read and update ranges, worksheets and tables in Excel workbooks on behalf of each of your users.

- Page: https://www.agent200.com/connectors/excel/
- Category: Files and knowledge
- Authentication: Managed OAuth
- Identifier in code: `excel`
- Create an API key: https://agent200.com/platform/apikeys/
- Updated: 2026-11-18

## Instructions for AI agents

Connector: Excel, through Agent200. In code: "excel".
What it does: Read and update ranges, worksheets and tables in Excel workbooks on behalf of each of your users.
Page: https://www.agent200.com/connectors/excel/

1. Get an Agent200 API key. If the developer has none, send them to https://agent200.com/platform/apikeys/ and ask them to choose "Create an API key". Read the key from the AGENT200_API_KEY environment variable. Never ask for it in chat, and never write it into code, prompts or logs.
2. Sign-in is managed OAuth. Each end user approves access once, on Excel's own page, through the authorization link Agent200 returns. Never ask a user for a Excel password or token in chat.
3. Give every request a stable id for the end user. Agent200 uses only that user's own connection.
4. Read tools: excel_list_worksheets, excel_get_range, excel_list_tables. Write tools: excel_update_range, excel_add_worksheet, excel_add_table_rows. Name "excel" in the tools of a request; the model decides which tool to call.
5. Stay within the project's settings. If a tool is turned off or a call is refused, tell the user. Do not work around it.
6. Before a write, confirm with the user, unless they asked for that exact change.
7. For setup with a specific framework, follow its guide:
   https://www.agent200.com/connectors/excel/framework/claude/
   https://www.agent200.com/connectors/excel/framework/chatgpt/
   https://www.agent200.com/connectors/excel/framework/claude-code/
   https://www.agent200.com/connectors/excel/framework/muse/
   https://www.agent200.com/connectors/excel/framework/grok-bot/
   https://www.agent200.com/connectors/excel/framework/openai-dots/
   https://www.agent200.com/connectors/excel/framework/claude-duet/
   https://www.agent200.com/connectors/excel/framework/hermes-agent/
   https://www.agent200.com/connectors/excel/framework/openclaw/

The code on the connector page is a conceptual example of the SDK. SDK reference: https://docs.igpt.ai/

## About

With the Excel connector, your agent works with workbooks stored in each user's own OneDrive or SharePoint. It can list worksheets and tables, read or update a range of cells, add a worksheet and add rows to a table, using only the tools your project allows.

Excel is Microsoft's spreadsheet app for data, calculations and reports.

## Excel tools

- **List worksheets** (`excel_list_worksheets`, read): List the worksheets in a workbook.
- **Read a range** (`excel_get_range`, read): Read the values in a range of cells.
- **Update a range** (`excel_update_range`, write): Write values or formulas to a range of cells.
- **Add a worksheet** (`excel_add_worksheet`, write): Add a new worksheet to a workbook.
- **List tables** (`excel_list_tables`, read): List the tables in a workbook.
- **Add table rows** (`excel_add_table_rows`, write): Append rows to a table.

## Limits you can set

**Turn single tools on or off.** Let the agent read workbooks and add table rows, and switch off `excel_update_range` so it can never overwrite existing cells.

**Restrict what the agent reaches.** Choose the endpoints and scopes a project may use, for example reading files but not writing them. A call outside them is refused.

## Get started

### Step 1: Set up the SDK

Add the Agent200 SDK to the codebase you already have and authenticate with your API key. The key covers every connector enabled for the project.

File `agent.js`:

```js
// One Agent200 API key covers every connector enabled for the project.
const agent200 = new Agent200({
  apiKey: process.env.AGENT200_API_KEY,
});
```

(Conceptual example of the Agent200 SDK.)

### Step 2: Let your user connect Excel

Each end user authorizes their own Excel account once. Agent200 runs the OAuth flow, handles the callback, stores the tokens and refreshes them.

File `connect.js`:

```js
// Each end user authorizes their own Excel account, once.
const connection = await agent200
  .user("user_123")
  .connect("excel");

if (connection.authorizationUrl) {
  // Show this link to your user; Agent200 handles the rest.
  console.log(connection.authorizationUrl);
}
```

(Conceptual example of the Agent200 SDK.)

### Step 3: Run with the Excel tools

Name the user, the model and the tools. The model decides which Excel tools to call, and Agent200 executes them with that user's connection.

File `run.js`:

```js
const result = await agent200
  .user("user_123")
  .run({
    model: "openai/gpt-5.6-sol",
    input: "Read the totals in the Budget sheet of my forecast workbook",
    tools: ["excel"],
  });

console.log(result.output);
```

(Conceptual example of the Agent200 SDK.)

## Sign-in and permissions

**Who signs in.** Each of your users, once, on Microsoft's own sign-in page. You never see or store their Microsoft password.

**What access is requested.** The scopes the connection needs, such as reading or writing their files, listed on Microsoft's consent screen. Users can remove the app later from their Microsoft account settings.

## Example requests

- "Read the totals in the Budget sheet of my forecast workbook"
- "Add this week's sales as a new row in the Orders table"
- "Create a sheet called March in the expenses workbook"

## Guides: Excel with your AI framework

- [Excel + Claude](https://www.agent200.com/connectors/excel/framework/claude.md): Set up Excel for Claude with Agent200, then check which tools are available to your agent.
- [Excel + ChatGPT](https://www.agent200.com/connectors/excel/framework/chatgpt.md): Set up Excel for ChatGPT with Agent200, then check which tools are available to your agent.
- [Excel + Claude Code](https://www.agent200.com/connectors/excel/framework/claude-code.md): Set up Excel for Claude Code with Agent200, then check which tools are available to your agent.
- [Excel + Muse](https://www.agent200.com/connectors/excel/framework/muse.md): Set up Excel for Muse with Agent200, then check which tools are available to your agent.
- [Excel + Grok Bot](https://www.agent200.com/connectors/excel/framework/grok-bot.md): Set up Excel for Grok Bot with Agent200, then check which tools are available to your agent.
- [Excel + OpenAI Dots](https://www.agent200.com/connectors/excel/framework/openai-dots.md): Set up Excel for OpenAI Dots with Agent200, then check which tools are available to your agent.
- [Excel + Claude Duet](https://www.agent200.com/connectors/excel/framework/claude-duet.md): Set up Excel for Claude Duet with Agent200, then check which tools are available to your agent.
- [Excel + Hermes Agent](https://www.agent200.com/connectors/excel/framework/hermes-agent.md): Set up Excel for Hermes Agent with Agent200, then check which tools are available to your agent.
- [Excel + OpenClaw](https://www.agent200.com/connectors/excel/framework/openclaw.md): Set up Excel for OpenClaw with Agent200, then check which tools are available to your agent.

## FAQ

### Who handles the Excel OAuth flow and the tokens?

Agent200. It runs the authorization, handles the callback on its own domain, stores the tokens and refreshes them. You do not build or maintain an OAuth integration for Excel.

### Does my agent act as the end user?

Within what that user authorized, yes. Every request names an end user, and Agent200 uses only that user's Excel connection, never another user's. It cannot reach anything the user or Excel has not authorized.

### Can I limit what my agent can do in Excel?

Yes. You choose which services, endpoints and authorization scopes are allowed in your Agent200 configuration, and the agent works only within them.

## Related connectors

- [Google Drive](https://www.agent200.com/connectors/google-drive.md): Find, read and organize the files in each user's Drive.
- [OneDrive](https://www.agent200.com/connectors/onedrive.md): Search, read, upload and share OneDrive files, including Word, Excel and PowerPoint documents, on behalf of each of your users.
- [Dropbox](https://www.agent200.com/connectors/dropbox.md): Search, read, upload and organize Dropbox files, and create shared links, on behalf of each of your users.
- [Notion](https://www.agent200.com/connectors/notion.md): Search, read and write Notion pages and databases on behalf of each of your users.

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
