excel-ai-analyst

excel-ai-analyst is a skill for Claude Code from zhanglunet/openworker-zh-localized. It costs 219 tokens per session (5,248 once invoked), scanned A, original, MIT.

A method for reverse-engineering business Excel files that contain formulas. It treats columns as named values, formulas as calculations, and links between sheets as data paths.

In plain words
What is it for?
It is for mapping fields and formulas, tracing data across sheets, checking every row against the original values, and producing annotated results and business analysis.
Why use it?
It helps explain how a poorly documented spreadsheet reaches its results before relying on those results for analysis or decisions.

Skill for Claude Code

Written for Claude Code: allowed-tools in frontmatter.

Needs its repository: it runs a file that does not travel with it, so clone the repository first. The line is python3 <resources_path>/scripts/excel_ai.py output spec.json -d ./03_verify/verification_detail.csv -o ./04_output.

Good fit It is for mapping fields and formulas, tracing data across sheets, checking every row against the original values, and producing annotated results and business analysis.

Compare 6 skills from other repositories ↓
Install

Getting it into your agent

It runs from inside its repository, so the clone comes first — what it calls does not travel with the file alone.

Clone the repo
git clone --depth 1 https://github.com/zhanglunet/openworker-zh-localized
agentmods
npx agentmods add skills/zhanglunet/openworker-zh-localized/excel-ai-analyst

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for excel-ai-analyst

README.md
[![agentmods](https://agentmods.dev/badge/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst/github.svg)](https://agentmods.dev/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst)
Your own site
<a href="https://agentmods.dev/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst"><img src="https://agentmods.dev/badge/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for excel-ai-analyst

Your own site · 80×15
<a href="https://agentmods.dev/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst"><img src="https://agentmods.dev/badge/skills/zhanglunet/openworker-zh-localized/excel-ai-analyst.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 219 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 5,248 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00219 $0.05248
Opus 5 $0.00110 $0.02624
Sonnet 5 $0.00044 $0.01050
Haiku 4.5 $0.00022 $0.00525

Measured 11d ago against content hash ebb97c68e606, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-11, from the pricing page.

Security

Grade A, and why

excel-ai-analyst scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 11d ago.

The scan reads SKILL.md. This mod also ships 13 executable files (scripts/excel_ai.py, tests/attacks/dirty-data/make_attack_fixtures.py, tests/attacks/dirty-data/run_attacks.py, …), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

docs/enterprise/templates/skills/excel-ai-analyst/SKILL.md · 280 lines

How it starts

The opening of the file, as written. The whole thing — 280 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Excel 智能分析(把表格当代码读)

核心主张

一张成熟的业务 Excel 就是一套没有文档的遗留代码:列名是变量名,公式是函数, 跨 Sheet 引用是模块依赖,check 列是单元测试。所以分析它的正确姿势不是"看数据", 而是逆向工程:先还原变量定义(本体)→ 再还原函数与调用图(公式链 + 血缘)→ 然后用全量真实数据跑一遍回归测试(验证)→ 通过了才有资格谈分析和推演。

跳过验证直接分析 = 在没读懂代码的情况下改代码。 这是本技能最重要的一条纪律。 用户催"直接给结论"时也不能跳——没验证过的结论,错了没人知道。

五步法

产出 谁来做
1 结构化转换 每个 Sheet 一份 MD:多行表头、合并单元格、真实公式、列画像 excel_ai.py tomd
2 字段本体 跨表统一的字段定义表(含义/类型/计算关系/来源) AI 手写
3 公式链与血缘 分层公式链 + 跨 Sheet 数据流向 AI 手写
4 数据验证 逐行比对「AI 理解」vs「Excel 实际值」,出通过率与不匹配清单 excel_ai.py verify
5 交付 带配色标注的结果表 + 分析报告(分布/异常/What-If) excel_ai.py output / analyze

Step 2/3 是认知工作,必须由你读着 Step 1 的 MD 亲自写,不要试图用脚本自动生成—— 业务含义不在文件里,在列名的言外之意里。Step 1/4/5 是机械工作,交给脚本。

开工第一件事是 todo_write 把这五步列出来(用户的进度面板就是它渲染的), 每完成一步更新状态,同时只保持一项 in_progress。


开工前:三件事

1. 找到脚本

脚本随技能分发,就在 load_skill 返回的 resources_path 下:

<resources_path>/scripts/excel_ai.py

load_skill 返回的那个 resources_path,不要假设当前目录下有 scripts/ (技能装在全局技能目录或项目技能目录里,与用户的工作区不是同一个地方; 一般是 ~/.config/coworker/skills/excel-ai-analyst,Windows 在 %APPDATA%\coworker\skills\ 下, 项目级则在 <工作区>/.coworker/skills/ 下——路径会变,resources_path 不会错。)

先确认它在:run_shellls <resources_path>/scripts,或 python3 <resources_path>/scripts/excel_ai.py --help。 万一确实缺文件(技能被裁剪过),按 references/spec-schema.md 的「附录」现写一份,别硬着头皮手算。

2. 让 python3 能跑

OpenWorker 的命令执行走审批:run_shell 默认每次弹审批卡,除非命令命中用户全局配置里的 allowed_commands 白名单。第一次调用时告诉用户:

想免掉后面每一步的审批,可以在全局配置 ~/.config/coworker/config.toml (Windows:%APPDATA%\coworker\config.toml)里加一行:

allowed_commands = ["python3"]

更保守的企业写法是只放行这一个脚本(白名单按命令词前缀匹配):

allowed_commands = ["python3 /Users/你/.config/coworker/skills/excel-ai-analyst/scripts/excel_ai.py"]

白名单只在用户全局配置里生效;工作区 .coworker/config.toml 里的同名配置要等这个工作区被信任后才追加。

两条会让白名单失效、必然弹审批的写法,能避就避:

  • 命令里带 &&;|><`$(( 或换行——一律强制审批。所以 一条命令只做一件事,不要串联、不要重定向。
  • 文件名带括号(工资表(1).xlsx)也会命中上面这条。必要时先把表复制成不带括号的名字。

Read the full file on GitHub · 280 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 11d ago First seen · 280 lines · 219 tokens per session scan A ebb97c68e606

Subscribe to this mod's changes

excel-ai-analyst is a skill published in the GitHub repository zhanglunet/openworker-zh-localized (2 stars, last pushed 4d ago), licensed MIT. It adds 219 tokens to every session and 5,248 once invoked, about $0.0011 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

chat-complex-documents

Chat with and search your complex documents — ask questions, extract tables and fields, and get answers grounded in the source. Connects the hosted Unstructured Transform MCP server to parse, structure, and enrich PDFs, Word/Excel/PowerPoint, images, scanned files, emails, and 60+ other formats into clean, AI-ready…

vellum-ai/vellum-assistant · 90 tokens

google-apps-script

Build Google Apps Script automation for Sheets and Workspace. Custom menus, triggers (onEdit / time-driven / form submit), dialogs, sidebars, email batches, PDF export, external API. Use whenever the user wants to automate a Google Sheet, build a Sheets menu / sidebar / dialog, hit a Sheets row from email or a…

jezweb/claude-skills · 89 tokens

office-document-editor

Edit existing Office documents in the project space. Use when the user asks to (1) modify a PPT slide's title/content/data, (2) update a Word document's section/paragraph/table, (3) change Excel cell values/formulas/rows/columns, (4) add/remove/reorder slides or pages, (5) fix formatting, update data, or make…

guoliang1114-boop/AriaAI · 114 tokens

google

Google Workspace integration — Gmail, Drive, Calendar, Contacts, Tasks, and Sheets via gogcli.

thewolffish/wolffish-app · 21 tokens

spreadsheet

Read, create, modify, analyze, and convert spreadsheet files (xlsx, csv, tsv).

thewolffish/wolffish-app · 23 tokens

library

A skill for managing WorkBuddy’s built-in library, which stores online documents, web links, data tables, dashboards, web pages, files, and shared spaces. It also supports publishing, collaboration, and file transfers.

crane-in-clear-sky/WorkWit-AI-Agent · 207 tokens