excel-vision-mcp
Enables AI agents to read Excel files with full content extraction, including embedded images, cell data, formulas, and merged cells, returning multimodal content for vision-capable models.
README
<div align="center">
π Excel Vision MCP
The first MCP server that lets AI agents see images inside your spreadsheets.
Read Excel files with full content extraction β cell data, formulas, merged cells, and embedded images β all returned as multimodal content your AI can actually understand.
Installation Β· Tools Β· Configuration Β· How It Works Β· FAQ
</div>
π€ The Problem
You ask your AI assistant to analyze an Excel document. It reads the text just fine β but completely misses the diagrams, screenshots, and charts embedded in the file. That's because every existing Excel MCP server ignores images.
Excel MCP Server fixes this. It extracts embedded images, optimizes them, and returns them as native ImageContent that vision-capable AI models can see and analyze β alongside all the text data.
β¨ Key Features
| Feature | Description |
|---|---|
| πΌοΈ Image Extraction | Extracts all embedded images with cell-position mapping |
| π Full Content Reading | Text + images in a single call β nothing is missed |
| π Smart Pagination | Handles massive spreadsheets without blowing up context |
| π Text Search | Find content across all sheets instantly |
| π 100% Local | Your files never leave your machine |
| β‘ Fast | 16MB file with 40 images processed in ~4 seconds |
| π₯οΈ Cross-Platform | macOS, Linux, Windows |
Image Extraction β What Makes This Different
Most Excel MCP servers only read cell values. This server uses a dual extraction strategy:
- Cell-Position Mapping (primary) β Maps each image to its exact cell location using
openpyxl-image-loader - Archive Scanning (fallback) β Scans the xlsx ZIP archive's
xl/media/directory to catch any images missed by method 1
The result: zero images left behind, with position metadata when available.
π Quick Start
Install via uvx (Recommended)
No installation needed β runs directly:
uvx excel-vision-mcp
Install via pip
pip install excel-vision-mcp
Then run:
excel-vision-mcp
Install from source
git clone https://github.com/VOYAGER-Inc/excel-vision-mcp.git
cd excel-vision-mcp
uv sync
uv run excel-vision-mcp
π§ Configuration
Add the server to your MCP client's configuration file.
Claude Desktop
Edit ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows):
{
"mcpServers": {
"excel-reader": {
"command": "uvx",
"args": ["excel-vision-mcp"]
}
}
}
Cursor
Edit .cursor/mcp.json in your project root:
{
"mcpServers": {
"excel-reader": {
"command": "uvx",
"args": ["excel-vision-mcp"]
}
}
}
Windsurf / VS Code (Copilot)
Edit your MCP settings file:
{
"mcpServers": {
"excel-reader": {
"command": "uvx",
"args": ["excel-vision-mcp"]
}
}
}
Antigravity IDE
Edit ~/.gemini/config/mcp_config.json:
{
"mcpServers": {
"excel-reader": {
"command": "uvx",
"args": ["excel-vision-mcp"]
}
}
}
Note: After editing the config, restart your IDE/client to load the new server.
π οΈ Available Tools
list_sheets
List all sheets with dimensions, merged cell counts, and image totals. Use this first to understand a workbook's structure.
list_sheets(file_path="/path/to/file.xlsx")
Returns: Sheet names, rowΓcolumn dimensions, data ranges, merged cell counts, total image count.
read_excel_data
Read cell data from a specific sheet with pagination support.
read_excel_data(
file_path="/path/to/file.xlsx",
sheet_name="Sheet1", # optional, defaults to first sheet
start_row=1, # optional, 1-indexed
max_rows=200 # optional, default 200
)
Returns: Cell values organized by row with coordinate labels and merged cell indicators.
extract_images
Extract all embedded images from the workbook as base64 ImageContent.
extract_images(
file_path="/path/to/file.xlsx",
sheet_name="Overview", # optional, None = all sheets
max_width=1024, # optional, resize limit
max_height=1024 # optional, resize limit
)
Returns: List of ImageContent (base64) with metadata β cell position, sheet name, original dimensions.
read_full_content β
The star tool. Reads ALL text data AND all embedded images in a single call. Ideal for comprehensive document analysis.
read_full_content(
file_path="/path/to/file.xlsx",
max_rows_per_sheet=500, # optional
max_image_width=1024, # optional
max_image_height=1024 # optional
)
Returns: Complete workbook contents β every sheet's data as structured text, followed by every embedded image with cell-position mapping.
Example use case: "Analyze this requirements document and summarize all use cases, including the workflow diagrams."
get_workbook_overview
Quick structural summary of a workbook β file size, sheet list, dimensions, image count.
get_workbook_overview(file_path="/path/to/file.xlsx")
search_excel
Case-insensitive text search across all cells in the workbook.
search_excel(
file_path="/path/to/file.xlsx",
query="revenue",
sheet_name="Q4 Report" # optional, None = all sheets
)
Returns: Matching cells with sheet name, coordinate, and value. Limited to 100 results.
βοΈ How It Works
Architecture
Your AI Client (Claude, Cursor, etc.)
β
β stdio (JSON-RPC)
βΌ
βββββββββββββββββββββββββββββββ
β Excel MCP Server β
β β
β βββββββββββββββββββββββββ β
β β openpyxl β ββββ Cell data, formulas, merged cells
β β (Excel parser) β β
β βββββββββββββββββββββββββ β
β β
β βββββββββββββββββββββββββ β
β β openpyxl-image-loader β ββββ Images with cell positions
β β + zipfile (fallback) β β
β βββββββββββββββββββββββββ β
β β
β βββββββββββββββββββββββββ β
β β Pillow β ββββ Resize, optimize, base64 encode
β β (image processing) β β
β βββββββββββββββββββββββββ β
βββββββββββββββββββββββββββββββ
β
β TextContent + ImageContent
βΌ
AI sees text AND images
Data Flow & Privacy
- Your file stays on your machine. The server runs locally via
stdioβ no network requests, no uploads, no cloud. - Nothing is written to disk. All image processing happens in-memory (
BytesIObuffers). The original.xlsxfile is never modified. - Memory is freed automatically. After each request, Python's garbage collector reclaims all buffers.
Image Processing Pipeline
Original image in .xlsx (e.g., 2048Γ1536px PNG)
β Extract from ZIP archive / drawing layer
β Resize to fit max dimensions (default 1024px)
β Compress (JPEG 80% / PNG optimized)
β Base64 encode
β ImageContent returned to AI client (~100-300KB per image)
π Supported Formats
| Format | Status | Notes |
|---|---|---|
.xlsx |
β Fully supported | Excel 2007+ Open XML |
.xlsm |
β Fully supported | Macro-enabled workbooks |
.xls |
β Not supported | Legacy Excel 97-2003 format |
.csv |
β Not supported | Use a CSV-specific tool |
Image Types
| Image Type | Cell-Mapped | Archive Extraction |
|---|---|---|
| PNG | β | β |
| JPEG | β | β |
| GIF | β | β |
| BMP | β | β |
| TIFF | β οΈ Partial | β |
| EMF/WMF | β | β |
=IMAGE() formula |
β | β |
| Images in comments | β | β |
π Performance
Tested on real-world enterprise Excel files (macOS, Apple Silicon):
| File | Size | Sheets | Images Extracted | Time |
|---|---|---|---|---|
| Requirements Doc A | 4.5 MB | 12 | 24 | 2.4s |
| Requirements Doc B | 5.0 MB | 6 | 18 | 2.4s |
| Requirements Doc C | 10.7 MB | 6 | 13 | 1.5s |
| Master Spec | 16.0 MB | 12 | 40 | 4.4s |
β FAQ
<details> <summary><b>Why can't it extract images from .xls files?</b></summary>
.xls is the legacy binary format (Excel 97-2003). It uses a completely different internal structure (BIFF) compared to .xlsx (ZIP-based Open XML). The libraries used (openpyxl, openpyxl-image-loader) only support the modern Open XML format. If you have .xls files, convert them to .xlsx using Excel or LibreOffice first.
</details>
<details> <summary><b>Why are some images marked as "orphan"?</b></summary>
The primary extraction method (openpyxl-image-loader) maps images to specific cells but may miss images that aren't anchored to the standard drawing layer. The fallback archive scanner catches these "orphan" images from the xl/media/ directory β you get every image, just without cell-position metadata for orphans.
</details>
<details> <summary><b>Can I use this with models that don't support vision?</b></summary>
Yes! Text data extraction works perfectly with any model. Image extraction will still return ImageContent, but text-only models will simply ignore the image data. You won't get errors.
</details>
<details> <summary><b>Is my data safe?</b></summary>
Yes. The server runs entirely on your local machine via stdio transport. No data is sent over the network, no files are uploaded anywhere, and no temporary files are created on disk. Your Excel files are read in-place and never modified.
</details>
<details> <summary><b>How do I handle very large files (100MB+)?</b></summary>
The server uses read_only mode for data iteration and processes images in-memory one at a time. For extremely large files, use read_excel_data with pagination (start_row + max_rows) instead of read_full_content to control memory usage.
</details>
πΊοΈ Roadmap
- [ ] Write support β Create and update cells, insert images
- [ ] Chart extraction β Render charts as images
- [ ] Formula evaluation β Show calculated values alongside formulas
- [ ] Conditional formatting β Extract formatting rules
- [ ] CSV/TSV support β Extend to other tabular formats
π€ Contributing
Contributions are welcome! Please open an issue first to discuss what you'd like to change.
git clone https://github.com/VOYAGER-Inc/excel-vision-mcp.git
cd excel-vision-mcp
uv sync
uv run pytest # Run the test suite
π License
MIT β use it however you want.
<!-- mcp-name: io.github.VOYAGER-Inc/excel-vision-mcp -->
<div align="center">
Built for AI agents that need to see the whole picture, not just the text.
β Star this repo if it helped you!
</div>
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
E2B
Using MCP to run code via e2b.
Neon Database
MCP server for interacting with Neon Management API and databases
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.