---
title: "Clean Data - Air Market"
description: "Someone sent you a sheet where the dates are in three formats, the numbers will not add up because they are text, and half the names are capitalised differently. This tidies all of that: whitespace,…"
canonical: "https://airmarket.ai/app/clean-data-xls"
---

[Air Market](/) / [Data & Analytics](/category/data) / Clean Data

Skill by [Anthropic](/@anthropics)

# Clean Data

Make a messy sheet usable before you try to analyse it

## What this does

Someone sent you a sheet where the dates are in three formats, the numbers will not add up because they are text, and half the names are capitalised differently. This tidies all of that: whitespace, casing, number types, dates, duplicates. It also flags columns that hold more than one kind of value.

### Top 3 things it does for you

- Clean up a messy spreadsheet
- Fix numbers that are stored as text
- Standardise dates and inconsistent casing

## Information

**Clean Data at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Anthropic](/@anthropics) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Size | 3 KB |
| Licence | Apache-2.0 |
| Repository | [anthropics/financial-services](https://github.com/anthropics/financial-services/tree/bb4a2b3e53cf27f8900b33ed6a2d95ed32e57f1d/plugins/vertical-plugins/financial-analysis/skills/clean-data-xls) |
| GitHub stars | 34,484 (as of Nov 2026) |
| Installs | 2,158, counted by skills.sh (Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of Clean Data and flagged nothing. AIR's verdict: **safe**.

**What Clean Data's check was run against**

|  |  |
| --- | --- |
| Commit | bb4a2b3e53cf27f8900b33ed6a2d95ed32e57f1d |
| Content hash | 1b9647292edf9743b8a876a0c29b30e30e29e6b98b4bc25bdd57bceeeeb4b413 |
| Files read | [Browse the files at this exact commit](https://github.com/anthropics/financial-services/blob/bb4a2b3e53cf27f8900b33ed6a2d95ed32e57f1d/plugins/vertical-plugins/financial-analysis/skills/clean-data-xls/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for Clean Data](/security/clean-data-xls)

## About Clean Data

This cleans up messy spreadsheet data. It trims whitespace, fixes inconsistent casing, converts numbers stored as text, standardises dates, removes duplicates, and flags columns holding mixed types.

Use it when data is messy, inconsistent, or needs preparation before analysis.

## What's inside

- SKILL.md - instructions

## Questions

### Is Clean Data safe to install?

AIR scanned this exact version of Clean Data and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit bb4a2b3e53cf, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/clean-data-xls.

### How do I install Clean Data?

Open https://airmarket.ai/app/clean-data-xls on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/anthropics/financial-services/tree/bb4a2b3e53cf27f8900b33ed6a2d95ed32e57f1d/plugins/vertical-plugins/financial-analysis/skills/clean-data-xls. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Anthropic](/@anthropics)

---

Canonical URL: <https://airmarket.ai/app/clean-data-xls>