Excel MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Excel MCP or direct API to read spreadsheets, update cells, generate summaries, and automate data workflows through natural language.

Get started for free Get a demo

Excel

Oauth2S2s Oauth2

Microsoft Excel is a robust spreadsheet application for organizing, analyzing, and visualizing data. It's the go-to tool for calculations, reporting, and flexible data management.

54 Tools

Try Excel now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND

Excel

Enter ↵

Try asking

TOOLS

Supported Tools

Every Excel action and event your agent gets out of the box.

Add Chart

Add a chart to a worksheet using Microsoft Graph API.

Add SharePoint Worksheet

Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.

Add Table

Create a new table in a worksheet using the Microsoft Graph API.

Add Table Column

Add a column to a table using Microsoft Graph API.

Add Table Row

Add a row to a table using Microsoft Graph API.

Add Workbook Permission

Tool to grant access to a workbook via invite.

Add Worksheet

Add a new worksheet to an Excel workbook using Microsoft Graph API.

Apply Table Filter

Apply a filter to a table column using Microsoft Graph API.

Apply Table Sort

Apply a sort to a table using Microsoft Graph API.

Clear Range

Tool to clear values, formats, or contents in a specified worksheet range.

Clear Table Filter

Clear a filter from a table column using Microsoft Graph API.

Close Excel Session

Tool to close an existing Excel workbook session.

Convert Table To Range

Convert a table to a range using Microsoft Graph API.

Create Workbook

Tool to create a new Excel workbook file at a specified drive path.

Delete Table Column

Delete a column from a table using Microsoft Graph API.

Delete Table Row

Delete a row from a table using Microsoft Graph API.

Delete Worksheet

Tool to delete a worksheet from the workbook.

Export Workbook to PDF

Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion.

Get Chart Axis

Tool to retrieve a specific axis from a chart.

Get Chart Data Labels

Tool to retrieve the data labels object of a chart.

Get Chart Legend

Tool to retrieve the legend object of a chart.

Get Range

Get a range from a worksheet using Microsoft Graph API.

Create Excel Session

Create a session for an Excel workbook using Microsoft Graph API.

Get SharePoint Range

Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.

Get SharePoint Worksheet

Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.

Get table column

Tool to retrieve a specific column from a workbook table.

Get workbook

Tool to retrieve the properties and relationships of a workbook.

Get Worksheet

Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.

Get Worksheet Used Range

Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address.

Insert Range

Tool to insert a new cell range into a worksheet, shifting existing cells down or right.

List Charts

List charts in a worksheet using Microsoft Graph API.

List Chart Series

Tool to list all data series in a chart.

List Comments

Tool to list comments in an Excel workbook.

List Drive Item Children

Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId.

List Drive Files

List files and folders in a drive root or specified path.

List Named Items

List named items in a workbook using Microsoft Graph API.

List SharePoint Tables

List tables in a SharePoint worksheet using Microsoft Graph Sites API.

List SharePoint Worksheets

List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.

List Table Columns

List columns in a table using Microsoft Graph API.

List Table Rows

List rows in a table using Microsoft Graph API.

List Tables

List tables in a worksheet using Microsoft Graph API.

List Workbook Permissions

Tool to list permissions set on the workbook file.

List Worksheets

List worksheets in an Excel workbook using Microsoft Graph API.

Merge Cells

Merge cells in a worksheet range using Microsoft Graph API.

Protect Worksheet

Tool to protect a worksheet using optional protection options.

Search Drive Files

Tool to search OneDrive drive items by query to discover Excel workbook IDs.

Sort Range

Sort a range in a worksheet using Microsoft Graph API.

Update Chart

Update a chart in a worksheet using Microsoft Graph API.

Update Chart Legend

Tool to update formatting or position of a chart legend.

Update Range

Update a range in a worksheet using Microsoft Graph API.

Update SharePoint Range

Update a range in a SharePoint worksheet using Microsoft Graph Sites API.

Update Table

Update a table in a workbook using Microsoft Graph API.

Update Worksheet

Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

Upload Workbook from URL

Tool to upload an external Excel file from a URL into OneDrive/SharePoint.

SETUP GUIDE

Connect Excel MCP Tool with your Agent

Install Composio

typescript

npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai

Install the Composio SDK and your agent framework

Create a session with MCP enabled

typescript

import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["excel"],
  mcp: true,
});

Create a session scoped to Excel and read its MCP URL and headers

Connect your agent to the MCP server

typescript

import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "Insert a new row into the \"Sales\" table with today's data",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();

Pass the session's MCP URL and headers to your agent and run a Excel request

SETUP GUIDE

Connect Excel API Tool with your Agent

Install Composio

typescript

npm install @composio/core @composio/openai openai

Install the Composio SDK, the OpenAI provider, and the OpenAI SDK

Create a Composio session

typescript

import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["excel"] });
const tools = await session.tools();

Initialize Composio with the OpenAI Responses provider and create a session scoped to Excel

Run Excel tools with your agent

typescript

let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "Insert a new row into the \"Sales\" table with today's data" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);

Send a request, execute the Excel tool calls through the session, and print the final answer

Why Use Composio?

AI Native Excel Integration

Supports both Excel MCP and direct API based integrations
Structured, LLM-friendly schemas for reliable tool execution
Rich coverage for reading, writing, and querying your Excel data

Managed Auth

Built-in OAuth handling with automatic token refresh and rotation
Central place to manage, scope, and revoke Excel access
Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

Tools are tuned using real error and success rates to improve reliability over time
Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

Fine-grained RBAC so you control which agents and users can access Excel
Scoped, least privilege access to Excel resources
Full audit trail of agent actions to support review and compliance

FRAMEWORKS

Use Excel with any AI Agent Framework

Choose a Framework you want to connect Excel with

Claude Code

Use Excel MCP with Claude Code

Cursor

Use Excel MCP with Cursor

ChatGPT

Use Excel MCP with ChatGPT

Claude Cowork

Use Excel MCP with Claude Cowork

Antigravity

Use Excel MCP with Antigravity

OpenAI Agents SDK

Use Excel MCP with OpenAI Agents SDK

Claude Agents SDK

Use Excel MCP with Claude Agents SDK

Grok Bot

Use Excel MCP with Grok Bot

Codex

Use Excel MCP with Codex

Kimi Code

Use Excel MCP with Kimi Code

Grok Build

Use Excel MCP with Grok Build

VS Code

Use Excel MCP with VS Code

OpenCode

Use Excel MCP with OpenCode

OpenClaw

Use Excel MCP with OpenClaw

Hermes

Use Excel MCP with Hermes

Atomic Agent

Use Excel MCP with Atomic Agent

CLI

Use Excel MCP with CLI

Google ADK

Use Excel MCP with Google ADK

Langchain

Use Excel MCP with Langchain

AI SDK

Use Excel MCP with AI SDK

Mastra AI

Use Excel MCP with Mastra AI

LlamaIndex

Use Excel MCP with LlamaIndex

CrewAI

Use Excel MCP with CrewAI

Pydantic AI

Use Excel MCP with Pydantic AI

Autogen

Use Excel MCP with Autogen

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

21risk

Api Key

21RISK is a web app built for easy checklist, audit, and compliance management. It streamlines risk processes so teams can focus on what matters.

Abstract

Api Key

Abstract provides a suite of APIs for automating data validation and enrichment tasks. It helps developers streamline workflows and ensure data quality with minimal effort.

AccuWeather

Api Key

AccuWeather is a global weather service providing current conditions, forecasts, MinuteCast precipitation, alerts, and lightning data. Use it for fast, localized forecasts and real-time weather alerts.

Adafruit IO

Api Key

Adafruit IO is Adafruit's cloud platform for connected device and IoT project data. It helps you store, visualize, and act on sensor feeds without running your own backend.

FAQ

Frequently asked questions

No. Composio provides a managed OAuth app for Excel, so you sign in with your normal Excel account and approve access. If you later want the consent screen to show your own company name, you can add your own Excel OAuth app in the Composio dashboard, and every connection after that uses it.

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Yes. Composio is SOC 2 Type II compliant and is built to keep your Excel connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.

Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

When you connect a Excel account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Excel as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.

Exactly the ones Excel lists on its consent screen when you connect. Review that screen before approving. If you connect a work account, your Excel administrator may need to approve the app first, and you can revoke the access inside Excel whenever you want.

Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Excel connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.

Composio refreshes Excel tokens automatically, so day to day you do nothing. If you revoke access inside Excel, or Excel invalidates the session, the connection shows as expired in Composio and the agent stops acting on that account until you reconnect it, which is a single sign-in.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, and up to 20,000 of those can run through Composio-managed apps like Excel. Personal Excel use rarely gets near that. Paid plans add higher limits and team features, and Excel's own pricing is unaffected.

Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Excel accounts).

With Composio, you connect Excel once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.

Start with Excel.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Excel tool your agent needs.Free to start.

Start building

Excel MCP server for AI agents and assistants

Try Excel now

Supported Tools

Connect Excel MCP Tool with your Agent

Install Composio

Create a session with MCP enabled

Connect your agent to the MCP server

Connect Excel API Tool with your Agent

Install Composio

Create a Composio session

Run Excel tools with your agent

Why Use Composio?

AI Native Excel Integration

Managed Auth

Agent Optimized Design

Enterprise Grade Security

Use Excel with any AI Agent Framework

Claude Code

Cursor

ChatGPT

Claude Cowork

Antigravity

OpenAI Agents SDK

Claude Agents SDK

Grok Bot

Codex

Kimi Code

Grok Build

VS Code

OpenCode

OpenClaw

Hermes

Atomic Agent

CLI

Google ADK

Langchain

AI SDK

Mastra AI

LlamaIndex

CrewAI

Pydantic AI

Autogen

Rolling this out across your team?

Explore Other Toolkits

21risk

Abstract

AccuWeather

Adafruit IO

Frequently asked questions

Do I need my own Excel developer credentials or OAuth app?+

Can I use multiple toolkits together?+

Is Composio secure with my Excel account?+

What if the API changes?+

Does the agent act as me inside Excel?+

Which Excel permissions does Composio get?+

Can I use multiple Excel accounts with Claude and ChatGPT?+

What happens when my Excel access expires or I revoke it?+

Does using Excel through Composio cost extra?+

How is Composio different from the Excel connectors already built into Claude and ChatGPT?+

Start with Excel.It takes 30 seconds.