Data & Analysis ✓ Anthropic · Official xlsxopenpyxlspreadsheet-modelingfinancial-modelingheadless-automation

Headless Excel Workbook Builder

Create deliverable Excel files in managed-agent sessions without an open Office application.

FollowSkills review · FSRS-2.0
Not recommended
52/ 100 5-point scale 2.6 / 5
Trust17 / 25 · 3.4/5

The skill limits its stated action to creating a local ./out/<name>.xlsx artifact, requires no external connector, and distinguishes headless mode from Cowork mode. It lacks user confirmation, sensitive-data handling, rollback or cleanup guidance, and dependency-security controls, so points are deducted.

Reliability8 / 20 · 2.0/5

The output path, openpyxl example, and modeling conventions make the happy path understandable. There are no tests, input validation, exception handling, pinned dependency or diagnostic failure messages, so the static score remains limited.

Adaptability9 / 15 · 3.0/5

It clearly targets headless/CMA sessions without an open Office application and identifies Cowork mode as out of scope. Inputs, complex-workbook boundaries, trigger precision, Chinese-language support, and broader environment compatibility are not specified, so points are deducted.

Convention8 / 15 · 2.7/5

The document has concise sections for the output contract, example, conventions, and non-fit case. Repository-level Apache-2.0 licensing and official provenance are available, but the skill lacks versioning, changelog, maintenance ownership, installation notes, FAQs, and explicit limitations.

Effectiveness6 / 15 · 2.0/5

It can directly guide creation of a basic xlsx artifact with formulas, styles, and a known output location. The example is narrow and does not demonstrate a realistic month-end-close workbook, validation, or complex inputs, so direct usability still requires review.

Verifiability4 / 10 · 2.0/5

The instructions are auditable, and repository CI provides plugin validation and secret scanning. Those workflows do not reproduce the skill's key workbook-generation paths, and no committed test suite or third-party execution evidence is provided, so verification is limited.

Evidence confidence:Low Reviewed Jul 20, 2026 Reviewed revision 4aa51ed3d379
Before you use it
  • Confirm that a compatible Python environment and openpyxl installation are available; installation and version pinning are undocumented.
  • The skill writes to ./out/ but does not define overwrite behavior, failed-artifact cleanup, or recovery.
  • Color, named-range, and Checks conventions are advisory only; no automated audit or formula-result verification is supplied.
  • Do not treat the example as a complete month-end-close workflow; financial outputs still require human review.
Review evidence [1][2][3][4][5][6]
See the full review method →

What it does & when to use it

xlsx-author creates Excel workbook files in headless managed-agent or CMA environments. It uses Python and openpyxl to write the workbook to disk instead of driving a live Excel workbook. The required output location is ./out/<name>.xlsx, and the relative path must be returned in the final message. The skill also defines conventions for inputs, formulas, links, named ranges, and model checks.

Creates ./out/ when needed, writes and runs a Python script, uses openpyxl to create or modify one Excel workbook, and saves it as ./out/<name>.xlsx. The workbook may include Inputs, calculation, and Checks tabs; hardcoded inputs use blue font, formulas use black font, and links to another sheet or file use green font. Calculation cells must contain formulas, values referenced from decks or memos should use named ranges, and applicable balance checks should be included for the balance sheet, cash flow, and related ties.

  1. A managed-agent user needs an Excel financial model when no Office application is open.
  2. A financial analyst needs to generate a new workbook with input, calculation, and check tabs using Python and openpyxl.
  3. A modeler needs consistent color conventions for hardcoded inputs, formulas, and cross-sheet links during review.
  4. An orchestration workflow needs a generated .xlsx file saved on disk as a collectable artifact.

Pros & cons

Pros
  • Designed for managed-agent environments without an open Office application.
  • Defines a clear output path and artifact-delivery contract.
  • Provides concrete conventions for inputs, formulas, links, and checks.
  • Uses Python and openpyxl, making workbook generation scriptable.
Limitations
  • Requires Python, Bash, filesystem write access, and openpyxl.
  • The source provides instructions and an example but no test suite or supported-platform matrix.
  • It is not intended for interactive editing of an already open Excel workbook.
  • The source does not document formula recalculation, complex-format compatibility, or error-recovery behavior.

How to install

The skill is located at plugins/agent-plugins/month-end-closer/skills/xlsx-author/SKILL.md. The README does not document a standalone installation command for this skill; in Cowork, you can open Settings → Plugins → Add plugin, paste https://github.com/anthropics/financial-services, and select the required agent or vertical. The repository is licensed under Apache-2.0.

How to use

In a headless managed-agent or CMA session, request an Excel artifact, for example: “Create an Excel workbook with Inputs, calculation, and Checks tabs and save it as ./out/model.xlsx.” The skill requires running a Python script with Bash and using openpyxl to generate the file; the final response must return the relative path ./out/<name>.xlsx. If mcp__office__excel_* tools are available, use the live Excel workflow instead of this file-producing fallback.

Compared to similar skills

The skill explicitly distinguishes itself from mcp__office__excel_* live Excel tools: xlsx-author produces a disk-based .xlsx artifact, while those tools drive a user's live workbook.

FAQ

Can it directly edit an already open Excel workbook?
It is not intended for that use. The skill targets headless file generation; when mcp__office__excel_* tools are available, the live-workbook workflow should be used.
Where is the output saved?
It must be saved to ./out/<name>.xlsx, creating ./out/ first if necessary.
Does it require network access or external data connectors?
The source does not require network access or external data connectors. Its stated dependencies are Bash, Python, and openpyxl.
Does it guarantee that the workbook is correct?
No guarantee is stated. The skill requires a Checks tab with TRUE/FALSE results, but the source provides no test suite or independent validation mechanism.

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