Description
clean-data-xls is an agent skill from the anthropics/financial-services collection for cleaning messy data in a spreadsheet. It works on the active sheet or on a range the user specifies, and it fixes the common problems: trimming stray whitespace, correcting inconsistent capitalization, converting numbers that are stored as text, standardizing dates, removing duplicates, and flagging outliers. Its workflow scopes the work, profiles each column to find its dominant type of text, number or date and the values that do not fit it, and then detects the issues and applies the fixes. Inside Excel it works through Office JavaScript and writes helper columns with formulas such as TRIM, so the original data stays visible, and on a standalone file it uses Python with openpyxl. It is useful for analysts who receive data from several sources and need it consistent before analysis. Cleaning changes data, and removing duplicates or converting values can change the meaning of a column, so the original should be kept and the changes checked against the source before the cleaned data is used. The skill is installed with the skills CLI from the anthropics/financial-services repository. Its skills.sh page showed about 2.0K installs and passing results from three security audits at the time of the scan.…
Highlights
- Trims whitespace and fixes capitalization
- Converts numbers stored as text and standardizes dates
- Removes duplicates and flags outliers
- Helper columns with formulas inside Excel
- Installs with the skills CLI
Ratings & Reviews
No ratings yet
Be the first to rate clean-data-xls.
People also visit
clean-data-xls FAQ
What does it fix?
Whitespace, capitalization, numbers stored as text, date formats, duplicates, and it flags outliers.
Is the original kept?
Inside Excel it adds helper columns, so the original data stays visible. Keep a copy of standalone files before cleaning.
Could cleaning change the data?
Yes, for example removing duplicates or converting values can change a column's meaning, so check the result against the source.
How do I install it?
Run npx skills add https://github.com/anthropics/financial-services --skill clean-data-xls.
What security audits does it have?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best clean-data-xls alternatives?
Popular alternatives to clean-data-xls include data-quality-frameworks, datanalysis-credit-risk and 3-statement-model. See all clean-data-xls alternatives