AI Skill MartBrowse skillsPromptsProgramsLearnWhat is a Skill?
 
← Back to list

XLSX Creation & Editing

Official

Official Anthropic skill for building, editing, and validating Excel files with real formulas, professional formatting, and automated recalculation checks.

Docs & OfficeIntermediate★ 167,132⑂ 19,920AI score 10/10Last updated: Aug 7, 2026

What it does

  • Opens, reads, edits, or creates .xlsx, .xlsm, .xltx, .csv, and .tsv files.
  • Writes live formulas instead of hardcoded Python results so the workbook recalculates.
  • Runs scripts/recalc.py (LibreOffice-backed) to recalculate in place and report every formula error before delivery.
  • Steers away from functions LibreOffice can't evaluate (XLOOKUP, FILTER, UNIQUE, SEQUENCE) and applies the _xlfn. prefix rules for post-2007 functions.
  • Applies financial-model conventions: blue inputs, black formulas, green cross-sheet links, currency/percent/multiple number formats, isolated assumption cells.

Who it's for

  • Finance and FP&A folks building models, budgets, and forecasts.
  • Data workers turning messy CSVs into clean, formatted spreadsheets.
  • Anyone editing an existing workbook who must respect its original conventions.

Examples

  1. "Add quarterly totals and a growth-rate column to the revenue xlsx in my Downloads."
  2. "Clean up raw_data.csv — headers are buried mid-file and there are junk rows — into a proper sheet."
  3. "Build a 3-year P&L model with assumptions on their own tab, inputs in blue."

· · · Install guide · · ·

Try it now, no install

Paste this into Claude to use the skill without installing anything.

Read the instructions in this file and follow them to help me:
https://raw.githubusercontent.com/anthropics/skills/HEAD/skills/xlsx/SKILL.md

What I want: (describe your task here)

If Claude can't open the link, open it yourself and paste the contents instead.

↓ If it works for you, download the ZIP below and install it. Then it runs on its own — no pasting each time.

Install in the Claude app (no terminal)
  1. Download the ZIP with the button below.
  2. In Claude, open Settings → Capabilities and turn on 'Code execution and file creation'. (one time)
  3. Go to Customize → Skills → + → 'Upload a skill' and upload the ZIP.
↓ Download ZIP
Install in Claude Code

Let Claude do it — paste this into Claude Code

Install the skill I found on AI Skill Mart.
Copy the skills/xlsx folder from the GitHub repo anthropics/skills into my ~/.claude/skills/xlsx/.
When it's done, tell me in one line what this skill can do.

Install with a command instead

git clone https://github.com/anthropics/skills.git /tmp/anthropic-skills && mkdir -p ~/.claude/skills && cp -r /tmp/anthropic-skills/skills/xlsx ~/.claude/skills/xlsx

⚠ This is a third-party skill. Check the source repository before installing.

  1. Open a terminal.
  2. Clone the repo: git clone https://github.com/anthropics/skills.git /tmp/anthropic-skills
  3. Create the skills folder: mkdir -p ~/.claude/skills
  4. Copy just this skill: cp -r /tmp/anthropic-skills/skills/xlsx ~/.claude/skills/xlsx
  5. Install LibreOffice so recalc.py can verify formulas (macOS: brew install --cask libreoffice; Ubuntu: sudo apt install libreoffice).
  6. Install the Python deps if missing: pip install openpyxl pandas markitdown
  7. Restart Claude Code and try a prompt like "add a totals column to this xlsx" — the skill triggers automatically.
View source on GitHub ↗