Data & Analysis ✓ Anthropic · Official

XLSX Spreadsheet Skill

Create, edit, analyze, and convert spreadsheet files with reliable formula checks.

40/ 100
Not recommended

Current benefit does not outweigh risk or uncertainty.

See how it was scored ↓
Works as-is in
Codex · Claude Code · Claude.ai(Partial support) · Claude API(Partial support)
Stars
★ 180k
Last updated
6d ago
spreadsheet-automationxlsxcsvopenpyxl
+2pandaslibreoffice

What does this skill do, and when should you use it?

This Agent Skill targets spreadsheet workflows involving XLSX, XLSM, XLTX, CSV, and TSV files. It directs Claude to use openpyxl for formulas and formatting, pandas for bulk tabular data, and markitdown for quick workbook inspection. It also covers recalculation, formula-error checks, financial-model conventions, and safe editing of existing workbooks. It fits teams that need spreadsheet files as deliverables, but the source does not provide a standalone test suite or a general installation procedure for every client.

Reads, creates, edits, and converts XLSX, XLSM, XLTX, CSV, and TSV files; writes formulas, formatting, and comments with openpyxl; imports and exports bulk tabular data with pandas; previews sheets with markitdown; invokes LibreOffice through scripts/recalc.py to recalculate formulas and report errors; and addresses merged cells, macro preservation, cross-sheet references, and formula compatibility.

Good fit
  • A financial analyst builds a forecast model with formulas, input cells, and documented assumptions.
  • An operations user cleans malformed CSV or TSV data with misplaced headers and exports a structured workbook.
  • An analyst reads multiple Excel files in bulk and consolidates them into a new spreadsheet.
  • A user edits an existing XLSX or XLSM file while preserving its formulas, macros, and formatting conventions.
  • A team validates formula-containing workbooks with LibreOffice before delivery.

How do you install this skill?

Before you use it
  • Fallback pip installation introduces supply-chain risk and may depend on network access that is unreliable from mainland China; dependency sources and versions should be pinned.
  • recalc.py and its complete runtime environment are absent from the supplied evidence, so recalculation and formula-error checking are not confirmed.
  • validate.py --auto-repair and related flows may modify files in place; confirmation and a recoverable backup should be required first.
  • The license, version, maintenance ownership, and update path still require verification against the pinned repository contents.
Before you start
Your agent needs
  • Shell / CLI
  • Local filesystem
Install first
  • Python
  • openpyxl
  • pandas
  • markitdown
  • LibreOffice

The README documents a Claude Code installation path: run /plugin marketplace add anthropics/skills, choose Browse and install plugins, select anthropic-agent-skills and document-skills, then choose Install now. The documented direct command is /plugin install document-skills@anthropic-agent-skills. The source does not document standalone xlsx installation for other clients.

Generic route: install into Claude Code manually (macOS / Linux)
tmp="$(mktemp -d)"
git clone --depth 1 https://github.com/anthropics/skills.git "$tmp"
mkdir -p ~/.claude/skills
cp -R "$tmp/skills/xlsx" ~/.claude/skills/
rm -rf "$tmp"

Generated from the source repository and skill path; it copies only this skill's folder. If the author's install steps above differ, follow those first. To scope it to one project, replace ~/.claude/skills with that project's .claude/skills.

How do you use this skill?

After loading the skill in a compatible Agent Skills client, submit a spreadsheet task such as: Open downloads/report.xlsx, clean the data, add formulas and formatting, and output the edited workbook. For files containing formulas, follow the skill's validation step: run python scripts/recalc.py output.xlsx [timeout_seconds] and inspect the returned JSON status.

What are this skill's strengths and limitations?

Pros
  • Covers common spreadsheet workflows including creation, editing, inspection, bulk processing, and conversion.
  • Requires formulas instead of hardcoded results and requires formula-error checks before delivery.
  • Clearly separates the roles of openpyxl, pandas, and markitdown.
  • Provides detailed financial-model conventions for colors, number formats, and structure.
Limitations
  • The skill is marked Proprietary, with complete terms in LICENSE.txt; the repository-level license is listed as unknown.
  • Formula recalculation depends on LibreOffice, which may require additional environment setup.
  • XLOOKUP, SORT, FILTER, UNIQUE, and SEQUENCE are prohibited, limiting some modern Excel implementations.
  • The source provides no standalone test suite, supported-platform matrix, or cross-platform validation results.
  • The skill requires a spreadsheet file as the primary deliverable and is unsuitable when the main output is a Word document, HTML report, standalone script, database pipeline, or Google Sheets API integration.

How does this skill compare with similar options?

Side by side with related skills; every score comes from the same FSRS standard.

Skill FS score Stars Last updated License
XLSX Spreadsheet Skill this page ✓ Anthropic · Official 40 · Not recommended ★ 180k 6d ago —
xlsx Spreadsheet Skill 49 · Use with care ★ 3k 7mo ago MIT
DeepTutor XLSX Skill 60 · Recommended ★ 41k 3d ago Apache-2.0
Headless Excel Workbook Builder ✓ Anthropic · Official 51 · Use with care ★ 39k 20d ago Apache-2.0
OfficeCLI Data Dashboard Skill 57 · Use with care ★ 32k 5d ago Apache-2.0

How did FollowSkills review this skill?

FollowSkills review · FSRS-2.0
Not recommended
40/ 100 5-point scale 2.0 / 5
The upstream repository has new commits since this review. The score still applies to the reviewed revision shown and may not cover the latest changes.
1Trust9 / 25 · 1.8/5

The evidence scopes the skill to spreadsheet processing and requires following user-specified formats, but it lacks explicit user confirmation, data-flow disclosure, backup/rollback, and sensitive-data handling. It permits pip installation when imports fail, while the office helper uses LD_PRELOAD, compiles C code, and may rewrite files in place, so substantial points are deducted. No credential theft, covert exfiltration, or other explicit red-line behavior is shown.

2Reliability5 / 20 · 1.3/5

The documentation specifies recalculation, error checking, and several abnormal-case warnings, but the referenced scripts/recalc.py is absent from the supplied evidence. Dependency and LibreOffice availability are not statically proven, and parts of the validator coverage do not fully match the XLSX target. The static ceiling and lack of reproducible tests require a low score.

3Adaptability10 / 15 · 3.3/5

Trigger conditions, input formats, tool choices, and non-trigger cases are comparatively clear across spreadsheet creation, editing, reading, and conversion. However, non-fit boundaries, Chinese spreadsheet semantics, and cross-environment Excel/LibreOffice compatibility lack evidence; the pip fallback may depend on external sources with unreliable mainland-China reachability, so points are deducted.

4Convention7 / 15 · 2.3/5

The skill is well organized and includes a task table, requirements, formula constraints, gotchas, financial-model conventions, and dependencies. Versioning, changelog, maintenance ownership, update path, and verifiable licensing are incomplete; the SKILL.md claims Proprietary licensing with a complete LICENSE.txt, while the supplied license metadata remains unknown, preventing a high score.

5Effectiveness5 / 15 · 1.7/5

The instructions address common spreadsheet workflows and add useful safeguards for formula recalculation, errors, and maintainable formatting, so the core value is plausible. However, no representative directly usable outputs or execution evidence are supplied, and the key recalculation script is missing from the evidence; correctness and usability can only be partially established under the static cap.

6Verifiability4 / 10 · 2.0/5

The supplied source is auditable and contains concrete rules, commands, and implementation code. It does not include committed tests, CI results covering the XLSX key paths, or third-party execution records, so formula, recalculation, and file-modification behavior cannot be independently reproduced statically.

1 2 3 4 5 6

Open a dimension to read why it scored that way

Reviewed Jul 19, 2026 Reviewed revision fa0fa64bdc96 Review evidence[1][2][3][4][5][6][7][8][9][10][11]

Evidence confidence:Low — Mostly static review, author material or a limited demo; useful for discovery, not high-risk decisions.

See the full review method →

FAQ

Which file formats are supported?
XLSX, XLSM, XLTX, CSV, and TSV are supported, and the primary deliverable must be a spreadsheet file.
Does it require network access?
The source describes no runtime network calls. If openpyxl, pandas, and markitdown are already available, no installation is needed; pip installation is suggested only if an import fails or the markitdown command is missing.
Can it handle macro-enabled XLSM files?
Yes. When editing XLSM files, the instructions require `keep_vba=True` to preserve macros.
How are formulas validated?
Run scripts/recalc.py and inspect `status`, `total_errors`, and the error summary. A clean recalculation shows that formulas evaluate, but it does not prove that their business logic is correct.

More skills from this repository

All from anthropics/skills

Related skills