# clean-data-xls

> Claude/Codex skill by [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars · Updated 2026-08-04

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

```sh
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-xls
```

## From 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.

## Links

- HTML page: https://omgskills.com/skills/anthropics/financial-services-plugins/clean-data-xls/
- GitHub: https://github.com/anthropics/financial-services-plugins
- Author: [@anthropics](https://omgskills.com/library/anthropics/index.md)

## More from this repo

- [bond-futures-basis](https://omgskills.com/skills/anthropics/financial-services-plugins/bond-futures-basis/index.md) — Used to analyze the bond futures basis by pricing futures, identifying the cheapest-to-deliver, and comparing with...
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars
- [comps-analysis](https://omgskills.com/skills/anthropics/financial-services-plugins/comps-analysis/index.md) — Used to build institutional-grade comparable company analyses with operating metrics, valuation multiples, and...
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars
- [dcf-model](https://omgskills.com/skills/anthropics/financial-services-plugins/dcf-model/index.md) — Real DCF (Discounted Cash Flow) model creation for equity valuation.
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars