CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

excel2json

把 Excel 工作表转换成 JSON,支持 records、columns、values 三种结构,日期自动转 ISO 字符串。当用户提到 Excel 转 JSON、表格转接口数据、Excel 生成 mock 数据时使用。

Quality

90%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

92%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

An excellent lean, single-purpose skill document: executable import-and-call examples with expected outputs, a complete parameter table, and clearly organized sections that need no external reference files. The only improvement space is trimming the slight redundancy between the tagline, 功能描述, and the two repo-metadata sections.

DimensionReasoningScore

Conciseness

The body is compact and assumes competence — a parameter table with types/defaults, return-type spec, and no explanations of concepts Claude already knows. Minor trimmable redundancy (the tagline "把 Excel 转成程序能直接消费的 JSON" restates 功能描述, and 所属分类/原始函数 are repo metadata) places it at anchor 4 ('efficient; minor instances that could be trimmed') rather than anchor 5.

4 / 5

Actionability

Fully executable guidance: "from skills.excel import excel2json" plus three runnable calls with expected outputs (e.g. "print(rows[0]) # {'商品名': '苹果', '价格': 5.5}"), a complete 6-parameter table with types and defaults, and documented return shapes for each orient. This matches anchor 5's copy-paste-ready, common-cases-covered standard; anchor 4 would require missing key details, which there are none.

5 / 5

Workflow Clarity

This is a simple single-task skill — call one function — and the single action is unambiguous: 调用方式 shows the exact call with arguments and 参数说明 enumerates every option. The operation is non-destructive (reads an Excel file, optionally writes a JSON file), so the destructive/batch validation cap does not apply and the simple-skill exception yields 5.

5 / 5

Progressive Disclosure

The body is ~55 lines with clear section headers and no bundle files exist (no references/, scripts/, or assets/ directories), so everything is appropriately inline — per the rubric's simple-skill note, well-organized sections with no need for external references warrant 5. The "原始函数 contributors/my12yyds/excel2json.py" line is provenance metadata, not a navigation reference.

5 / 5

Total

19

/

20

Passed

Description

83%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description: it names concrete capabilities (three output structures, automatic ISO date conversion) and gives an explicit use-when clause with three natural trigger phrases, answering both 'what' and 'when' clearly. The only gaps are missing file-extension triggers (.xlsx) and a couple of common synonyms, which keep trigger coverage just short of comprehensive.

DimensionReasoningScore

Specificity

States several concrete behaviors — "把 Excel 工作表转换成 JSON", "支持 records、columns、values 三种结构", "日期自动转 ISO 字符串" — matching anchor 4's 'several specific actions; minor gaps in coverage' (null handling and duplicate-column dedup are only stated in the body). It exceeds anchor 3 (only 1-2 actions) but falls short of anchor 5's comprehensive coverage.

4 / 5

Completeness

Explicitly answers both parts: what ("把 Excel 工作表转换成 JSON,支持 records、columns、values 三种结构,日期自动转 ISO 字符串") and when ("当用户提到 Excel 转 JSON、表格转接口数据、Excel 生成 mock 数据时使用") with three concrete trigger phrases — a direct match to anchor 5's example structure, clearly above anchor 4 where the 'when' is less specific.

5 / 5

Trigger Term Quality

The trigger phrases "Excel 转 JSON", "表格转接口数据", and "Excel 生成 mock 数据" are natural phrasings a user would say, giving good keyword coverage per anchor 4. Not anchor 5 because file extensions (.xlsx/.xls) and common synonyms (e.g. 电子表格, 导出) are absent; not anchor 3 because multiple natural variations are present.

4 / 5

Distinctiveness Conflict Risk

Excel-to-JSON conversion is a clear niche with distinct triggers, but "Excel 生成 mock 数据" and "表格转接口数据" could overlap with sibling Excel or mock-data-generation skills — anchor 4's 'mostly distinct; minor overlap risk with closely related skills'. Not anchor 5 (some overlap risk exists), well above anchor 3's generic overlap.

4 / 5

Total

17

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

CoderWanFeng/python-office

Path

skills/excel/excel2json/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.