Clean Data (Spreadsheet) skill
Fix messy spreadsheet data: spaces, casing, numbers stored as text, mixed dates and duplicates.
A Free skill. Sign-in opens soon.
- By
- Anthropic
- Licence
- Apache-2.0
- Installs
- 2K
- Works in
- 17 apps
What Clean Data (Spreadsheet) makes
Clean Data tidies a messy sheet. It finds extra spaces, inconsistent capital letters, numbers stored as text, dates in mixed formats, duplicate rows, blank cells, odd characters and error values like #REF! or #N/A.
It shows you a table of issues and proposed fixes before changing anything. Where it can, it writes the cleaned values as formulas in a helper column so you can see how each value was produced, and it only overwrites originals when you ask. You get a before and after summary.
Best for: Anyone who inherited a messy export and needs it ready for pivot tables or analysis.
- Works inside Excel or on a standalone xlsx file
- Detects whitespace, casing, number-as-text, mixed dates, duplicates, blanks, mixed types, encoding glitches and error values
- Proposes fixes first, then applies them one category at a time with your confirmation
- Prefers formulas like TRIM and VALUE in helper columns over silent overwrites
- Asks before any destructive step such as removing duplicates
Made with this skill
Proposed fixes for a messy class sign-up sheet. Clean up a messy 12-row sign-up spreadsheet for pottery classes: stray spaces, mixed casing, prices typed as text, three date formats and duplicates. Any brands, names or numbers inside are invented examples.
Example prompts
Type something like this once the skill is added. Your app opens the skill when the request matches.
-
Clean up this sheet, it is a mess
-
Normalize the country column, I have USA, usa and Usa
-
Convert the price column to real numbers and fix the dates in column D
-
Remove duplicate customers but show me what you would delete first
What’s inside
2 files in the skill folder, with its Apache-2.0 licence kept inside. Only text instructions and reference files, no program files.
- SKILL.md the instructions
- LICENSE licence
Which apps it works in
A skill is a folder of plain files, so any app that reads the open skills format can use it. Pick your app for its page.
How to add Clean Data (Spreadsheet) to your app
Step by step for each app. We say where to click, so you never need to leave this page.
ChatGPTby OpenAI
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Open the ChatGPT desktop app and look for Skills in the sidebar, where standalone skills are listed.
- 3 Add the “clean-data-xls” folder there if your version offers it. If you do not see Skills yet, use this skill in Claude or Codex instead.
- 4 In a chat, type @ and pick the skill, or just ask. Ask for what you want, for example: “Clean up this sheet, it is a mess”
To make your own, describe the workflow to @skill-creator in ChatGPT Work and it drafts a skill for you.
Claude appby Anthropic
- 1 Download the skill (.zip) with the button at the top of this page.
- 2 In the Claude app, open Settings > Features.
- 3 Upload the .zip file.
- 4 Ask for what you want, for example: “Clean up this sheet, it is a mess”
The current Claude Help Center lists Free, Pro, Max, Team and Enterprise. Organization policy can restrict uploads and sharing. Chat runs code in an isolated environment; uploading a skill does not give it your local project, coding-agent tools or unrestricted network access.
Codexby OpenAI
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.agents/skills - 3 Or paste the install prompt below into Codex and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Codex
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.agents/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .agents/skills inside that project instead.
Claude Codeby Anthropic
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.claude/skills - 3 Or paste the install prompt below into Claude Code and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Claude Code
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.claude/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: claude plugin marketplace add <owner/repo>
Built-in installer: claude plugin install <plugin>@<marketplace>
To use the skill in one project only, put it in .claude/skills inside that project instead.
Cursor
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.cursor/skills - 3 Or paste the install prompt below into Cursor and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Cursor
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.cursor/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .cursor/skills inside that project instead. Cursor also reads ~/.agents/skills, ~/.claude/skills, ~/.codex/skills.
GitHub Copilotby GitHub
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.copilot/skills - 3 Or paste the install prompt below into GitHub Copilot and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into GitHub Copilot
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.copilot/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: gh skill install <owner/repo> <skill> --agent github-copilot --scope user
To use the skill in one project only, put it in .github/skills inside that project instead. GitHub Copilot also reads ~/.agents/skills.
Gemini CLIby Google
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.gemini/skills - 3 Or paste the install prompt below into Gemini CLI and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Gemini CLI
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.gemini/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: gemini skills install <git-url>
To use the skill in one project only, put it in .gemini/skills inside that project instead. Gemini CLI also reads ~/.agents/skills.
Windsurf
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.codeium/windsurf/skills - 3 Or paste the install prompt below into Windsurf and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Windsurf
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.codeium/windsurf/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .windsurf/skills inside that project instead.
Kiro
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.kiro/skills - 3 Or paste the install prompt below into Kiro and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Kiro
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.kiro/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .kiro/skills inside that project instead.
Antigravityby Google
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.gemini/antigravity/skills - 3 Or paste the install prompt below into Antigravity and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Antigravity
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.gemini/antigravity/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .agents/skills inside that project instead.
OpenCode
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.config/opencode/skills - 3 Or paste the install prompt below into OpenCode and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into OpenCode
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.config/opencode/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .opencode/skills inside that project instead. OpenCode also reads ~/.agents/skills, ~/.claude/skills.
Cline
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.agents/skills - 3 Or paste the install prompt below into Cline and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Cline
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.agents/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .agents/skills inside that project instead.
Amp
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.config/agents/skills - 3 Or paste the install prompt below into Amp and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Amp
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.config/agents/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: amp skill add <github-url> --global
To use the skill in one project only, put it in .agents/skills inside that project instead. Amp also reads ~/.agents/skills, ~/.config/amp/skills, ~/.claude/skills.
Gooseby Block
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.agents/skills - 3 Or paste the install prompt below into Goose and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Goose
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.agents/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .agents/skills inside that project instead. Goose also reads ~/.claude/skills.
OpenClaw
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.openclaw/skills - 3 Or paste the install prompt below into OpenClaw and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into OpenClaw
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.openclaw/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: openclaw skills install @owner/<slug>
Built-in installer: openclaw skills install @owner/<slug> --global
Built-in installer: openclaw skills install git:owner/repo@ref
To use the skill in one project only, put it in skills inside that project instead. OpenClaw also reads ~/.agents/skills.
Hermes Agentby Nous Research
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.hermes/skills - 3 Or paste the install prompt below into Hermes Agent and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into Hermes Agent
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.hermes/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
Built-in installer: hermes skills install <owner/repo/skill>
VS Codeby Microsoft
- 1 Download the skill (.zip) with the button at the top of this page, then unzip it.
- 2 Move the “clean-data-xls” folder into your skills folder:
~/.copilot/skills - 3 Or paste the install prompt below into VS Code and let it do the copying.
- 4 Start a new session. Ask for what you want, for example: “Clean up this sheet, it is a mess”
Install prompt: paste this into VS Code
I downloaded the agent skill "Clean Data (Spreadsheet)" as clean-data-xls.zip. Unzip it and copy the clean-data-xls folder into ~/.copilot/skills. Before you finish, list every file it contains, show me any scripts and what they do, and stop if anything asks for passwords, API keys or downloads from other websites.
To use the skill in one project only, put it in .github/skills inside that project instead. VS Code also reads ~/.claude/skills, ~/.agents/skills.
Questions about Clean Data (Spreadsheet)
Will it overwrite my data?
Not by default. It prefers helper columns with formulas, and asks for confirmation before destructive changes.
Can I limit it to a range?
Yes. Give a range such as A1:F200, otherwise it uses the whole used range of the sheet.
What licence is it under?
Apache-2.0, from the repository it comes from.
Is the Clean Data (Spreadsheet) skill free?
Yes. It is a Free skill on Best Agent Skills. Sign-in opens soon; when it does, a free account is all you need to download it.
Who made the Clean Data (Spreadsheet) skill?
Anthropic. We did not write it. Best Agent Skills curates skills like this one, explains them in plain words and shows how to add them to your app. It is shared under the Apache-2.0 licence (Copyright [yyyy] [name of copyright owner]).
