Excel-MCP-Server-Master

Overview

The Excel MCP Server provides complete Excel manipulation capabilities through the Model Context Protocol, allowing users to read, write, analyze, and automate Excel files (.xlsx, .xlsm, .xltx, .xltm) without having Microsoft Excel installed. It supports advanced features like creating charts, pivot tables, dashboards, and importing/exporting data in multiple formats (CSV, JSON, PDF). The server integrates seamlessly with AI assistants like Claude and offers professional formatting options to create publication-ready documents.

Try asking AI

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

• create_workbook_tool

  Create a new Excel workbook without Microsoft Excel

  Try:Create a new sales report workbookTry:Generate an empty budget spreadsheet for me
• open_workbook_tool

  Open an existing Excel file (XLSX, XLSM, XLTX, XLTM)

  Try:Open the financial data spreadsheetTry:Load the Q3 report Excel file
• write_sheet_data_tool

  Write data to an Excel worksheet

  Try:Enter sales data into the spreadsheetTry:Update the monthly figures sheet
• list_sheets_tool

  List all worksheets in an Excel workbook

  Try:Show me all sheets in this workbookTry:What sheets are available in the report file
• add_sheet_tool

  Add a new worksheet to an Excel workbook

  Try:Create a summary sheet at the beginningTry:Add a new worksheet called 'Analysis'
• create_formatted_table_tool

  Create a formatted Excel table with professional styling

  Try:Format the sales data as a professional tableTry:Create a styled table with alternating row colors
• add_chart_tool

  Create charts in Excel files (column, bar, line, pie, scatter)

  Try:Add a column chart showing quarterly salesTry:Create a pie chart of market share data
• import_data_tool

  Import data from CSV, JSON, or SQL sources into Excel

  Try:Import data from sales.csv into a new sheetTry:Load customer information from JSON file
• export_data_tool

  Export Excel data to CSV, JSON, or PDF formats

  Try:Export the data as CSV for analysisTry:Convert the report to PDF format
• filter_data_tool

  Filter Excel data based on specified criteria

  Try:Filter sales data for regions with growth over 10%Try:Show only products with inventory below 50
• create_dashboard_tool

  Create dynamic Excel dashboards with tables and charts

  Try:Build an executive dashboard with key metricsTry:Create a performance dashboard with multiple charts
• update_cell_tool

  Update a specific cell in an Excel worksheet

  Try:Update cell B5 with the latest sales figureTry:Change the title in cell A1 to 'Annual Report'

Comparable tools

Installation

npx @guillehr2/excel-mcp-server@latest

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

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

FAQ

What Excel file formats are supported?

The server supports XLSX, XLSM, XLTX, and XLTM formats for reading and writing operations.

Does it require Microsoft Excel to be installed?

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

What chart types can be created?

The server supports creating various chart types including column, bar, line, pie, scatter, and area charts with multiple styling options.

Compare Excel-MCP-Server-Master with