How do I install the Analyzing Spreadsheets skill?

Run npx skillmds@latest add telagod/analyzing-spreadsheets in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Analyzing Spreadsheets safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Analyzing Spreadsheets?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Analyzing Spreadsheets free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Analyzing Spreadsheets?

telagod (@telagod) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Analyzing Spreadsheets by telagod — Agent Skill

Name: Analyzing Spreadsheets
Author: telagod

Analyzing Spreadsheets

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.

telagod e410b9f 4 files · 14.7 KB Updated Sep 17, 2026

File contents

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

Task	Tool	Reference
Data analysis, bulk ops, simple export	pandas	recipes.md
Formulas, formatting, Excel features	openpyxl	recipes.md
Financial model standards	—	financial-model.md
Recalculate formulas	`recalc.py`	recipes.md

Common Workflow

Choose tool: pandas for data, openpyxl for formulas/formatting
Create/Load workbook
Modify data, formulas, formatting
Save
Recalculate (MANDATORY if formulas): python recalc.py output.xlsx
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.

---name: analyzing-spreadsheetsdescription: 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.---# XLSX ProcessingCreate, 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| Task | Tool | Reference ||------|------|-----------|| Data analysis, bulk ops, simple export | pandas | [recipes.md](references/recipes.md) || Formulas, formatting, Excel features | openpyxl | [recipes.md](references/recipes.md) || Financial model standards | — | [financial-model.md](references/financial-model.md) || Recalculate formulas | `recalc.py` | [recipes.md](references/recipes.md) |## Common Workflow1. **Choose tool**: pandas for data, openpyxl for formulas/formatting2. **Create/Load** workbook3. **Modify** data, formulas, formatting4. **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](references/recipes.md#critical-use-formulas-not-hardcoded-values).- **Preserve existing templates** — match existing format/style EXACTLY when updating; user template overrides defaults.- **Financial models** — follow color/format conventions in [financial-model.md](references/financial-model.md).## Code Style- Concise Python, no unnecessary comments or print statements.- Excel files: comment cells with complex formulas, document hardcode sources.

Frequently asked questions