mcpbeat

Analyzing Spreadsheets

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.

4k tokens
context cost
the whole folder, loaded on every use
4
files
ships runnable scripts
0
copies elsewhere
how many repositories repackaged it
238
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository 
npx skills add https://github.com/telagod/code-abyss --skill analyzing-spreadsheets

The instruction itself

6 sections, as written by the author

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.

How to use it

Copy the folder

Take telagod/analyzing-spreadsheets from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.