Data & Analysis ✓ Anthropic · Official xlsx-generationspreadsheet-automationopenpyxlheadless-workflowsfinancial-modeling

Headless Excel Workbook Builder

Generate a deliverable .xlsx file in managed-agent sessions without an open Excel application.

FollowSkills review · FSRS-2.0
Not recommended
49/ 100 5-point scale 2.5 / 5
Trust15 / 25 · 3.0/5

The skill restricts the task to producing a local ./out/<name>.xlsx artifact, declares no network or credential access, and says not to append to an existing workbook, so the scope is relatively contained. It does not specify user confirmation, sensitive financial-data handling, overwrite protection, rollback, or data-flow disclosure, so points are deducted.

Reliability8 / 20 · 2.0/5

The output path, openpyxl dependency, formula conventions, and formatting rules make the happy path plausible. However, there are no dependency installation or version-pinning instructions, input validation, exception handling, diagnostic failure messages, collision handling, or execution tests; static calibration therefore keeps the score at or below 10.

Adaptability8 / 15 · 2.7/5

The intended managed-agent/CMA headless scenario is explicit, and the non-fit case of available live Excel tools is stated. Inputs, complex-model boundaries, precise semantic trigger conditions, Chinese-language support, and mainland-China environment fit are not documented, so points are deducted.

Convention8 / 15 · 2.7/5

The document has a concise structure with name, description, output contract, example, modeling conventions, and a non-use condition. Repository evidence supplies an Apache-2.0 license, official provenance, CI validation, and contribution guidance, but the skill lacks versioning, changelog, named maintenance responsibility, dependency installation guidance, troubleshooting, and FAQs.

Effectiveness6 / 15 · 2.0/5

The skill directly addresses creating an xlsx artifact headlessly and provides a usable openpyxl example plus input, formula, and checks-tab conventions. There is no representative complete output, formula-result validation, complex-template coverage, or end-to-end execution evidence, so manual review remains necessary and the static score is capped at 7.

Verifiability4 / 10 · 2.0/5

The output contract, code example, repository CI, and secret-scan workflows provide limited auditable evidence. The workflows do not cover the skill's key workbook-generation paths, and there is no committed test suite, pinned runtime dependency set, or third-party execution result, so only limited credit is justified.

Evidence confidence:Low Reviewed Jul 20, 2026 Reviewed revision 4aa51ed3d379
Before you use it
  • The skill instructs the agent to write and run a Python/Bash script but does not define script-permission boundaries or protection against overwriting existing outputs.
  • Formulas created by openpyxl may not be calculated or validated; qualified personnel should review inputs, formulas, links, balance checks, and final values.
  • Dependency installation, version pinning, abnormal-input handling, and recovery are unspecified, so failures may be difficult to diagnose when openpyxl or write access is unavailable.
  • No confidentiality, redaction, or local-retention policy is stated for sensitive financial data.
Review evidence [1][2][3][4][5][6]
See the full review method →

What it does & when to use it

xlsx-author creates an Excel workbook as a disk artifact for headless managed-agent or CMA sessions instead of editing a live Office workbook. It uses openpyxl through a short Python script and saves the result under ./out/. The skill defines conventions for inputs, formulas, links, named ranges, and balance checks. It fits automated workflows that need a collected workbook file, but it is not a live Excel editing tool.

Writes and runs a Python script using openpyxl to create a workbook; creates ./out/ when needed; saves the workbook as ./out/<name>.xlsx; applies blue, black, and green conventions for hardcoded inputs, formulas, and links; keeps inputs on an Inputs tab; requires calculation cells to use formulas; and adds a Checks tab with TRUE/FALSE model checks such as balance-sheet and cash-flow ties.

  1. A managed-agent workflow needs to produce and deliver an Excel model without an open Office application.
  2. A financial analyst wants inputs, calculations, links, and checks organized according to explicit workbook conventions.
  3. An orchestration layer must collect a generated workbook from a predictable relative path.
  4. A modeling workflow needs to reduce hardcoded calculation cells and surface balance-check results.

Pros & cons

Pros
  • Defines a predictable `./out/<name>.xlsx` artifact path for orchestration.
  • Provides concrete conventions for inputs, formulas, links, named ranges, and checks.
  • Designed specifically for sessions without an open Office application.
Limitations
  • Requires Python and openpyxl, with no version specified.
  • Does not edit live Excel workbooks; a different workflow is preferred when live Excel tools are available.
  • The supplied source shows no test suite, sample input workbook, or platform-specific validation.

How to install

The README does not document a standalone installation command for this skill. To install the collection in Cowork, open Settings → Plugins → Add plugin, add https://github.com/anthropics/financial-services, and select the relevant agents or verticals. In Claude Code, run claude plugin marketplace add anthropics/financial-services, then claude plugin install financial-analysis@claude-for-financial-services. The skill is located at plugins/agent-plugins/valuation-reviewer/skills/xlsx-author/SKILL.md.

How to use

In a headless managed-agent/CMA session, use a prompt such as: Create a financial workbook as a file artifact, using an Inputs tab for hardcoded values, formulas for calculations, and a Checks tab. Save it as ./out/model.xlsx. The final response should return the relative output path. If live Excel tools named mcp__office__excel_* are available, the source instructs users to use those instead.

Compared to similar skills

The source explicitly distinguishes this file-producing workflow from mcp__office__excel_* live Excel workbook operations; it does not provide enough information for other product comparisons.

FAQ

Does it operate an open Excel workbook?
No. It is for headless sessions that generate a workbook file. When live Excel tools are available, the source recommends `mcp__office__excel_*` instead.
Where is the workbook saved?
It must be saved to `./out/<name>.xlsx`, and the relative path should be returned in the final response.
Does it require network access or MCP?
The skill body does not require network access or MCP. It requires Bash/Python execution and local filesystem writes.
Does it provide investment or accounting advice?
The README states that the repository produces analyst work product for qualified-professional review and does not constitute investment, legal, tax, or accounting advice.

More skills from this repository

All from anthropics/financial-services

Data & Analysis ✓ Anthropic · Official

Three-Statement Model Builder

Populate and validate linked income statement, balance sheet, and cash flow models with formulas.

Data & Analysis ✓ Anthropic · Official

Spreadsheet Auditor

Checks spreadsheet formulas, errors, and financial-model integrity.

Data & Analysis ✓ Anthropic · Official

Three-Statement Model Builder

Complete existing three-statement templates with linked formulas, projections, scenarios, and audit checks.

Data & Analysis ✓ Anthropic · Official

Comparable Company Valuation

Build institutional-grade peer valuation analyses with operating metrics, trading multiples, and statistical benchmarks in spreadsheets.

Data & Analysis ✓ Anthropic · Official

Competitive Landscape Analyst

Turn competitive research into an approved, comparable market landscape deck.

Data & Analysis ✓ Anthropic · Official

Earnings Update Researcher

Turn quarterly results into an institutional-style update focused on beats, estimate changes, valuation, and thesis impact.

Data & Analysis ✓ Anthropic · Official

Sector Landscape Research

Structure industry dynamics, competition, valuation, and investment themes in one research workflow.

Productivity & Collaboration ✓ Anthropic · Official

PE Investment Committee Memo Writer

Turns diligence, financial analysis, and deal terms into a structured memo for private equity investment committee approval.

Data & Analysis ✓ Anthropic · Official

Excel Data Cleaning Assistant

Clean inconsistent spreadsheets before analysis.

Data & Analysis ✓ Anthropic · Official

Financial Deck Refresh

Update financial figures across an existing presentation while preserving its formatting and structure.

Writing & Content ✓ Anthropic · Official

IC Memo Drafting

Turns diligence and financial inputs into a structured IC memo.

Data & Analysis ✓ Anthropic · Official

Financial Model Auditor

Find spreadsheet formula errors and test financial-model integrity before review.

Automation & Ops ✓ Anthropic · Official

Reconciliation Break Tracer

Trace ledger breaks to source entries and state the operational root cause.

Automation & Ops ✓ Anthropic · Official

KYC Intake Parser

Turn onboarding packets into structured KYC data ready for screening.

Data & Analysis ✓ Anthropic · Official

Audit XLS: Spreadsheet Model Review

Systematically checks spreadsheet formulas, errors, and financial-model integrity issues.

Data & Analysis ✓ Anthropic · Official

General Ledger Roll-Forward

Connects a balance-sheet account’s opening balance to its period-end GL balance for close packages and audit support.

Data & Analysis ✓ Anthropic · Official

Investment Banking Pitch Deck Filler

Populate existing investment banking PowerPoint templates with validated data from Excel, CSV, and other source files.

Data & Analysis ✓ Anthropic · Official

Three-Statement Model Filler

Complete and validate integrated three-statement templates with formulas, linkages, and audit checks.

Data & Analysis ✓ Anthropic · Official

Financial Model Audit

Systematically checks spreadsheet formulas and model integrity.

Data & Analysis ✓ Anthropic · Official

GL–Subledger Reconciliation

Reconcile general ledger and subledger data, expose breaks, and suggest likely causes for investigation.

Related skills