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

XLSX Workbook Creation & Editing

Builds and edits Excel workbooks with real formulas and professional formatting, then verifies them error-free via LibreOffice recalculation.

Docs & OfficeIntermediate★ 33,030⑂ 3,248AI score 10/10Last updated: Aug 9, 2026

What it does

  • Creates or edits .xlsx, .xlsm, .xltx workbooks with formulas, formatting, and multiple sheets.
  • Always writes live formulas (=SUM(B2:B9)) instead of Python-computed constants so the sheet recalculates.
  • Runs scripts/recalc.py (LibreOffice) to catch #NAME?/#VALUE! errors before delivery, and refuses to ship a workbook with errors.
  • Encodes openpyxl pitfalls: two-pass loading for formulas + values, the destructive data_only=True save, merged-cell anchors, keep_vba=True for macros, quoting sheet names with spaces.
  • Applies financial-modeling conventions: blue inputs, black formulas, green cross-sheet links, currency/percent number formats, one assumption per labeled cell.

Who it's for

  • Analysts delivering financial models, budgets, or reporting packs as Excel files.
  • Anyone exporting cleaned data or CSVs into a properly formatted workbook.
  • Users burned by AI-generated spreadsheets whose formula cells read back empty or broken.

Examples

  1. "Build a 3-year revenue projection model" → separate assumptions block, blue input cells, consistent formulas, verified with a clean recalc.
  2. "Fill in this existing template" → writes only into the marked input cells and leaves existing formulas and styles untouched.
  3. "Merge three sales CSVs into a workbook with a monthly summary sheet" → pandas for the data, SUMIFS/INDEX-MATCH for the summary, currency formatting applied.

· · · 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/K-Dense-AI/scientific-agent-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 K-Dense-AI/scientific-agent-skills into my ~/.claude/skills/k-dense-ai-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/K-Dense-AI/scientific-agent-skills.git /tmp/sas && mkdir -p ~/.claude/skills && cp -r /tmp/sas/skills/xlsx ~/.claude/skills/

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

  1. Open a terminal and confirm prerequisites: Python 3.8+ and LibreOffice (soffice --version should work).
  2. Clone the repository: git clone https://github.com/K-Dense-AI/scientific-agent-skills.git
  3. Create the skills folder: mkdir -p ~/.claude/skills
  4. Copy the skill in: cp -r scientific-agent-skills/skills/xlsx ~/.claude/skills/
  5. Verify with ls ~/.claude/skills/xlsx — you should see SKILL.md and scripts/recalc.py.
  6. Restart Claude Code and ask something like "create an Excel budget workbook" to trigger the skill.
View source on GitHub ↗License: MIT