Microsoft Office MCP Servers

• PowerPoint: Create and manipulate presentations

• Excel: Interact with workbooks and spreadsheets

Prerequisites

• Windows operating system

• Microsoft Office installed (PowerPoint and/or Excel)

• Python 3.7+

• `pywin32` package

Installation

1. Clone the repository:

1. Install dependencies using `uv`:

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

Setting up with Claude

PowerPoint MCP Server

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

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

Template Operations

• `list_templates`: List all available templates

• `apply_template`: Apply a template to a presentation

• `create_slide_from_template`: Create a new slide from a template

• `save_as_template`: Save a slide as a template

Debug Tools

• `debug_element_mappings`: Debug tool to inspect element mappings for a slide

Usage

Interacting with Claude

PowerPoint Examples

Excel Examples

How It Works

1. **Natural Language Understanding** - Claude interprets your requests and breaks them down into specific actions - It understands context from previous interactions - It can handle complex, multi-step operations

2. **Tool Selection** - Claude automatically selects the appropriate MCP tools for each task - It can chain multiple tools together for complex operations - It handles error cases and provides feedback

3. **Context Management** - Claude maintains context about: - Currently open files - Recent operations - Selected elements - User preferences

4. **Error Handling** - If an operation fails, Claude will: - Explain what went wrong - Suggest alternatives - Help troubleshoot common issues

Best Practices

1. **Be Specific** - Mention slide numbers when relevant - Specify exact cell ranges in Excel - Describe desired formatting clearly

2. **Complex Operations** - Break down complex requests into steps - Confirm intermediate results - Ask for adjustments as needed

3. **Troubleshooting** - Ensure PowerPoint/Excel is running - Check file permissions - Verify COM automation is working - Run pywin32_postinstall.py if needed

Example Workflows

Creating a Financial Presentation

Analyzing Excel Data

Directory Structure

Dependencies

• python-pptx: PowerPoint file manipulation

• Pillow: Image processing

• numpy: Numerical operations

• MCP SDK: Model Context Protocol implementation

Contributing

License

Excel MCP Server

Features

Workbook Management

• Connect to running Excel instances

• List open workbooks

• Save workbooks with various formats (.xlsx, .xlsm, .xlsb, .xls)

Worksheet Operations

• List worksheets in a workbook

• Add new worksheets

• Access worksheets by name or index

Cell and Range Operations

• Read and write individual cell values

• Get and set values for cell ranges

• Handle various data types (text, numbers, dates, currency)

• Automatic type conversion for dates and currency values

Available MCP Tools

Workbook Management

• `list_open_workbooks`: List all currently open Excel workbooks

• `save_workbook`: Save a workbook to disk with optional format selection

Worksheet Operations

• `list_worksheets`: List all worksheets in a workbook

• `add_worksheet`: Add a new worksheet to a workbook

• `get_worksheet`: Get a worksheet by name or index

Cell and Range Operations

• `get_cell_value`: Read a single cell's value

• `set_cell_value`: Set a single cell's value

• `get_range_values`: Read values from a range of cells

• `set_range_values`: Set values for a range of cells

Notes

• Both servers require Windows and their respective Microsoft Office applications installed

• The servers interact with *running* instances of the applications

• COM automation requires proper initialization; run the post-install script if you encounter COM-related errors

• For better constant handling, consider using `makepy` to generate Office constants