Home/数据分析/office-mcp
O

office-mcp

by @claude-office-skillsv
4.7(17)

MCP server, integrating 39 tools, supports processing office files such as Word, Excel, PowerPoint, and PDF.

Microsoft ExcelData Analysis in ExcelVBA MacrosPower QueryData VisualizationGitHub
Installation
npx skills add claude-office-skills/skills --skill office-mcp
compare_arrows

Before / After Comparison

1
Before

When handling Office documents such as Word, Excel, PPT, PDF, and performing OCR operations, frequent tool switching is required, leading to low efficiency and complex operations.

After

Provides 39 centralized Office document processing tools, covering Word, Excel, PPT, PDF, and OCR operations, offering a one-stop solution for document processing challenges and significantly improving work efficiency.

description SKILL.md


═══════════════════════════════════════════════════════════════════════════════

CLAUDE OFFICE SKILL - Enhanced Metadata v2.0

═══════════════════════════════════════════════════════════════════════════════

Basic Information

name: office-mcp description: "MCP server with 39 tools for Word, Excel, PowerPoint, PDF, OCR operations" version: "2.1" author: claude-office-skills license: MIT

Categorization

category: workflow tags:

  • office
  • mcp
  • pdf
  • excel
  • word
  • powerpoint
  • automation department: All

AI Model Compatibility

models: recommended: - claude-sonnet-4 - claude-opus-4 compatible: - claude-3-5-sonnet - gpt-4 - gpt-4o

Skill Capabilities

capabilities:

  • office_automation
  • mcp_tools
  • pdf_processing
  • spreadsheet_analysis
  • document_generation
  • presentation_creation
  • format_conversion

Language Support

languages:

  • en
  • zh

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)

ToolDescription
extract_text_from_pdfExtract text content, supports page selection
extract_tables_from_pdfExtract table data from PDFs
merge_pdfsMerge multiple PDFs into one
split_pdfSplit PDF by page ranges
compress_pdfReduce PDF file size
add_watermark_to_pdfAdd text/image watermarks
fill_pdf_formFill PDF form fields
get_pdf_metadataGet PDF properties and metadata
ocr_pdfOCR on scanned PDFs (multi-language)
ocr_imageOCR on image files (PNG, JPG, TIFF, etc.)

Spreadsheet Tools (7)

ToolDescription
read_xlsxRead Excel files with sheet/range selection
create_xlsxCreate multi-sheet Excel files
analyze_spreadsheetStatistical analysis (min/max/mean/median)
apply_formulaApply Excel formulas to cells
create_chartGenerate chart configurations
pivot_tableCreate pivot tables with aggregation
xlsx_to_jsonConvert Excel to JSON

Document Tools (6)

ToolDescription
extract_text_from_docxExtract text from Word documents
create_docxCreate DOCX with headings, lists, tables
fill_docx_templateFill templates with {{placeholders}}
analyze_document_structureAnalyze headings, tables, word count
insert_table_to_docxInsert tables into documents
merge_docx_filesMerge multiple Word documents

Conversion Tools (9)

ToolDescription
xlsx_to_csvConvert Excel to CSV
csv_to_xlsxConvert CSV to Excel
json_to_xlsxConvert JSON arrays to Excel
docx_to_mdConvert Word to Markdown
md_to_docxConvert Markdown to Word
pdf_to_docxConvert PDF to Word (text extraction)
docx_to_pdfConvert Word to PDF (external tool required)
html_to_pdfConvert HTML to PDF (external tool required)
batch_convertBatch convert multiple files

Presentation Tools (7)

ToolDescription
create_pptxCreate PowerPoint with themes
extract_from_pptxExtract text and images from PPTX
md_to_pptxConvert Markdown to slides
add_slideAdd slides to existing presentations
update_slideUpdate slide content
pptx_to_htmlConvert to reveal.js HTML
get_pptx_outlineGet 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

Resources

forumUser Reviews (0)

Write a Review

Effect
Usability
Docs
Compatibility

No reviews yet

Statistics

Installs452
Rating4.7 / 5.0
Version
Updated2026年3月16日
Comparisons1

User Rating

4.7(17)
5
0%
4
0%
3
0%
2
0%
1
0%

Rate this Skill

0.0

Compatible Platforms

🔧Claude Code
🔧OpenClaw
🔧OpenCode
🔧Codex
🔧Gemini CLI
🔧GitHub Copilot
🔧Amp
🔧Kimi CLI

Timeline

Created2026年3月16日
Last Updated2026年3月16日