exstruct

Overview

ExStruct reads Excel workbooks into structured data and provides extraction APIs, editing CLI, and an MCP server for integrations. It supports multiple output modes (light, libreoffice, standard, verbose) and can extract cells, shapes, charts, SmartArt, tables, formulas, and hyperlinks. The project offers both CLI and Python interfaces with patch-based editing workflows, making it suitable for LLM/RAG pipelines and automation scenarios.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• exstruct_extract

  Extracts data from an Excel workbook

  Try:Extract data from financial_report.xlsxTry:Read the workbook in verbose mode to include all shapes and hyperlinksTry:Extract cells and table candidates from budget.xlsx
• exstruct_capture_sheet_images

  Captures images from Excel sheets

  Try:Capture images from presentation.xlsxTry:Get all images from slide deck.xlsxTry:Export images from chart_summary.xlsx
• exstruct_make

  Creates a new Excel workbook

  Try:Create a new workbook called quarterly_report.xlsxTry:Generate an empty Excel file with template formattingTry:Make a new workbook with named sheets
• exstruct_patch

  Applies editing patches to a workbook

  Try:Apply these edits to sales_data.xlsxTry:Patch the workbook using the operations in changes.jsonTry:Update cells A1 to C5 with new values
• exstruct_read_json_chunk

  Reads extracted JSON chunks from a workbook

  Try:Read the JSON chunks from extracted_dataTry:Get the chunk with sheet summaries from extractedTry:Read the formula chunks from the extracted data
• exstruct_read_range

  Reads cells from a specified range

  Try:Read cells from A1 to C10 in financial.xlsxTry:Get values from range B5:D20 in report.xlsxTry:Extract data from range F1:H15 in budget.xlsx
• exstruct_read_cells

  Reads data cell by cell from a workbook

  Try:Read all cells from inventory.xlsxTry:Get cell data from products.xlsxTry:Extract individual cells from dataset.xlsx
• exstruct_read_formulas

  Reads cell formulas from a workbook

  Try:Read formulas from calculations.xlsxTry:Get all formula expressions from budget.xlsxTry:Extract formula references from financial_model.xlsx
• exstruct_validate_input

  Validates input workbook data

  Try:Validate this workbook before processingTry:Check if data.xlsx is readable and validTry:Validate the structure of input_file.xlsx

Comparable tools

Installation

pip install exstruct[mcp]

{
  "mcpServers": {
    "exstruct": {
      "command": "exstruct-mcp",
      "args": ["--root", "/path/to/your/data", "--on-conflict", "rename"]
    }
  }
}

uvx --from 'exstruct[mcp]' exstruct-mcp --root /path/to/your/data

FAQ

What platforms does ExStruct support?

ExStruct works on Windows with Excel COM, and on Linux/macOS through direct OOXML parsing or with LibreOffice runtime.

How do I install ExStruct with optional dependencies?

Use `pip install exstruct[yaml,toon,render]` to install with YAML support, TOON format, and rendering capabilities.

Compare exstruct with