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

office-mcp