excel-mcp-server

概述

excel-mcp-server通过模型上下文协议提供了全面的Excel操作功能。它允许AI代理创建、读取、更新和修改Excel工作簿，具有公式、格式设置、图表、数据透视表和数据验证等丰富功能。服务器支持多种传输方式（stdio、SSE和可流式HTTP），既可作为本地服务运行，也可作为远程服务使用，适用于多种部署场景。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• read_excel_file

  Read data from an Excel workbook

  试试:Read data from the sales report.xlsx file试试:What's in the budget spreadsheet?
• create_workbook

  Create a new Excel workbook

  试试:Create a new workbook named quarterly_report.xlsx试试:Make me an empty spreadsheet for tracking expenses
• write_to_cell

  Write data to a specific cell in a worksheet

  试试:Put 'Total' in cell A1试试:Set the value in B2 to 150.75
• add_formula

  Add a formula to a cell in a worksheet

  试试:Add a sum formula to calculate the total in column C试试:Put a VLOOKUP formula in D3
• create_chart

  Create a chart from worksheet data

  试试:Create a bar chart from the sales data试试:Make a pie chart showing market share distribution
• create_pivot_table

  Create a pivot table from worksheet data

  试试:Create a pivot table to summarize quarterly sales by region试试:Make a pivot table showing average scores by department
• format_cells

  Apply formatting to cells in a worksheet

  试试:Make the header cells bold and centered试试:Format the numbers in column B as currency
• create_table

  Create an Excel table from data

  试试:Convert the data range into an Excel table试试:Create a formatted table from the monthly data
• add_worksheet

  Add a new worksheet to a workbook

  试试:Add a new worksheet called Summary试试:Create a backup worksheet named Archive
• rename_worksheet

  Rename an existing worksheet

  试试:Rename Sheet1 to Sales Data试试:Change the name of the second tab to Expenses
• delete_worksheet

  Delete a worksheet from a workbook

  试试:Delete the unused temp sheet试试:Remove the old data worksheet
• save_workbook

  Save changes to an Excel workbook

  试试:Save the changes to my financial spreadsheet试试:Update the budget file with new data

说明：Tool names inferred from feature descriptions in the README since it references a separate TOOLS.md file that wasn't provided

可对比工具

安装

pip install excel-mcp-server

{
  "mcpServers": {
    "excel": {
      "command": "uvx",
      "args": ["excel-mcp-server", "stdio"]
    }
  }
}

EXCEL_FILES_PATH=/文件路径 uvx excel-mcp-server streamable-http

FAQ

使用此服务器需要安装Microsoft Excel吗？

不需要，此服务器无需在系统上安装Microsoft Excel即可操作Excel文件。

支持哪些传输方式？

服务器支持三种传输方式：stdio（本地使用）、SSE（已弃用）和可流式HTTP（推荐用于远程连接）。

excel-mcp-server 对比