Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From financial-analysis
Cleans messy spreadsheet data: trims whitespace, fixes casing, converts numbers-as-text, standardizes dates, removes duplicates, flags mixed-type columns. Works in Excel (Office JS) or on .xlsx files (Python/openpyxl).
npx claudepluginhub anthropics/financial-services --plugin financial-analysisHow this skill is triggered — by the user, by Claude, or both
Slash command
/financial-analysis:clean-data-xlsThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Clean messy data in the active sheet or a specified range.
Cleans CSV/TSV/Excel files: normalizes headers, trims whitespace, removes duplicates, fixes row lengths, validates data using qsv tools.
Edits, creates, cleans, and formats spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with zero formula errors, professional styling, and financial model standards like color coding.
Edits, creates, fixes .xlsx/.csv/.tsv spreadsheets: clean data, add formulas/charts, apply financial formatting standards with zero errors.
Share bugs, ideas, or general feedback.
Clean messy data in the active sheet or a specified range.
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.A1:F200), use it| Issue | What to look for |
|---|---|
| Whitespace | leading/trailing spaces, double spaces |
| Casing | inconsistent casing in categorical columns (usa / USA / Usa) |
| Number-as-text | numeric values stored as text; stray $, ,, % in number cells |
| Dates | mixed formats in the same column (3/8/26, 2026-03-08, March 8 2026) |
| Duplicates | exact-duplicate rows and near-duplicates (case/whitespace differences) |
| Blanks | empty cells in otherwise-populated columns |
| Mixed types | a column that's 98% numbers but has 3 text entries |
| Encoding | mojibake (é, ’), non-printing characters |
| Errors | #REF!, #N/A, #VALUE!, #DIV/0! |
Show a summary table before changing anything:
| Column | Issue | Count | Proposed Fix |
|---|
=TRIM(A2), =VALUE(SUBSTITUTE(B2,"$","")), =UPPER(C2), =DATEVALUE(D2)), write the formula in an adjacent helper column rather than computing the result in Python and overwriting the original. This keeps the transformation transparent and auditable.