electrical_services

Excel MCP Server — Hosted Api Connectors Integration

MCP Server language Hosted language Public

Read, write, and analyze Excel workbooks — cell operations, formulas, pivot tables, charts, and worksheet management via Microsoft Graph.

@aerostack verified

• v0.1.0 • MIT • Updated Jun 28, 2026

add_circleAdd to Workspace

robot_2

Use with AI AssistantsMCP

Connect Claude, Cursor, or any MCP-compatible client — then call tools directly

① Add This MCP Server

Paste into your AI client config — then all its tools are available instantly.

.claude/mcp.json

{
  "mcpServers": {
    "excel": {
      "url": "https://mcp.aerostack.dev/s/aerostack/mcp-excel",
      "headers": {
        "Authorization": "Bearer YOUR_AEROSTACK_TOKEN"
      }
    }
  }
}

Replace YOUR_AEROSTACK_TOKEN with your API token from the dashboard.

② Call a Tool

Ask your AI assistant to call a specific tool, or send raw JSON-RPC:

+12 more

Natural Language Prompt

“Use the _ping tool to verify microsoft credentials by calling a lightweight read endpoint. used internally by aerostack to validate credentials”

Using a Workspace?

Add this MCP to your Workspace — your team shares one token, secrets are stored securely, and every AI agent in the workspace can call it without per-user setup.

add_circleAdd to Workspace

description Overview

mcp-excel — Excel MCP Server

Read, write, and analyze Excel workbooks — cell operations, formulas, pivot tables, charts, and worksheet management via Microsoft Graph.

Live endpoint: https://mcp.aerostack.dev/s/aerostack/mcp-excel

What You Can Do

This MCP server gives AI agents access to Excel via 17 tools. Connect it to any Aerostack workspace and your agents can interact with Excel directly.

Available Tools

Tool	Description
`list_excel_files`	List Excel files (.xlsx) in OneDrive root or a specific folder
`get_workbook_info`	Get workbook metadata: worksheets, named ranges, tables
`create_workbook_session`	Create a persistent session for batch operations (keeps file open for edits)
`list_worksheets`	List all worksheets in a workbook with visibility and position
`add_worksheet`	Add a new worksheet to the workbook
`delete_worksheet`	Delete a worksheet from the workbook
`get_range`	Read cell values from a range (e.g.
`update_range`	Write values to a cell range. Values is a 2D array matching range dimensions.
`clear_range`	Clear cell contents, formatting, or both from a range
`get_used_range`	Get the used range of a worksheet (smallest range containing all data)
`list_tables`	List all tables in a worksheet with column names and row count
`get_table_rows`	Get all rows from a table
`add_table_rows`	Append rows to an existing table
`list_charts`	List all charts in a worksheet
`get_chart_image`	Get a chart as a base64-encoded PNG image
`set_formula`	Set a formula in a cell (e.g.
`calculate_workbook`	Recalculate all formulas in the workbook

Configuration

Variable	Required	Description
`MICROSOFT_ACCESS_TOKEN`	Yes	Microsoft OAuth 2.0 access token (requires Files.ReadWrite scope for OneDrive/SharePoint access)

Quick Start

Add to Aerostack Workspace

Go to aerostack.dev → Your Project → MCPs
Search for "Excel" and click Add to Workspace

Add the following secrets under Project → Secrets:

MICROSOFT_ACCESS_TOKEN

Once added, every AI agent in your workspace can use Excel tools automatically.

Direct API Call

curl -X POST https://mcp.aerostack.dev/s/aerostack/mcp-excel \
  -H 'Content-Type: application/json' \
  -H 'X-Mcp-Secret-MICROSOFT-ACCESS-TOKEN: your-microsoft-access-token' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"list_excel_files","arguments":{}}}'

License

MIT

terminal Tools (18)

Available tools on this MCP server. Each tool can be called directly from any AI agent.

terminal

_ping #1

Verify Microsoft credentials by calling a lightweight read endpoint. Used internally by Aerostack to validate credentials.

terminal

list_excel_files #2

List Excel files (.xlsx) in OneDrive root or a specific folder

terminal

get_workbook_info #3

Get workbook metadata: worksheets, named ranges, tables

terminal

create_workbook_session #4

Create a persistent session for batch operations (keeps file open for edits)

terminal

list_worksheets #5

List all worksheets in a workbook with visibility and position

terminal

add_worksheet #6

Add a new worksheet to the workbook

terminal

delete_worksheet #7

Delete a worksheet from the workbook

terminal

get_range #8

Read cell values from a range (e.g. "A1:D10" or "Sheet1!B2:F20")

terminal

update_range #9

Write values to a cell range. Values is a 2D array matching range dimensions.

terminal

clear_range #10

Clear cell contents, formatting, or both from a range

terminal

get_used_range #11

Get the used range of a worksheet (smallest range containing all data)

terminal

list_tables #12

List all tables in a worksheet with column names and row count

terminal

get_table_rows #13

Get all rows from a table

terminal

add_table_rows #14

Append rows to an existing table

terminal

list_charts #15

List all charts in a worksheet

terminal

get_chart_image #16

Get a chart as a base64-encoded PNG image

terminal

set_formula #17

Set a formula in a cell (e.g. "=SUM(A1:A10)")

terminal

calculate_workbook #18

Recalculate all formulas in the workbook

Details

upgrade Version 0.1.0

gavel License MIT

wifi Transport streamable-http

lock Access Public

category Category API Connectors

terminal Tools 18

language Live Endpoint

https://mcp.aerostack.dev/s/aerostack/mcp-excel

Sub-50ms globally · Zero cold start

Publisher

@aerostack verified

Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.

Frequently asked questions

What is the Excel MCP server and what can it do? +

The Excel MCP server is hosted on Aerostack and exposes these tools to your AI agent: `_ping`, `list_excel_files`, `get_workbook_info`, `create_workbook_session`, `list_worksheets`. You get one hosted URL — no self-hosting — that works from Claude, Cursor, ChatGPT, Gemini, VS Code, or any MCP-compatible client, and you can share it with your team or combine it with other MCP servers in a workspace.

Is the Excel MCP server hosted, or do I have to run it myself? +

It's hosted on Aerostack's edge infrastructure — you don't deploy or maintain anything. Add it to a workspace and you get one authenticated URL, with secrets encrypted, that any AI agent or editor can connect to. Use it solo or share the same URL across your whole team.

Which AI agents and editors can use the Excel MCP server? +

Any MCP client: Claude and Claude Code, Cursor, ChatGPT, Gemini, Windsurf, Cline, VS Code, and custom agents. Because it's one hosted URL, the same Excel MCP server works everywhere — and you can compose it with other MCP servers, skills, and functions behind a single workspace URL.

How do I install the Excel MCP server in Claude Desktop? +

Add the following to your Claude Desktop config (`claude_desktop_config.json`): ```json { "mcpServers": { "@aerostack/mcp-excel": { "command": "npx", "args": ["-y", "@aerostack/@aerostack/mcp-excel"] } } } ``` Then restart Claude Desktop and the tools will appear automatically.

How do I use the Excel MCP server in Cursor? +

In Cursor, open **Settings → MCP** and add: ```json { "name": "@aerostack/mcp-excel", "command": "npx", "args": ["-y", "@aerostack/@aerostack/mcp-excel"] } ``` Save and reload Cursor. The MCP tools will be available in Agent mode.

Does Excel MCP require authentication? +

Yes. Excel requires authentication. Check the MCP's documentation for the required credentials.

Excel MCP Server — Hosted Api Connectors Integration

description Overview

mcp-excel — Excel MCP Server

What You Can Do

Available Tools

Configuration

Quick Start

Add to Aerostack Workspace

Direct API Call

License

terminal Tools (18)

Details

Publisher

Tags

More in API Connectors

Aerostack Registry

Algolia

Arangodb

Ayrshare

Basecamp

Bigquery

Frequently asked questions