# Clean data XLS

Cleans messy spreadsheet data by fixing spaces, casing, numbers stored as text, dates and duplicates.

- Kind: a skill for AI agents
- Version: 1.0, updated 2026-11-18
- Shared by: Workotron
- Written by: [Anthropic](https://github.com/anthropics/financial-services/tree/3e32c2287dcb637c184c01cc0ad82d6af7e9bb0f/plugins/vertical-plugins/financial-analysis/skills/clean-data-xls)
- License: Apache-2.0
- Business area: Finance
- Tags: #finance #claude
- Rank: not ranked yet, with 0 copies, 0 thumbs up and 0 thumbs down
- Permanent address: https://skills.workotron.com/clean-data-xls

## Who is this for?

- Anyone who works with exports or lists that arrive messy
- Owners who need data tidy before they analyze it

## What it does

- Profiles each column to find its main data type and the odd values
- Spots extra spaces, mixed casing, text numbers, mixed date formats, duplicates and garbled text
- Shows a table of issues, counts and proposed fixes before it changes anything
- Writes fixes as formulas in a helper column so you can see each change
- Confirms with you before it removes duplicates or overwrites data, then reports before and after

## When to use it

- When a sheet is messy or inconsistent
- Before you analyze data, to fix formats and remove duplicates
- When one column mixes numbers and text

## About this skill

It works on a range you name, or on the whole used range of the active sheet. Inside Excel it uses Office JS. On a standalone Excel file it runs Python with openpyxl on your computer.

It keeps your original data and writes cleaned values beside it unless you ask it to overwrite. It shows a sample after each kind of fix and waits for your go.

## Supported platforms

- Workotron
- Claude Cowork
- Claude Code
- ChatGPT
- Codex

## Install

Get https://skills.workotron.com/clean-data-xls.zip and extract it into your skills folder. If you cannot unzip, get each file:

- https://skills.workotron.com/clean-data-xls/files/LICENSE.txt
- https://skills.workotron.com/clean-data-xls/files/SKILL.md

## Discussion (0)
