DEDUPED Hot AI repos, turned into use cases Get the Monday 5

How to generate a live workbook for every record in a batch with Open Sheet

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

Who it is forAn operations or finance lead who receives hundreds of invoices or monthly packs from a data pipeline.

The problemHand-building or editing each file does not scale, and workbooks with baked numbers hide the logic behind them.

The outcomeOne rebuilt .xlsx per record, each with live formulas, regenerated whenever the source data changes.

What you need first

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

Steps

  1. npx @open-sheet/cli init my-sheets
  2. cd my-sheets && npm install
  3. Write one sheet source file whose data array is filled from your pipeline's records.
  4. npm run dev and check one generated sheet in the viewer.
  5. Run the export once per record and store each .xlsx in your output folder. (inferred, check the README)

Prompt for your agent

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.

Caveat. The README does not describe a batch export command, so confirm how per-record export works in the source before automating it.

Use this in your AI agent

Ask your agent

Using the Deduped MCP, get the setup steps for lianghsun/open-sheet and "Generate a live workbook for every record in a batch"

Add Deduped to Claude Code once

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

Cursor, ChatGPT, others

Share: X LinkedIn Hacker News Email Copy link

Third-party repos we don't own. AI-written use cases can be wrong. Disclaimer