Data Cleaning
Define cleaning rules, then deduplicate and standardise dirty data into a clean table with a line-by-line cleaning log, delivered as an Excel workbook
Install
npx skills add genspark-ai/genoffice --skill data-cleaninggit clone --depth 1 https://github.com/genspark-ai/genoffice.git /tmp/genoffice
mkdir -p ~/.claude/skills
cp -r /tmp/genoffice/skills/recommended/data-cleaning ~/.claude/skills/data-cleaningPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
You are a data-cleaning specialist. The user gives you dirty data (system exports, multi-source merged tables, manually keyed sheets); you deliver a cleaned standard table and a cleaning log that explains every change. ## Workflow 1. Health check first: field meanings, row count, blank rate per column, mixed types (text inside number columns, several date formats), obvious duplicates, inconsistent units and codes, leading / trailing spaces and full-width versus half-width characters. List the findings. 2. Ask about the downstream use (system import / analysis / mailing); the use decides the standard format. When the target system has a field specification, follow it. 3. Set the rules and confirm them: one rule per problem class -- blanks (delete / fill default / keep and flag), dedupe key (which column combination counts as the same record, and which to keep on conflict: newest / most complete / first), date and number formats, text normalisation (case, full/half width, trimming, alias unification such as "Beijing City" and "Beijing"), code mapping tables. Send the rules to the user for confirmation first; anything involving deletion must be confirmed before it runs. 4. Run the cleaning: leave the original data untouched and process by the rules in a new table. Use formulas where possible (TRIM / CLEAN / DATEVALUE / VLOOKUP mappings) so the work can be checked; every modified or deleted record goes into the log.
Details
- Skill name
data-cleaning- Repository
- genspark-ai/genoffice
- Path
skills/recommended/data-cleaning/SKILL.md- License
- Apache-2.0
- Repo updated
- 18 November 2026
FAQ
What does the Data Cleaning skill do?
Define cleaning rules, then deduplicate and standardise dirty data into a clean table with a line-by-line cleaning log, delivered as an Excel workbook
How do I install the Data Cleaning skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add genspark-ai/genoffice --skill data-cleaning. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Data Cleaning popular?
It lives in genspark-ai/genoffice, which has 12,590 GitHub stars and 1,758 forks.
Related skills
Brand Copy
13kgenspark-ai/genoffice
Turn product and audience information into multiple versions of taglines, selling points and brand story, delivered as Markdown
Budget Planner
13kgenspark-ai/genoffice
Turn a business plan into an annual or project budget with account lines, monthly spread, summaries and a separate assumptions sheet, delivered as an Excel workbook
Business Plan
13kgenspark-ai/genoffice
Turn a project idea into a full business plan covering market, product, model, competition, financial projections and team, delivered as a Word document
Executive Deck
13kgenspark-ai/genoffice
Build a reporting or executive presentation where every slide title states a conclusion and the deck follows a pyramid, answer-first structure. Use when the user asks for a management update, board deck, status report, business review or a presentation that argues for a decision, including turning a document into slides.
Data Analyst
13kgenspark-ai/genoffice
Take raw data through cleaning, formulas and charts to plain-language conclusions, delivered as an Excel workbook
Expense Report
13kgenspark-ai/genoffice
Turn a pile of receipts into an expense claim summary that flags missing receipts, over-limit items and duplicates, delivered as an Excel workbook
Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.