Clean Data Xls

This handles the grunt work of cleaning messy spreadsheets before analysis. It profiles your columns, detects whitespace issues, inconsistent casing, numbers stored as text, mixed date formats, duplicates, and type mismatches, then shows you a summary table of proposed fixes before touching anything. The smart bit is that it writes formulas like TRIM() and VALUE() in helper columns instead of just overwriting your data, so you can see and audit the transformations. It walks through each category of fix and asks for confirmation on destructive operations. Works in Excel via Office JS or on standalone .xlsx files with Python. Good for when you inherit a dataset and need to normalize it without guessing what silent changes got made.

Install to Claude Code

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