Microsoft Office MCP Servers

This repository contains Model Context Protocol (MCP) servers for interacting with Microsoft Office applications through AI assistance. Currently supported applications:

• PowerPoint: Create and manipulate presentations
• Excel: Interact with workbooks and spreadsheets

Both servers use pywin32 for COM automation, allowing direct interaction with running Office applications.

Prerequisites

• Windows operating system
• Microsoft Office installed (PowerPoint and/or Excel)
• Python 3.7+
• pywin32 package

Installation

1. Clone the repository:

git clone https://github.com/jenstangen1/mcp-pptx.git
cd mcp-pptx

2. Install dependencies using uv:

uv pip install pywin32

3. Run the pywin32 post-install script with administrator privileges:

python C:\path\to\your\env\Scripts\pywin32_postinstall.py -install

Setting up with Claude

To integrate these MCP servers with Claude, add the following configuration to your Claude Desktop app settings:

{
    "mcpServers": {
        "powerpoint_mcp_win32": {
            "command": "uv",
            "args": [
                "run",
                "mcp_powerpoint_server_win32.py"
            ],
            "cwd": "C:\\path\\to\\your\\workspace"
        },
        "excel_mcp_win32": {
            "command": "uv",
            "args": [
                "run",
                "mcp_excel_server_win32.py"
            ],
            "cwd": "C:\\path\\to\\your\\workspace"
        }
    }
}

Note: Replace C:\\path\\to\\your\\workspace with your actual workspace path.

PowerPoint MCP Server

The PowerPoint server provides a comprehensive API for AI models to interact with PowerPoint presentations, supporting advanced formatting, financial charts, and data integration.

Features

Presentation Management

• Create and modify PowerPoint presentations
• Add, delete, and modify slides
• Save and load presentations from workspace
• Template management system

Element Operations

• Fine-grained control over slide elements (text, shapes, images, charts)
• Advanced shape creation and styling
• Element positioning and grouping
• Connector lines between shapes

Financial Integration

• Create financial charts (line, bar, column, pie, waterfall, etc.)
• Generate comparison tables
• Support for various financial metrics:
  • Revenue
  • EBITDA
  • Profit
  • Assets
  • Equity
  • Growth rates
  • Margins
• Currently uses dummy data, with plans to integrate Proff API for Norwegian company data
• Adaptable to other financial data providers through API customization

Styling and Formatting

• Rich text formatting
• Shape styling (fills, gradients, outlines)
• Chart customization
• Background colors and effects

Note: You may need to modify the directory path to match your installation location.

Available MCP Tools

Presentation Management

• list_presentations: List all PowerPoint files in the workspace
• upload_presentation: Upload a new presentation to the workspace
• save_presentation: Save the current presentation

Slide Operations

• add_slide: Add a new slide to the presentation
• delete_slide: Delete a slide from the presentation
• get_slide_count: Get the total number of slides in the presentation
• analyze_slide: Analyze the content of a slide
• set_background_color: Set the background color of a slide

Element Operations

• add_text: Add text to a slide
• add_shape: Add a shape to a slide
• edit_element: Edit an element's properties
• style_element: Apply styling to an element
• connect_shapes: Connect two shapes with a connector
• find_element: Find elements on a slide based on criteria

Financial Tools

• get_company_financials: Get financial data for a company (currently returns dummy data)
• create_financial_chart: Create a financial chart on a slide
• create_comparison_table: Create a comparison table for companies

Note: The financial tool

... View full README on GitHub