excel-mcp-server

Overview

The excel-mcp-server provides comprehensive Excel manipulation capabilities through the Model Context Protocol. It allows AI agents to create, read, update, and modify Excel workbooks with extensive features including formulas, formatting, charts, pivot tables, and data validation. The server supports multiple transport methods (stdio, SSE, and streamable HTTP) and works both locally and as a remote service, making it versatile for different deployment scenarios.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• read_excel_file

  Read data from an Excel workbook

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

  Create a new Excel workbook

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

  Write data to a specific cell in a worksheet

  Try:Put 'Total' in cell A1Try:Set the value in B2 to 150.75
• add_formula

  Add a formula to a cell in a worksheet

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

  Create a chart from worksheet data

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

  Create a pivot table from worksheet data

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

  Apply formatting to cells in a worksheet

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

  Create an Excel table from data

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

  Add a new worksheet to a workbook

  Try:Add a new worksheet called SummaryTry:Create a backup worksheet named Archive
• rename_worksheet

  Rename an existing worksheet

  Try:Rename Sheet1 to Sales DataTry:Change the name of the second tab to Expenses
• delete_worksheet

  Delete a worksheet from a workbook

  Try:Delete the unused temp sheetTry:Remove the old data worksheet
• save_workbook

  Save changes to an Excel workbook

  Try:Save the changes to my financial spreadsheetTry:Update the budget file with new data

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

Comparable tools

Installation

pip install excel-mcp-server

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

EXCEL_FILES_PATH=/path/to/files uvx excel-mcp-server streamable-http

FAQ

Do I need Microsoft Excel installed to use this server?

No, this server manipulates Excel files without requiring Microsoft Excel to be installed on the system.

What transport methods are supported?

The server supports three transport methods: stdio (local use), SSE (deprecated), and streamable HTTP (recommended for remote connections).

Compare excel-mcp-server with