How to use Open Sheet: what you can do with it

3 use cases

• Build a model whose numbers recalculate on change

  Write a P&L as React and export an .xlsx whose formulas update when an assumption moves.

  • REPO lianghsun/open-sheet
  • Data and analytics
  • Intermediate
  View prompt

  In the open-sheet repo at <project path>, write a P&L sheet from this description: <description of revenue, costs and assumptions>. Use references such as r.cell and ref().column, with no A1 addresses, then export the .xlsx to <output path>. Verify that changing the growth assumption in the exported file moves the net income column.

  Share Email me this

• Generate a live workbook for every record in a batch

  Turn each row of incoming data into its own .xlsx, with formulas kept rather than baked values.

  • REPO lianghsun/open-sheet
  • Data and analytics
  • Advanced
  View prompt

  Using the open-sheet repo at <project path>, create a sheet template that reads the rows in <input file> and exports one .xlsx per row to <output folder>. Each file must keep its formulas instead of values. Verify that the number of exported files equals the number of input rows and that formula cells remain formulas in one sample file.

  Share Email me this

• Trace a wrong cell to its source and send notes back

  Use inspect mode to see a cell's source line and formula, then leave a note for your agent.

  • REPO lianghsun/open-sheet
  • Data and analytics
  • Intermediate
  View prompt

  In the open-sheet project at <project path>, collect the notes left in inspect mode on the sheet <sheet name> and apply them with the /apply-comments skill. Expected output: the source file edited for each note. Verify by listing any cell that still shows #NOT_EVALUATED and explaining why.

  Share Email me this

Quick start with Open Sheet

1. Check you have what it needs: Node; npm or pnpm; A coding agent or text editor.
2. Open lianghsun/open-sheet on GitHub and read the README and license.
3. npx @open-sheet/cli init my-sheets
4. cd my-sheets && npm install && npm run dev
5. Describe the P&L to your coding agent and have it write the React source using references such as ref('pl').column('revenue').
6. Check the sheet in the viewer, then use its export option to download the .xlsx. (inferred, check the README)

These steps come from our top use case, Build a model whose numbers recalculate on change, which also has a copy-paste agent prompt.

Using the Deduped MCP, get the setup steps for lianghsun/open-sheet

claude mcp add --transport http deduped https://dedupedai.com/mcp

Open Sheet alternatives · Best AI repos for Data and analytics

About this repo

• Who it is forWritten for developers and their coding agents who generate spreadsheet models from code instead of editing workbooks by hand.
• Why it is hot127 stars, launched 67 days ago
• LanguageTypeScript
• Sourcegithub.com/lianghsun/open-sheet · Back to Hot repos

Requirements

• Node
• npm or pnpm
• A coding agent or text editor
• A local dev server to preview the sheet

Related repos

• Trended earlier REPO Aisland-SJL/dsh-usage DSH Usage dsh-usage is a JavaScript plugin for DeepSeek Harness that adds a persistent balance and token-usage dock, a detail panel, an activity heatmap, and a DSH versus Claude Code usage comparison.
• Trended earlier REPO ashishsinha1602/schemagate Schemagate schemagate is a Python library and local studio page that filters a text-to-SQL schema by the caller's grants, so restricted tables never reach the LLM prompt.
• Trended earlier REPO AsoBeast/asobeast Asobeast AsoBeast is an open source App Store Optimization tool and keyword rank tracker for the Apple App Store and Google Play, self-hosted with Docker or used as a hosted service.