Excel

by fish0710

2 stars

Not rated

GitHub

About

Enables Excel file manipulation capabilities including workbook creation, data manipulation, formatting, charts, and pivot tables without requiring Microsoft Excel installation.

Details

Author: fish0710
Repository: fish0710/excel-mcp
GitHub stars: 2
License: MIT License
Categories: File Management, Other, Productivity, Developer Tools, Design, Workplace, AI, Frontend, Infrastructure
Tags: #visualization

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name Excel

Command (node, npx, python, etc.) uv run excel-mcp-server
Environment
- EXCEL_FILES_PATH /path/to/excel/files
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
            },
            "args": [
                "/c",
                "uv run excel-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
            },
            "args": [
                "/c",
                "uv run excel-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
            },
            "args": [
                "/c",
                "uv run excel-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
            },
            "args": [
                "/c",
                "uv run excel-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
            },
            "args": [
                "/c",
                "uv run excel-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

From the repository

The server can be configured using the following environment variables:

- EXCEL_FILES_PATH: Directory where Excel files will be stored (default: ./excel_files)

You can set this in different ways:

Windows CMD:

set EXCEL_FILES_PATH=C:\path\to\excel\files
uv run excel-mcp-server

Windows PowerShell:

$env:EXCEL_FILES_PATH="C:\path\to\excel\files"
uv run excel-mcp-server

Linux/MacOS:

export EXCEL_FILES_PATH=/path/to/excel/files
uv run excel-mcp-server

Or in Claude Desktop config:

{
  "mcpServers": {
    "excel": {
      "command": "uv run excel-mcp-server",
      "transport": "sse",
      "env": {
        "EXCEL_FILES_PATH": "/path/to/excel/files"
      }
    }
  }
}

This server provides a comprehensive set of Excel manipulation tools. For detailed documentation of all available tools, their parameters, and usage examples, please refer to TOOLS.md.

The tools include capabilities for:

- Workbook and worksheet management
- Data reading and writing
- Formatting and styling
- Charts and visualizations
- Pivot tables and data analysis

See TOOLS.md for complete documentation.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "excel": {
            "env": {
                "EXCEL_FILES_PATH": "/path/to/excel/files"
            },
            "args": [],
            "command": "uv run excel-mcp-server"
        }
    }
}

Linux

{
    "env": {
        "EXCEL_FILES_PATH": "/path/to/excel/files"
    },
    "args": [],
    "command": "uv run excel-mcp-server"
}

Macos

{
    "env": {
        "EXCEL_FILES_PATH": "/path/to/excel/files"
    },
    "args": [],
    "command": "uv run excel-mcp-server"
}

Windows

{
    "env": {
        "EXCEL_FILES_PATH": "C:\\path\\to\\excel\\files"
    },
    "args": [
        "/c",
        "uv run excel-mcp-server"
    ],
    "command": "cmd"
}

A Model Context Protocol (MCP) server implementation that provides Excel file manipulation capabilities without requiring Microsoft Excel installation. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.

- Python 3.10+
- MCP SDK 1.2.0+
- OpenPyXL 3.1.2+

The server provides Excel workbook manipulation through OpenPyXL:

- Creates and modifies Excel workbooks
- Manages worksheets and ranges
- Handles formatting and styles
- Supports charts and pivot tables

This server provides a comprehensive set of Excel manipulation tools. For detailed documentation of all available tools, their parameters, and usage examples, please refer toTOOLS.md.

- Workbook and worksheet management
- Data reading and writing
- Formatting and styling
- Charts and visualizations
- Pivot tables and data analysis

See TOOLS.mdfor complete documentation.

The server can be configured using the following environment variables:

- EXCEL_FILES_PATH: Directory where Excel files will be stored (default:./excel_files)

set EXCEL_FILES_PATH=C:\path\to\excel\files uv run excel-mcp-server

$env:EXCEL_FILES_PATH="C:\path\to\excel\files" uv run excel-mcp-server

export EXCEL_FILES_PATH=/path/to/excel/files uv run excel-mcp-server

{ "mcpServers": { "excel": { "command": "uv run excel-mcp-server", "transport": "sse", "env": { "EXCEL_FILES_PATH": "/path/to/excel/files" } } } }

The server will start in SSE mode and wait for connections from MCP clients.

After starting the server, connect to the SSE endpoint in Cursor IDE:

The Excel MCP tools will be available through the agent.

For available tools and their usage, please refer to TOOLS.md.

This project is licensed under the MIT License - see the LICENSEfile for details.

Read and analyze Excel (.xlsx) and CSV (.csv) files with scalable, chunked, and column-specific data access, ideal for large datasets.

An MCP server that wraps the OpenPyXL library, enabling clients to retrieve data from Excel files.

An MCP server for accurately reading, analyzing, and editing Excel (.xlsx) workbooks while preserving existing structure, styles, formulas, and data integrity. Supports cell operations, sheet and row/column management, formatting, data aggregation, formula recalculation, and safe concurrent file access.

A server for processing PDF files, allowing text and table extraction, metadata retrieval, and file listing within a specific directory.

Read, analyze, and manipulate data in Excel (XLSX, XLS) and CSV files with advanced filtering and analytics.

A high-performance MCP server for comprehensive JSON file operations, including reading, writing, and advanced querying, optimized for LLM interactions.

Read large Excel files with automatic chunking and pagination support.

Access and manage local music collections with advanced metadata, classification, and analytics.

A minimal MCP server providing read-only access to the file system.

Quickly integrate with Tencent Cloud Storage (COS) and Data Processing (CI) capabilities powered

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

Excel

About

Details

Jump to

Setting up with Highlight

Setting up with Cursor

JSON

JSON

JSON

Setting up with Claude Desktop

JSON

JSON

JSON

Setting up with Windsurf

JSON

JSON

JSON

Setting up with Cline

JSON

JSON

JSON

Setting up with Goose

JSON

JSON

JSON

From the repository

Claude Desktop / Cursor

Linux

Macos

Windows

Install

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

Linux

Macos

Windows

Install

More like this

Sequential Thinking

Time

Filesystem

EverArt

Google Drive

Reactive Resume