Excel Automation Python Packages

exstruct

Conversion from Excel to structured JSON (tables, shapes, charts) for LLM/RAG pipelines, and autonomous Excel reading/writing by AI agents via CLI and MCP integration.

excelalchemy

Schema-driven Python library for typed Excel import/export workflows with Pydantic, locale-aware workbooks, pluggable storage, and contract-tested architecture.

pivoteer

pivoteer injects pandas DataFrames into existing Excel templates without breaking PivotTables, filters, or formatting. Built for enterprise reporting workflows where Excel templates must stay intact and pivots refresh reliably on open.

iflow-mcp-harumiweb-exstruct

Conversion from Excel to structured JSON (tables, shapes, charts) for LLM/RAG pipelines, and autonomous Excel reading/writing by AI agents via CLI and MCP integration.