data-cleaning-for-excel

Files (1)

• SKILL.md

SKILL.md (first lines)

> **Windows 环境**：技能目录为 C:\Users\Willian\.agents\skills\data-cleaning-for-excel，脚本请用绝对路径或先 cd 进技能目录；产物写到当前工作目录。本机没有 LibreOffice（soffice），依赖它做渲染、缩略图、接受修订、公式重算的步骤会失败，其余 Python 操作正常。
# Data Cleaning for Excel

## When to use
Use this immediately after pasting or importing raw data, a CSV export, a copy from another
system, or a table copied out of a document, before you build a pivot table or a formula on
top of it.

## Instructions
1. Identify inconsistent formats within the same column (text numbers next to real numbers, mixed date formats, inconsistent casing).
2. Remove or flag exact duplicate rows, stating the rule used to define a duplicate.
3. Standardize blank cells: distinguish a true zero from a missing value and handle each consistently.
4. Trim stray whitespace and normalize inconsistent category labels that clearly refer to the same thing.
5. Convert text-formatted numbers and dates to their proper Excel types so formulas can use them.
6. Report what was changed, row by row where practical, so the cleaning is auditable.

## Example prompts
- "Use the data-cleaning-for-excel skill on this pasted CSV before I pivot it."
- "Clean up this exported customer list, the dates are in three different formats."

## Output
A cleaned, consistently formatted range, plus a short change log describing what was standardized, removed, or converted.

From Willian8021743/windows-ai-toolkit, MIT.

More from Willian8021743/windows-ai-toolkit