Solving With AI
Workflowchatgptclaude

Clean a messy spreadsheet in three prompts

Fix dates, split names and remove duplicates without writing formulas.

Ben Carr

Oct 16, 2026

Workflow
1. Upload the CSV and ask: "Describe the columns and any data quality problems you see."
2. Ask: "Fix the problems you listed. Standardise dates as YYYY-MM-DD, split full names into first and last, remove exact duplicates."
3. Ask: "Give me the cleaned file and a short log of every change."
Try it inChatGPT Claude Grok

How to use it

Works best with files under 10,000 rows.

Result

A clean file plus a change log you can share.

Tips and gotchas

Never upload customer personal data. Remove it first.

Comments