Office MCP Server

Overview

A complete MCP (Model Context Protocol) server providing 39 tools for Office document operations. Implemented in TypeScript/Node.js with real functionality (not placeholders).

Tool Categories

PDF Tools (10)

| Tool | Description | |------|-------------| | extract_text_from_pdf | Extract text content, supports page selection | | extract_tables_from_pdf | Extract table data from PDFs | | merge_pdfs | Merge multiple PDFs into one | | split_pdf | Split PDF by page ranges | | compress_pdf | Reduce PDF file size | | add_watermark_to_pdf | Add text/image watermarks | | fill_pdf_form | Fill PDF form fields | | get_pdf_metadata | Get PDF properties and metadata | | ocr_pdf | OCR on scanned PDFs (multi-language) | | ocr_image | OCR on image files (PNG, JPG, TIFF, etc.) |

Spreadsheet Tools (7)

| Tool | Description | |------|-------------| | read_xlsx | Read Excel files with sheet/range selection | | create_xlsx | Create multi-sheet Excel files | | analyze_spreadsheet | Statistical analysis (min/max/mean/median) | | apply_formula | Apply Excel formulas to cells | | create_chart | Generate chart configurations | | pivot_table | Create pivot tables with aggregation | | xlsx_to_json | Convert Excel to JSON |

Document Tools (6)

| Tool | Description | |------|-------------| | extract_text_from_docx | Extract text from Word documents | | create_docx | Create DOCX with headings, lists, tables | | fill_docx_template | Fill templates with {{placeholders}} | | analyze_document_structure | Analyze headings, tables, word count | | insert_table_to_docx | Insert tables into documents | | merge_docx_files | Merge multiple Word documents |

Conversion Tools (9)

| Tool | Description | |------|-------------| | xlsx_to_csv | Convert Excel to CSV | | csv_to_xlsx | Convert CSV to Excel | | json_to_xlsx | Convert JSON arrays to Excel | | docx_to_md | Convert Word to Markdown | | md_to_docx | Convert Markdown to Word | | pdf_to_docx | Convert PDF to Word (text extraction) | | docx_to_pdf | Convert Word to PDF (external tool required) | | html_to_pdf | Convert HTML to PDF (external tool required) | | batch_convert | Batch convert multiple files |

Presentation Tools (7)

| Tool | Description | |------|-------------| | create_pptx | Create PowerPoint with themes | | extract_from_pptx | Extract text and images from PPTX | | md_to_pptx | Convert Markdown to slides | | add_slide | Add slides to existing presentations | | update_slide | Update slide content | | pptx_to_html | Convert to reveal.js HTML | | get_pptx_outline | Get presentation structure |

Installation

1. Clone and Build

cd mcp-servers/office-mcp
npm install
npm run build

2. Configure Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "office-mcp": {
      "command": "/usr/local/bin/node",
      "args": ["/path/to/claude-office-skills/mcp-servers/office-mcp/dist/index.js"]
    }
  }
}

3. Restart Claude Desktop

Example Prompts

"Read the Excel file at ~/Documents/sales.xlsx"
"Create a PowerPoint with 5 slides about AI trends"
"Extract text from this PDF and convert to Markdown"
"Merge these 3 Word documents into one"
"Analyze the data in this spreadsheet"

Dependencies

pdf-parse, pdf-lib       - PDF operations
tesseract.js             - OCR (pure JavaScript, no native binary needed)
xlsx                     - Excel operations
mammoth, docx            - Word operations
docxtemplater, pizzip    - Template filling
pptxgenjs, jszip         - PowerPoint operations
turndown, marked         - Markdown conversion

Supported OCR Languages

eng - English
chi_sim - Simplified Chinese
chi_tra - Traditional Chinese
jpn - Japanese
kor - Korean
fra - French
deu - German
spa - Spanish