App

Microsoft Excel integrations

Connect Microsoft Excel to any other app, or use it from your AI client over MCP. Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables

Managed connectionexcel.cloud.microsoft

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with Microsoft Excel?

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client
Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide (opens in a new tab)
Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide (opens in a new tab)
Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide (opens in a new tab)
Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide (opens in a new tab)
Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide (opens in a new tab)
Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide (opens in a new tab)

Pair it

Connect Microsoft Excel with another app

What your agent can do with Microsoft Excel

Triggers and actions 49 actions

  • Action
    Add Chart

    Add a chart to a worksheet using microsoft graph api.

  • Action
    Add Sharepoint Worksheet

    Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.

  • Action
    Add Table

    Create a table over a range in an Excel workbook.

  • Action
    Add Table Column

    Add a column to a table using microsoft graph api.

  • Action
    Add Table Row

    Add a row to a table using microsoft graph api.

  • Action
    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.

  • Action
    Add Worksheet

    Add a new worksheet to an excel workbook using microsoft graph api.

  • Action
    Apply Table Filter

    Apply a filter to a table column using microsoft graph api.

  • Action
    Apply Table Sort

    Apply a sort to a table using microsoft graph api.

  • Action
    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.

  • Action
    Clear Table Filter

    Clear a filter from a table column using microsoft graph api.

  • Action
    Close Session

    Tool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.

  • Action
    Convert Table To Range

    Convert a table to a range using microsoft graph api.

  • Action
    Create Workbook

    Create an .xlsx workbook in the user's OneDrive, from a file URL or blank.

  • Action
    Delete Table Column

    Delete a column from a table using microsoft graph api.

  • Action
    Delete Table Row

    Delete a row from a table using microsoft graph api.

  • Action
    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."

  • Action
    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.

  • Action
    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.

  • Action
    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.

  • Action
    Get Range

    Get a range from a worksheet using microsoft graph api.

  • Action
    Get Session

    Create a session for an excel workbook using microsoft graph api.

  • Action
    Get Sharepoint Range

    Get a range from a worksheet in sharepoint using microsoft graph sites api.

  • Action
    Get Sharepoint Worksheet

    Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.

  • Action
    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.

  • Action
    Get Workbook

    Tool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.

  • Action
    Get Worksheet

    Get a worksheet by name or id from an excel workbook using microsoft graph api.

  • Action
    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.

  • Action
    List Charts

    List charts in a worksheet using microsoft graph api.

  • Action
    List Chart Series

    Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

  • Action
    List Comments

    Tool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.

  • Action
    List Files

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

  • Action
    List Named Items

    List named items in a workbook using microsoft graph api.

  • Action
    List Sharepoint Tables

    List tables in a sharepoint worksheet using microsoft graph sites api.

  • Action
    List Sharepoint Worksheets

    List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.

  • Action
    List Table Columns

    List columns in a table using microsoft graph api.

  • Action
    List Table Rows

    List rows in a table using microsoft graph api.

  • Action
    List Tables

    List tables in a worksheet using microsoft graph api.

  • Action
    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'."

  • Action
    List Worksheets

    List worksheets in an excel workbook using microsoft graph api.

  • Action
    Merge Cells

    Merge cells in a worksheet range using microsoft graph api.

  • Action
    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."

  • Action
    Sort Range

    Sort a range in a worksheet using microsoft graph api.

  • Action
    Update Chart

    Update a chart in a worksheet using microsoft graph api.

  • Action
    Update Chart Legend

    Tool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.

  • Action
    Update Range

    Update a range in a worksheet using microsoft graph api.

  • Action
    Update Sharepoint Range

    Update a range in a sharepoint worksheet using microsoft graph sites api.

  • Action
    Update Table

    Update a table in a workbook using microsoft graph api.

  • Action
    Update Worksheet

    Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

Reviews

What our customers say

Questions

Microsoft Excel, answered

Is there a Microsoft Excel MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with Microsoft Excel. Add that address to any AI client that takes a remote MCP server, sign in once in your browser, and your client can build, test and run automations that use Microsoft Excel. Nothing to install.

What can your agent do in Microsoft Excel?

Any of Microsoft Excel's 49 actions, including Create Workbook, Update Chart, Update Chart Legend and Update Range. Your agent maps the data both ways and tests every scenario before it ships.

Which apps can Microsoft Excel connect to?

Any app in the catalog; the list on this page pairs Microsoft Excel with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.