Agent skill

Excel Model

by mohitagw15856 in mohitagw15856/pm-claude-skills

Build a real, formula-driven Excel (.xlsx) model — not a static table.

MITAuto-check passedDocuments & Office

Install Excel Model

skills CLI
$ npx skills add mohitagw15856/pm-claude-skills --skill excel-model -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install mohitagw15856/pm-claude-skills excel-model --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/mohitagw15856/pm-claude-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/excel-model .claude/skills/excel-model && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
excel-model
GitHub stars
1.4k
Token cost
~1.2k tokens
SKILL.md length
557 words
Files
2 (incl. scripts)
Skills in repo
1,322
Repo updated
First seen
Licence
MIT

At a glance

Build a real, formula-driven Excel (.xlsx) model — not a static table.

  • Works in 3 steps: Design before coding — lay out the… → Write an openpyxl script that → Run it, then state the formulas used and…
  • Asked to build an Excel model
  • SKILL.md covers Required Inputs, Process, Output Format and Quality Checks, plus 4 more sections
  • Runs Python scripts from its folder; calls python3

What it does

Excel Model is an agent skill from mohitagw15856/pm-claude-skills. Build a real, formula-driven Excel (.xlsx) model — not a static table. Use when asked to build an Excel model, a financial model, a budget/forecast spreadsheet, or any .xlsx with live formulas a user can edit. Produces an actual .xlsx file via a generated openpyxl script: an inputs/assumptions sheet, calculation sheets with real cell formulas, and formatting — so changing an input recalculates the model. Requires a code-execution environment (Claude Code, the API code tool, or Claude.ai).

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including scripts (for example `scripts/xlsx_tool.py`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel and openpyxl. The repository describes itself as: 1255 professional Agent Skills for Claude, ChatGPT, Gemini, Cursor & Codex — PRDs, postmortems, leases, medical bills, layoffs, go-bags, new countries. Plain markdown, MIT, in… The licence is MIT.

When your agent uses it

  • Asked to build an Excel model
  • A financial model
  • A budget/forecast spreadsheet
  • Any .xlsx with live formulas a user can edit

Example prompts

  • “/excel-model”

Requirements

  • Python 3

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. Design before coding — lay out the sheets (Inputs · Calculations · Output/Summary), and which cells are inputs vs. formulas. Confirm the…
  2. Write an openpyxl script that
  3. Run it, then state the formulas used and tell the user which cells to change to flex the model.

What it can do on your machine

Read from SKILL.md and the folder at commit 1cbf1f0. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/ (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • python3

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Excel Model loads about 1.2k tokens when it runs. Until then it costs about 126 tokens; SKILL.md has 557 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~126
When it runs · the whole SKILL.md, loaded when a task matches
~1.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from mohitagw15856/pm-claude-skills at commit 1cbf1f0, republished under its MIT licence (© mohitagw15856). 557 words, ~1,190 tokens.

Download SKILL.mdSave it as .claude/skills/excel-model/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
excel-model
description
Build a real, formula-driven Excel (.xlsx) model — not a static table. Use when asked to build an Excel model, a financial model, a budget/forecast spreadsheet, or any .xlsx with live formulas a user can edit. Produces an actual .xlsx file via a generated openpyxl script: an inputs/assumptions sheet, calculation sheets with real cell formulas, and formatting — so changing an input recalculates the model. Requires a code-execution environment (Claude Code, the API code tool, or Claude.ai).

Excel Model Skill

A model is only useful if it's live — change an assumption and everything recalculates. A markdown table can't do that; a real .xlsx with cell formulas can. This skill builds an actual Excel workbook by writing and running an openpyxl script: a clean inputs sheet, calculation sheets that reference those inputs with real = formulas, and sensible formatting — so the user gets a file they can drive, not a snapshot.

Environment: this produces a binary file, so it needs a place to run code — Claude Code, the Anthropic API code-execution tool, or Claude.ai (with the analysis/code tool). In the browser playground (no code execution), use the markdown output as the spec instead.

Required Inputs

Ask for these only if they aren't already provided:

  • What the model is — financial model, budget, forecast, pricing model, scenario planner, etc.
  • The inputs/assumptions — the driver variables (and rough values) the user will change.
  • The outputs — what it should compute (revenue, burn, margins, totals, a P&L, etc.).
  • Structure — periods (months/years), tiers/segments, and any required layout.

Process

  1. Design before coding — lay out the sheets (Inputs · Calculations · Output/Summary), and which cells are inputs vs. formulas. Confirm the calculation logic with the user if non-trivial.
  2. Write an openpyxl script that:
    • Puts all driver assumptions on an Inputs sheet (one source of truth), labelled and formatted.
    • Builds calculation cells as real formulas referencing the input cells (e.g. =Inputs!B2*Inputs!B3), never hard-coded results — so the model is live.
    • Adds formatting: headers, number/currency/percent formats, column widths, and light cell styling for readability.
    • Saves to a clearly named .xlsx.
  3. Run it, then state the formulas used and tell the user which cells to change to flex the model.

Output Format

  • The generated .xlsx file (the deliverable).
  • A short README of the model: the sheets, the input cells to change, the key formulas in plain English, and any assumptions.
Show full SKILL.md (248 more words)Show less

Quality Checks

  • Calculations are live cell formulas, not pasted static values
  • All driver assumptions live on one Inputs sheet and are referenced, not duplicated
  • Numbers are formatted (currency/percent/thousands) and sheets are readable
  • The script runs cleanly and the file opens in Excel/Sheets/Numbers
  • The user is told exactly which cells to change to drive the model

Anti-Patterns

  • Do not write computed results as static numbers — the whole point is that inputs recalculate
  • Do not hard-code an assumption inside a formula — put it on the Inputs sheet and reference it
  • Do not scatter inputs across sheets — one assumptions sheet, single source of truth
  • Do not skip formatting — an unformatted grid of numbers is hard to trust or use
  • Do not claim a file was produced if there was no code execution — fall back to a clear spec instead

Based On

Financial-modelling best practice (separate inputs from calculations, formula-driven, no hard-codes) implemented with openpyxl.

Programmatic Helper

This skill ships scripts/xlsx_tool.py — a zero-dependency (stdlib zip+XML) tool that produces real .xlsx files, so the model you design can be delivered as a working workbook, not a markdown table:

bash
# Build a workbook from JSON (numbers stay numbers, "=B2*C2" becomes a live formula)
python3 scripts/xlsx_tool.py create model.xlsx --data '{"Model": [["Item","Qty","Price","Total"],["Widget",4,9.5,"=B2*C2"]]}'

# Fill {{placeholders}} in an existing template workbook
python3 scripts/xlsx_tool.py fill template.xlsx out.xlsx --values '{"month":"July","revenue":21000}'

Design the model first (per this skill), then emit the JSON and run create. Honest limits: default styling only, no charts — for formatted finals, open the generated file and style it, or use the playground's Excel export.

Example Trigger Phrases

  • "Build an Excel model."
  • "Build a financial model in Excel."
  • "Make a budget spreadsheet with live formulas."
  • "Make me an .xlsx forecast I can edit."

© mohitagw15856, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (scripts) in skills/excel-model of mohitagw15856/pm-claude-skills.

  • SKILL.md
  • scripts/xlsx_tool.py

Open the folder on GitHubat commit 1cbf1f0

Compare with similar skills

Excel Model next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Excel Model compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Excel Model this skillmohitagw15856/pm-claude-skills1.4k—~1.2kAutomated safety check: PassMIT
XLSXNousResearch/hermes-agent252k—~2.4kAutomated safety check: PassMIT
Z Md Exceltjxj/z-skills546—~728Automated safety check: PassNone
Sn Da Large File AnalysisMichaelYang-lyx/AIDABench1111 repos~3.1kAutomated safety check: PassNone
XLSXprapaa-ai/agav147—~486Automated safety check: PassApache-2.0
XLSXjjyaoao/HelloAgents3.2k—~5kAutomated safety check: PassProprietary

Similar skills

  • XLSX

    NousResearch/hermes-agent

    Create, read, edit Excel .xlsx workbooks and CSVs. An agent skill from NousResearch/hermes-agent.

    252k GitHub stars~2.4k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Z Md Excel

    tjxj/z-skills

    Extract all Markdown tables from a .md file and export to Excel (.xlsx).

    546 GitHub stars~728 tokensUpdated 16 days ago
    Documents & OfficeAuto-check passed
  • Sn Da Large File Analysis

    MichaelYang-lyx/AIDABench

    万行以上 Excel 数据集的高性能分析引擎。提供 openpyxl readonly 流式读取(iterrows 支持 10 万行以上)、Parquet 转换加速、内存优化、分块处理和大文件写入模式。遇到以下任一情况就主动使用本 skill:①数据行数 ≥ 10k(由 sn-da-excel-workflow 的行数评估步骤触发);②用户出现触发词:大文件 / 大数据量 / 性能优化 /…

    111 GitHub starsUsed in 1 repo~3.1k tokens
    Documents & OfficeAuto-check passed
  • XLSX

    prapaa-ai/agav

    Create, read, and edit Excel .xlsx spreadsheets and CSV files

    147 GitHub stars~486 tokensUpdated today
    Documents & OfficeAuto-check passed
  • XLSX

    jjyaoao/HelloAgents

    Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization.

    3.2k GitHub stars~5k tokensUpdated 2 days ago
    Documents & OfficeAuto-check passed
  • XLSX

    ginlix-ai/LangAlpha

    Excel workbooks with live formulas: build or edit .xlsx models with openpyxl, recalculate with IronCalc or LibreOffice, audit conventions, profile messy uploads, render for review

    1.8k GitHub stars~9.3k tokensUpdated today
    Documents & OfficeAuto-check passed

More from mohitagw15856/pm-claude-skills

All 1,322 skills in this repo
  • Exit Waterfall

    mohitagw15856/pm-claude-skills

    Compute who gets what at each exit price from a cap table — liquidation preferences, conversion points, and where the founders' share collapses.

    1.4k GitHub stars~1.1k tokensUpdated yesterday
    Auto-check passed
  • Feature Prioritisation

    mohitagw15856/pm-claude-skills

    Apply prioritisation frameworks (RICE, MoSCoW, Kano, ICE, Opportunity Scoring) to rank features and backlog items.

    1.4k GitHub stars~2k tokensUpdated yesterday
    Auto-check passed
  • Freelance Rate

    mohitagw15856/pm-claude-skills

    Derive a freelance day/hourly rate backwards from target income, honest billable utilization, overhead, and the self-employment tax premium — the arithmetic that proves a rate is not salary÷2000.

    1.4k GitHub stars~1.2k tokensUpdated yesterday
    Auto-check passed
  • Offer Comparison

    mohitagw15856/pm-claude-skills

    Compare two or more job offers as total-comp curves over four years — vesting cliffs, bonuses, 401(k) match, and the crossover year computed, not vibed.

    1.4k GitHub stars~1.1k tokensUpdated yesterday
    Auto-check passed
  • Refinance Breakeven

    mohitagw15856/pm-claude-skills

    Compute the month a refinance actually starts saving money — payment delta, breakeven month, and total interest on both paths including the term-reset trap.

    1.4k GitHub stars~1k tokensUpdated yesterday
    Auto-check passed
  • Rent Vs Buy

    mohitagw15856/pm-claude-skills

    Model rent-vs-buy honestly — year-by-year net position for both paths including the assumption everyone drops (the renter invests the difference), with a breakeven horizon instead of a verdict.

    1.4k GitHub stars~1.2k tokensUpdated yesterday
    Auto-check passed

Questions about Excel Model

What does Excel Model do?

Build a real, formula-driven Excel (.xlsx) model — not a static table. Excel Model is an agent skill from mohitagw15856/pm-claude-skills.xlsx) model — not a static table.

When should I use Excel Model?

Excel Model fits situations like: asked to build an Excel model; A financial model; A budget/forecast spreadsheet; any .xlsx with live formulas a user can edit.

How do I install Excel Model in Claude Code?

Run `npx skills add mohitagw15856/pm-claude-skills --skill excel-model -a claude-code`. Or copy the skill folder (skills/excel-model in mohitagw15856/pm-claude-skills) into .claude/skills/excel-model in your project. Claude Code loads it when a task matches its description.

How do I install Excel Model in Codex?

Run `npx skills add mohitagw15856/pm-claude-skills --skill excel-model -a codex`. Or copy the skill folder (skills/excel-model in mohitagw15856/pm-claude-skills) into .agents/skills/excel-model in your project. Codex loads it when a task matches its description.

Can I use Excel Model in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add mohitagw15856/pm-claude-skills --skill excel-model -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/excel-model, .gemini/skills/excel-model, .github/skills/excel-model and .opencode/skills/excel-model in your project.

What does Excel Model need to run?

Going by SKILL.md and its folder, Excel Model needs Python for the scripts in its folder and the command-line tools its instructions call (python3). Our summary lists: Python 3.

Does Excel Model access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Excel Model safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Excel Model use?

Excel Model is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Excel Model use?

About 1.2k tokens (SKILL.md is roughly 4.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Excel Model?

Skills that share tags, products or a category with Excel Model: XLSX (NousResearch/hermes-agent, 252k stars), Z Md Excel (tjxj/z-skills, 546 stars), Sn Da Large File Analysis (MichaelYang-lyx/AIDABench, 111 stars) and XLSX (prapaa-ai/agav, 147 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Excel Model?

mohitagw15856 (a GitHub user) maintains it in mohitagw15856/pm-claude-skills, which has 1,431 GitHub stars. The repository holds 1,322 skills in this directory. The repository was last updated on October 7, 2026.

Source: mohitagw15856/pm-claude-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.