# 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.

- Skill: `telagod/analyzing-spreadsheets` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add telagod/analyzing-spreadsheets`
- Raw SKILL.md: https://api.skillmd.com/api/skills/telagod/analyzing-spreadsheets/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: telagod (https://skillmd.com/u/telagod)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/telagod/analyzing-spreadsheets

---


# 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](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 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](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.