analyzing-spreadsheets

Solid

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.

Data & Documents 228 stars 30 forks Updated today MIT

Install

View on GitHub

Quality Score: 92/100

Stars 20%
79
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
82
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

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

Details

Author
telagod
Repository
telagod/code-abyss
Created
4 months ago
Last Updated
today
Language
JavaScript
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category

Data & Documents Solid

xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

27,984 Updated today
davila7
AI & Automation Solid

xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

2,279 Updated 3 weeks ago
foryourhealth111-pixel
Data & Documents Solid

xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

1,596 Updated 4 days ago
OpenCoworkAI