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".
Install
git clone https://github.com/anthropics/financial-services /tmp/financial-services && ln -s /tmp/financial-services/plugins/vertical-plugins/financial-analysis/skills/clean-data-xls ~/.claude/skills/clean-data-xlsFrom README
Clean Data Clean messy data in the active sheet or a specified range. Environment If running inside Excel (Office Add-in / Office JS): Use Office JS directly (Excel.run(async (context) => {...})). Read via range.values, write helper-column formulas via range.formulas = [["=TRIM(A2)"]]. The in-place vs helper-column decision still applies. If operating on a standalone .xlsx file: Use Python/openpyxl. Workflow Step 1: Scope If a range is given (e.g.
More from this repo
bond-futures-basis
Used to analyze the bond futures basis by pricing futures, identifying the cheapest-to-deliver, and comparing with...
comps-analysis
Used to build institutional-grade comparable company analyses with operating metrics, valuation multiples, and...
dcf-model
Real DCF (Discounted Cash Flow) model creation for equity valuation.