X

xlwings Excel

Enables Excel file manipulation without Microsoft Excel installation through xlwings library, provid...

6 views
0 installs
Updated Dec 20, 2025
Not audited
Enables Excel file manipulation without Microsoft Excel installation through xlwings library, providing 30+ tools for workbook creation, data operations, formatting, formulas, charts, pivot tables, and worksheet management across Windows and cross-platform environments.
  1. Open the FastMCP connection interface for this MCP server

    • In FastMCP, locate the xlwings-mcp-server connection record and open its configuration pane.
  2. Click the “Install Now” button

    • Use the provided “Install Now” control to begin adding environment variables for the server.
  3. Add the environment variables into the FastMCP env form

    • For each of the following keys, create a new env entry and paste the value (or choose it in the UI) into the value field:
      1. EXCEL_MCP_SESSION_TTL — Session TTL in seconds. Default: 600. Example: 600
        • Type: integer (seconds). Controls how long an idle workbook session is retained.
      2. EXCEL_MCP_MAX_SESSIONS — Maximum concurrent sessions. Default: 8. Example: 8
        • Type: integer. Limits number of simultaneous Excel sessions.
      3. EXCEL_MCP_DEBUG_LOG — Enable debug logging. Default: 0. Example: 0 or 1
        • Type: boolean/int (0 = off, 1 = on). Turn on (1) to capture verbose logs for troubleshooting.
      4. EXCEL_MCP_VISIBLE — Show Excel windows. Default: false. Example: false or true
        • Type: boolean. Set true when you need visible Excel instances for debugging; usually false in production.
      5. EXCEL_MCP_CALC_MODE — Excel calculation mode. Default: automatic. Example: automatic, manual, or semiautomatic
        • Type: string. Controls Excel calculation behavior.
  4. Use sensible values and formats

    • Enter integers for TTL and MAX_SESSIONS (no units), 0/1 or true/false for boolean flags, and one of the strings listed above for CALC_MODE.
    • If you want the README defaults, use: EXCEL_MCP_SESSION_TTL=600, EXCEL_MCP_MAX_SESSIONS=8, EXCEL_MCP_DEBUG_LOG=0, EXCEL_MCP_VISIBLE=false, EXCEL_MCP_CALC_MODE=automatic.
  5. Save / Apply the environment configuration

    • Click Save / Apply in the FastMCP UI so the env values are persisted for the server install.
  6. Install / redeploy the MCP server via the FastMCP interface

    • Continue the “Install Now” workflow so FastMCP deploys the server with the provided envs.
  7. Start the server (if not auto-started) and confirm it reads the envs

    • Use FastMCP’s start/run controls or the server logs to confirm the service started and the configured values are in effect.
  8. Verify basic functionality

    • With debug logging enabled (optional), check the server logs for a successful startup message.
    • Optionally run a simple MCP call (for example, list_workbooks) from your MCP client to verify the server responds.
  9. Adjust and reapply if needed

    • If you need different behavior (longer TTL, more sessions, visible Excel), update the env values in the FastMCP connection interface and reapply/restart the server.
  10. Notes & prerequisites

    • This server requires Windows + Microsoft Excel installed on the host where the MCP server runs; ensure those prerequisites are met before expecting Excel-based operations to work.

Quick Start

More for Productivity

View All →

More for Automation

View All →

Similar MCP Servers

E

Excel File Manipulation

Enables Excel file manipulation without Microsoft Excel installation using openpyxl, providing workbook operations, data validation detection, formatting, formulas, charts, pivot tables, and native Excel table support for automating spreadsheet workflows and report generation.

Productivity Analytics and Data

Report Issue

Thank you! Your issue report has been submitted successfully.