← Skills
Claude Code skill Free

Data Cleaning Plan Free Claude Code skill, copy & paste

Gives you a step-by-step plan to clean a messy spreadsheet, from duplicates and blanks to inconsistent dates and names.

WHEN TO USE IT

When a spreadsheet is too messy to analyse and you do not know where to start.

Lives in A folder per skill with a SKILL.md inside: .claude/skills/<name>/ or ~/.claude/skills/<name>/.
Checked

Formats change. If a field stops working, check it against Anthropic's documentation.

SKILL.md

One file. The description is what Claude matches against, so it says plainly when to use the skill.

---
name: data-cleaning-plan
description: Plan how to clean a messy dataset, step by step, with checks. Use when the user asks how to clean, tidy or fix a spreadsheet or data file.
---

Write a data cleaning plan.

1. If the column names, a few sample rows or the tool used (Excel, Google Sheets, Python) are missing, ask once, in one message, then continue.
2. List the problems spotted, in a table: Column | Problem | Example | Fix.
3. Order the steps:
   1. Keep an untouched copy of the original.
   2. Remove exact duplicate rows.
   3. Standardise formats: dates, phone numbers, currency, capitals.
   4. Decide what to do with blanks: fill, flag or remove, and say why.
   5. Fix inconsistent categories ("Delhi", "delhi", "New Delhi").
   6. Check numbers for impossible values.
4. For each step, name how to do it in the user's tool, in plain words.
5. End with three checks to confirm the clean data is right, such as row counts before and after.

Rules:
- Never delete data silently; every removal is listed.
- Do not guess missing values as facts; mark them [missing].
Install and use it

Put the folder in your skills directory. Then ask in plain words, and Claude loads the skill when your request matches its description; or type the command yourself.

# for you, in every project
mkdir -p ~/.claude/skills/data-cleaning-plan
mv SKILL.md ~/.claude/skills/data-cleaning-plan/

# then, inside Claude Code, either ask naturally:
#   help me clean this messy customer list
# or run it by name:
#   /data-cleaning-plan

MORE SKILLS

The authority

Anthropic's documentation for Skills

This template is a starting point. Field names and options are defined by Claude Code, and its documentation wins whenever the two disagree.

Read the docs ↗

https://code.claude.com/docs/en/skills

New drops, every week

Free tools & Claude templates, landing regularly.

We keep shipping new free tools, code recipes and Claude Code templates. Follow @freeyantra on Instagram or join the newsletter so you never miss one.

Follow @freeyantra

or get them by email

Double opt-in. Unsubscribe any time. Privacy