Excel -Master

Excel Master MCP Server lets you manipulate Excel workbooks without requiring Microsoft Excel. It exposes a suite of tools to create, read, write, format, and visualize data inside .xlsx/.xlsm/.xlstx/.xltm files, plus capabilities to import and export data to CSV, JSON, SQL, and PDF. The server is designed to work with MCP clients and AI assistants (e.g., Claude) to enable natural language-driven Excel automation—from creating formatted tables and dashboards to generating pivot tables and charts. Use the provided npm/npx entry point to run the server and connect your MCP client configuration to the excel-master entry, enabling a carousel of Excel operations through the MCP protocol. The server exposes tools such as create_workbook_tool, open_workbook_tool, write_sheet_data_tool, add_chart_tool, create_dashboard_tool, import_data_tool, export_data_tool, and more to cover end-to-end Excel workflows.

Prerequisites:

• Node.js (recommended latest LTS) installed or access to npm/npx
• Basic familiarity with MCP client configuration (JSON snippet shown below)

Option A: Run without installation using npx (recommended)

1. Ensure you have npm installed.
2. Run the MCP server with:

npx @guillehr2/excel-mcp-server@latest

Option B: Install globally and run

1. Install globally:

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

2. Run the server (the CLI entrypoint will start listening for MCP requests).

Option C: Use in development mode (from source)

1. Clone the repository and install dependencies:

git clone <repo-url>
cd Excel-MCP-Server-Master
npm install

2. Start in development mode (adjust path to entry.js as needed):

node path/to/Excel-MCP-Server-Master/index.js

Configuration tip: In your MCP client (e.g., Claude Desktop), reference the server as shown in the examples, typically using the npx command with -y and the package name to fetch a ready-to-use server instance.

Notes and tips:

• Commands and args shown in the README are standard IPC for MCP; you can switch between npx usage or a permanent local installation depending on your deployment model.
• The npm package name to use in MCP configs is @guillehr2/excel-mcp-server. If you pin a specific version, replace latest accordingly (e.g., @1.0.7).
• The server supports a broad set of Excel operations (read/write, formatting, charts, dashboards, imports/exports). When using in production, consider security/sandboxing and ensure AI-assisted commands do not expose sensitive data.
• If developing or testing locally, you can run in development mode by pointing to the source entry file (index.js) via the node command.
• Environment variables can be used to configure runtime behavior (e.g., logging level, temp directories). Add any needed VAR_NAME placeholders in your deployment configuration.