Excel

A Model Context Protocol (MCP) server that reads and writes MS Excel data

go

817

GitHub Stars

go

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "negokaz-excel-mcp-server": {
      "command": "cmd",
      "args": [
        "/c",
        "npx",
        "--yes",
        "@negokaz/excel-mcp-server"
      ],
      "env": {
        "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000"
      }
    }
  }
}

You can use the Excel MCP Server to read and write data in MS Excel workbooks through a Model Context Protocol (MCP) interface. It supports reading and writing values and formulas, creating new sheets, and, on Windows, live editing and screen capture for a sheet.

How to use

Install the MCP server and run it locally or connect to it from your MCP client. You can read and write cell values, read formulas, create new sheets, and manage tables and formats in Excel workbooks. Use the provided tools to describe sheets, read ranges with pagination, write values or formulas, create tables, copy sheets, format ranges, and capture screen content (Windows only). Ensure the target Excel file is accessible from the environment where the MCP server runs.

How to install

Prerequisites: Node.js 20.x or later must be installed on your machine.

{
  "mcpServers": {
    "excel": {
      "command": "cmd",
      "args": ["/c", "npx", "--yes", "@negokaz/excel-mcp-server"],
      "env": {
        "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000"
      }
    }
  }
}

For non-Windows platforms, set up the MCP server with the following configuration.

{
  "mcpServers": {
    "excel": {
      "command": "npx",
      "args": ["--yes", "@negokaz/excel-mcp-server"],
      "env": {
        "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000"
      }
    }
  }
}

Configuration

You can adjust server behavior using environment variables. The following variable is exposed for paging control.

EXCEL_MCP_PAGING_CELLS_LIMIT=4000

Available tools

excel_describe_sheets

List all sheet information for a specified Excel file.

excel_read_sheet

Read values from an Excel sheet with pagination, with options to show formulas and styles.

excel_screen_capture

(Windows only) Take a screenshot of an Excel sheet with pagination.

excel_write_to_sheet

Write values or formulas to a specified range in an Excel sheet, creating a new sheet if requested.

excel_create_table

Create a table within a specified Excel sheet and range.

excel_copy_sheet

Copy an existing sheet to a new sheet within the same workbook.

excel_format_range

Apply styling to a range of cells in an Excel sheet.