Excel

You can manipulate Excel workbooks without Microsoft Excel by running the Excel MCP Server locally or via an MCP client. It supports reading, writing, formatting, and analyzing XLSX, XLSM, and related formats, and works with AI assistants to automate Excel tasks across platforms.

How to use

You integrate the Excel MCP Server with your MCP client to perform Excel operations through natural language prompts or scripted requests. You can run the server using a local stdio command or connect to a remote MCP host when needed. Typical use cases include creating workbooks, reading data with pagination, writing data and formulas, generating charts and dashboards, and importing/exporting CSV, JSON, SQL, and PDF data. Your MCP client will send requests to the server to open, modify, and save Excel files, with automated formatting and styles applied.

How to install

Prerequisites you need on your machine before starting:

• Node.js 14.0 or higher

• Python 3.8 or higher

Install methods

npx @guillehr2/excel-mcp-server@latest

npm install -g @guillehr2/excel-mcp-server

Configure your MCP client

Choose one of the following configurations in your MCP client to connect to the Excel MCP Server.

{
  "mcpServers": {
    "excel_master": {
      "command": "npx",
      "args": [
        "-y",
        "@guillehr2/excel-mcp-server@latest"
      ]
    }
  }
}

Development mode (optional)

{
  "mcpServers": {
    "excel_master": {
      "command": "node",
      "args": ["path/to/Excel-MCP-Server-Master/index.js"]
    }
  }
}

Available tools

create_workbook_tool

Create new Excel workbooks and initialize them with data structures and formatting.

open_workbook_tool

Open Excel files in memory for reading or modification (supports XLSX, XLSM, XLTX, XLTM).

save_workbook_tool

Save changes back to disk with formatting preserved.

list_sheets_tool

List all sheets in a workbook for quick navigation.

add_sheet_tool

Add a new worksheet to an existing workbook.

delete_sheet_tool

Remove a worksheet from a workbook.

rename_sheet_tool

Rename an existing worksheet.

write_sheet_data_tool

Write data into a sheet with support for formatting and tables.

update_cell_tool

Update individual cell values or formulas.

add_table_tool

Create and format an Excel table with styling.

create_formatted_table_tool

Generate a formatted table with predefined styles.

add_chart_tool

Create charts (column, bar, line, pie, scatter, etc.) based on data ranges.

create_dashboard_tool

Assemble a dashboard with multiple visualizations and layouts.

pivot_tables_tool

Create and configure pivot tables for advanced analysis.

filter_data_tool

Filter data in sheets to narrow down results.

import_data_tool

Import data from CSV, JSON, and SQL sources into Excel.

export_data_tool

Export data from Excel to CSV, JSON, or PDF.

export_single_sheet_pdf_tool

Export a single sheet to a PDF file.

export_sheets_pdf_tool

Export multiple sheets to a single or multiple PDF files.