All How-To Guides

3 Ways to Read Excel Files with Claude Code

How to read Excel files with Claude Code?

3 MCP servers featured

Excel spreadsheets contain valuable data but Claude can't read them directly. MCP servers can convert Excel files to formats Claude understands, or provide direct spreadsheet manipulation. Here are the best options for working with Excel data.

Recommended MCP Servers

MarkItDown

microsoft/markitdown

>80k

Official Microsoft library that converts Excel spreadsheets to Markdown tables for LLM consumption.

Key Features

  • Converts XLSX to Markdown tables
  • Preserves cell formatting
  • Handles multiple sheets
  • Official Microsoft support

Installation

pip install 'markitdown[all]'

MarkItDown converts Excel spreadsheets into clean Markdown tables that Claude can easily read and analyze. Multiple sheets, formatting, and formulas are preserved as readable text. The most reliable option for Excel reading.

Best for: Reading Excel data as text View on GitHub

Microsoft 365 MCP

softwarearchitect817/microsoft-graph-mcp

>300

Microsoft Office integration including Excel via Graph API for cloud-based spreadsheets.

Key Features

  • Excel Online access
  • Read and write cells
  • OneDrive integration
  • Full Graph API support

Installation

See GitHub for Azure setup

For organizations using Microsoft 365, this MCP provides direct access to Excel files stored in OneDrive or SharePoint. Read cells, update values, and work with cloud spreadsheets without downloading files.

Best for: Cloud Excel files on Microsoft 365 View on GitHub

Markdownify MCP

zcaceres/markdownify-mcp

>2k

Convert XLSX files along with PDFs, images, and other formats to Markdown.

Key Features

  • XLSX to Markdown conversion
  • Multiple format support
  • Batch processing
  • All-in-one solution

Installation

pnpm install && pnpm run build

If you work with Excel alongside other document types, Markdownify handles everything in one MCP. Convert spreadsheets, PDFs, and documents all through the same interface.

Best for: Mixed document workflows View on GitHub

Quick Comparison

MCPStarsBest ForProsCons
MarkItDown>80kLocal Excel filesBest conversion qualityRead-only
Microsoft 365>300Cloud spreadsheetsRead and writeM365 required
Markdownify>2kMixed formatsAll-in-oneMore setup

Getting Started

To read Excel files with Claude Code:

  1. For local Excel files, install MarkItDown:

    pip install 'markitdown[all]'
    
  2. For Microsoft 365 spreadsheets, set up the Microsoft Graph MCP.

  3. Point Claude to your file and ask for analysis.

Example prompt: "Read this Excel file and summarize the sales data by region."

Related Guides