How to integrate Excel MCP with OpenClaw

OpenClaw is the fastest growing agent harness out there, which can work 24/7 to automate almost any kind of tasks. However, its capabilities are limited to the tools it has access to. Composio allows your OpenClaw to access Excel with authentication management handled for you. You can execute actions on Excel via your favorite OpenClaw interface (Telegram, WhatsApp, TUI, etc), whichever you prefer.

Get started for freeGet a demo
Excel logoExcel
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

Introduction

OpenClaw is the fastest growing agent harness out there, which can work 24/7 to automate almost any kind of tasks. However, its capabilities are limited to the tools it has access to. Composio allows your OpenClaw to access Excel with authentication management handled for you. You can execute actions on Excel via your favorite OpenClaw interface (Telegram, WhatsApp, TUI, etc), whichever you prefer.

Also integrate Excel with

ChatGPTOpenAI Agents SDKClaude Agent SDKClaude CodeClaude CoworkCodexOpenCodeCursorVS CodeHermesCLIGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAI

Why use Composio?

Apart from a managed and hosted MCP server, you will get:

  • Programmatic tool calling allows LLMs to write its code in a remote workbench to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
  • Handling Large tool responses out of LLM context to minimize context rot.
  • Dynamic just-in-time access to 20,000 tools across 1000+ other Apps for cross-app workflows. It loads the tools you need, so LLMs aren't overwhelmed by tools you don't need.

How to install Excel with OpenClaw

Using Composio API Key and Setup Prompt

Copy the setup prompt from the OpenClaw dashboard
  • Run it in your OpenClaw chat interface.
  • Authenticate Excel from the dashboard
  • Go back to your OpenClaw interface and start asking questions.

Using OpenClaw/Composio Plugin

1. Install OpenClaw Composio plugin

bash
openclaw plugins install @composio/openclaw-plugin

2. Copy the API Key from dashboard.composio.dev

3. Setup OpenClaw Config

bash
openclaw config set plugins.entries.composio.config.consumerKey "ck_your_key_here"

4. Restart OpenClaw

bash
openclaw gateway restart

5. Go to your chat interface and start asking questions.

6. When prompted, authenticate the app and you're all set.

How It Works

The plugin connects to Composio's MCP server at https://connect.composio.dev/mcp and registers all available tools directly into the OpenClaw agent. Tools are called by name — no extra search or execute steps needed.

If a tool returns an auth error, the agent will prompt you to connect that toolkit at dashboard.composio.dev.

Configuration

bash
{
  "plugins": {
    "entries": {
      "composio": {
        "enabled": true,
        "config": {
          "consumerKey": "ck_your_key_here"
        }
      }
    }
  }
}
OptionDescriptionDefault
enabledEnable or disable the plugintrue
consumerKeyYour Composio consumer key (ck_...)—
mcpUrlMCP server URL (advanced)https://connect.composio.dev/mcp

What is the Excel MCP server, and what's possible with it?

The Excel MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Excel account. It provides structured and secure access to your spreadsheets, so your agent can perform actions like adding data, creating tables, managing worksheets, generating charts, and sharing workbooks on your behalf.

  • Automated data entry and updates: Let your agent add rows, columns, or clear specific ranges in any worksheet—keeping your data fresh, organized, and accurate.
  • Effortless table and worksheet management: Direct your agent to create tables, add new worksheets, or organize data structures for seamless tracking and reporting.
  • Dynamic chart generation: Have your agent visualize your data instantly by adding charts to any worksheet for quick insights and analysis.
  • Advanced filtering and sorting: Ask your agent to apply filters or custom sorts to tables, making it easy to focus on what matters most in your datasets.
  • Secure sharing and permission control: Empower your agent to grant access or update permissions on workbooks, ensuring your team can collaborate safely and efficiently.

Conclusion

You've successfully integrated Excel with OpenClaw using Composio plugin. Now interact with Excel directly from your terminal, Web UI, or any messenger app using natural language commands.

Key benefits of this setup:

  • Seamless integration across TUI, Web UIs, and Messenger apps like Telegram, WhatsApp, Slack, etc.
  • Natural language commands for Excel operations
  • Managed authentication through Composio
  • Access to 20,000+ tools across 1000+ apps for cross-app workflows
  • Programmatic tool calling for complex tool chaining

Next steps:

  • Try asking OpenClaw to perform various Excel operations
  • Explore cross-app workflows by connecting more toolkits like Calendar, Slack, Notion, etc.
  • Build complex automation scripts that leverage OpenClaw's 24/7 running capabilities
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.

FRAMEWORKS

How to build Excel MCP Agent with another framework

ChatGPT logo

ChatGPT

Use Excel MCP with ChatGPT

OpenAI Agents SDK logo

OpenAI Agents SDK

Use Excel MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use Excel MCP with Claude Agent SDK

Claude Code logo

Claude Code

Use Excel MCP with Claude Code

Claude Cowork logo

Claude Cowork

Use Excel MCP with Claude Cowork

Codex logo

Codex

Use Excel MCP with Codex

Cursor logo

Cursor

Use Excel MCP with Cursor

Hermes logo

Hermes

Use Excel MCP with Hermes

CLI logo

CLI

Use Excel MCP with CLI

Google ADK logo

Google ADK

Use Excel MCP with Google ADK

LangChain logo

LangChain

Use Excel MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Excel MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Excel MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Excel MCP with LlamaIndex

CrewAI logo

CrewAI

Use Excel MCP with CrewAI

OpenCode logo

OpenCode

Use Excel MCP with OpenCode

VS Code logo

VS Code

Use Excel MCP with VS Code

FAQ

Frequently asked questions

With a standalone Excel MCP server, the agents and LLMs can only access a fixed set of Excel tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Excel and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. OpenClaw fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Excel tools.

Yes, absolutely. You can configure which Excel scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Excel data and credentials are handled as safely as possible.

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 FREEBOOK A DEMO
agent.aiZoomLettaGleanHubSpotAWSWabi

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
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
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
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
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
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
Jerome Leclanche
Co-Founder, Ingram Technologies