Sample output · 1 of 3
A messy sheet in, a tidy sheet out, and a log of every cell that changed: the spaces off the values, the dates written as days, the numbers written as numbers, the duplicate rows gone, the blanks said out loud. The person names the rules and the locale; the script applies them and says what it did.
The first task in a new project also sets up its computer (about 3 min).
Clean up a messy spreadsheet in one go
Try this prompt
Use the Sheet Cleaner skill to tidy our orders sheet: the name has spaces at the edges, the order dates are written three different ways, the amounts are text, and the same customer is on two rows. Read it as en-US, keep the first row per customer, and tell me which cells changed.
Two files for one sheet: cleaned.xlsx, the tidy sheet with the columns the rules asked for, the dates as date columns and the numbers as numbers, and changes.xlsx, a log with one row for every cell that moved — the row it was on, the column, the value before, the value after and the rule that moved it. Plus a page image of the cleaned sheet and a QA report.
| Field | Required | Hint |
|---|---|---|
| path | Yes | The file to clean, at most 200 characters, as a path inside the input directory |
| bytes | Yes | The size of that file in bytes, a whole number; the build refuses a file whose size is not the one stated |
| locale | Yes | The locale the sheet is written in, at most 35 characters: it says how a date reads and how a number is written |
| sheet | No | Which sheet of a workbook to clean, at most 31 characters; a workbook with more than one sheet is refused |
| rules | Yes | The rules to apply, at most 50: trim, dates-iso, number-format, split, merge, dedupe, flag-blanks |
You say
Use the Sheet Cleaner skill to tidy our orders sheet: the name has spaces at the edges, the order dates are written three different ways, the amounts are text, and the same customer is on two rows. Read it as en-US, keep the first row per customer, and tell me which cells changed.
None
Node 20+; Python with openpyxl; Chromium for the preview; no network at run time
None
path (The file to clean, at most 200 characters, as a path inside the input directory), bytes (The size of that file in bytes, a whole number; the build refuses a file whose size is not the one stated), locale (The locale the sheet is written in, at most 35 characters: it says how a date reads and how a number is written), rules (The rules to apply, at most 50: trim, dates-iso, number-format, split, merge, dedupe, flag-blanks)
onlypro, claude-code, codex, cursor