Clean Data Xls
- 1 installs
- 34k repo stars
- Updated August 4, 2026
- anthropics/financial-services
Clean-data-xls is a Claude skill that cleans and standardizes messy spreadsheet data in Excel or standalone .xlsx files.
About
Clean-data-xls cleans messy spreadsheet data by trimming whitespace, fixing inconsistent casing, converting numbers stored as text, standardizing dates, removing duplicates, and flagging mixed-type columns. It runs inside Excel via Office JS or against standalone .xlsx files via Python/openpyxl. It prefers auditable helper-column formulas over overwriting values and confirms before any destructive operation.
- Cleans messy spreadsheet data: trims whitespace, fixes casing, converts numbers-stored-as-text, standardizes dates, and
- Works inside Excel via Office JS or on standalone .xlsx files via Python/openpyxl
- Prefers auditable helper-column formulas over overwriting values and confirms before destructive edits
Clean Data Xls by the numbers
- 1 all-time installs (skills.sh)
- Ranked #565 of 688 Office & Documents skills by installs in the Skillselion catalog
- Data as of Aug 5, 2026 (Skillselion catalog sync)
clean-data-xls capabilities & compatibility
- Capabilities
- audit xls · accrual schedule
- Works with
- excel
- Use cases
- data analysis
What clean-data-xls says it does
Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns.
Prefer formulas over hardcoded cleaned values
npx skills add https://github.com/anthropics/financial-services --skill clean-data-xlsAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 1 |
|---|---|
| repo stars | ★ 34k |
| Last updated | August 4, 2026 |
| Repository | anthropics/financial-services ↗ |
What it does
Clean and standardize messy spreadsheet data before analysis, keeping transformations auditable.
Who is it for?
Anyone prepping messy spreadsheet data before analysis who wants auditable, formula-based cleaning
Skip if: Auditing formula logic or model integrity; that is audit-xls
When should I use this skill?
When data is messy, inconsistent, or needs prep before analysis
What you get
A profiled, cleaned range with a before/after summary and helper-column formulas, changed in confirmed steps.
- Cleaned range or helper columns
- Issue summary table
- Before/after change summary
By the numbers
- 9-issue detection table (whitespace, casing, number-as-text, dates, duplicates, blanks, mixed types, encoding, errors)
Files
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 viarange.values, write helper-column formulas viarange.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.
A1:F200), use it - Otherwise use the full used range of the active sheet
- Profile each column: detect its dominant type (text / number / date) and identify outliers
Step 2: Detect issues
| 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! |
Step 3: Propose fixes
Show a summary table before changing anything:
| Column | Issue | Count | Proposed Fix |
|---|
Step 4: Apply
- Prefer formulas over hardcoded cleaned values — where the cleaned output can be expressed as a formula (e.g.
=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. - Only overwrite in place with computed values when the user explicitly asks for it, or when no sensible formula equivalent exists (e.g. encoding/mojibake repair)
- For destructive operations (removing duplicates, filling blanks, overwriting originals), confirm with the user first
- After each category of fix (whitespace → casing → number conversion → dates → dedup), show the user a sample of what changed and get confirmation before moving to the next category
- Report a before/after summary of what changed
Related skills
Lark DocGenerate, update, and maintain structured documentation directly inside Lark/Feishu using natural language and agentic workflows.494kLark DriveLet their coding agents read, create, update and search documents stored in Lark (Feishu) Drive directly from prompts.493kLark SheetsConnect Claude, Cursor or other agents directly to Feishu/Lark spreadsheets for live data reads, writes, and structured automation.493kLark WikiGenerate, update, and sync structured knowledge bases inside Lark (Feishu) directly from code, specs, or agent output.493kLark WhiteboardGenerate, edit, and collaborate on visual diagrams and flowcharts directly inside Claude, Cursor or other agents.493kLark SlidesInstantly generate polished, professional slide decks from specs, roadmaps, or meeting notes using Lark/Feishu.493kFAQ
Does it overwrite my data?
It prefers helper-column formulas like =TRIM(A2) and only overwrites in place when you explicitly ask or when no formula equivalent exists.
Can it run outside Excel?
Yes. Inside Excel it uses Office JS; on a standalone .xlsx file it uses Python/openpyxl.