Analyzing Spreadsheets

What it does

When your agent uses it

• Working with spreadsheet files
• Tabular data analysis
• Database pipelines

Example prompts

• “Use the analyzing-spreadsheets skill to process Excel spreadsheet files (.xlsx, .xlsm, .csv). An agent skill from telagod/code-abyss”
• “/analyzing-spreadsheets”

Requirements

• Python 3
• Pre-approved tools (allowed-tools): Bash, Read, Write, Edit, Glob

Workflow steps

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

1. 1Choose tool: pandas for data, openpyxl for formulas/formatting
2. 2Create/Load workbook
3. 3Modify data, formulas, formatting
4. 4Save
5. 5Recalculate (MANDATORY if formulas): python recalc.py output.xlsx
6. 6Verify & fix errors — check JSON output, fix #REF! / #DIV/0! / #VALUE! / #NAME?

What it can do on your machine

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

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Bash
  • Read
  • Write
  • Edit
  • Glob

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Ships script files (Python), which the agent can run.

  Shell commands in SKILL.md call:

  • python

  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

Analyzing Spreadsheets loads about 532 tokens when it runs, and up to ~2.2k if it reads all its reference files. Until then it costs about 91 tokens; SKILL.md has 157 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~91

When it runs · the whole SKILL.md, loaded when a task matches

~532

With references · SKILL.md plus every file in references/, read only if the agent opens them

~2.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

• NotePre-approves every shell command (allowed-tools: Bash)SKILL.md

  allowed-tools: Bash, Read, Write, Edit, Glob

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); files beside SKILL.md are not scanned.

SKILL.md

The full file from telagod/code-abyss at commit 2544577, republished under its MIT licence (© telagod). 157 words, ~532 tokens.

name

analyzing-spreadsheets

description

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.

allowed-tools

Bash, Read, Write, Edit, Glob

user-invocable

false

argument-hint

<file.xlsx | task>

© telagod, 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 3 other files (references) in skills/analyzing-spreadsheets of telagod/code-abyss.

• SKILL.md
• recalc.py
• references/financial-model.md
• references/recipes.md

Open the folder on GitHubat commit 2544577