excel-mcp-server

excel-mcp-server

2

Excel MCP Server is a Model Context Protocol server that facilitates reading and writing data in MS Excel files, including text values and formulas. It supports various Excel file formats and offers features like pagination and screen capturing, designed to integrate easily with Node.js environments.

Excel MCP Server

A Model Context Protocol (MCP) server designed for reading and writing MS Excel data.

Features

  • Read and write text values and formulas from/to MS Excel files
  • Capture screen images from Excel files (Windows only)

Requirements

  • Node.js 20.x or later

Supported file formats

  • xlsx, xlsm, xltx, xltm

Installation

Installing via NPM and Smithery

  • Use NPM or Smithery CLI to install and configure with stdio or SSE transport.

Tools

  • read_sheet_names: List sheet names
  • read_sheet_data: Read data with pagination
  • read_sheet_formula: Read formulas with pagination
  • write_sheet_data: Write data to sheets
  • write_sheet_formula: Write formulas to sheets

Command-line Arguments and Environment Variables

Customize transport and paging settings through command-line arguments and environment variables.