Spreadsheet and CSV Cleanup Report Skill (SKILL.md)

A SKILL.md that has your agent profile a messy CSV or spreadsheet, fix it in a copy with a script, and report every change so the cleaned data can be trusted.

You get: Profile table, change log table and rows needing human review

More like this

Ready to use: no blanks to fill in.

The prompt

Installs to .agents/skills/spreadsheet-and-csv-cleanup-report-skill-skill-md/

mkdir -p .agents/skills/spreadsheet-and-csv-cleanup-report-skill-skill-md && curl -sL "https://prompts-gpt.com/prompts/spreadsheet-and-csv-cleanup-report-skill-skill-md/raw" -o .agents/skills/spreadsheet-and-csv-cleanup-report-skill-skill-md/SKILL.md
SKILL.md
Preview
---
name: spreadsheet-and-csv-cleanup-report-skill-skill-md
description: "A SKILL.md that has your agent profile a messy CSV or spreadsheet, fix it in a copy with a script, and report every change so the cleaned data can be trusted."
---

# Spreadsheet and CSV Cleanup Report Skill (SKILL.md)

A SKILL.md that has your agent profile a messy CSV or spreadsheet, fix it in a copy with a script, and report every change so the cleaned data can be trusted.

## Prompt

```
---
name: csv-cleanup-report
description: Profiles and cleans a CSV or spreadsheet export into a new file, with a report of every change. Use when the user shares a CSV, Excel or Google Sheets export and asks to clean, fix, dedupe, standardise or prepare it for analysis or import.
---

# CSV cleanup report

## Steps
1. Never edit the original. Write all changes to a new file named with a -clean suffix.
2. Profile first: row and column counts, column types, empty values per column, duplicate rows, and unusual values (outliers, mixed formats, stray whitespace, encoding problems).
3. Show the profile and the proposed fixes, then wait for approval. Typical fixes:
   - Trim whitespace and normalise case in category columns.
   - Standardise dates to ISO 8601 and phone numbers to one format.
   - Split or merge columns that hold more than one value.
   - Remove exact duplicates; flag near-duplicates for review instead of deleting them.
   - Convert numbers stored as text, keeping currency and units in a separate column.
4. Do the cleaning with a script (Python with pandas, or the tool the user prefers) saved next to the data, so it can be re-run on next month's export.
5. Recount rows after cleaning and explain any difference.

## Output format
- Profile table: Column, Type, Empty, Distinct, Problems.
- Change log table: Fix, Column, Rows affected, Example before and after.
- Rows needing human review, with the reason.
- Paths to the cleaned file and the script.

## Stop and ask
- A fix would delete rows or overwrite values that cannot be recovered.
- The file contains personal data such as emails or ID numbers; confirm how it may be handled.

## Risks
Silent data loss. The row count before and after must reconcile exactly.
```

## Usage Notes

Save as .claude/skills/csv-cleanup-report/SKILL.md in a repo, or ~/.claude/skills/csv-cleanup-report/SKILL.md for every project. Claude Code loads it when the description matches; the same file works in Codex, Cursor and Gemini CLI, which also read SKILL.md.

Tips and common edits

Save as .claude/skills/csv-cleanup-report/SKILL.md in a repo, or ~/.claude/skills/csv-cleanup-report/SKILL.md for every project. Claude Code loads it when the description matches; the same file works in Codex, Cursor and Gemini CLI, which also read SKILL.md.

Questions about this prompt

Conventional Commit and PR Description Writer Skill (SKILL.md)

A ready-to-save SKILL.md that makes your coding agent write Conventional Commits messages and pull request descriptions from the staged diff, never from guesses.

Meeting Notes to Decisions and Action Items Skill (SKILL.md)

A SKILL.md that turns any meeting transcript or rough notes into a decision log, owner-and-date action items, open questions and a ready-to-send recap email.

Pre-Merge Code Review Checklist Skill (SKILL.md)

A save-ready SKILL.md that has your coding agent review a branch before merge: correctness, security, tests and migrations, with findings ranked by severity and no style nitpicks.

Release Notes From Git Log Skill for Users and Developers (SKILL.md)

A SKILL.md that writes release notes from the commits between two tags, split into a plain-language section for users and a technical changelog for developers.

Test-First Bug Fix Skill: Reproduce, Fix, Prove (SKILL.md)

A SKILL.md that forces your coding agent to reproduce a bug with a failing test before changing code, apply the smallest fix, and prove it with the test suite.

Brand Voice Guard Skill That Checks Drafts Against VOICE.md (SKILL.md)

A SKILL.md that makes Claude write and edit in your brand's voice: it reads a VOICE.md in the project, or builds one from samples, then checks every draft against it.

Write a SKILL.md From a Workflow You Keep Repeating

Interviews you about a task you do over and over, then writes a complete, save-ready SKILL.md with a trigger description, steps, output format and stop conditions.

Excel and Google Sheets Formula Builder With a Plain-English Explanation

Writes the formula for what you want a spreadsheet to do, in both Excel and Google Sheets syntax, explains each part, and gives a test case so you can check it works.

Codex Writes an AGENTS.md for This Repository From the Real Setup

Has Codex inspect your repository and write a short, accurate AGENTS.md with the real build, test and lint commands, conventions and boundaries, checked by actually running them.

4-Week Small Business Launch Plan: $0 and Small-Budget Versions

Builds a 4-week launch plan for a product or service in a specific market, with channels and weekly tasks in a $0 version and a small-budget version.

Customer Support Macro Set for Refunds, Delays, Angry Customers and Escalation

Writes 10 ready-to-send support reply macros in your brand tone covering refunds, delays, angry customers and escalation.

Meeting Notes to Action Items, Owners and a Ready-to-Send Follow-Up Email

Turns raw meeting notes or a transcript into decisions, action items with owners and dates, open questions, and a short follow-up email you can send right after the call.