AugmentClaude
FinanceDashboards

Spreadsheet Analyzer

By telagod· telagod/code-abyss· 0

Create, edit, and analyze Excel and CSV files with formulas and data validation.

Installation

  1. Make sure Claude is on your device and in your terminal.

    Skills load from ~/.claude/skills/ when Claude Code starts up — so you need it on your machine first. If you don't have it yet, install it once with the command below, then run claude in any terminal to verify.

    One-time setup
    npm i -g @anthropic-ai/claude-code

    Already have it? Skip ahead.

  2. Paste into Claude Code or into your terminal.
    Install
    Sign up to copy
    Sign up free to reveal

    This copies the whole skill folder into ~/.claude/skills/analyzing-spreadsheets-telagod/ — the SKILL.md plus any scripts, reference docs, or templates the skill ships with. Safe default: works for every skill.

    Faster alternative (instruction-only skills)

    Skips the clone and grabs only the SKILL.md file. Don't use this if the skill ships Python scripts, reference markdowns, or asset templates — they won't be downloaded and the skill will fail when it tries to load them.

    Quick install (SKILL.md only)
    Sign up to copy
    Sign up free to reveal
  3. Restart Claude Code.

    Quit and reopen Claude Code (or any other agent that loads from ~/.claude/skills/). New skills are picked up on startup.

  4. Just ask Claude.

    Skills auto-activate when your request matches the skill's description — no slash command needed. Trigger phrases live in the skill's own frontmatter; you can read them in the “What this skill does” section above.

Prefer to read the source first? Open on GitHub.

When Claude uses it

Processes Excel spreadsheet files (.xlsx, .xlsm, .csv). Creates workbooks, builds formulas, preserves formatting, analyzes tabular data, and validates financial models with zero-formula-error delivery. Use when working with spreadsheet files or tabular data analysis. Do NOT use for Word documents, PDFs, presentations, or database pipelines.

What this skill does

XLSX Processing

Create, edit, analyze .xlsx files. LibreOffice required for formula recalculation via recalc.py.

Iron Rule

Zero formula errors at delivery. All formulas must compute — no #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?. Always run recalc.py after writing formulas.

Decision Matrix

TaskToolReference
Data analysis, bulk ops, simple exportpandasrecipes.md
Formulas, formatting, Excel featuresopenpyxlrecipes.md
Financial model standards—financial-model.md
Recalculate formulasrecalc.pyrecipes.md

Common Workflow

  1. Choose tool: pandas for data, openpyxl for formulas/formatting
  2. Create/Load workbook
  3. Modify data, formulas, formatting
  4. Save
  5. Recalculate (MANDATORY if formulas): python recalc.py output.xlsx
  6. Verify & fix errors — check JSON output, fix #REF! / #DIV/0! / #VALUE! / #NAME?

Hard Constraints

  • Use formulas, not hardcoded values — calculations stay dynamic. See recipes.md.
  • Preserve existing templates — match existing format/style EXACTLY when updating; user template overrides defaults.
  • Financial models — follow color/format conventions in financial-model.md.

Code Style

  • Concise Python, no unnecessary comments or print statements.
  • Excel files: comment cells with complex formulas, document hardcode sources.

Related skills

C

Contract & Proposal Writer

alirezarezvani

Generate professional contracts, proposals, and legal documents for multiple jurisdictions.

C

CFO Financial Advisor

alirezarezvani

Build financial models, analyze unit economics, and plan fundraising strategy for startups.

MIT
C

CHRO People Advisor

alirezarezvani

Build hiring plans, compensation frameworks, and organizational structures that scale.

MIT
D

Domain Name Brainstormer

Prat011

Generate creative domain name ideas and check availability across multiple extensions.