Onlypro
Log in
Agent Market
New
Log in
  1. Agent Market
  2. ›Data & Analytics
  3. ›Sheet Cleaner

Sample output · 1 of 3

Data & Analytics
v1.0.2★ Recommended

Sheet Cleaner

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.

1 person used this· · About 1-3 min·Updated Nov 7

The first task in a new project also sets up its computer (about 3 min).

#spreadsheet cleaning#csv#xlsx#excel sheet#duplicate rows#date formats#change log#office documents

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.

What this skill does

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.

How to use

  1. 1Add to agentPick the agent to put it on. If you have one agent, one click adds it.
  2. 2Ask in chatUse 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.
  3. 3Get the resultWhat it makes appears in the agent's Files.

What you get

  • cleaned.xlsx, the cleaned sheet: the columns the rules asked for, dates as day columns, numbers as numbers
  • changes.xlsx, the log of every cell that moved, with its five columns: row, column, before, after, rule
  • A 1240x1754 page image of the cleaned sheet as it reads back
  • A QA report: the log is complete, the formats stuck, no formula survived, the blanks are flagged

What you give

FieldRequiredHint
pathYesThe file to clean, at most 200 characters, as a path inside the input directory
bytesYesThe size of that file in bytes, a whole number; the build refuses a file whose size is not the one stated
localeYesThe locale the sheet is written in, at most 35 characters: it says how a date reads and how a number is written
sheetNoWhich sheet of a workbook to clean, at most 31 characters; a workbook with more than one sheet is refused
rulesYesThe 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.

Sign in to try

Fit

Good fit

  • A sheet that came out of a system or a colleague and has to be read before anybody can work with it
  • Rows that say the same thing twice, where the first one is the one that stays
  • Dates written three different ways, where somebody has to be told which way round they read
  • A tidy sheet somebody else has to sign off, where every change has to be traceable to a rule

Not for

  • Deciding what is wrong with the data: the rules are the person's
  • Reading a workbook with more than one sheet without being told which one
  • A spreadsheet with formulas in it: a cell that was a formula is refused
  • Analysing the numbers: this skill tidies a sheet and writes a log
  • Files over 10 MB or over 50000 data rows: those are refused
  • Sending or publishing the sheet: the two files are the whole deliverable

Requirements

  • Browser rendering
  • Charts & spreadsheets

None

FAQ

Where does it run?

Node 20+; Python with openpyxl; Chromium for the preview; no network at run time

Does it cost anything outside Onlypro?

None

What do I need to give it?

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)

Which agents can use it?

onlypro, claude-code, codex, cursor

Add this skill to your agent and start using it right away.

  • Easy to set upAdd in one click
  • Runs on your agentYour agent follows it step by step
  • Works with your dataUse with your files and tools

Creator

OOnlypro

Related Skills

View all
  • Market ResearchData & Analytics
  • Table to ExcelData & Analytics
  • Chart ReportData & Analytics
  • Bookkeeping SummaryData & Analytics
© 2026 Onlypro
  • Terms
  • Privacy
  • Contact