Finance

Clean data XLS

V1.0

Cleans messy spreadsheet data by fixing spaces, casing, numbers stored as text, dates and duplicates.

WorkotronSecurity audited

skills.workotron.com/clean-data-xls

Give this to your agent

Install the skill "Clean data XLS" from Workotron Skills. Get https://skills.workotron.com/clean-data-xls.zip and extract it into your skills folder. If you cannot unzip, get each file from the links below.

2 file links
  • https://skills.workotron.com/clean-data-xls/files/LICENSE.txt
  • https://skills.workotron.com/clean-data-xls/files/SKILL.md

Make a workflow from this skill in your own Workotron.

Add to my Workotron
0

Workotron2 installs of their skills

By Anthropic

Updated

Apache-2.0

Security audited

Not tested by Workotron

Who is this for?

  • Anyone who works with exports or lists that arrive messy
  • Owners who need data tidy before they analyze it

What it does

  • Profiles each column to find its main data type and the odd values
  • Spots extra spaces, mixed casing, text numbers, mixed date formats, duplicates and garbled text
  • Shows a table of issues, counts and proposed fixes before it changes anything
  • Writes fixes as formulas in a helper column so you can see each change
  • Confirms with you before it removes duplicates or overwrites data, then reports before and after

When to use it

  • When a sheet is messy or inconsistent
  • Before you analyze data, to fix formats and remove duplicates
  • When one column mixes numbers and text

About this skill

by Workotron

It works on a range you name, or on the whole used range of the active sheet. Inside Excel it uses Office JS. On a standalone Excel file it runs Python with openpyxl on your computer.

It keeps your original data and writes cleaned values beside it unless you ask it to overwrite. It shows a sample after each kind of fix and waits for your go.

Supported platforms

On Workotron, it becomes a workflow.

Files in this skill

2 files
  • LICENSE.txt11.4k bytes
  • SKILL.md2.9k bytes

Security audit

Passed

Every file was checked by a model and a scanner, and approved by Workotron.

Versions

1
  • V1.0,

Discussion

0
View all

Accrual schedule

Builds a month-end accrual schedule with the calculation, the support and a draft journal entry for each accrual.

#claude

000

Workotron

Audit XLS

Audits a spreadsheet for formula errors and common mistakes, from a selected range up to a full financial model check.

#claude

000

Workotron

Bill reminder

Tells you which bills in your inbox are due and when. It never pays.

Workotron workflow

000

Workotron

Close management

Plans and tracks your month end close as a day by day checklist, with task order, owners and blockers.

#claude

000

Workotron

Financial statements

Builds an income statement with prior period and budget comparisons and flags the variances that need a look.

#claude

000

Workotron

Forgotten invoices

Finds finished work you never invoiced. It never sends an invoice.

Workotron workflow

000

Workotron

Invoice chaser

Finds unpaid invoices and drafts a reminder to each customer for your yes.

Workotron workflow

000

Workotron

Journal entry

Prepares a journal entry with debits, credits and supporting detail for accruals, depreciation, prepaids, payroll or revenue.

#claude

000

Workotron

Workotron's own workflows, picked for small businesses

  1. Invoice chaser

    Finds unpaid invoices and drafts a reminder to each customer for your yes.

    Workotron workflow

    000

    Workotron

  2. Lead responder

    Answers new leads in your voice and follows up the quiet ones, after your yes.

    Workotron workflow

    000

    Workotron

  3. Morning briefing

    One briefing every morning on your mail, messages, calendar and reminders.

    Workotron workflow

    000

    Workotron

  4. Email manager

    Reads, searches and answers your email in Gmail, iCloud, Outlook or any web mail.

    Workotron workflow

    000

    Workotron

  5. Reviews keeper

    Drafts a reply to each new review of your business and posts the ones you approve.

    Workotron workflow

    000

    Workotron

  6. Meeting preparer

    Before each outside meeting, a one-page note on who they are and what to ask.

    Workotron workflow

    000

    Workotron

  7. Post everywhere

    Turns one piece you wrote into a post for each channel, sent on your yes.

    Workotron workflow

    000

    Workotron

  8. Contract reader

    Reads a contract before you sign it and says which clauses to push back on.

    Workotron workflow

    000

    Workotron

  9. Receipts submitter

    Every day, sends the receipts and invoices in your mail to your accounting software.

    Workotron workflow

    000

    Workotron

  10. AI search check

    Checks whether AI assistants name your business, and what they say about it.

    Workotron workflow

    000

    Workotron

Publish your skills

List them where small business owners look. Free to list.

Share on the web, or from your agent through MCP.

Share a skill
ยฉ 2026 Workotron. All rights reserved.