Excel MCP - AI-Powered Spreadsheet Automation

Excel MCP is an AI-powered Excel automation server that bridges natural language and spreadsheet operations. This Excel AI solution enables seamless Excel Formula MCP integration, spreadsheets MCP automation, and comprehensive AI Excel workflows using Aspose.Cells for Node.js.

📊 Supported File Formats

📥 Files We Can Load

Excel: .xlsx, .xlsm, .xlsb, .xls (Excel 97-2003)
OpenDocument: .ods, .fods, .ots, .sxc
Text/Data: .csv, .tsv, .md (Markdown)
XML: .xml (SpreadsheetML)

💾 Formats We Can Save To

All loadable formats above ✅
Documents: .pdf, .html, .mht
Images: .png, .jpeg, .tiff, .svg, .bmp, .gif
Data Exchange: .json
Total: 20+ formats supported!

AI-Powered Excel Operations & Spreadsheet Automation

This Excel MCP server enables AI assistants to create and format Excel spreadsheets programmatically through natural language. Perfect for Excel AI automation, AI-powered Excel report generation, Excel formula automation, and intelligent spreadsheet processing through conversational interfaces.

Key Capabilities

AI Excel Data Processing: Convert data into structured Excel worksheets with intelligent automation
Excel Formula Automation: Apply Excel formulas and calculations automatically through AI Excel integration
Smart Excel Formatting: Apply fonts, colors, borders, and Excel cell styles with AI-powered precision
Excel Layout Management: Manage Excel rows, Excel columns, and Excel cell operations intelligently
Multi-sheet Excel Support: Create and manage multiple Excel worksheets with spreadsheet MCP capabilities
Excel AI Integration: Seamless Excel MCP integration with popular AI platforms and tools

Use Cases

AI Excel Report Generation: Generate professional Excel reports from conversational data using Excel AI
Smart Spreadsheet Creation: Create formatted Excel spreadsheets from raw data with AI automation
Excel AI Data Conversion: Convert images/screenshots of tables into Excel files using AI Excel processing
Excel Task Automation: Automate repetitive Excel tasks with Excel MCP and AI-powered workflows
Excel Data Analysis: Build intelligent Excel data analysis workflows with Excel Formula MCP
Excel AI Chat Interface: Create Excel files through natural language conversations with AI assistants
Spreadsheet AI Integration: Integrate spreadsheets MCP with AI platforms for seamless automation

Overview

This Excel MCP server empowers AI assistants with 25+ comprehensive Excel automation tools organized for intelligent spreadsheet MCP operations:

📂 Excel File & Data Operations

create_workbook - Create new Excel workbooks with AI Excel automation
create_worksheet - Add Excel worksheets to existing Excel workbooks
get_workbook_info - Get comprehensive Excel workbook metadata with data preview, file analysis, VBA detection, pivot tables, charts, named ranges, and protection status
read_data_from_excel - Read tabular data from Excel worksheets with AI-powered precision
write_data_to_excel - Write tabular data to Excel worksheets through Excel MCP

📊 Excel Enhanced JSON Operations

read_worksheet - Read Excel worksheets and convert to JSON format (includes styles, fonts, formulas, merged cells, row/column dimensions, and complete formatting)
write_worksheet - Create Excel worksheets from JSON format (includes styles, fonts, formulas, merged cells, and complete formatting)
update_worksheet - Update existing Excel worksheets with new data from JSON format while preserving existing formatting

🧮 Excel Formula Operations

apply_formula - Apply Excel formulas to cells (SUM, IF, VLOOKUP, COUNTIF, AVERAGE, etc.) with automatic calculation and Excel Formula MCP

🎨 Excel Cell Formatting

cell_format - Advanced Excel cell formatting including:
- Font styling (family, size, bold, italic, underline, strikethrough, subscript/superscript, colors)
- Background patterns and colors with custom patterns
- Borders with individual side control, styles, and colors
- Alignment (horizontal, vertical, text rotation, text wrap, indentation)
- Number formatting with custom patterns (currency, dates, percentages, etc.)
- Cell protection (locked/hidden formulas)

🗂️ Excel Row & Column Operations

insert_delete_rows_columns - Insert/delete rows and columns with batch support:
- Insert rows/columns at specified positions
- Delete rows/columns with range support
- Batch operations for multiple ranges
resize_rows_columns - Resize rows and columns with precise measurements:
- Set row height in points with exact measurements
- Set column width in characters with precise control
- Auto-fit rows and columns to content
hide_unhide_rows_columns - Hide/unhide rows and columns:
- Hide rows/columns by setting height/width to zero
- Unhide rows/columns by restoring default dimensions

🔗 Excel Cell Operations

merge_cells - Merge/unmerge cells with advanced merge types:
- Merge cells into single cell
- Unmerge cells to restore individual cells
- Merge by rows for row-wise merging
copy_paste_cells - Copy/paste operations with cross-sheet support:
- Copy all content (values, formulas, formats)
- Copy text only (calculated values, no formatting)
- Copy formats only (styling without data)
- Cross-sheet operations for complex workbook manipulation
clear_cells - Clear cell operations with selective clearing:
- Clear contents (values and formulas)
- Clear formats (styling only)
- Clear all (contents and formats)

📈 Excel Pivot Tables & Charts

create_pivot_table - Create pivot tables with comprehensive configuration:
- Row/column/data/filter fields with advanced grouping
- Multiple aggregations (sum, count, average, max, min, etc.)
- Date grouping (years, months, quarters, days)
- Custom layouts (compact, outline, tabular)
- Styling and formatting options
excel_chart_basic - Create charts with extensive customization:
- Chart types: Column, Bar, Line, Area, Scatter, Combination
- Advanced styling: Colors, fonts, legends, titles
- Data series configuration and formatting
excel_chart_pie - Create pie charts with specialized options:
- Pie and doughnut charts with slice customization
- Data labels and percentage display
- Explosion effects for highlighted slices

🔄 Excel File Conversion

excel_to_pdf - PDF conversion with page layout options:
- Worksheet selection (specific sheet or all sheets)
- Page layout: one page per sheet, fit columns to page width
excel_to_image - Image conversion supporting PNG, JPG, TIFF, BMP, SVG with quality control:
- Quality settings (1-100) and DPI control (resolution)
- Worksheet selection for specific sheet conversion
excel_to_csv - CSV/TSV conversion with delimiter options:
- Custom separators (comma, tab, or custom characters)
excel_converter - Universal format converter supporting 20+ formats:
- Excel formats: XLSX, XLSM, XLSB, XLS, XLTX, XLTM
- Documents: PDF, HTML, MHT, JSON, XML, Markdown
- Images: PNG, JPG, TIFF, SVG, BMP, GIF
- Data formats: CSV, TSV, DBF, DIF
- OpenDocument: ODS, FODS
- Total: 20+ formats supported

Advanced Capabilities

🔍 Intelligent Workbook Analysis

Smart data preview with automatic header detection and sample data extraction
Comprehensive metadata analysis including file properties, VBA detection, and external links
Sheet analysis with formula detection, pivot table counting, and chart identification
Protection status and visibility assessment for all worksheets

🎨 Professional Formatting Engine

Complete font control including advanced typography (subscript/superscript, text rotation)
Sophisticated border system with individual side control and custom styling
Pattern-based backgrounds with full color palette support
Advanced alignment with text wrapping, indentation, and rotation capabilities
Custom number formatting for currencies, dates, percentages, and scientific notation

📊 Advanced Business Intelligence

Pivot table automation with complex grouping and aggregation options
Chart generation with professional styling and multiple chart types
Data analysis tools with advanced formula support
Cross-sheet data relationships and complex workbook structures

🔄 Universal Format Conversion

20+ output formats including PDF, images, documents, and data formats
Intelligent range export for partial data extraction
Quality control with DPI and compression settings for images
Advanced PDF options with page layout and formula calculation control
Smart JSON export with data type preservation and structure analysis

📋 JSON-Based Excel Operations

Complete style preservation during read/write operations
Merged cell handling with intelligent area detection
Formula preservation and calculation support
Row/column dimension management with auto-sizing
Cross-sheet operations for complex workbook manipulation

⚡ Batch Processing Support

Multiple range formatting in single operations
Specialized row/column operations with dedicated services for insert/delete, resize, and visibility
Cross-sheet copy/paste operations with selective content copying
Advanced cell operations with merge types, copy/paste options, and clear operations
Bulk pivot table and chart creation for dashboard automation

Installation

Install the Excel MCP server for AI Excel automation:

npm install aspose.cells.mcp

Quick Start - Excel MCP Setup

MCP Client Configuration for Excel AI

Add the Excel MCP server to your AI client configuration for Excel automation:

{
  "mcpServers": {
    "aspose-cells": {
      "command": "npx",
      "args": ["aspose.cells.mcp@latest"],
      "env": {
        "LICENSE_PATH": "/path/to/your/Aspose.Total.lic",
        "WORK_DIR": "/path/to/your/work/directory"
      }
    }
  }
}

Platform-Specific Excel MCP Installation

Install Excel MCP in VS Code

You can install the Excel MCP server for AI Excel integration using the VS Code CLI:

# For VS Code
code --add-mcp '{"name":"aspose-cells","command":"npx","args":["aspose.cells.mcp@latest"]}'

After installation, the Excel MCP server will be available for Excel AI automation with your GitHub Copilot agent in VS Code.

Install Excel MCP in Cursor

Go to Cursor Settings → MCP → Add new MCP Server. Name it "excel-mcp" or "aspose-cells", use command type with the command npx aspose.cells.mcp for Excel AI functionality. You can also add environment variables by clicking Edit.

{
  "mcpServers": {
    "aspose-cells": {
      "command": "npx",
      "args": ["aspose.cells.mcp@latest"],
      "env": {
        "LICENSE_PATH": "/path/to/your/Aspose.Total.lic",
        "WORK_DIR": "/path/to/your/work/directory"
      }
    }
  }
}

Install in Windsurf

Follow Windsurf MCP documentation. Use the following configuration:

{
  "mcpServers": {
    "aspose-cells": {
      "command": "npx",
      "args": ["aspose.cells.mcp@latest"],
      "env": {
        "LICENSE_PATH": "/path/to/your/Aspose.Total.lic",
        "WORK_DIR": "/path/to/your/work/directory"
      }
    }
  }
}

Install in Claude Desktop

Follow the MCP install guide, use the following configuration:

{
  "mcpServers": {
    "aspose-cells": {
      "command": "npx",
      "args": ["aspose.cells.mcp@latest"],
      "env": {
        "LICENSE_PATH": "/path/to/your/Aspose.Total.lic",
        "WORK_DIR": "/path/to/your/work/directory"
      }
    }
  }
}

Install in Qodo Gen

Open Qodo Gen chat panel in VSCode or IntelliJ → Connect more tools → + Add new MCP → Paste the following configuration:

{
  "mcpServers": {
    "aspose-cells": {
      "command": "npx",
      "args": ["aspose.cells.mcp@latest"],
      "env": {
        "LICENSE_PATH": "/path/to/your/Aspose.Total.lic",
        "WORK_DIR": "/path/to/your/work/directory"
      }
    }
  }
}

Click Save.

Environment Variables

LICENSE_PATH - Path to Aspose.Total license file (optional, runs in evaluation mode without it)
WORK_DIR - Working directory for file operations (optional)

License

Commercial license required for production use. Evaluation mode available for testing.

Visit Temporary License for licensing information.

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
src		src
test		test
.gitignore		.gitignore
.npmignore		.npmignore
AGENTS.md		AGENTS.md
README.md		README.md
index.d.ts		index.d.ts
index.d.ts.map		index.d.ts.map
index.js.map		index.js.map
index.ts		index.ts
package.json		package.json
tsconfig.json		tsconfig.json

Folders and files

Latest commit

History

Repository files navigation

Excel MCP - AI-Powered Spreadsheet Automation

📊 Supported File Formats

📥 Files We Can Load

💾 Formats We Can Save To

AI-Powered Excel Operations & Spreadsheet Automation

Key Capabilities

Use Cases

Overview

📂 Excel File & Data Operations

📊 Excel Enhanced JSON Operations

🧮 Excel Formula Operations

🎨 Excel Cell Formatting

🗂️ Excel Row & Column Operations

🔗 Excel Cell Operations

📈 Excel Pivot Tables & Charts

🔄 Excel File Conversion

Advanced Capabilities

🔍 Intelligent Workbook Analysis

🎨 Professional Formatting Engine

📊 Advanced Business Intelligence

🔄 Universal Format Conversion

📋 JSON-Based Excel Operations

⚡ Batch Processing Support

Installation

Quick Start - Excel MCP Setup

MCP Client Configuration for Excel AI

Platform-Specific Excel MCP Installation

Environment Variables

License

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages