Clean Data Xls

Does the boring but critical work of cleaning spreadsheet data before analysis. Profiles each column to detect whitespace, inconsistent casing, numbers stored as text, mixed date formats, duplicates, and type mismatches. The workflow is thoughtful: it scopes the range, shows you a summary table of issues found, proposes fixes, then applies them incrementally with confirmation at each step. Smart default is to use formulas like TRIM() and VALUE() in helper columns rather than overwriting your originals, which keeps the transformation auditable. Handles both Excel via Office JS and standalone files through Python. Most data cleaning skills just blast through your sheet; this one actually asks permission before destructive operations.

Install to Claude Code

npx -y skills add anthropics/financial-services-plugins --skill clean-data-xls --agent claude-code