open-sheet CLI
A framework where an agent writes a spreadsheet as React and open-sheet builds a live .xlsx from references.
- 126 ★ on the repository
- Last commit
- MIT
Extended access
Why this level
- Runs project code and a dev server and creates files in the working folder.
Install
- Works in
Manual install
npx @open-sheet/cli init my-sheetsThe first README command scaffolds a project with agent skills; then `cd my-sheets && npm install && npm run dev`.
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- Runs project code and a dev server and creates files in the working folder.
This is third-party code. Review the repository files before installing.
What it does
open-sheet is a framework and CLI where an agent writes a spreadsheet as a `.tsx` source file. Instead of addresses like `=SUM(B2:B13)`, the model uses references such as `ref('pl').column('revenue')`: addresses resolve at compile time, once the layout is known, so inserting a row does not break formulas. The output is an `.xlsx` with live formulas, number formats, defined names, frozen panes and conditional formatting, plus `.csv`, `.html` and `.pdf`. The skills `/create-sheet`, `/sheet-authoring`, `/current-sheet` and `/apply-comments` ship with the scaffolder, and the MCP server starts with `open-sheet dev --mcp`. A formula the engine cannot evaluate shows as `#NOT_EVALUATED` in the viewer rather than a plausible-looking number.
Who it is for. Developers whose agents regularly generate reports and financial models: quarterly packs, invoices, models rebuilt whenever data lands.
Good fit when
- A monthly financial report is generated from data and must open in Excel with live formulas.
- Five hundred invoices are generated by a loop from one template.
- A report change is reviewed as an ordinary code review instead of a binary diff.
- The file recipient changes an assumption, such as a tax rate, and watches a whole column recalculate.
Not a fit when
- A spreadsheet already exists and needs editing, since open-sheet cannot read foreign workbooks.
- You need pivot tables or the full range of Excel functions.
- The file is edited by hand once and never regenerated.
Example request
Create a yearly profit and loss sheet with a growth assumption and a tax rate, so net income is computed by formula.Limitations
The project is early, version 0.1.0: the README itself calls it early development. The framework builds a workbook only from the project's `.tsx` source and cannot read foreign workbooks. It has about a hundred Excel functions and no pivot tables. Numbers come from its own engine; agreement with a real spreadsheet engine is checked in CI through LibreOffice, not through Excel itself. Formulas outside engine support show as `#NOT_EVALUATED` in the viewer. Node is required and installation goes through npm. If a spreadsheet is opened and edited by hand, Excel with an assistant fits better.
How to disable. Delete the scaffolded project folder together with the skills in `.claude/skills` and `.agents/skills`, and remove the MCP entry if you connected `open-sheet dev --mcp`.
FAQ
How does open-sheet differ from Claude for Excel?
Claude for Excel speeds up a person working on an existing workbook. open-sheet builds the workbook from source on every rebuild, so one reviewed source yields the same file again.
Which output formats does it produce?
An `.xlsx` workbook with live formulas and formatting, plus `.csv`, `.html` and `.pdf`.
How do I connect the MCP server?
Run `open-sheet dev --mcp`. The server uses Streamable HTTP and works with any agent framework.
What happens to a formula the engine cannot evaluate?
The viewer shows `#NOT_EVALUATED` instead of an invented number. The formula stays live in the `.xlsx` file.
How do I create an open-sheet project?
Run `npx @open-sheet/cli init my-sheets`, then `cd my-sheets && npm install && npm run dev`. Agent skills install together with the project.
Discussion
No questions or reviews yet.
Related
CLI toolsagent-spreadsheet: Excel for AI agents
agent-spreadsheet
An MCP server, CLI and SDK for agents: read and edit Excel workbooks, recalculate formulas, prove changes without UI automation
A Python package, CLI and MCP server: Excel workbooks become structured JSON for LLMs and edits go through patches with a dry run
A skill plus the docx program: the agent fills forms, edits tables and reviews Word files with tracked changes
Excel MCP Server (negokaz): read and write Excel
Excel MCP Server (negokaz)
An MCP server that reads and writes Excel workbooks: values, formulas, tables, formatting and new sheets; on Windows it can also capture a sheet screenshot
office-oxide-mcp: Office and PDF for AI agents
office-oxide-mcp
A Rust MCP server that reads and creates Excel, Word, PowerPoint and PDF locally and fills PDF forms after your approval
An MCP server to create and edit Excel files without Microsoft Office: formulas, formatting, charts, pivot tables
README in short
Describes references instead of addresses, automatic block placement, one formula tree for Excel and the viewer, output formats and the monorepo layout.