It's an MCP (Model Context Protocol) server that connects Excel to your AI, giving the agent tools to act on your data — through a single remote link.

Which AI clients does it work with?

Any MCP-compatible client: Claude (web, desktop and mobile), Cursor, ChatGPT with connectors, OpenClaw and other agents.

No. Paste the remote URL into your client, authenticate once, and you're done — no packages to install, no code to write.

Is it secure? Can the AI change my data?

Access is authorized by you and can be revoked anytime. Permissions follow what Excel exposes; you approve them when connecting.

How much does it cost?

You start free and upgrade when you need more usage. Billing and limits are managed in your mcp.ai account.

Can I cancel anytime?

Yes. Plans are monthly and can be cancelled at any time, with no lock-in.

Excel MCP Server and REST API

Excel

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

Install in your client

MCP server URL

https://api.mcp.ai/p_excel

Secure connection via OAuth 2.0

Tools (49)

For developers

API & agent docs

Machine-readable docs to plug this server into an agent or call it over REST.

Skill (how to use)

Markdown: use via MCP or via the direct REST API.

Open

llms.txt

Agent-readable spec of this server.

Open

For agents

Install prompt — paste into Claude, ChatGPT, Cursor or any MCP agent and it sets itself up.

Open

Postman collection

Import the REST API into Postman.

Download

FAQ

Excel

Tools (49)

API & agent docs

Frequently asked questions

Example prompts

Excel

Tools (49)

excel_add_chartAdd a chart to a worksheet using microsoft graph api.

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

excel_add_tableCreate a table in a workbook using microsoft graph api.

excel_add_table_columnAdd a column to a table using microsoft graph api.

excel_add_table_rowAdd a row to a table using microsoft graph api.

excel_add_workbook_permissionTool 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_worksheetAdd a new worksheet to an excel workbook using microsoft graph api.

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

excel_apply_table_sortApply a sort to a table using microsoft graph api.

excel_clear_rangeTool 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_filterClear a filter from a table column using microsoft graph api.

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

excel_convert_table_to_rangeConvert a table to a range using microsoft graph api.

excel_create_workbookTool to create a new workbook file at a specified drive path. use when uploading a new .xlsx file to onedrive.

excel_delete_table_columnDelete a column from a table using microsoft graph api.

excel_delete_table_rowDelete a row from a table using microsoft graph api.

excel_delete_worksheetTool 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_get_chart_axisTool 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_labelsTool 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_legendTool 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_rangeGet a range from a worksheet using microsoft graph api.

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

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

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

excel_get_table_columnTool 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_workbookTool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.

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

excel_insert_rangeTool 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_chart_seriesTool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

excel_list_chartsList charts in a worksheet using microsoft graph api.

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

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

excel_list_named_itemsList named items in a workbook using microsoft graph api.

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

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

excel_list_table_columnsList columns in a table using microsoft graph api.

excel_list_table_rowsList rows in a table using microsoft graph api.

excel_list_tablesList tables in a worksheet using microsoft graph api.

excel_list_workbook_permissionsTool 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 fo

excel_list_worksheetsList worksheets in an excel workbook using microsoft graph api.

excel_merge_cellsMerge cells in a worksheet range using microsoft graph api.

excel_protect_worksheetTool 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_sort_rangeSort a range in a worksheet using microsoft graph api.

excel_update_chartUpdate a chart in a worksheet using microsoft graph api.

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

excel_update_rangeUpdate a range in a worksheet using microsoft graph api.

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

excel_update_tableUpdate a table in a workbook using microsoft graph api.

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

API & agent docs

Frequently asked questions

What is Excel MCP?

Which AI clients does it work with?

Do I need to code?

Is it secure? Can the AI change my data?

How much does it cost?

Can I cancel anytime?

Example prompts