XLSX Spreadsheet Toolkit
XiaomiMiMo/MiMo-Code
Builds, edits, cleans, recalculates and reads Excel workbooks and CSV files with openpyxl and pandas, plus LibreOffice for recalculation and PDF export.
Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values…
Install Data Cleanup
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install sgharlow/claude-code-recipes data-cleanup --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/data-cleanup .claude/skills/data-cleanup && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .claude/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanupType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install sgharlow/claude-code-recipes data-cleanup --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/data-cleanup .agents/skills/data-cleanup && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .agents/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install sgharlow/claude-code-recipes data-cleanup --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/data-cleanup .cursor/skills/data-cleanup && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .cursor/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/sgharlow/claude-code-recipes.git --path skills/data-cleanup--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install sgharlow/claude-code-recipes data-cleanup --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/data-cleanup .gemini/skills/data-cleanup && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .gemini/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install sgharlow/claude-code-recipes data-cleanupInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/data-cleanup .github/skills/data-cleanup && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .github/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install sgharlow/claude-code-recipes data-cleanup --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sgharlow/claude-code-recipes.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/data-cleanup .opencode/skills/data-cleanup && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "data-cleanup" agent skill from https://github.com/sgharlow/claude-code-recipes/tree/main/skills/data-cleanup into .opencode/skills/data-cleanup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-cleanup", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
data-cleanup- GitHub stars
- 389
- Token cost
- ~566 tokens
- SKILL.md length
- 269 words
- Files
- 2
- Skills in repo
- 6
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values…
- Works in 5 steps: Get the data (file path or paste) and… → Propose the cleanup plan as a checklist… → Apply the confirmed plan. For anything… → …
- The user says clean this data
- SKILL.md covers Steps and Constraints
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Data Cleanup is an agent skill from sgharlow/claude-code-recipes. Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values handled explicitly. Use when the user says "clean this data", "standardize this CSV", "dedupe this list", or pastes a table with inconsistent formatting.
Its SKILL.md is about 570 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `evals/ambiguity-and-accounting.md`).
It sits in Documents & Office, covering Data cleaning, Excel spreadsheets and CSV and tabular files. The repository describes itself as: 100 field-tested Claude Code recipes for knowledge workers — prompts, steps, and 6 installable graded skills.
When your agent uses it
- The user says clean this data
- Standardize this CSV
- Dedupe this list
- Pastes a table with inconsistent formatting
Example prompts
- “clean this data”
- “standardize this CSV”
- “dedupe this list”
- “/data-cleanup”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- Get the data (file path or paste) and profile it first: row count, columns, detected
- Propose the cleanup plan as a checklist the user confirms: target date format, name
- Apply the confirmed plan. For anything ambiguous (is 02/03/24 Feb 3 or Mar 2? are
- Deliver: the cleaned dataset, plus a transformation log — rows in/out, per-column changes
- Verify: spot-check that no value changed meaning (dates shifted, names merged wrongly);
What it can do on your machine
Read from SKILL.md and the folder at commit 9157c9a. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Data Cleanup loads about 566 tokens when it runs. Until then it costs about 91 tokens; SKILL.md has 269 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 269 words (~566 tokens).
“Standardize messy tabular data without ever silently changing what it says. Every transformation is declared; every ambiguous value is surfaced, not guessed.”
- name
- data-cleanup
Files
SKILL.md and 1 other file in skills/data-cleanup of sgharlow/claude-code-recipes.
- SKILL.md
- evals/ambiguity-and-accounting.md
Open the folder on GitHubat commit 9157c9a
Compare with similar skills
Data Cleanup next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Data Cleanup this skillsgharlow/claude-code-recipes | 389 | — | ~566 | Automated safety check: Pass | Custom licence | |
| XLSX Spreadsheet ToolkitXiaomiMiMo/MiMo-Code | 14k | — | ~2.9k | Automated safety check: Pass | Apache-2.0 | |
| CSV and Excel MergerOneWave-AI/claude-skills | 323 | — | ~1.6k | Automated safety check: Pass | MIT | |
| Excel Spreadsheet Creation and Editinganthropics/skills | 180k | 4 repos | ~2.1k | Automated safety check: Pass | Proprietary | |
| Sn Da Image CaptionMichaelYang-lyx/AIDABench | 111 | 1 repos | ~2k | Automated safety check: Pass | None | |
| Sn Da Excel WorkflowMichaelYang-lyx/AIDABench | 111 | 1 repos | ~2.5k | Automated safety check: Pass | None |
Similar skills
CSV and Excel Merger
OneWave-AI/claude-skills
Combines CSV, TSV and Excel files into one verified table with pandas, by stacking or joining, mapping columns, normalizing keys and removing duplicates.
- Official
Excel Spreadsheet Creation and Editing
anthropics/skills
Creates, edits and analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with openpyxl and pandas, writing live formulas and recalculating to confirm zero formula errors.
Sn Da Image Caption
MichaelYang-lyx/AIDABench
图片理解与数据提取 skill。当图片文件（.png/.jpg/.jpeg/.gif/.webp/.bmp）是主要输入且用户需要理解、提取数据或分析图片内容时使用。提供预配置的 caption 脚本（scripts/caption.py），通过 vision 模型将图片转为文本描述，无需额外配置 API Key。覆盖：(1) 通过 scripts/caption.py…
Sn Da Excel Workflow
MichaelYang-lyx/AIDABench
Excel 数据分析多步编排器。覆盖：(1) 读取多 Sheet Excel 文件并统计行数，(2) 大文件检测（≥10k 行自动 Parquet 优化），(3) 数据清洗（缺失值、文本标准化、无效字符），(4) 条件筛选与分类提取，(5) 跨 Sheet 统计聚合，(6) 导出 Excel/CSV 并提供下载链接。覆盖从数据读取到报告生成全流程，按步骤编排 capability 子…
Tabular Cleanup
gaasher/Agent-Loop-Skills
A skill your agent uses when the user has a messy tabular data dump (CSV/TSV/parquet/Excel/JSON) and wants it iteratively cleaned to an inferred data contract — a checklist of deterministic…
More from sgharlow/claude-code-recipes
Meeting Notes To Actions
sgharlow/claude-code-recipes
Turn raw meeting notes into a shareable summary, an action-item table with owners and deadlines, and follow-up email drafts.
Qc Checklist
sgharlow/claude-code-recipes
Turn a process description into an operational quality-control checklist — binary pass/fail checks, acceptance criteria, critical-vs-routine tiers, and failure modes with catch-points.
Research Synthesis
sgharlow/claude-code-recipes
Synthesize multiple sources — articles, reports, notes, transcripts — into one structured brief with themes, agreements, contradictions, and gaps.
Summarize Document
sgharlow/claude-code-recipes
Summarize a long document into an executive summary, key points, and role-specific implications.
Weekly Status Report
sgharlow/claude-code-recipes
Turn scattered weekly updates (notes, emails, task exports, meeting notes) into a structured status report with highlights, progress, severity-rated blockers, and next-week priorities.
Related
Categories
Questions about Data Cleanup
What does Data Cleanup do?
Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values…. Data Cleanup is an agent skill from sgharlow/claude-code-recipes. Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values handled explicitly.
When should I use Data Cleanup?
Data Cleanup fits situations like: the user says clean this data; standardize this CSV; dedupe this list; pastes a table with inconsistent formatting.
How do I install Data Cleanup in Claude Code?
Run `npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a claude-code`. Or copy the skill folder (skills/data-cleanup in sgharlow/claude-code-recipes) into .claude/skills/data-cleanup in your project. Claude Code loads it when a task matches its description.
How do I install Data Cleanup in Codex?
Run `npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a codex`. Or copy the skill folder (skills/data-cleanup in sgharlow/claude-code-recipes) into .agents/skills/data-cleanup in your project. Codex loads it when a task matches its description.
Can I use Data Cleanup in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add sgharlow/claude-code-recipes --skill data-cleanup -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/data-cleanup, .gemini/skills/data-cleanup, .github/skills/data-cleanup and .opencode/skills/data-cleanup in your project.
What does Data Cleanup need to run?
SKILL.md names no scripts, command-line tools or credentials: Data Cleanup is instructions for the agent only.
Does Data Cleanup access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Data Cleanup safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Data Cleanup use?
Data Cleanup has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does Data Cleanup use?
About 566 tokens (SKILL.md is roughly 2.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Data Cleanup?
Skills that share tags, products or a category with Data Cleanup: XLSX Spreadsheet Toolkit (XiaomiMiMo/MiMo-Code, 14k stars), CSV and Excel Merger (OneWave-AI/claude-skills, 323 stars), Excel Spreadsheet Creation and Editing (anthropics/skills, 180k stars) and Sn Da Image Caption (MichaelYang-lyx/AIDABench, 111 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Data Cleanup?
sgharlow (a GitHub user) maintains it in sgharlow/claude-code-recipes, which has 389 GitHub stars. The repository holds 6 skills in this directory. The repository was last updated on August 1, 2026.
Source: sgharlow/claude-code-recipes on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.