Excel Data Manager

by yzfly

23 stars

4.8k downloads

Not rated

GitHub Website

About

Enables Excel file operations and data analysis with tools for statistical analysis, data filtering, pivot table creation, and visualization through charts and plots.

Details

Author: yzfly
Repository: yzfly/mcp-excel-server
GitHub stars: 23
Downloads: 4,779
Categories: Productivity, Developer Tools, Design, File Management, AI, Infrastructure, Other
Tags: #analytics, #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 Data Manager

Command (node, npx, python, etc.) uvx
Arguments
- Argument 1 mcp-excel-server
Environment
- PYTHONPATH /path/to/your/python
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 data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

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 data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

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 data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

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 data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

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 data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

JSON

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

From the repository

1. Create a new Python environment (recommended):

```bash

- "Analyze my sales_data.xlsx file"
- "Create a bar chart for product_sales.csv"
- "Filter employees over 30 in employees.xlsx"
- "Generate a pivot table of department sales"

`read_excel`

Read Excel files in various formats.

`get_excel_info`

Get details about the Excel file.

`get_sheet_names`

List the names of worksheets in the Excel file.

`analyze_excel`

Perform statistical analysis on the Excel data.

`filter_excel`

Filter the Excel data based on specified conditions.

`pivot_table`

Create pivot tables from the Excel data.

`data_summary`

Generate a comprehensive summary of the Excel data.

`export_chart`

Generate various types of charts from Excel data (line, bar, scatter, histogram).

`write_excel`

Write new data to Excel files.

`update_excel`

Update existing Excel files with new data.

Claude Desktop / Cursor

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

{
    "mcpServers": {
        "excel data manager": {
            "env": {
                "PYTHONPATH": "/path/to/your/python"
            },
            "args": [
                "mcp-excel-server"
            ],
            "command": "uvx"
        }
    }
}

Linux

{
    "env": {
        "PYTHONPATH": "/path/to/your/python"
    },
    "args": [
        "mcp-excel-server"
    ],
    "command": "uvx"
}

Macos

{
    "env": {
        "PYTHONPATH": "/path/to/your/python"
    },
    "args": [
        "mcp-excel-server"
    ],
    "command": "uvx"
}

Windows

{
    "env": {
        "PYTHONPATH": "/path/to/your/python"
    },
    "args": [
        "mcp-excel-server"
    ],
    "command": "uvx"
}

Excel MCP Server

An MCP server that provides comprehensive Excel file management and data analysis capabilities.

Features

- Excel File Operations
- Read multiple Excel formats (XLSX, XLS, CSV, TSV, JSON)
- Write and update Excel files
- Get file information and sheet names

- Data Analysis
- Summary statistics and descriptive analysis
- Data quality assessment
- Pivot tables
- Filtering and querying data

- Visualization
- Generate charts and plots from Excel data
- Create data previews
- Export visualizations as images

Installation

1. Create a new Python environment (recommended):

# Using uv (recommended)
uv init excel-mcp-server
cd excel-mcp-server
uv venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
Or using pip
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

2. Install dependencies:

# Using uv
uv pip install -e .

Integration with Claude Desktop

1. Install Claude Desktop
2. Open Settings and go to the Developer tab
3. Edit claude_desktop_config.json:

{
  "mcpServers": {
      "command": "uvx",
      "args": [
        "mcp-excel-server"
      ],
      "env": {
        "PYTHONPATH": "/path/to/your/python"
      }
  }
}

Available Tools

File Reading

- read_excel: Read Excel files - get_excel_info: Get file details - get_sheet_names: List worksheet names

Data Analysis

- analyze_excel: Perform statistical analysis - filter_excel: Filter data by conditions - pivot_table: Create pivot tables - data_summary: Generate comprehensive data summary

Data Visualization

- export_chart: Generate charts - Supports line charts, bar charts, scatter plots, histograms

File Operations

- write_excel: Write new Excel files - update_excel: Update existing Excel files

Available Resources

- excel://{file_path}: Get file content
- excel://{file_path}/info: Get file structure information
- excel://{file_path}/preview: Generate data preview image

Prompt Templates

- analyze_excel_data: Guided template for Excel data analysis
- create_chart: Help create data visualizations
- data_cleaning: Assist with data cleaning

Usage Examples

- "Analyze my sales_data.xlsx file"
- "Create a bar chart for product_sales.csv"
- "Filter employees over 30 in employees.xlsx"
- "Generate a pivot table of department sales"

Security Considerations

- Read files only from specified paths
- Limit file size
- Prevent accidental file overwriting
- Strictly control data transformation operations

Dependencies

- pandas
- numpy
- matplotlib
- seaborn

License

MIT License

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.

About

Details

Jump to

Setting up with Highlight

From the repository

read_excel

get_excel_info

get_sheet_names

analyze_excel

filter_excel

pivot_table

data_summary

export_chart

write_excel

update_excel

Claude Desktop / Cursor

Linux

Macos

Windows

Excel MCP Server

Features

Installation

Or using pip

Integration with Claude Desktop

Available Tools

File Reading

Data Analysis

Data Visualization

File Operations

Available Resources

Prompt Templates

Usage Examples

Security Considerations

Dependencies

License

Install

More like this

Time

Sentry

Github

Git

GitLab

Context 7

`read_excel`

`get_excel_info`

`get_sheet_names`

`analyze_excel`

`filter_excel`

`pivot_table`

`data_summary`

`export_chart`

`write_excel`

`update_excel`