Claude Skill MartBrowse skillsQuick linesLearn by videoTerminal guideWhat is a Skill?
 
← Back to list

XLSX Spreadsheet Toolkit

Create, edit, and analyze Excel files with live formulas, finance-grade formatting, and automated formula error checks.

Docs & OfficeIntermediate★ 156⑂ 10AI score 10/10Last updated: Aug 17, 2026

What it does

  • Handles .xlsx, .xlsm, .csv, .tsv files for creation, editing, and analysis with a consistent rulebook.
  • Enforces Excel formulas over hardcoded Python results (=SUM(...), =AVERAGE(...)) so the workbook stays dynamic when source data changes.
  • Applies financial-model conventions: color coding (blue inputs, black formulas, green intra-workbook links, red external links), number formats ($#,##0, parentheses for negatives, 0.0x multiples), and source citations for every hardcode.
  • Runs recalc.py against headless LibreOffice to recalculate all sheets and return JSON pinpointing #REF!, #DIV/0!, #VALUE!, #NAME? errors.
  • Ships pandas recipes for pivots, group-bys, filtering, cleaning, merging, plus matplotlib charts and conditional formatting.

Who it's for

  • Finance, FP&A, and accounting folks building models and recurring reports.
  • Analysts and ops people consolidating messy multi-file spreadsheets.
  • Anyone updating an existing template without breaking its established styling.

Examples

  1. "Build a 3-year revenue projection from this quarterly data" → assumptions isolated in cells, all math as formulas, verified with zero recalc errors.
  2. "Merge sales_q1.xlsx and sales_q2.xlsx and produce a pivot by region" → pandas concat + pivot_table exported with auto-sized columns.
  3. "Update only the FY2025 column in our budget template" → existing formatting and conventions preserved exactly.

· · · 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/appautomaton/document-SKILLs/HEAD/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 Claude Skill Mart.
Copy the xlsx folder from the GitHub repo appautomaton/document-SKILLs into my ~/.claude/skills/appautomaton-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/appautomaton/document-SKILLs.git /tmp/document-SKILLs && mkdir -p ~/.claude/skills && cp -r /tmp/document-SKILLs/xlsx ~/.claude/skills/

⚠ 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/appautomaton/document-SKILLs.git
  3. Copy the skill folder: mkdir -p ~/.claude/skills && cp -r document-SKILLs/xlsx ~/.claude/skills/
  4. Install LibreOffice for formula recalculation: macOS brew install --cask libreoffice, Ubuntu/Debian sudo apt-get install libreoffice.
  5. (Optional, macOS) brew install coreutils so recalculation can be time-limited.
  6. Install uv so Python deps (openpyxl, pandas, matplotlib) resolve automatically: curl -LsSf https://astral.sh/uv/install.sh | sh
  7. Restart Claude Code and ask something like "create an Excel revenue model" — the skill triggers automatically.
View source on GitHub ↗License: MIT