sheetwright 0.1.2

A toolkit for working with spreadsheets from Claude Code

sheetwright

A toolkit that lets Claude Code work with spreadsheets the way it works with code: text-source files, git, TDD, diffs, and review.

.xlsx is treated as a build artifact compiled from text sources. You write Markdown tables and YAML sidecars; sheetwright produces the workbook and runs LibreOffice Calc in headless mode (the default, swappable calc engine) to evaluate every formula. From there you assert on outputs with ordinary Python tests, diff source against any other workbook, and snapshot calculated values for regression checks.

sheetwright also ships an MCP (Model Context Protocol) server, so Claude Code (or any MCP client) can drive a project end-to-end through typed tools that mirror the CLI.

Quick reference

sheetwright init my-model              # scaffold a fresh project
sheetwright import path/to/model.xlsx  # ingest an existing workbook (or re-import)
sheetwright build                      # compile sources -> build/<name>.xlsx
sheetwright recalc                     # run the calc engine, cache results
sheetwright test                       # run testsweet tests
sheetwright snapshot [--update]        # golden-file regression of outputs
sheetwright diff [--vs xlsx:<path>]    # semantic diff of source or vs an xlsx
sheetwright check                      # lint dangling refs, missing names, etc.
sheetwright mcp                        # run the MCP server on stdio

Installation

sheetwright uses uv for project management and Python 3.11.

git clone https://github.com/kaapstorm/sheetwright.git
cd sheetwright
uv sync
uv run sheetwright --help

LibreOffice must be on PATH for the default calc engine.

• Debian/Ubuntu: apt install libreoffice
• macOS: brew install --cask libreoffice
• Windows (PowerShell): winget install --id TheDocumentFoundation.LibreOffice

Windows users new to the command line should start with the Windows setup primer.

Documentation

• Getting started — install through first test in about ten minutes.
• CLI reference — every command and flag.
• Source format — on-disk layout and the Markdown / YAML / TOML semantics.
• Testing reference — the sheetwright.testing.Model API and testsweet patterns.
• MCP reference — typed tools, return shapes, error codes.
• Calc engine reference — the plugin interface and the LibreOffice backend.
• Tutorials: greenfield, importing, TDD, snapshots, escape hatch.

License

GPL-3.0-or-later.