What can you do with this server?

This MCP server enables creating, loading, editing, and saving Excel (.xlsx) workbooks via the IronCalc engine, allowing direct agent interaction without code generation. Workbook Management: Create new workbooks with locale, language, and timezone settings; load and save XLSX files; inspect metadata, sheets, and dimensions; set properties; undo/redo actions. Cell Operations: Read individual cells or ranges (content, formatted value, type); write single cells or batch ranges; set formulas (prefixed with =); apply array formulas; clear ranges; paste tab-delimited CSV data. Sheet Management: Add, delete, rename, duplicate, move, hide/unhide sheets; set tab colors; toggle gridlines. Row/Column Operations: Insert, delete, move, auto-fill rows and columns; set widths and heights; hide/unhide ranges; freeze top rows or left columns. Formatting: Get and set cell styles (font, fill, border, alignment, number format); apply borders to ranges. Named Styles: List, create, update, delete, and apply named styles. Conditional Formatting: Manage rules: list, add, update, delete, and reorder. Defined Names: Create and manage workbook- or sheet-scoped named ranges.

How do I use ironcalc-mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@ironcalc-mcp Create a budget with formulas and save it" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

ironcalc-mcp

by yolonir

Overview Schema Related Servers Score Discussions

Python

Local

ironcalc-mcp

PyPI Python 3.13+ License: MIT Tests

MCP server for the IronCalc spreadsheet engine. Create, read, edit, and save xlsx files through the Model Context Protocol.

Built on the typed high-level API in IronCalc 0.8.3. It exposes workbook editing, formulas, styles, structure, names, conditional formatting, and xlsx persistence through MCP.

Motivation

I was really inspired by paper.design's real-time MCP workflow, where exposing a design tool via MCP enables custom, extensible agent workflows that feel native rather than bolted on.

Current AI-spreadsheet integrations (like Claude's cowork mode for Excel) add an unnecessary layer of abstraction - the agent writes Python code that manipulates Excel, instead of talking to the spreadsheet directly. This MCP server removes that indirection. Agents read cells, write formulas, and get evaluated results in one hop. No codegen middleman, no openpyxl glue scripts.

Huge thanks to the IronCalc contributors - their Python SDK API is so clean that this entire MCP server is basically thin wrappers. The hard work is all theirs.

Current limitation: the server works with an in-memory workbook - load a file, edit it, save it back. There's no real-time streaming to a running IronCalc UI yet. The engine already has a diff queue for syncing, so the plumbing is there. If IronCalc adds a WebSocket bridge to their web app, we can wire up live sync and get a true reactive workflow - agent edits appearing in the browser as they happen.

Related MCP server: Excel MCP Server

Quick start

uvx ironcalc-mcp

Claude Code

claude mcp add ironcalc -- uvx ironcalc-mcp

Claude Desktop / Cursor

Add to your MCP config:

{
  "mcpServers": {
    "ironcalc": {
      "command": "uvx",
      "args": ["ironcalc-mcp"]
    }
  }
}

Examples

Build a spreadsheet from scratch

Create a budget with formulas and save it

Audit an existing xlsx for errors

Load quarterly_report.xlsx and find all #NAME?, #REF!, #VALUE! errors. Tell me which formulas are broken and why.

Fix broken cross-sheet references

The P&L sheet was renamed but formulas in the DCF sheet still reference the old name. Find and fix all broken references.

Build a financial model

Create a 5-year DCF model with revenue assumptions in one sheet, P&L in another, and free cash flow calculation in a third. Use =NPV() and =IRR() for valuation.

Analyze and transform data

Load sales_data.xlsx, add a column with running totals, insert a summary row at the bottom, and save.

Available tools (56)

Workbook

Tool	Description
`create_workbook`	Create an empty workbook with locale, timezone, and formula language
`load_workbook`	Load an xlsx file
`save_workbook`	Save to xlsx
`get_workbook_info`	Get metadata, theme, sheets, dimensions, states, and colors
`set_workbook_properties`	Update name, locale, timezone, language, or theme
`undo`	Undo the latest action
`redo`	Redo the latest undone action

Cells and ranges

Tool	Description
`get_cell`	Get content, formatted value, and type
`get_cells`	Read non-empty cells from an inclusive range
`set_cell`	Set a value or formula
`set_cells`	Batch-write cells with one evaluation pass
`set_array_formula`	Set an array formula over a result area
`clear_range`	Clear contents, formatting, or everything
`paste_csv`	Paste tab-delimited rows into a range

Sheets

Tool	Description
`add_sheet`	Create a sheet
`delete_sheet`	Delete a sheet
`rename_sheet`	Rename a sheet
`set_sheet_color`	Set the tab color
`duplicate_sheet`	Duplicate a sheet
`hide_sheet` / `unhide_sheet`	Change sheet visibility
`move_sheet`	Reorder a sheet
`set_grid_lines`	Show or hide grid lines

Rows and columns

Tool	Description
`insert_rows` / `delete_rows`	Insert or delete rows
`insert_columns` / `delete_columns`	Insert or delete columns
`move_rows` / `move_columns`	Move a contiguous row or column block
`set_column_width`	Size one column or an inclusive range
`set_row_height`	Size one row or an inclusive range
`set_rows_hidden` / `set_columns_hidden`	Hide or unhide inclusive ranges
`set_frozen_rows` / `set_frozen_columns`	Set frozen panes
`auto_fill_rows` / `auto_fill_columns`	Extend values and formulas from a source area

Formatting

Tool	Description
`get_cell_style`	Get font, fill, border, alignment, and number format
`set_cell_style`	Update selected style properties on a cell or range
`set_range_border`	Apply inner, outer, side, or full borders

Named styles and conditional formatting

Tool	Description
`list_named_styles` / `get_named_style`	Inspect named styles
`create_named_style` / `update_named_style` / `delete_named_style`	Manage named styles
`apply_named_style`	Apply a named style to a range
`list_conditional_formats`	List conditional formatting rules
`add_conditional_format` / `update_conditional_format` / `delete_conditional_format`	Manage rules
`raise_conditional_format_priority` / `lower_conditional_format_priority`	Reorder rules

Defined names

Tool	Description
`list_defined_names`	List workbook- and sheet-scoped names
`create_defined_name`	Create a defined name
`update_defined_name`	Rename, re-scope, or update a defined name
`delete_defined_name`	Delete a defined name

Contributing

Prerequisites: uv and just.

git clone https://github.com/yolonir/ironcalc-mcp
cd ironcalc-mcp
just init

just init syncs the locked environment and installs the deterministic prek commit hook.

just test                      # Behavioral tests
just quality-check             # Ruff, mypy, and ty
just quality-check src/path.py # Targeted quality checks
just precommit                 # Run all commit-time hooks
just format                    # Format and apply safe lint fixes

Please create a new branch for your changes and open a focused pull request against main.

License

MIT

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Related MCP Servers

Spire.XLS MCP Server
App Automation Developer Tools File Systems
eiceblue
A
license
Not graded
quality
D
maintenance
A robust solution that enables AI agents to create, read, modify, and convert Excel files through the Model Context Protocol without requiring Microsoft Office installation.
Updated a year ago (2025-09-15 03:40 UTC)
6
MIT
Excel MCP Server
Workplace & Productivity App Automation
SuperPyonchiX
A
license
B
quality
D
maintenance
A Model Context Protocol server that enables AI agents to freely operate Excel spreadsheets, providing tools for workbook creation, cell manipulation, formatting, formula handling, and data export.
Updated 7 months ago (2026-01-18 03:52 UTC)
11
52
ISC
Excel MCP Server
Workplace & Productivity App Automation Developer Tools
kousunh
A
license
A
quality
D
maintenance
Enables AI assistants to perform comprehensive Microsoft Excel operations including data analysis, cell editing, advanced formatting, and VBA execution on Windows systems. It provides a structured workflow for managing workbooks and worksheets through a dedicated Model Context Protocol interface.
Updated 6 months ago (2026-03-04 05:48 UTC)
5
52
4
MIT
excel-mcp-server
Workplace & Productivity App Automation
yaoyuansh
A
license
Not graded
quality
B
maintenance
Enables AI assistants to automate Microsoft Excel tasks such as reading/writing cells, formatting, creating charts, and managing sheets through natural language using the Model Context Protocol.
Updated 2 months ago (2026-06-13 17:13 UTC)
1
Apache 2.0

View all related MCP servers

Related MCP Connectors

hithereiamaliff-mcp-nextcloud
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
agentbay-mcp
Persistent memory and knowledge management for AI agents with semantic search and 50+ tools.
writespace-mcp
Persistent docs and memory for AI agents — read, write, organize & search a shared workspace.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/yolonir/ironcalc-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

ironcalc-mcp

Motivation

Quick start

Claude Code

Claude Desktop / Cursor

Examples

Available tools (56)

Workbook

Cells and ranges

Sheets

Rows and columns

Formatting

Named styles and conditional formatting

Defined names

Contributing

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

Spire.XLS MCP Server

Excel MCP Server

Excel MCP Server

excel-mcp-server

Related MCP Connectors

Latest Blog Posts

MCP directory API