xlsx

xlsx

Team Pick
Analytics & Attribution
Anthropic
The skill behind Claude's spreadsheet output: formulas and not hardcoded totals, a mandatory recalculation step, and a documented list of functions it refuses to write.
REPO
anthropics/skills
INSTALL
Claude Code plugin
NEEDS
Data or a spec
Last updated
August 4, 2026

Preview

xlsx

What it is.

This is the skill that powers Claude's own spreadsheet output, published as a reference. For a marketing team it is how you get a funnel model or a spend tracker that recalculates when you change an input, instead of a grid of pasted numbers.

The rule that matters: write the formula, never the computed result. A sheet with =SUM(B2:B9) in it survives being edited, and a sheet with the total typed in does not.

Then there is a mandatory recalculation step. The recalc script runs the file through LibreOffice, reports the total formula count and every error cell by location, and the skill instructs you never to deliver while errors remain.

What you get.

  • Spreadsheets that recalculate, because inputs stay as formulas
  • A recalculation report naming up to 100 error cells per error type
  • A documented function ban list, so a delivered file has no unevaluated cells in it
  • Assumption documentation next to the numbers, with a source citation format
  • An input legend and one example row when the sheet is built for someone else to fill
HOW TO USE IT

How to set it up.

1

Add the marketplace with /plugin marketplace add anthropics/skills, then /plugin install document-skills@anthropic-agent-skills.

2

State the tab names, column headers and the formulas you want in the words you want them. The skill is instructed to follow a spec literally instead of redesign it.

3

Write two or three formulas first and check they pull the values you expect, before building out a full grid.

4

Run scripts/recalc.py on the output. It rewrites the file in place and returns the formula count plus every error cell.

5

Read the status field, not the exit code. A file with errors still exits zero, so a clean exit is not a clean workbook.

6

Stay away from XLOOKUP, FILTER and UNIQUE. The recalculation step evaluates fewer functions than Excel does, and the skill routes you to INDEX and MATCH instead.

Pricing Plans

Free to use. Source-available license, not open source.

Included in Anthropic's document-skills plugin. Checked against the repo in July 2026.

Use cases

A funnel model for handoff

The pipeline model will be edited by someone else. Describe the tab names and the formulas you want, and the file arrives with live formulas throughout and an input legend with one example row for whoever fills it in.

Cleaning a junk export

The CSV from your ad platform has misplaced headers and garbage rows. Hand it the export and a proper spreadsheet comes back, with the structure repaired, not worked around.

Error check before sending

A workbook is about to go to a client. Run the recalculation script and it reports the formula count and every error cell by location, and the rule is that nothing goes out while errors remain.

A spend tracker with receipts

Your budget sheet mixes measured numbers with guesses. The skill requires every hardcoded figure to carry a note where the reader will see it, with a citation format for the published ones.

Best for

A funnel model someone else will edit

Live formulas mean a colleague can change the conversion rate assumption and see the pipeline number move.

Cleaning a messy export

It handles CSV and TSV in, spreadsheet out, including exports with misplaced headers and junk rows.

A spend tracker with sourced assumptions

The skill requires every hardcoded number to carry a note where the reader will see it, with a citation format for published sources.

Read the source

Published by Anthropic. Opens in a new tab.
Open the Tool

Questions about xlsx

Why can I not use XLOOKUP?
Is it open source?
Do I need to install anything?
How do I know the numbers are right?

Questions about Analytics & Attribution

Why keep live formulas in a delivered spreadsheet?
What breaks a shared spreadsheet?
Strengths
  • Formulas over computed results is enforced as a requirement, not offered as a preference.
  • The recalculation step names error cells by location, so a broken model is findable.
  • It warns that a green recalculation proves formulas evaluate and says nothing about whether they are correct.
  • It documents which functions to avoid and what to use instead, which is where most generated spreadsheets break.
Limitations
  • Source-available and not open source, unlike most of the Anthropic set. Read the license before you build a product on it.
  • A workbook linked to another file on disk loses those links when it is re-saved, and the script refuses to run in that state.
  • Spilling array functions have no place here, so lookups get written the older way.
  • It is published as a reference implementation, and Anthropic says these skills are for demonstration.
Skip this if
  • Skip it if your spreadsheet output already carries the formulas you need.

The team behind these plays.

We build inbound GTM engines for B2B software teams, and these are the plays we build from. Tell us the pipeline target and we'll show the plan under it.