Which integrations are available for this server?

Integrates with GitHub Copilot to allow performing Excel operations through natural language prompts in VS Code, such as reading, writing, and manipulating Excel files.

How do I use excel-mcp?

This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.

excel-mcp

by az-coder-123

Overview Schema Source Related Servers Discussions Admin

TypeScript

Local

Excel MCP Server

A Model Context Protocol (MCP) server for Excel operations with enterprise-grade security and clean architecture. Seamlessly integrates with GitHub Copilot, Cline, and other MCP-compatible tools in VS Code.

Features

Complete Excel Operations: Read, write, and manipulate Excel files (.xlsx, .xls)
Clean Architecture: Follows Single Responsibility Principle for maintainability
Enterprise Security: Robust permission system with path restrictions and access control
VS Code Integration: Works seamlessly with GitHub Copilot and Cline
TypeScript: Full type safety with modern ES2022+ features
Zero Deprecated Dependencies: Uses only current, actively maintained libraries

Related MCP server: Excel MCP Server

Quick Start

Installation

# Clone the repository
git clone https://github.com/az-coder-123/excel-mcp.git
cd excel-mcp

# Install dependencies
npm install

# Build the project
npm run build

# Copy example environment file
cp .env.example .env

📌 Đã cấu hình sẵn cho Cline

Server đã được cấu hình và kết nối sẵn với Cline! Xem Hướng dẫn cài đặt chi tiết để biết:

✅ Trạng thái hiện tại: Đã kết nối và hoạt động bình thường

Server đang chạy: node dist/index.js
Cấu hình Cline: .cline/mcp_servers.json
File cấu hình đã sẵn sàng sử dụng

Xem ngay: docs/SETUP_GUIDE.md để biết cách sử dụng

Configuration

Edit .env file to customize permissions:

# Restrict access to specific directories
MCP_ALLOWED_PATHS=/home/user/documents,/workspace

# Block sensitive system directories
MCP_DENIED_PATHS=/etc/*,/sys/*,C:\Windows\*

# Set maximum file size (50MB default)
MCP_MAX_FILE_SIZE=52428800

VS Code Integration

This server works seamlessly with MCP-compatible tools in VS Code. See the dedicated setup guides for detailed configuration instructions:

Google Antigravity Setup — Configuration for Google Antigravity IDE and agy CLI.
GitHub Copilot Setup — Configuration for GitHub Copilot Chat in VS Code.
Cline Setup — Configuration for the Cline extension in VS Code.

Available Tools

For detailed parameter references, see the Tools Reference.

System

Tool	Description
`excel_health_check`	Check server health, dependencies, and configuration

Workbook Operations

Tool	Description
`excel_open_workbook`	Open an Excel file for operations
`excel_create_workbook`	Create a new Excel workbook
`excel_save_workbook`	Save the workbook to disk
`excel_close_workbook`	Close an opened workbook
`excel_get_workbook_context`	Get workbook context and state
`excel_export_worksheet_to_new_file`	Export worksheet to a new Excel file

Worksheet Operations → Detailed docs

Tool	Description
`excel_list_worksheets`	List all worksheets in a workbook
`excel_add_worksheet`	Add a new worksheet
`excel_delete_worksheet`	Delete a worksheet
`excel_rename_worksheet`	Rename a worksheet
`excel_copy_worksheet`	Copy a worksheet
`excel_insert_rows`	Insert rows at position
`excel_delete_rows`	Delete rows from position
`excel_insert_columns`	Insert columns at letter
`excel_delete_columns`	Delete columns from letter
`excel_merge_cells`	Merge a cell range
`excel_unmerge_cells`	Unmerge cells
`excel_add_table`	Add styled Excel table
`excel_add_filter`	Add auto-filter to range
`excel_remove_filter`	Remove auto-filter

Cell Operations → Detailed docs

Tool	Description
`excel_read_cell`	Read a single cell value
`excel_read_range`	Read multiple cells
`excel_write_cell`	Write a value to a cell
`excel_write_batch`	Write multiple cells at once
`excel_get_cell_info`	Get detailed cell information (type, formula)
`excel_copy_range`	Copy a cell range to another location
`excel_find_replace`	Find and replace text
`excel_sort_range`	Sort a range ascending/descending
`excel_get_named_ranges`	List defined named ranges
`excel_add_named_range`	Create a new named range

Formatting & Styles → Detailed docs

Tool	Category	Docs
`excel_set_font_style`	Font & Text	→
`excel_set_font_name_size`	Font & Text	→
`excel_set_rich_text`	Font & Text	→
`excel_set_alignment`	Alignment	→
`excel_center_text`	Alignment	→
`excel_set_border`	Borders	→
`excel_apply_all_borders`	Borders	→
`excel_apply_outline_border`	Borders	→
`excel_set_background_color`	Colors	→
`excel_set_font_color`	Colors	→
`excel_set_gradient_fill`	Colors	→
`excel_set_number_format`	Number Formats	→
`excel_apply_currency_format`	Number Formats	→
`excel_apply_percentage_format`	Number Formats	→
`excel_apply_date_format`	Number Formats	→
`excel_apply_header_style`	Style Presets	→
`excel_apply_title_style`	Style Presets	→
`excel_apply_table_style`	Style Presets	→
`excel_auto_fit_columns`	Layout & Dimensions	→
`excel_set_column_width`	Layout & Dimensions	→
`excel_set_row_height`	Layout & Dimensions	→
`excel_freeze_panes`	Layout & Dimensions	→
`excel_set_print_area`	Layout & Dimensions	→
`excel_add_header_footer`	Layout & Dimensions	→
`excel_add_comment`	Notes & Links	→
`excel_remove_comment`	Notes & Links	→
`excel_add_hyperlink`	Notes & Links	→
`excel_add_data_validation`	Validation	→
`excel_format_worksheet`	Batch Formatting	→
`excel_batch_format`	Batch Formatting	→

Data Utilities & Analytics → Detailed docs

Tool	Category	Docs
`excel_import_csv`	CSV Transfer	→
`excel_export_csv`	CSV Transfer	→
`excel_find_duplicates`	Duplicates	→
`excel_count_unique_values`	Duplicates	→
`excel_highlight_duplicates`	Duplicates	→
`excel_remove_duplicates`	Duplicates	→
`excel_text_to_columns`	Transformations	→
`excel_flash_fill`	Transformations	→
`excel_vlookup`	Lookups	→
`excel_index_match`	Lookups	→
`excel_create_pivot_table`	Pivot Tables	→
`excel_get_column_stats`	Analytics	→
`excel_filter_data`	Analytics	→
`excel_group_aggregate`	Analytics	→
`excel_profile_data`	Analytics	→
`excel_search`	Search	→
`excel_compare_ranges`	Range Comparison	→

Visualizations & Protection → Charts | Protection

Tool	Category	Docs
`excel_add_chart`	Charts	→
`excel_update_chart`	Charts	→
`excel_delete_chart`	Charts	→
`excel_list_charts`	Charts	→
`excel_add_conditional_format`	Conditional Formats	→
`excel_remove_conditional_format`	Conditional Formats	→
`excel_add_data_bar`	Visual Rules	→
`excel_add_color_scale`	Visual Rules	→
`excel_add_icon_set`	Visual Rules	→
`excel_protect_worksheet`	Protection	→
`excel_unprotect_worksheet`	Protection	→
`excel_protect_cells`	Protection	→

Formula Engineering & Auditing → Detailed docs

Tool	Category	Docs
`excel_list_formulas`	Inventory	→
`excel_analyze_formula`	Structure Analysis	→
`excel_get_dependencies`	Dependencies	→
`excel_trace_precedents`	Precedent Tracing	→
`excel_trace_dependents`	Dependent Tracing	→
`excel_check_circular`	Cycle Detection	→
`excel_explain_formula`	Multi-language Explanation	→
`excel_audit_formulas`	Automated Audit	→

Accounting & Finance → Detailed docs

Tool	Category	Docs
`excel_financial_sum`	Financial Calculations	→
`excel_financial_average`	Financial Calculations	→
`excel_running_total`	Financial Calculations	→
`excel_percentage_of_total`	Financial Calculations	→
`excel_year_to_date`	Financial Calculations	→
`excel_accounting_format`	Accounting Formats	→
`excel_vnd_currency_format`	Accounting Formats	→
`excel_negative_red_format`	Accounting Formats	→
`excel_show_zeros_instead_of_empty`	Accounting Formats	→
`excel_period_comparison`	Financial Analysis	→
`excel_variance_analysis`	Financial Analysis	→
`excel_check_balance`	Financial Analysis	→
`excel_find_anomalies`	Financial Analysis	→
`excel_calculate_npv`	Investment Analysis	→
`excel_calculate_irr`	Investment Analysis	→
`excel_calculate_xirr`	Investment Analysis	→
`excel_calculate_financial_ratio`	Investment Analysis	→
`excel_create_amortization_schedule`	Loan & Debt	→
`excel_create_aging_report`	Loan & Debt	→
`excel_calculate_tax`	Tax & Currency	→
`excel_calculate_progressive_tax`	Tax & Currency	→
`excel_convert_currency`	Tax & Currency	→
`excel_calculate_depreciation`	Asset Depreciation	→

Usage Examples & Reference

Examples — Practical usage examples for all tool groups
Reference — Color codes, border styles, font names, AARRGGBB format

Security Features

Permission Levels

read: Read-only access to Excel files
write: Create and modify Excel files
delete: Delete worksheets and clear data
admin: Full administrative access

Path Restrictions

Configure allowed and denied paths using wildcards:

# Allow only specific directories
MCP_ALLOWED_PATHS=/workspace/*,/home/user/documents/*

# Block sensitive system paths
MCP_DENIED_PATHS=/etc/*,/sys/*,/proc/*,C:\Windows\*

File Size Limits

Prevent processing of excessively large files:

MCP_MAX_FILE_SIZE=52428800  # 50MB

Extension Whitelist

Only process specific file types (configured by default):

.xlsx - Excel Workbook
.xls - Excel 97-2003 Workbook
.xlsm - Excel Macro-Enabled Workbook
.xlsb - Excel Binary Workbook

Architecture

excel-mcp/
├── src/
│   ├── index.ts                 # Application entry point
│   ├── types/
│   │   └── index.ts            # Type definitions
│   ├── security/
│   │   └── permission-checker.ts # Access control
│   ├── services/
│   │   └── excel-service.ts    # Excel operations
│   ├── tools/
│   │   ├── tool-definitions.ts # Tool schemas
│   │   └── tool-handler.ts     # Tool execution
│   ├── server/
│   │   └── excel-mcp-server.ts # MCP server core
│   └── utils/
│       └── logger.ts           # Logging utility
├── docs/
│   ├── AI_WORKFLOW.md          # AI agent SOP & collaboration guidelines
│   ├── ARCHITECTURE.md         # Architecture details
│   ├── API.md                  # API reference
│   ├── SECURITY.md             # Security guide
│   └── TROUBLESHOOTING.md      # Common issues
└── dist/                       # Compiled JavaScript

Design Principles

Single Responsibility: Each class/module has one clear purpose
Dependency Injection: Components are loosely coupled
Type Safety: Full TypeScript coverage with strict mode
Error Handling: Comprehensive error catching and reporting
Security First: Permission checks before all operations

Development

Scripts

# Development with hot reload
npm run dev

# Build for production
npm run build

# Run tests
npm test

# Lint code
npm run lint

# Format code
npm run format

# Clean build artifacts
npm run clean

Project Structure

src/ - TypeScript source files
dist/ - Compiled JavaScript output
docs/ - Documentation
package.json - Dependencies and scripts
tsconfig.json - TypeScript configuration

Environment Variables

Variable	Description	Default
`MCP_SERVER_NAME`	Server identifier	`excel-mcp`
`MCP_SERVER_VERSION`	Server version	`1.0.0`
`MCP_LOG_LEVEL`	Logging verbosity	`info`
`MCP_ALLOWED_PATHS`	Comma-separated allowed paths	All paths
`MCP_DENIED_PATHS`	Comma-separated denied paths	System paths
`MCP_MAX_FILE_SIZE`	Maximum file size in bytes	`52428800` (50MB)

Troubleshooting

Common Issues

"Permission denied" errors

Check your MCP_ALLOWED_PATHS configuration
Ensure the file isn't in a denied path
Verify you have the required permission level

"Workbook not opened" errors

Call excel_open_workbook before other operations
Check that the file path is correct
Ensure the file isn't corrupted

TypeScript compilation errors

Run npm install to ensure all dependencies are installed
Check Node.js version (requires >= 18.0.0)

For more troubleshooting help, see docs/TROUBLESHOOTING.md.

License

MIT License - see LICENSE file for details.

Contributing

Contributions are welcome! Please read our contributing guidelines and code of conduct.

Support

GitHub Issues: Report bugs
Documentation: Full docs
Tools Reference: Tools index

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

This server cannot be deployed

Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

Resources

Related MCP Connectors

outlook-email
com.mintmcp
A MCP server for Outlook email that lets you search, read, and draft emails and replies.
Communication Workplace & Productivity
28
https://outlook-email.mintmcp.com/mcp
gcalA
com.mintmcp
A MCP server that works with Google Calendar to manage event listing, reading, and updates.
Calendar Management App Automation
728
https://gcal.mintmcp.com/mcp
outlook-calendar
com.mintmcp
A MCP server that works with Outlook Calendar to manage event listing, reading, and updates.
Calendar Management Communication App Automation
38
https://outlook-calendar.mintmcp.com/mcp
PDF Redaction MCPA
com.pdf-redaction
MCP server for detecting and redacting PII (Personally Identifiable Information) in PDF documents.
File Systems Security
23
https://api.pdf-redaction.com/mcp/

Related MCP Servers

Excel MCP Server
Data Platforms Developer Tools Research & Data
yzfly
A
license
B
quality
D
maintenance
An MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.
Updated 4 months ago (2026-07-02 08:06 UTC)
8
95
MIT
Excel MCP Server
Developer Tools File Systems Workplace & Productivity
jauinones
A
license
Not graded
quality
D
maintenance
An MCP server for manipulating Excel files that features a headless engine for real-time formula calculation and data validation. It enables users to create, read, and manage workbooks, sheets, and charts without requiring Microsoft Excel installed.
Updated 10 months ago (2026-01-14 17:09 UTC)
26 npm
MIT
xls-mcp-servers
File Systems Developer Tools
Lincyghb
A
license
Not graded
quality
D
maintenance
MCP server for reading and writing .xls (Excel 97-2003) files, enabling data manipulation, sheet listing, and metadata retrieval.
Updated 10 months ago (2026-01-22 07:04 UTC)
MIT
MCP Document Processorofficial
File Systems Developer Tools Knowledge & Memory
leanzero-srl
A
license
A
quality
B
maintenance
An MCP server for reading, creating, and managing PDF, DOCX, and Excel documents with OCR, styling, categorization, and remote file bridges.
Updated 6 days ago (2026-11-05 23:30 UTC)
17
1
MIT

Excel MCP Server

Features

Quick Start

Installation

📌 Đã cấu hình sẵn cho Cline

Configuration

VS Code Integration

Available Tools

System

Workbook Operations

Worksheet Operations → Detailed docs

Cell Operations → Detailed docs

Formatting & Styles → Detailed docs

Data Utilities & Analytics → Detailed docs

Visualizations & Protection → Charts | Protection

Formula Engineering & Auditing → Detailed docs

Accounting & Finance → Detailed docs

Usage Examples & Reference

Security Features

Permission Levels

Path Restrictions

File Size Limits

Extension Whitelist

Architecture

Design Principles

Development

Scripts

Project Structure

Environment Variables

Troubleshooting

Common Issues

License

Contributing

Support

Tool Schema Changelog

Resources

Related MCP Connectors

Related MCP Servers

Excel MCP Server

Excel MCP Server

xls-mcp-servers

MCP Document Processorofficial