excel-vision-mcp
The excel-vision-mcp server enables AI agents to comprehensively analyze Excel workbooks by extracting both text data and embedded images, entirely on your local machine.
List Sheets (
list_sheets): View all sheets in a workbook, including dimensions, merged cell counts, and total image counts.Read Cell Data (
read_excel_data): Extract cell values from a specific sheet with pagination support (start_row+max_rows), returning structured data with coordinate labels and merged cell indicators.Extract Images (
extract_images): Pull all embedded images as base64-encodedImageContentwith cell-position metadata and optional resizing β enabling vision-capable AI models to analyze them directly.Read Full Content (
read_full_content): The all-in-one tool β retrieves every sheet's text data and all embedded images in a single call, ideal for comprehensive analysis of reports, requirement docs, or design specs.Get Workbook Overview (
get_workbook_overview): Quickly retrieve file metadata, sheet list, dimensions, image count, and merged cell info for a fast structural assessment.Search Across Cells (
search_excel): Perform case-insensitive text searches across all cells in a workbook, returning matching coordinates and values.
Key highlights: Supports .xlsx and .xlsm formats; handles large files via pagination; dual image extraction (cell-position mapping + ZIP archive fallback); all processing is 100% local.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@excel-vision-mcp extract all images from financial report.xlsx"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
π Excel Vision MCP
Your AI reads the spreadsheet. It can't see the diagram in cell B12.
This fixes that. Other Excel MCP servers return cell values and silently drop every embedded image, so the flowchart your spec depends on never reaches the model. Excel Vision MCP returns them as native ImageContent your AI can actually look at β alongside the text, formatting, and formulas.
Installation Β· Tools Β· Configuration Β· How It Works Β· FAQ
π€ The Problem
Ask your assistant to review a requirements spec. Half the meaning lives in screenshots, flowcharts, and annotated diagrams pasted into cells β and every Excel MCP server hands the model text only. The answer comes back confident and incomplete, because the model never knew the pictures existed.
The same blind spot applies to the other signals authors leave behind:
What the author did | What other MCP servers report | What Excel Vision MCP reports |
Pasted a flowchart in | nothing | The image itself, mapped to |
Struck through a cancelled row |
|
|
Highlighted a row for review |
|
|
Hid an internal-cost column | The hidden values, as if normal | Skipped β unless a formula needs it |
Same file. One agent sees a table of strings; the other sees what the author actually meant.
Related MCP server: Excel MCP Server
β¨ 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 |
π·οΈ Format-Aware Reading | Reports bold, strikethrough, highlights and font colors so agents read intent, not just text |
π Hidden-Content Aware | Skips hidden rows/columns by default, keeping those formulas depend on |
βοΈ Write Support | Create workbooks, update cells, write formulas, insert images |
π¨ Formatting | Colors, fonts, borders, alignment, number formats, auto-fit columns |
π‘οΈ Atomic Saves | A failed write can never corrupt your original file |
π 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-loaderArchive 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.
π See It In Action
A requirements spec where the workflow lives in a pasted diagram and the status lives in cell colors:
You: Review this spec and tell me which features are still in scope, and how the dispatch flow works.
read_full_content returns the sheet as text with formatting markers, then the embedded diagram as an image:
Row 1: A1: Feature [B] [HL:blue] | B1: Status [B] [HL:blue]
Row 2: A2: Vehicle dispatch | B2: Approved [HL:green]
Row 3: A3: Legacy CSV export [S] | B3: Cancelled [S]
Row 4: A4: Driver roll call | B4: Needs review [HL:yellow]
βΉοΈ Skipped 3 hidden row(s) with content. Pass include_hidden=true to read them.
**[Image 1]** Sheet: `Spec` | Cell: `B12` | Original: 1180Γ840px
[the actual flowchart, as ImageContent]The model can now answer both halves of the question: "Legacy CSV export is struck through and marked cancelled, so three features remain in scope β and the flowchart in B12 shows dispatch requires roll-call confirmation before assignment."
Without image support, the second half is unanswerable. Without formatting, the cancelled row looks identical to the active ones.
π Quick Start
Install via uvx (Recommended)
No installation needed β runs directly:
uvx excel-vision-mcpInstall via pip
pip install excel-vision-mcpThen run:
excel-vision-mcpInstall from source
git clone https://github.com/VOYAGER-Inc/excel-vision-mcp.git
cd excel-vision-mcp
uv sync
uv run excel-vision-mcpRun with Docker
docker build -t excel-vision-mcp .
docker run --rm -i -v /path/to/spreadsheets:/data excel-vision-mcpThe server speaks JSON-RPC over stdin/stdout, so it must run attached (-i). Mount the directory holding your files and reference them by their in-container path (/data/report.xlsx). The image sets EXCEL_VISION_MCP_ALLOWED_DIRS=/data, so reads and writes stay inside the mount.
As an MCP client config:
{
"mcpServers": {
"excel-reader": {
"command": "docker",
"args": ["run", "--rm", "-i", "-v", "/path/to/spreadsheets:/data", "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.
Restricting file access (optional)
By default the server can read/write any Excel file your user account can access. To sandbox it to specific directories, set EXCEL_VISION_MCP_ALLOWED_DIRS (multiple paths separated by : on macOS/Linux, ; on Windows):
{
"mcpServers": {
"excel-reader": {
"command": "uvx",
"args": ["excel-vision-mcp"],
"env": {
"EXCEL_VISION_MCP_ALLOWED_DIRS": "/Users/me/Documents/spreadsheets:/Users/me/Projects/data"
}
}
}
}π οΈ 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
include_hidden=False # optional, read hidden rows/columns too
)Returns: Cell values organized by row with coordinate labels and markers for merged cells and formatting.
Row 1: A1: Feature [B] [HL:blue] | B1: Status [B] [HL:blue]
Row 3: A3: Legacy export [S] | B3: Cancelled [S]
Row 4: A4: Report | B4: Needs review [HL:yellow] | C4: Urgent [B] [C:red]Marker | Meaning |
| Merged cell |
| Bold Β· Italic Β· Strikethrough |
| Highlighted background (color named, e.g. |
| Font color |
| Hidden cell kept because a visible formula references it |
Markers and a short legend appear only on sheets that actually use formatting, so plain sheets cost no extra context.
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 (with formatting markers), 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."
Hidden rows & columns
All read tools skip hidden rows and columns by default β an author who hid them signalled they aren't part of the content to review.
One exception: a hidden cell that a visible formula references is still returned, marked [HIDDEN-REF], because its value drives results you can see. Skipped content is always reported so nothing disappears silently:
βΉοΈ Skipped 2 hidden row(s) with content. 1 hidden cell(s) are shown anyway
because visible formulas reference them. Pass include_hidden=true to read them.Pass include_hidden=true to read_excel_data, read_full_content, or search_excel to read everything.
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.
create_excel_file
Create a new empty workbook with the sheets you name.
create_excel_file(
file_path="/path/to/new.xlsx",
sheet_names=["Summary", "Detail"], # optional, default ["Sheet1"]
overwrite=False # optional, refuses to replace by default
)add_excel_sheet
Add a new empty sheet to an existing workbook.
add_excel_sheet(file_path="/path/to/file.xlsx", sheet_name="Q3", position=0)update_excel_cells
Set individual cells by coordinate. Values starting with = are written as formulas.
update_excel_cells(
file_path="/path/to/file.xlsx",
updates={"A1": "Title", "B2": 42, "C2": "=SUM(B2:B10)"},
sheet_name="Data" # optional, defaults to first sheet
)Note: newly written formulas show no calculated value until the file is opened in Excel. For merged ranges, write to the top-left anchor cell.
write_excel_rows
Write a rectangular block of tabular data in one call.
write_excel_rows(
file_path="/path/to/file.xlsx",
rows=[["Item", "Qty"], ["Widget", 4], ["Gadget", 7]],
sheet_name="Data", # optional
start_cell="A1" # optional
)insert_excel_image
Insert a local image file into a workbook, anchored at a cell.
insert_excel_image(
file_path="/path/to/file.xlsx",
image_path="/path/to/chart.png",
cell="B2",
sheet_name="Report", # optional
width=480, height=320 # optional display size in px
)format_excel_cells
Style a range: font, colors, borders, alignment, number formats. Only the attributes you pass are changed β existing styling is preserved.
format_excel_cells(
file_path="/path/to/file.xlsx",
cell_range="A1:D1",
bold=True,
font_color="FFFFFF",
fill_color="4472C4",
horizontal_align="center",
border_style="thin", # thin | medium | thick | double | dashed | dotted
border_edges="all", # "all" or "outline" (outer edge of range only)
number_format="#,##0.00" # any Excel format code
)set_excel_column_widths
Set column widths manually and/or auto-fit to content.
set_excel_column_widths(
file_path="/path/to/file.xlsx",
widths={"A": 12, "B": 35}, # explicit widths (skipped by auto-fit)
auto_fit=True, # size remaining columns to content
max_width=60, # cap for auto-fit
wrap_overflow=True # wrap cells longer than the cap
)Auto-fit counts full-width CJK characters (ζ₯ζ¬θͺ) as 2 units. Cells longer than
max_widthget wrap text enabled instead of stretching the column β Excel auto-expands their row heights on open.
All write tools use atomic saves: the workbook is written to a temp file and swapped into place, so a failed save never corrupts your original.
.xlsmmacros are preserved. Known openpyxl limitation: pivot tables and some complex chart features are not preserved on re-save.
βοΈ How It Works
Architecture
Your AI Client (Claude, Cursor, etc.)
β
β stdio (JSON-RPC)
βΌ
βββββββββββββββββββββββββββββββ
β Excel Vision MCP β
β β
β βββββββββββββββββββββββββ β
β β 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 imagesData Flow & Privacy
Your file stays on your machine. The server runs locally via
stdioβ no network requests, no uploads, no cloud.Read tools never modify your files. All image processing happens in-memory (
BytesIObuffers). Write tools change only the exact file you specify, via atomic saves (temp file + swap) that can never leave a half-written workbook.Optional directory sandbox. Set
EXCEL_VISION_MCP_ALLOWED_DIRS(path-separator-separated list) to restrict which directories the server may read or write. Unset = no restriction.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 |
| β Fully supported | Excel 2007+ Open XML |
| β Fully supported | Macro-enabled workbooks |
| β Not supported | Legacy Excel 97-2003 format |
| β Not supported | Use a CSV-specific tool |
Image Types
Image Type | Cell-Mapped | Archive Extraction |
PNG | β | β |
JPEG | β | β |
GIF | β | β |
BMP | β | β |
TIFF | β οΈ Partial | β |
EMF/WMF | β | β |
| β | β |
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
.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.
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.
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.
Yes. The server runs entirely on your local machine via stdio transport. No data is sent over the network and no files are uploaded anywhere. Read tools never modify your files; write tools change only the file you explicitly target, using atomic saves so a failed write can't corrupt it. You can also sandbox the server to specific directories with the EXCEL_VISION_MCP_ALLOWED_DIRS environment variable.
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.
πΊοΈ Roadmap
Write support β Create workbooks, update cells, write formulas, insert images (v1.1.0)
Format-aware reading β Bold, strikethrough, highlights, colors; hidden-content handling (v1.2.0)
Formula evaluation β Show formulas alongside their calculated values
CSV/TSV support β Extend to other tabular formats
Conditional formatting β Extract formatting rules
Chart extraction β Render charts as images
π€ 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.
Built for AI agents that need to see the whole picture, not just the text.
β Star this repo if it helped you!
Available Tools
13 toolsadd_excel_sheetA
Add a new empty sheet to an existing workbook.
@param file_path: Absolute path to the .xlsx/.xlsm file. @param sheet_name: Name for the new sheet; must not already exist. @param position: 0-based index to insert at. None = append at the end. @return: Confirmation with the updated sheet list.
Inputs: file_path (required), sheet_name (required), position. Returns: result
create_excel_fileA
Create a new empty .xlsx workbook.
@param file_path: Absolute destination path; parent directory must exist. @param sheet_names: Sheet names to create in order. None = single "Sheet1". @param overwrite: Set true to replace an existing file. Default false. @return: Confirmation with the created sheet list.
Inputs: file_path (required), overwrite, sheet_names. Returns: result
extract_imagesA
Extract all embedded images from an Excel file.
Uses dual extraction strategy: cell-position mapping (primary) and ZIP archive scanning (fallback) to ensure no images are missed. Returns images as base64-encoded ImageContent that AI can visually analyze.
@param file_path: Absolute path to the .xlsx file. @param sheet_name: Specific sheet, or None for all sheets. @param max_width: Max width in pixels for image optimization (default 1024). @param max_height: Max height in pixels for image optimization (default 1024). @return: Mixed list of TextContent (metadata) and ImageContent (images).
Inputs: file_path (required), max_width, max_height, sheet_name. Returns: result
format_excel_cellsA
Apply formatting to a cell range: font, colors, borders, alignment, number format.
Only the attributes you pass are changed; existing styling is preserved. Example β style a header row: cell_range="A1:D1", bold=true, font_color="FFFFFF", fill_color="4472C4", horizontal_align="center", border_style="thin".
@param file_path: Absolute path to the .xlsx/.xlsm file. @param cell_range: Range like "A1:C10" or a single cell like "B2". @param sheet_name: Target sheet. None = first sheet. @param font_name: Font family (e.g. "Calibri"). @param font_size: Font size in points. @param bold: Bold on/off. @param italic: Italic on/off. @param font_color: Text color, RRGGBB hex (e.g. "FFFFFF"). @param fill_color: Background color, RRGGBB hex (e.g. "4472C4"). @param border_style: thin, medium, thick, double, dashed, or dotted. @param border_edges: "all" = every cell; "outline" = outer edge of range only. @param horizontal_align: left, center, right, or justify. @param vertical_align: top, center, or bottom. @param wrap_text: Enable/disable text wrapping. @param number_format: Excel format code (e.g. "#,##0.00", "dd/mm/yyyy", "0%"). @return: Confirmation with the number of cells formatted.
Inputs: file_path (required), cell_range (required), bold, italic, +11 more. Returns: result
get_workbook_overviewA
Get a quick summary overview of an Excel workbook.
Returns file metadata, sheet list with dimensions, image count, and merged cell information. Use this for a fast assessment before deeper analysis.
@param file_path: Absolute path to the .xlsx file. @return: Formatted text summary.
Inputs: file_path (required). Returns: result
insert_excel_imageA
Insert an image from a local file into a workbook, anchored at a cell.
@param file_path: Absolute path to the .xlsx/.xlsm file. @param image_path: Absolute path to the image file (PNG/JPEG/GIF/BMP). @param cell: Anchor cell coordinate (e.g. "B2"). @param sheet_name: Target sheet. None = first sheet. @param width: Display width in pixels. None = natural size. @param height: Display height in pixels. None = natural size. @return: Confirmation with anchor position and display size.
Inputs: cell (required), file_path (required), image_path (required), width, +2 more. Returns: result
list_sheetsA
List all sheets in an Excel workbook with their dimensions and metadata.
Returns sheet names, row/column counts, data ranges, merged cell counts, and total embedded image count. Use this to understand the structure of an Excel file before reading its contents.
@param file_path: Absolute path to the .xlsx file. @return: Formatted text with workbook structure overview.
Inputs: file_path (required). Returns: result
read_excel_dataA
Read cell data from an Excel sheet with pagination for large files.
Returns cell values organized by row with coordinate labels and formatting markers ([B]=bold, [S]=strikethrough, [HL:color]=highlight, [C:color]=font color) that reveal the author's emphasis and status marks.
Hidden rows/columns are skipped by default β the author hid them for a reason β except hidden cells that visible formulas depend on, which are kept and marked [HIDDEN-REF].
@param file_path: Absolute path to the .xlsx file. @param sheet_name: Sheet to read. None = first/active sheet. @param start_row: Starting row number (1-indexed). @param max_rows: Maximum rows to return (default 200). @param include_hidden: Set true to also read hidden rows/columns. @return: Formatted text table with cell values and formatting markers.
Inputs: file_path (required), max_rows, start_row, sheet_name, +1 more. Returns: result
read_full_contentA
Read the FULL content of an Excel file including all text data AND embedded images.
This is the primary tool for comprehensive document analysis. Returns all sheet data as structured text followed by all extracted images with their cell positions. Ideal for analyzing documents where both text and diagrams/screenshots are essential, such as requirement definitions, reports, or design specs.
For very large files, data is paginated per sheet. Image extraction uses dual strategy (cell-mapping + archive) for maximum coverage. Cell text carries formatting markers ([B]=bold, [S]=strikethrough, [HL:color]= highlight) so emphasis and status marks survive into the analysis.
Hidden rows/columns are skipped by default, except hidden cells that visible formulas depend on.
@param file_path: Absolute path to the .xlsx file. @param max_rows_per_sheet: Max rows to read per sheet (default 500). @param max_image_width: Max width for image optimization (default 1024). @param max_image_height: Max height for image optimization (default 1024). @param include_hidden: Set true to also read hidden rows/columns. @return: Mixed list of TextContent and ImageContent covering entire workbook.
Inputs: file_path (required), include_hidden, max_image_width, max_image_height, +1 more. Returns: result
search_excelA
Search for text content across all cells in an Excel workbook.
Performs case-insensitive substring search and returns matching cells with their coordinates and values. Hidden rows/columns are excluded by default. Limited to 100 results.
@param file_path: Absolute path to the .xlsx file. @param query: Text to search for. @param sheet_name: Limit to specific sheet, or None for all sheets. @param include_hidden: Set true to also search hidden rows/columns. @return: Formatted text with search results.
Inputs: query (required), file_path (required), sheet_name, include_hidden. Returns: result
set_excel_column_widthsA
Set column widths manually and/or auto-fit them to content.
Auto-fit sizes each column to its longest content (full-width CJK
characters count double), capped at max_width. Cells longer than the
cap get wrap_text enabled so long descriptions wrap onto multiple
lines instead of stretching the column; Excel auto-expands their row
heights on open. Columns in widths are set exactly and skipped by
auto-fit.
@param file_path: Absolute path to the .xlsx/.xlsm file. @param sheet_name: Target sheet. None = first sheet. @param widths: Explicit widths per column letter, e.g. {"A": 12, "B": 35}. @param auto_fit: Auto-size all other columns in the used range. @param max_width: Width cap for auto-fit in character units (default 60). @param wrap_overflow: Wrap cells longer than max_width (default true). @return: Confirmation listing each column and the width applied.
Inputs: file_path (required), widths, auto_fit, max_width, +2 more. Returns: result
update_excel_cellsA
Set individual cells by coordinate, e.g. {"A1": "Title", "B2": 42}.
String values starting with "=" are written as formulas (e.g. "=SUM(A1:A5)"). Note: newly written formulas have no calculated value until the file is opened in Excel. For cells inside a merged range, write to the range's top-left anchor cell.
The save is atomic β a failed write never corrupts the original file.
@param file_path: Absolute path to the .xlsx/.xlsm file. @param updates: Mapping of cell coordinate to value. @param sheet_name: Target sheet. None = first sheet. @return: Confirmation with the number of cells written.
Inputs: updates (required), file_path (required), sheet_name. Returns: result
write_excel_rowsA
Write a rectangular block of rows starting at start_cell.
Efficient for tabular data: pass a list of rows, each a list of values. Existing cells in the target range are overwritten; cells outside it are untouched. The save is atomic.
@param file_path: Absolute path to the .xlsx/.xlsm file. @param rows: List of rows, each a list of cell values. @param sheet_name: Target sheet. None = first sheet. @param start_cell: Top-left coordinate of the block (default "A1"). @return: Confirmation with the written range.
Inputs: rows (required), file_path (required), sheet_name, start_cell. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 13 tools
Tools like list_sheets and get_workbook_overview have overlapping purposes, both providing workbook structure. Similarly, read_excel_data and read_full_content both read cell data, differing mainly in image inclusion and pagination. However, most other tools target distinct actions (e.g., search, image extraction, formatting), so disambiguation is adequate but not perfect.
All tool names use snake_case and follow a verb_noun pattern (e.g., list_sheets, update_excel_cells, set_excel_column_widths). Minor variations in adjective placement (e.g., 'excel' vs 'workbook') are predictable and do not hinder recognition.
With 13 tools, the server covers reading (structure, data, images, search) and writing (create, add sheet, update cells/rows, insert image, format, column widths) comprehensively without overwhelming excess.
Core read and write operations are well-covered, but notable gaps exist for deletion (no delete sheet, delete rows, or delete images). Renaming sheets and advanced formula handling are also missing, limiting full lifecycle management.
Maintenance
Related MCP Connectors
The Excel engine for AI agents: read, check and edit Excel models over MCP.
File tools for your AI chat: PDF tables to Excel, merge PDFs, images to PDF, fill PDF forms.
Convert, create and edit Word, PowerPoint, Excel and PDF documents from any AI agent.
Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol (MCP) server that allows AI models to safely access and interact with local file systems, enabling reading file contents, listing directories, and retrieving file metadata.10MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to create, read, and manipulate Excel files without requiring Microsoft Excel installation. Supports comprehensive spreadsheet operations including formulas, formatting, charts, pivot tables, and data validation.MIT
- AlicenseAqualityDmaintenanceEnables cloud browser automation through Browserbase and Stagehand, allowing LLMs to interact with web pages, take screenshots, extract data, and perform automated actions with support for proxies, stealth mode, and parallel sessions.14Apache 2.0
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to create, read, and modify Excel workbooks without requiring Microsoft Excel, supporting operations like formulas, charts, pivot tables, formatting, and data validation.MIT