Read, write, and analyze Excel workbooks — cell operations, formulas, pivot tables, charts, and worksheet management via Microsoft Graph.
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.
{
"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:
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.
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
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.
| 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 |
| Variable | Required | Description |
|---|---|---|
MICROSOFT_ACCESS_TOKEN | Yes | Microsoft OAuth 2.0 access token (requires Files.ReadWrite scope for OneDrive/SharePoint access) |
Add the following secrets under Project → Secrets:
MICROSOFT_ACCESS_TOKENOnce added, every AI agent in your workspace can use Excel tools automatically.
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":{}}}'
MIT
Live Endpoint
https://mcp.aerostack.dev/s/aerostack/mcp-excel
Sub-50ms globally · Zero cold start
@aerostack
Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.
by @aerostack
Discover and invoke any MCP, Function, or Skill published to the Aerostack marketplace — the universal AI capability hub.
by @aerostack
Search indexes, manage records, browse data, and configure ranking in Algolia — AI-native instant search access.
by @aerostack
Query documents, run AQL, traverse graphs, and manage collections in your ArangoDB database — AI-native multi-model database access.
by @aerostack
Post, schedule, and analyze social media across 13 platforms — Facebook, Instagram, X, LinkedIn, TikTok, Bluesky, Threads, Reddit, Pinterest, YouTube, Telegram, Snapchat, Google Business.
by @aerostack
Manage projects, to-dos, messages, schedules, and campfire chats in Basecamp — AI-native project management.
by @aerostack
Run SQL queries, list datasets and tables, inspect schemas, and export results from Google BigQuery — AI-native data warehouse access.
Yes. The Excel MCP includes a create_workbook_session tool that lets Claude create workbook sessions in your Excel account from a plain-English prompt. You can also update and delete workbook sessions — no Excel UI needed.
Yes. The Excel MCP includes tools to list and retrieve excel files from your Excel account. Claude can filter, sort, and summarize excel files based on your instructions.
Yes. The Excel MCP uses the open Model Context Protocol standard, so it works in Claude, Cursor, Windsurf, and any other MCP-compatible AI tool. All 17 Excel tools are available everywhere you connect it — install once on Aerostack.
Yes. The Excel MCP includes tools to update ranges in your Excel account. Tell Claude what to change in plain English — it reads the current state and applies the update via the Excel API.