# Excel

```json
{
  "name": "Excel",
  "slug": "excel",
  "url": "https://composio.dev/toolkits/excel",
  "markdown_url": "https://composio.dev/toolkits/excel.md",
  "logo_url": "https://logos.composio.dev/api/excel",
  "categories": [
    "data & analytics"
  ],
  "is_composio_managed": true,
  "updated_at": "2026-05-12T10:10:57.727Z"
}
```

![Excel logo](https://logos.composio.dev/api/excel)

## Description

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.

## Summary

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.

## Categories

- data & analytics

## Toolkit Details

- Tools: 54
- Managed auth: Managed by Composio

## Images

- Logo: https://logos.composio.dev/api/excel

## Authentication

- **Oauth2**
  - Type: `oauth2`
  - Description: Oauth2 authentication for Excel.
  - Setup:
    - Configure Oauth2 credentials for Excel.
    - Use the credentials when creating an auth config in Composio.
- **S2s Oauth2**
  - Type: `custom`
  - Description: S2s Oauth2 authentication for Excel.
  - Setup:
    - Configure S2s Oauth2 credentials for Excel.
    - Use the credentials when creating an auth config in Composio.

## Suggested Prompts

- Add sales data row to Q2 table
- Create bar chart from revenue column
- Share this workbook with my manager
- Clear outdated entries from worksheet range

## Supported Tools

| Tool slug | Name | Description |
|---|---|---|
| `EXCEL_ADD_CHART` | Add Chart | Add a chart to a worksheet using Microsoft Graph API. |
| `EXCEL_ADD_SHAREPOINT_WORKSHEET` | Add SharePoint Worksheet | Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API. |
| `EXCEL_ADD_TABLE` | Add Table | Create a new table in a worksheet using the Microsoft Graph API. |
| `EXCEL_ADD_TABLE_COLUMN` | Add Table Column | Add a column to a table using Microsoft Graph API. |
| `EXCEL_ADD_TABLE_ROW` | Add Table Row | Add a row to a table using Microsoft Graph API. |
| `EXCEL_ADD_WORKBOOK_PERMISSION` | Add Workbook Permission | Tool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles. |
| `EXCEL_ADD_WORKSHEET` | Add Worksheet | Add a new worksheet to an Excel workbook using Microsoft Graph API. |
| `EXCEL_APPLY_TABLE_FILTER` | Apply Table Filter | Apply a filter to a table column using Microsoft Graph API. |
| `EXCEL_APPLY_TABLE_SORT` | Apply Table Sort | Apply a sort to a table using Microsoft Graph API. |
| `EXCEL_CLEAR_RANGE` | Clear Range | Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data. |
| `EXCEL_CLEAR_TABLE_FILTER` | Clear Table Filter | Clear a filter from a table column using Microsoft Graph API. |
| `EXCEL_CLOSE_SESSION` | Close Excel Session | Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both active and already-closed sessions. This action validates the session first and returns an error for invalid or already-closed sessions to provide clearer user feedback. The validation uses refreshSession which is the only API endpoint that can detect closed sessions. |
| `EXCEL_CONVERT_TABLE_TO_RANGE` | Convert Table To Range | Convert a table to a range using Microsoft Graph API. |
| `EXCEL_CREATE_WORKBOOK` | Create Workbook | Tool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive. |
| `EXCEL_DELETE_TABLE_COLUMN` | Delete Table Column | Delete a column from a table using Microsoft Graph API. |
| `EXCEL_DELETE_TABLE_ROW` | Delete Table Row | Delete a row from a table using Microsoft Graph API. |
| `EXCEL_DELETE_WORKSHEET` | Delete Worksheet | Tool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: "Delete 'Sheet2' after review." |
| `EXCEL_EXPORT_WORKBOOK_TO_PDF` | Export Workbook to PDF | Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching. |
| `EXCEL_GET_CHART_AXIS` | Get Chart Axis | Tool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis. |
| `EXCEL_GET_CHART_DATA_LABELS` | Get Chart Data Labels | Tool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart. |
| `EXCEL_GET_CHART_LEGEND` | Get Chart Legend | Tool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting. |
| `EXCEL_GET_RANGE` | Get Range | Get a range from a worksheet using Microsoft Graph API. |
| `EXCEL_GET_SESSION` | Create Excel Session | Create a session for an Excel workbook using Microsoft Graph API. |
| `EXCEL_GET_SHAREPOINT_RANGE` | Get SharePoint Range | Get a range from a worksheet in SharePoint using Microsoft Graph Sites API. |
| `EXCEL_GET_SHAREPOINT_WORKSHEET` | Get SharePoint Worksheet | Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API. |
| `EXCEL_GET_TABLE_COLUMN` | Get table column | Tool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name. |
| `EXCEL_GET_WORKBOOK` | Get workbook | Tool to retrieve the properties and relationships of a workbook. Use when you need to inspect comments, names, tables, or worksheets. |
| `EXCEL_GET_WORKSHEET` | Get Worksheet | Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API. |
| `EXCEL_GET_WORKSHEET_USED_RANGE` | Get Worksheet Used Range | Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells. |
| `EXCEL_INSERT_RANGE` | Insert Range | Tool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting. |
| `EXCEL_LIST_CHARTS` | List Charts | List charts in a worksheet using Microsoft Graph API. |
| `EXCEL_LIST_CHART_SERIES` | List Chart Series | Tool to list all data series in a chart. Use when you need to enumerate chart series for further analysis. |
| `EXCEL_LIST_COMMENTS` | List Comments | Tool to list comments in an Excel workbook. Use when you need to retrieve all workbook comments via Microsoft Graph API. |
| `EXCEL_LIST_DRIVE_ITEM_CHILDREN` | List Drive Item Children | Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support. |
| `EXCEL_LIST_FILES` | List Drive Files | List files and folders in a drive root or specified path. |
| `EXCEL_LIST_NAMED_ITEMS` | List Named Items | List named items in a workbook using Microsoft Graph API. |
| `EXCEL_LIST_SHAREPOINT_TABLES` | List SharePoint Tables | List tables in a SharePoint worksheet using Microsoft Graph Sites API. |
| `EXCEL_LIST_SHAREPOINT_WORKSHEETS` | List SharePoint Worksheets | List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API. |
| `EXCEL_LIST_TABLE_COLUMNS` | List Table Columns | List columns in a table using Microsoft Graph API. |
| `EXCEL_LIST_TABLE_ROWS` | List Table Rows | List rows in a table using Microsoft Graph API. |
| `EXCEL_LIST_TABLES` | List Tables | List tables in a worksheet using Microsoft Graph API. This action retrieves information about all tables present in a specified worksheet of an Excel file. It requires the file ID and worksheet name or ID, and can optionally use a session ID for workbook operations. |
| `EXCEL_LIST_WORKBOOK_PERMISSIONS` | List Workbook Permissions | Tool to list permissions set on the workbook file. Use when you need to see which users or links have access to a specific Excel file by supplying its drive and item IDs. Example: "List permissions for workbook with drive_id 'b!abc123' and item_id '0123456789abcdef'." |
| `EXCEL_LIST_WORKSHEETS` | List Worksheets | List worksheets in an Excel workbook using Microsoft Graph API. |
| `EXCEL_MERGE_CELLS` | Merge Cells | Merge cells in a worksheet range using Microsoft Graph API. |
| `EXCEL_PROTECT_WORKSHEET` | Protect Worksheet | Tool to protect a worksheet using optional protection options. Use when you need to prevent editing certain parts of a sheet before sharing. Example: "Protect 'Sheet1' to lock formatting and sorting." |
| `EXCEL_SEARCH_FILES` | Search Drive Files | Tool to search OneDrive drive items by query to discover Excel workbook IDs. Use when you need to find Excel files by name before performing workbook operations. |
| `EXCEL_SORT_RANGE` | Sort Range | Sort a range in a worksheet using Microsoft Graph API. |
| `EXCEL_UPDATE_CHART` | Update Chart | Update a chart in a worksheet using Microsoft Graph API. |
| `EXCEL_UPDATE_CHART_LEGEND` | Update Chart Legend | Tool to update formatting or position of a chart legend. Use when adjusting legend settings after confirming chart and worksheet exist. |
| `EXCEL_UPDATE_RANGE` | Update Range | Update a range in a worksheet using Microsoft Graph API. |
| `EXCEL_UPDATE_SHAREPOINT_RANGE` | Update SharePoint Range | Update a range in a SharePoint worksheet using Microsoft Graph Sites API. |
| `EXCEL_UPDATE_TABLE` | Update Table | Update a table in a workbook using Microsoft Graph API. |
| `EXCEL_UPDATE_WORKSHEET` | Update Worksheet | Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API. |
| `EXCEL_UPLOAD_WORKBOOK` | Upload Workbook from URL | Tool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations. |

## Supported Triggers

None listed.

## Installation and MCP Setup

### Path 1: SDK Installation

#### Path 1, Step 1: Install Composio

Install the Composio SDK
```python
pip install composio_openai
```

```typescript
npm install @composio/openai
```

#### Path 1, Step 2: Initialize Composio and Create Tool Router Session

Import and initialize Composio client, then create a Tool Router session
```python
from openai import OpenAI
from composio import Composio
from composio_openai import OpenAIResponsesProvider

composio = Composio(provider=OpenAIResponsesProvider())
openai = OpenAI()
session = composio.create(user_id='your-user-id')
```

```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');
```

#### Path 1, Step 3: Execute Excel Tools via Tool Router with Your Agent

Get tools from Tool Router session and execute Excel actions with your Agent
```python
tools = session.tools
response = 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'
  }]
)
result = composio.provider.handle_tool_calls(
  response=response,
  user_id='your-user-id'
)
print(result)
```

```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);
```

### Path 2: MCP Server Setup

#### Path 2, Step 1: Install Composio

Install the Composio SDK and Claude Agent SDK
```python
pip install composio claude-agent-sdk
```

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

#### Path 2, Step 2: Create Tool Router Session

Initialize the Composio client and create a Tool Router session
```python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
```

```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}`);
```

#### Path 2, Step 3: Connect to AI Agent

Use the MCP server with your AI agent
```python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Excel tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('Add a chart to Q2 sales worksheet')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
```

```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}`);
```

## Why Use Composio?

### 1. 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

### 2. 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

### 3. 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

### 4. 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

## Use Excel with any AI Agent Framework

Choose a framework you want to connect Excel with:

- [ChatGPT](https://composio.dev/toolkits/excel/framework/chatgpt)
- [OpenAI Agents SDK](https://composio.dev/toolkits/excel/framework/open-ai-agents-sdk)
- [Claude Agent SDK](https://composio.dev/toolkits/excel/framework/claude-agents-sdk)
- [Claude Code](https://composio.dev/toolkits/excel/framework/claude-code)
- [Claude Cowork](https://composio.dev/toolkits/excel/framework/claude-cowork)
- [Codex](https://composio.dev/toolkits/excel/framework/codex)
- [Cursor](https://composio.dev/toolkits/excel/framework/cursor)
- [VS Code](https://composio.dev/toolkits/excel/framework/vscode)
- [OpenCode](https://composio.dev/toolkits/excel/framework/opencode)
- [OpenClaw](https://composio.dev/toolkits/excel/framework/openclaw)
- [Hermes](https://composio.dev/toolkits/excel/framework/hermes-agent)
- [CLI](https://composio.dev/toolkits/excel/framework/cli)
- [Google ADK](https://composio.dev/toolkits/excel/framework/google-adk)
- [LangChain](https://composio.dev/toolkits/excel/framework/langchain)
- [Vercel AI SDK](https://composio.dev/toolkits/excel/framework/ai-sdk)
- [Mastra AI](https://composio.dev/toolkits/excel/framework/mastra-ai)
- [LlamaIndex](https://composio.dev/toolkits/excel/framework/llama-index)
- [CrewAI](https://composio.dev/toolkits/excel/framework/crew-ai)
- [Pydantic AI](https://composio.dev/toolkits/excel/framework/pydantic-ai)
- [AutoGen](https://composio.dev/toolkits/excel/framework/autogen)

## Related Toolkits

- [21risk](https://composio.dev/toolkits/_21risk) - 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](https://composio.dev/toolkits/abstract) - 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](https://composio.dev/toolkits/addressfinder) - 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](https://composio.dev/toolkits/agentql) - 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.
- [Agenty](https://composio.dev/toolkits/agenty) - Agenty is a web scraping and automation platform for extracting data and automating browser tasks—no coding needed. It streamlines data collection, monitoring, and repetitive online actions.
- [Ambee](https://composio.dev/toolkits/ambee) - Ambee is an environmental data platform providing real-time, hyperlocal APIs for air quality, weather, and pollen. Get precise environmental insights to power smarter decisions in your apps and workflows.
- [Ambient weather](https://composio.dev/toolkits/ambient_weather) - Ambient Weather is a platform for personal weather stations with a robust API for accessing local, real-time, and historical weather data. Get detailed environmental insights directly from your own sensors for smarter apps and automations.
- [Anonyflow](https://composio.dev/toolkits/anonyflow) - Anonyflow is a service for encryption-based data anonymization and secure data sharing. It helps organizations meet GDPR, CCPA, and HIPAA data privacy compliance requirements.
- [Api ninjas](https://composio.dev/toolkits/api_ninjas) - Api ninjas offers 120+ public APIs spanning categories like weather, finance, sports, and more. Developers use it to supercharge apps with real-time data and actionable endpoints.
- [Api sports](https://composio.dev/toolkits/api_sports) - Api sports is a comprehensive sports data platform covering 2,000+ competitions with live scores and 15+ years of stats. Instantly access up-to-date sports information for analysis, apps, or chatbots.
- [Apify](https://composio.dev/toolkits/apify) - Apify is a cloud platform for building, deploying, and managing web scraping and automation tools called Actors. It lets you automate data extraction and workflow tasks at scale—no infrastructure headaches.
- [Autom](https://composio.dev/toolkits/autom) - Autom is a lightning-fast search engine results data platform for Google, Bing, and Brave. Developers use it to access fresh, low-latency SERP data on demand.
- [Beaconchain](https://composio.dev/toolkits/beaconchain) - Beaconchain is a real-time analytics platform for Ethereum 2.0's Beacon Chain. It provides detailed insights into validators, blocks, and overall network performance.
- [Big data cloud](https://composio.dev/toolkits/big_data_cloud) - BigDataCloud provides APIs for geolocation, reverse geocoding, and address validation. Instantly access reliable location intelligence to enhance your applications and workflows.
- [Bigpicture io](https://composio.dev/toolkits/bigpicture_io) - BigPicture.io offers APIs for accessing detailed company and profile data. Instantly enrich your applications with up-to-date insights on 20M+ businesses.
- [Bitquery](https://composio.dev/toolkits/bitquery) - Bitquery is a blockchain data platform offering indexed, real-time, and historical data from 40+ blockchains via GraphQL APIs. Get unified, reliable access to complex on-chain data for analytics, trading, and research.
- [Brightdata](https://composio.dev/toolkits/brightdata) - Brightdata is a leading web data platform offering advanced scraping, SERP APIs, and anti-bot tools. It lets you collect public web data at scale, bypassing blocks and friction.
- [Builtwith](https://composio.dev/toolkits/builtwith) - BuiltWith is a web technology profiler that uncovers the technologies powering any website. Gain actionable insights into analytics, hosting, and content management stacks for smarter research and lead generation.
- [Byteforms](https://composio.dev/toolkits/byteforms) - Byteforms is an all-in-one platform for creating forms, managing submissions, and integrating data. It streamlines workflows by centralizing form data collection and automation.
- [Cabinpanda](https://composio.dev/toolkits/cabinpanda) - Cabinpanda is a data collection platform for building and managing online forms. It helps streamline how you gather, organize, and analyze responses.

## Frequently Asked Questions

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

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

### Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. [Learn more](https://docs.composio.dev/tool-router/overview).

### Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. [Learn more](https://trust.composio.dev).

### What if the API changes?

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

---
[See all toolkits](https://composio.dev/toolkits) · [Composio docs](https://docs.composio.dev/llms.txt)