Excel MCP Server

MCPOpen SourceMIT86.7

by haris-musa • Visualization & Charts

A Model Context Protocol (MCP) server that lets agents create, read, and modify Excel workbooks without Microsoft Excel installed.

Example Use Cases

1
Create, update, or read Excel workbooks programmatically without relying on a local Microsoft Excel installation.
2
Generate charts, pivot tables, and formatted reports from data and save them as .xlsx files for downstream consumption.
3
Remote access to Excel file operations via streamable HTTP or local access via stdio transport, with configurable server-side file storage.

Description

This MCP server provides a comprehensive API for manipulating Excel files programmatically, including worksheets, formulas, formatting, tables, charts, and pivot tables. It works locally or as a remote service and supports multiple transports (stdio, SSE (deprecated), and streamable HTTP). The server can run without Excel installed on the host and exposes file path configuration for remote deployments. It is distributed under the MIT license and available as a Python package.

Capabilities(25 total)

Tools (25)

apply_formula

Apply Excel formula to cell. Excel formula will write to cell with verification.

filepath:string*sheet_name:string*cell:string*formula:string*

validate_formula_syntax

Validate Excel formula syntax without applying it.

filepath:string*sheet_name:string*cell:string*formula:string*

format_range

Apply formatting to a range of cells.

filepath:string*sheet_name:string*start_cell:string*end_cell:anybold:booleanitalic:booleanunderline:booleanfont_size:anyfont_color:anybg_color:anyborder_style:anyborder_color:anynumber_format:anyalignment:anywrap_text:booleanmerge_cells:booleanprotection:anyconditional_format:any

read_data_from_excel

Read data from Excel worksheet with cell metadata including validation rules. Args: filepath: Path to Excel file sheet_name: Name of worksheet start_cell: Starting cell (default A1) end_cell: Ending cell (optional, auto-expands if not provided) preview_only: Whether to return preview only Returns: JSON string containing structured cell data with validation metadata. Each cell includes: address, value, row, column, and validation info (if any).

filepath:string*sheet_name:string*start_cell:stringend_cell:anypreview_only:boolean

write_data_to_excel

Write data to Excel worksheet. Excel formula will write to cell without any verification. PARAMETERS: filepath: Path to Excel file sheet_name: Name of worksheet to write to data: List of lists containing data to write to the worksheet, sublists are assumed to be rows start_cell: Cell to start writing to, default is "A1"

filepath:string*sheet_name:string*data:array*start_cell:string

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MODERATE

Can modify files, state, or send data externally

Trust Score

C62/100

9/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities25 Tools / 0 Prompts / 0 Resources

Ownerharis-musa

CategoryVisualization & Charts

DependenciesStandalone

Set Your Username