CtrlK
BlogDocsLog inGet started
Tessl Logo

clean-data-xls

Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet", "normalize this data", "fix formatting", "dedupe", "standardize this column", "this data is messy".

75

Quality

92%

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

85%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.

A tight, well-structured skill body that gives executable formulas and API patterns with strong validation checkpoints for destructive data-cleaning operations. The only gaps are a minor explanatory clause and a missing openpyxl code snippet.

Suggestions

Add a short openpyxl code snippet for the standalone .xlsx path (e.g. load workbook, iterate cells, apply cleaning) to match the actionability of the Office JS section.

Trim the justification sentence 'This keeps the transformation transparent and auditable' or fold it into the preceding instruction to tighten conciseness.

Optionally show one filled-in row of the Step 3 propose-fixes table as a concrete example of the expected output format.

DimensionReasoningScore

Conciseness

Mostly lean with bullet lists and no preamble explaining concepts Claude knows, but the justification 'This keeps the transformation transparent and auditable' is a minor instance of over-explanation that could be trimmed.

4 / 5

Actionability

Provides executable Office JS patterns and concrete formulas (=TRIM, =VALUE(SUBSTITUTE...), =DATEVALUE) covering common cases, but the openpyxl path is named without a copy-paste snippet, leaving a minor gap.

4 / 5

Workflow Clarity

Four sequenced steps with explicit validation feedback loops: propose-fixes table before changing, per-category sample-and-confirm checkpoints, destructive-op confirmation, and a before/after summary — fully satisfying the destructive/batch validation requirement.

5 / 5

Progressive Disclosure

Under 50 lines, single-purpose, no external references needed, and well-organized with clear section headers (Environment, Workflow sub-steps), qualifying for the top anchor under the simple-skill exception.

5 / 5

Total

18

/

20

Passed

Description

100%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.

The description is exemplary: concise, action-specific, and explicit about both capabilities and trigger conditions. It avoids fluff and over-claims while covering the data-cleaning niche comprehensively.

DimensionReasoningScore

Specificity

Lists six concrete cleaning actions (trim whitespace, fix casing, convert numbers-stored-as-text, standardize dates, remove duplicates, flag mixed-type columns), matching the comprehensive-coverage anchor.

5 / 5

Completeness

Explicitly answers both what (the six actions) and when ('Use when data is messy...') with concrete trigger phrases, hitting the top anchor.

5 / 5

Trigger Term Quality

Seven natural user phrases including the synonym 'dedupe' and spreadsheet-specific wording like 'clean up this sheet' and 'standardize this column', giving comprehensive natural-term coverage.

5 / 5

Distinctiveness Conflict Risk

Scoped to spreadsheet data cleaning with sheet/column-specific triggers, a clear niche with minimal conflict risk against other skills.

5 / 5

Total

20

/

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.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
anthropics/financial-services
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.