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 namesread_sheet_data
: Read data with paginationread_sheet_formula
: Read formulas with paginationwrite_sheet_data
: Write data to sheetswrite_sheet_formula
: Write formulas to sheets
Command-line Arguments and Environment Variables
Customize transport and paging settings through command-line arguments and environment variables.