Skip to main content
Glama

πŸ“Š 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.

Python 3.11+ License: MIT MCP PyPI

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 B12

nothing

The image itself, mapped to B12

Struck through a cancelled row

Legacy export

Legacy export [S] β€” strikethrough

Highlighted a row for review

Pending

Pending [HL:yellow]

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:

  1. Cell-Position Mapping (primary) β€” Maps each image to its exact cell location using openpyxl-image-loader

  2. 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.


πŸ‘€ 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-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

Run with Docker

docker build -t excel-vision-mcp .
docker run --rm -i -v /path/to/spreadsheets:/data excel-vision-mcp

The 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

[M]

Merged cell

[B] [I] [S]

Bold Β· Italic Β· Strikethrough

[HL:color]

Highlighted background (color named, e.g. yellow, red)

[C:color]

Font color

[HIDDEN-REF]

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_width get 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. .xlsm macros 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 images

Data Flow & Privacy

  1. Your file stays on your machine. The server runs locally via stdio β€” no network requests, no uploads, no cloud.

  2. Read tools never modify your files. All image processing happens in-memory (BytesIO buffers). Write tools change only the exact file you specify, via atomic saves (temp file + swap) that can never leave a half-written workbook.

  3. 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.

  4. 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

.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 tools
add_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

    A4.1/5.0

    Scored across 13 tools

    Disambiguation3/5

    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.

    Naming Consistency4/5

    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.

    Tool Count5/5

    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.

    Completeness3/5

    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

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      A 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.
      10
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables 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
    • A
      license
      A
      quality
      D
      maintenance
      Enables 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.
      14
      Apache 2.0