Skip to content
Skills Library
Documents & office · Analysis

spreadsheet

/spreadsheet

Fast Excel (.xlsx) formula recalculation, targeted cell reads, batch edits, and dependency tracing. Use to explain unexpected totals, trace precedents or dependents, test assumptions, fix stale results, and calculate workbooks created or edited with other tools.

Licence
Apache-2.0
Last repository change
11.11.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
17
Scripts
10
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 11.11.2026, without references to retired models or APIs.

Licence

Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.

What to check before installing
  • 10 scripts in this package. Review them before installing, as Claude may execute them.

Scripts: engine/formualizer_engine.mjs, scripts/engine.mjs, scripts/synthetic.mjs, scripts/xlsx.mjs, test/edit.test.mjs, test/inspect.test.mjs, test/mcp-and-edge.test.mjs, test/practical.test.mjs, test/source.test.mjs, test/transport.test.mjs

What it does and when to use it

Fast Excel (.xlsx) formula recalculation, targeted cell reads, batch edits, and dependency tracing. Use to explain unexpected totals, trace precedents or dependents, test assumptions, fix stale results, and calculate workbooks created or edited with other tools.

Original author description

Fast Excel (.xlsx) formula recalculation, targeted cell reads, batch edits, and dependency tracing. Use to explain unexpected totals, trace precedents or dependents, test assumptions, fix stale results, and calculate workbooks created or edited with other tools.

How it works

  1. Run locally
  2. Check and deliver
Original SKILL.md headings · 83 lines, 574 words
SKILL.md preview
---
name: spreadsheet
description: Fast Excel (.xlsx) formula recalculation, targeted cell reads, batch edits, and dependency tracing. Use to explain unexpected totals, trace precedents or dependents, test assumptions, fix stale results, and calculate workbooks created or edited with other tools.
---

Route tasks to the matching `formualizer:spreadsheet` operation:

- **Explain formulas, drivers, or unexpected totals (read-only):** run `trace` (`--roots ... --direction precedents --max-depth 2`) to map formula dependencies and `inspect` (`--cells ...` or `--range ...`) to read formulas and stored cached values. Do **not** run `source-recalculate` on explanation or read-only requests unless the user asks to verify or repair stale caches, or stored caches are missing.
- **Test assumptions or edit cells/formulas:** run `edit` to apply atomic `set_cells` changes and recalculate in one step, then `inspect` affected output cells and verify the receipt.
- **Calculate a final deliverable from other tools:** when creating or modifying a formula-bearing `.xlsx` with another library, run `source-recalculate --output /path/final.xlsx` (or `--check` for read-only verification) after saving final changes and before returning the file.

`inspect` and `trace` never evaluate formulas or modify files. Stored formula caches carry `freshness: "unverified"`. Reading or explaining a workbook does not authorize recalculation.

## Run locally

Requires Node >=20. The engine is bundled; no install, network access, credentials, or local server is required. Locate this `SKILL.md` and set `CLAUDE_SKILL_DIR` to its parent directory.

Check the bundled engine:

```sh
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" doctor
```

### 1. Inspect cells or ranges (read-only)

Pass `--cells` or `--range` directly (addresses must be sheet-qualified, such as `Sheet1!A1` or `'My Sheet'!A1:D20`):

```sh
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" inspect /path/input.xlsx --cells "Sheet1!B1" "Sheet1!G12"
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" inspect /path/input.xlsx --range "Sheet1!A1:M20" --limit 100
```

Or pass canonical JSON via `--json '<JSON>'` or a `REQUEST.json` file. Top-level fields are singular `selection` and optional `page` only (never `selections` or `sheets`):

```json
{"selection":{"kind":"cells","addresses":["Sheet1!A1","Sheet1!B1"]}}
{"selection":{"kind":"range","address":"Sheet1!A1:D20"},"page":{"limit":50}}
```

### 2. Trace precedents or dependents (read-only)

Trace upstream inputs (`precedents`) or downstream formulas (`dependents`):

```sh
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" trace /path/input.xlsx --roots "Sheet1!G12" --direction precedents --max-depth 2
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" trace /path/input.xlsx --roots "Assumptions!B9" --direction dependents --max-depth 2
```

Or pass canonical JSON via `--json '<JSON>'` or `REQUEST.json` (including verbatim `next_trace_request` or `next_request` cursors). Top-level fields are `roots` plus optional `direction`, `limits`, `details`, and `page`:

```json
{"roots":["Sheet1!G12"],"direction":"precedents","limits":{"max_depth":2}}
```

Traces are bounded (`max_depth` defaults to `0` if omitted) and do not guarantee the entire dependency graph. Follow returned `next_trace_request` or `next_inspect_request` payloads for deeper hops. See [stateless-inspection.md](references/stateless-inspection.md).

### 3. Batch edit assumptions or formulas

Apply atomic changes and recalculate in one call via `--operations-json` or `--operations /path/ops.json`:

```sh
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" edit /path/input.xlsx \
  --operations-json '{"ops":[{"kind":"set_cells","sheet_name":"Sheet1","cells":{"A1":{"kind":"value","value":30}}}],"recalculate":"auto"}' \
  --output /path/edited.xlsx
```

To replace an existing formula in `set_cells`, include `"overwrite_formulas": true` and `{"kind":"formula","formula":"A1*3"}` (without leading `=`). Set `"details": true` on the request for an exact cell diff. Rich editing can rewrite the workbook package and does not guarantee original-package preservation; see [stateless-edits.md](references/stateless-edits.md).

### 4. Recalculate original workbook bytes

Check cached formula results without writing, or write recalculated caches while preserving non-cache package bytes:

```sh
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" source-recalculate /path/input.xlsx --check
node "${CLAUDE_SKILL_DIR}/scripts/xlsx.mjs" source-recalculate /path/input.xlsx --output /path/recalculated.xlsx
```

See [source-runtime.md](references/source-runtime.md) for `--options` / `--options-json` calculation settings and receipt fields.

## Check and deliver

Only an explicit `--output` argument writes a workbook. It overwrites an existing destination, including the input if explicitly selected; parent directories must exist.

Read receipt `coverage`, `completed`, and error counts before reporting calculated results. `bytesUnchanged` and legacy `current` mean byte equality only. Report partial or deferred calculation explicitly; an available artifact alone does not establish completed calculation or fresh caches.

Verify comparative narrative claims (such as minimums, troughs, percentage shares, or counterfactuals) against all relevant periods and cells before stating them. Attach or link any requested saved workbook using the host's artifact mechanism and verify that the output file exists.
Files in this package (17)
  • SKILL.md 5 KB
  • engine/PROVENANCE.json 1 KB
  • engine/formualizer_engine.mjs 20 KB
  • engine/formualizer_engine.wasm.br 2,151 KB
  • references/host-probe.md 1 KB
  • references/source-runtime.md 5 KB
  • references/stateless-edits.md 7 KB
  • references/stateless-inspection.md 7 KB
  • scripts/engine.mjs 1 KB
  • scripts/synthetic.mjs 4 KB
  • scripts/xlsx.mjs 16 KB
  • test/edit.test.mjs 12 KB
  • test/inspect.test.mjs 12 KB
  • test/mcp-and-edge.test.mjs 9 KB
  • test/practical.test.mjs 9 KB
  • test/source.test.mjs 17 KB
  • test/transport.test.mjs 5 KB

Versions

RepositoryScoreLicence
This page · PSU3D0/formualizer-plugin100Apache-2.0
fcakyon/claude-codex-settings100Apache-2.0
davila7/claude-code-templates100MIT
letta-ai/skills100MIT

Database snapshot: 13.11.2026 · package version 69bf4936ec68 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 95sheetxl
    Work with spreadsheets using SheetXL — an Excel-grade engine built for agents. Use for any task involving .xlsx, .sxl, or .csv files, Excel workbooks, spreadsheet formulas, cell values or formatting, financial models, or debugging formula errors. Load it before reaching for…
  • 95Xlsx
    Create, read, analyze Excel workbooks — formulas, financial models, data analysis, recalculation, and CSV/TSV conversion. USE WHEN xlsx, Excel, spreadsheet, formulas, financial model, data analysis.
  • 95Xlsx
    Create, read, analyze Excel workbooks — formulas, financial models, data analysis, recalculation, and CSV/TSV conversion. USE WHEN xlsx, Excel, spreadsheet, formulas, financial model, data analysis.
  • 90spreadsheets
    Hosted xlsx-for-ai tools for spreadsheet files and links (.xlsx, .xlsm, .xls, .csv, .tsv, a Google Sheet). Use when the answer depends on formula results, totals, errors or whether saved values are current, on differences between versions, or on cleaning, converting or writing…
  • 100xlsx
    Open, create, read, analyze, edit, or validate Excel/spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Use when the user asks to create, build, modify, analyze, read, validate, or format any Excel spreadsheet, financial model, pivot table, or tabular data file. Covers: creating new…
  • 90spreadsheets
    Create, inspect, calculate, edit, import, and export durable spreadsheet artifacts and explicit XLSX/CSV file boundaries. Use for workbooks, formulas, analyses, tables, calculations, and spreadsheet visual QA. Not for a workbook open in Excel; use excel_run there.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.