How to integrate Excel MCP with Kimi Code

How to integrate Excel MCP with Kimi Code Kimi Code is Moonshot AI's open-source coding agent, powered by Kimi K2.6. It runs in your terminal, reads and edits code, executes shell commands, and plans multi-step tasks, with native MCP support for extending it to outside tools. In this guide, I will explain the easiest and most secure way to connect your Excel account to Kimi Code via Composio Connect, so it can add sales data row to Q2 table, create bar chart from revenue column, share this workbook with your manager, and more without ever putting your account credentials at risk.

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

How to integrate Excel MCP with Kimi Code

Kimi Code is Moonshot AI's open-source coding agent, powered by Kimi K2.6. It runs in your terminal, reads and edits code, executes shell commands, and plans multi-step tasks, with native MCP support for extending it to outside tools.

In this guide, I will explain the easiest and most secure way to connect your Excel account to Kimi Code via Composio Connect, so it can add sales data row to Q2 table, create bar chart from revenue column, share this workbook with your manager, and more without ever putting your account credentials at risk.

Also integrate Excel with

Why use Composio?

Composio provides:

  • Access to 1,000+ managed apps from a single MCP endpoint. This makes it convenient for agents to run cross-app workflows.
  • Managed OAuth. You do not have to worry about authentication and authorization flows for every app.
  • Programmatic tool calling. Allows LLMs to write code in a remote workbench to handle complex tool chaining. This reduces back-and-forth for frequent tool calls.
  • Large tool response handling outside the LLM context. This minimizes context bloat from large tool responses.
  • Dynamic just-in-time access to thousands of tools across hundreds of apps. Composio loads the tools your agent needs, so LLMs are not overwhelmed by tools they do not need.

Connect Excel to Kimi Code

Kimi Code is a TypeScript agent distributed through npm. It acts as an MCP client and reads server definitions from an mcp.json file, and it can also add and authenticate servers conversationally through /mcp-config. Composio is a remote HTTP server that authenticates with OAuth, so no API key is stored anywhere.

1. Install Kimi Code

The quickest way is the official install script, which requires no pre-installed Node.js and places the kimi executable on your PATH.

bash
# macOS or Linux
curl -fsSL https://code.kimi.com/kimi-code/install.sh | bash

# Windows PowerShell
irm https://code.kimi.com/kimi-code/install.ps1 | iex

# Confirm the installation
kimi --version

2. Log in

Start Kimi Code in your project directory, then sign in from the interactive UI:

bash
kimi

Run /login and choose Kimi Code OAuth using the device-code flow, or use a Moonshot API key.

3. Add Composio with /mcp-config

In current versions of Kimi Code, MCP servers are managed inside the app, not with a shell subcommand. From the interactive UI, run:

bash
/mcp-config
Kimi Code MCP config flow for adding the Composio MCP server

Tell it the server name and URL in plain language. For example:

Server name is Composio, and here is the server URL: https://connect.composio.dev/mcp

Kimi Code asks whether to add it globally, at ~/.kimi-code/mcp.json, or project-local for the current checkout, then writes the entry for you:

bash
{
  "mcpServers": {
    "Composio": {
      "url": "https://connect.composio.dev/mcp"
    }
  }
}

There is no transport field to set. Kimi Code infers HTTP from the url.

4. Restart the session

The new server is picked up on a fresh session, not the current one. Start a new session:

bash
/new

On the new session, Kimi Code detects that the server needs authorization and prompts you to run:

bash
/mcp-config login Composio

5. Authorize with OAuth

Run the command Kimi suggests:

bash
/mcp-config login composio

Kimi Code opens Composio's authorization page or surfaces a URL. Approve access, then return to the session. You should see confirmation that the Composio MCP server is connected.

Composio authorization page for Kimi Code MCP setup

Check the connection status any time with /mcp. Composio should appear as connected with its tools listed.

Kimi Code showing Composio connected after OAuth authorization

Connect your Excel account

Back in a Kimi Code session, ask the agent to connect to Excel or give it any Excel-related task.

For example, ask it to:

  • "Add sales data row to Q2 table"
  • "Create bar chart from revenue column"
  • "Share this workbook with your manager"

It will prompt you to authenticate and authorize access to Excel.

That is it. Composio tools are now available in Kimi Code, and your Excel account is ready to use.

Conclusion

You have successfully connected Excel to Kimi Code using Composio Connect. Your agent can now manage Excel from the terminal with natural language, without exposing credentials in prompts or local scripts.

Since the same Composio endpoint exposes 1,000+ apps, you can add Slack, Calendar, Linear, and more to the same server and chain them into cross-app workflows.

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.

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. Kimi Code 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