Skip to content

ExcelMcp v1.4.9 - MCP Server & CLI

Choose a tag to compare

View all tags
@github-actions github-actions released this 20 Nov 06:38
· 14 commits to main since this release
v1.4.9
7c51ebb
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

ExcelMcp v1.4.9 - MCP Server & CLI

Unified release: MCP Server and CLI share the same version for consistency.

MCP Server - AI-Powered Excel Development

The Model Context Protocol (MCP) Server enables AI assistants like GitHub Copilot, Claude, and ChatGPT to perform Excel development tasks through conversational interfaces.

Key Features

  • Native AI Integration - Built for GitHub Copilot and AI assistants
  • Conversational Excel - Natural language Excel operations
  • Resource-Based API - 12 structured tools for comprehensive Excel automation
  • Development Focus - Power Query refactoring, VBA enhancement, Data Model operations, table management, range operations
  • Smart Context - AI understands Excel development workflows

Installation

Option 1: .NET Tool (Recommended)

dotnet tool install --global Sbroenne.ExcelMcp.McpServer --version 1.4.9
mcp-excel
```n
**Option 2: Download Binary**
1. Download ExcelMcp-MCP-Server-1.4.9-windows.zip
2. Extract and run: dotnet ExcelMcp.McpServer.dll

### MCP Tools Available
- excel_file - File management (create-empty, close-workbook)
- excel_powerquery - Power Query operations (list, view, import, export, update, refresh, delete, set-load-config, get-load-config)
- excel_worksheet - Worksheet operations (list, create, rename, copy, delete)
- excel_range - Range operations (get-values, set-values, get-formulas, set-formulas, clear-all, clear-contents, clear-formats)
- excel_table - Table operations (list, create, info, rename, delete, resize, set-style, toggle-totals, set-column-total, append, apply-filter, clear-filters, get-filters, add-column, remove-column, rename-column, sort, add-to-datamodel, get-structured-reference)
- excel_parameter - Named range management (list, read, write, create, delete, update)
- excel_cell - Cell operations (get-value, set-value, get-formula, set-formula)
- excel_connection - Connection management (list, view, import, update, refresh, delete, loadto, properties, set-properties, test)
- excel_datamodel - Data Model operations (list-tables, list-measures, read, export-measure, list-relationships, refresh, delete-measure, delete-relationship, read-table, list-columns, read-info)
- excel_vba - VBA script management (list, view, import, update, run, delete)
- excel_batch - Batch operation management (begin, commit, list)

### CLI - Scriptable Excel Automation

Command-line interface with 147 commands for Excel automation, perfect for CI/CD pipelines and scripting.

### CLI Installation

**Option 1: .NET Tool (Recommended)**
```powershell
dotnet tool install --global Sbroenne.ExcelMcp.CLI --version 1.4.9
excelcli --help
```n
**Option 2: Download Binary**
1. Download ExcelMcp-CLI-1.4.9-windows.zip
2. Extract and run: dotnet ExcelMcp.CLI.dll --help

### Requirements
- Windows OS with Microsoft Excel installed
- .NET 8.0 runtime
- Excel 2016+ (for COM interop)

### Documentation
- GitHub Repository: https://github.com/sbroenne/mcp-server-excel
- MCP Server: src/ExcelMcp.McpServer/README.md
- CLI: src/ExcelMcp.CLI/README.md
Assets 4
Loading