Excel MCP for AI Agents

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

1

Install Composio

typescript

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

Install the Composio SDK and Claude Agent SDK

2

Create Tool Router Session

typescript

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

const composio = new Composio({ apiKey: 'your-api-key' });

console.log("Creating Tool Router session...");
const { mcp } = await composio.create('your-user-id');
console.log(`Tool Router session created: ${mcp.url}`);

Initialize the Composio client and create a Tool Router session

3

Connect to AI Agent

typescript

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

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: mcp.url,
    headers: { 'x-api-key': 'your-composio-api-key' }
  }
});

const tools = await client.tools();

const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{ role: 'user', content: 'Add a chart to Q2 sales worksheet' }],
  stopWhen: stepCountIs( 5 )
});

console.log(`Agent: ${text}`);

Use the MCP server with your AI agent

SETUP GUIDE

Connect Excel API Tool with your Agent

1

Install Composio

typescript

npm install @composio/openai

Install the Composio SDK

2

Initialize Composio and Create Tool Router Session

typescript

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

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');

Import and initialize Composio client, then create a Tool Router session

3

Execute Excel Tools via Tool Router with Your Agent

typescript

const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'Insert a new row into the "Sales" table with today\'s data'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);

Get tools from Tool Router session and execute Excel actions with your Agent

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

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.

Addressfinder

Api Key

Addressfinder is a data quality platform for verifying addresses, emails, and phone numbers. It helps you ensure accurate customer and contact data every time.

Agentql

Api Key

Agentql is a toolkit that connects AI agents to the web using a specialized query language. It enables structured web interaction and data extraction for smarter automations.

FAQ

Frequently asked questions

No, you can get started immediately using Composio's built-in Excel app. For production, we recommend configuring your own OAuth credentials.

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

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

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

Start with Excel.It takes 30 seconds.

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

Start building

Customer stories

Teams ship real agents on Composio

GET STARTED FOR FREE BOOK A DEMO

Karan skipped his own birthday party to fix our critical issue. It was 10pm and he diverted his Waymo to help us instead. This really sets the bar — it shows the commitment you need when users rely on your software.

Harsha Gaddipati

Co-founder, Slashy

A lot of students tell us that the moment their connected tools start talking to each other inside Opennote feels almost magical. The agent just knows them, and it's immensely helped keep new users on the platform.

Abhi Arya

Co-founder, Opennote

We chose Composio over Pipedream because it delivered depth where it mattered — niche tools and tricky edge cases other platforms simply ignored. That gave us confidence to scale without compromising.

Nirman Dave

CEO, Zams

As a solo builder, shipping fast is life or death. The only way I can outcompete incumbents is by outmanoeuvring them. Getting bogged down managing agent auth would have been a death sentence.

Ryan Yu

Founder, Extra Thursday

Before Composio, adding tool integrations was slow and resource-intensive. Each one could take weeks of engineering time, and maintaining them meant constantly keeping up with API changes.

Tomisin Jenrola

Founder & CEO, SwarmZero

With hands-on help from their founder, we integrated Gmail and Google Drive in just 30 minutes. This level of personal support and commitment is exactly what startups should strive for.

Jerome Leclanche

Co-Founder, Ingram Technologies

Excel MCP for AI Agents

Try Excel now

Supported Tools

Connect Excel MCP Tool with your Agent

Install Composio

Create Tool Router Session

Connect to AI Agent

Connect Excel API Tool with your Agent

Install Composio

Initialize Composio and Create Tool Router Session

Execute Excel Tools via Tool Router 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

ChatGPT

OpenAI Agents SDK

Claude Agents SDK

Claude Code

Claude Cowork

Codex

Cursor

VS Code

OpenCode

OpenClaw

Hermes

CLI

Google ADK

Langchain

AI SDK

Mastra AI

LlamaIndex

CrewAI

Pydantic AI

Autogen

Explore Other Toolkits

21risk

Abstract

Addressfinder

Agentql

Frequently asked questions

Do I need my own developer credentials to use Excel with Composio?+

Can I use multiple toolkits together?+

Is Composio secure?+

What if the API changes?+

Start with Excel.It takes 30 seconds.

Teams ship real agents on Composio