Data & Analytics

Clean, dedupe and standardise a messy spreadsheet

Pby Pier S. · runs in Claude · built for Opus 4.x

Fixes inconsistent formats, removes duplicates and standardises columns, then explains every change.

Verified working on 22 June 2026 · 14 days ago.

No “did it work?” reports yet — be the first to say if it worked. Kept separate from popularity, so reliability and hype don’t get confused.

The workflow

Upload the file

Drag in the CSV or Excel file.

Prompt · paste into Claude

Clean this spreadsheet: standardise date and currency formats, fix inconsistent casing, split or merge columns where sensible, and remove duplicate rows. Return the cleaned table plus a short list of every change you made.

AI output can be inaccurate — always check results before relying on them. Workflows are provided by their authors as-is and aren’t professional (medical, legal or financial) advice.

Clean, dedupe and standardise a messy spreadsheet

Build charts and a summary from any spreadsheet