excel-live-mac
This server enables real-time interaction with live Microsoft Excel instances on macOS, allowing AI agents to read, write, and manipulate spreadsheet data and execute macros directly — locally, with no API keys required.
List open workbooks — view all currently open Excel files, including names, paths, and sheet counts
Get sheet names — retrieve all sheet names from a specific or active workbook
Read a cell range — read a rectangular range (e.g.
A1:D20) as a 2D array, with optional auto-expansion to contiguous dataWrite a range — write a 2D array of data starting from a specified cell; changes appear instantly in Excel
Write a single cell — write a value, number, or formula (e.g.
=SUM(A1:A10)) to one cellRead a single cell — read the value and formula of a specific cell
Open a workbook — open an Excel file from a given path, launching Excel if needed
Save a workbook — save the active or specified workbook in place or to a new path
Run a VBA macro — execute an existing VBA macro in the active workbook, optionally passing arguments
Get current selection — retrieve the address, values, and sheet of the user's currently selected range
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@excel-live-macread the current selection in the active sheet"
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.
excel-live-mac
Live Excel MCP server for macOS — interact with running Excel instances in real time.
Unlike file-based tools (openpyxl) that work on saved files offline, this server talks to the live Excel app via the xlwings AppleScript bridge. Changes appear instantly in the spreadsheet you're looking at.
Features
10 tools for reading, writing, and interacting with open Excel workbooks
Real-time updates — write data and watch it appear in Excel immediately
Formula support — write Excel formulas that calculate live
VBA macro execution — trigger existing macros from your AI agent
Selection awareness — read what the user currently has highlighted
Zero config — no API keys, no network, runs entirely local
Related MCP server: Excel MCP Server
Requirements
macOS (AppleScript bridge — not available on Windows/Linux)
Microsoft Excel installed
Python 3.10+
Installation
For Kiro IDE (as a Power)
Import from GitHub in the Kiro Powers panel:
https://github.com/dcol3/excel-live-macFor any MCP client (via uvx)
uvx --from git+https://github.com/dcol3/excel-live-mac excel-live-macOr add to your MCP config:
{
"mcpServers": {
"excel-live-mac": {
"command": "uvx",
"args": ["--from", "git+https://github.com/dcol3/excel-live-mac", "excel-live-mac"],
"disabled": false
}
}
}Manual install
pip install excel-live-mac
excel-live-macmacOS Permission
On first use, macOS will prompt you to allow your terminal to control Microsoft Excel.
Go to System Settings → Privacy & Security → Automation and ensure your terminal/IDE has permission to control Excel.
Tools
Tool | Description |
| List all open workbooks (name, path, sheets) |
| Get sheet names from a workbook |
| Read a cell range as a 2D array |
| Write a 2D array (appears instantly) |
| Write a value or formula to one cell |
| Read one cell's value and formula |
| Open a file in Excel |
| Save the workbook |
| Execute a VBA macro |
| Get the current selection |
Use Cases
Report generation — AI builds formatted spreadsheets while you watch
Financial modeling — populate budgets, forecasts, and scenario tables live
Data entry automation — read from databases, write directly into open workbooks
Interactive analysis — AI reads your current selection, computes, writes results back
Kiro Power
This repo includes a kiro_power/ directory with POWER.md, mcp.json, and steering files for use as a Kiro Power. When installed as a Power, Kiro's agent automatically knows when and how to use these tools based on keyword activation.
License
MIT
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/dcol3/excel-live-mac'
If you have feedback or need assistance with the MCP directory API, please join our Discord server