Practical task guide
Use an XLSX skill for CSV cleanup, typed cells, formulas and editable Excel delivery. Download a messy CSV and the checked workbook example with missing values preserved.
Decision prompt
Help me clean a messy csv. Ask for missing inputs, choose by output, explain dependencies, and deliver a checked file without inventing results.
Published by OpenAgentSkill. This workflow follows pinned upstream instructions. Inspect the source, prerequisites and deliverable checks before installing. Editorial update: .
Task fit, source instructions, setup and limitations.
Clean data and create editable spreadsheets
Recommended shortlist
Clean data and create editable spreadsheets
Setup: A coding runtime, spreadsheet libraries and a compatible recalculation / inspection path
Check formula results and missing values. A CSV or screenshot is not an editable Excel workbook.
Read pinned SKILL.md ↗How to use this guide
Keep the original CSV and define a record key and explicit cleanup rules.
Normalize numbers and dates, remove only duplicates allowed by the rule, and leave missing values unavailable.
Create a workbook with the cleaned table, review flags and a total for known values.
Reconcile record counts and totals, change an input to check recalculation, and inspect the layout before delivery.
Evaluation notes
An Excel skill should hand you a useful workbook, not only a text explanation. Start with a small CSV cleanup task, preserve the original input and check that formulas respond to edits.
Source review, an editorial example and a successful runtime test answer different questions. Record which one you actually have.
FAQ
The source XLSX skill focuses on spreadsheet files: opening or editing them, cleaning CSV or TSV, creating formulas and formatting, and exporting a workbook. Your runtime still needs the required libraries.
Only when the task explicitly defines that rule. In the example, missing and invalid revenue stays blank with a review flag, and the total covers known values only.
The file-processing task can be adapted to another coding runtime, but inspect that client's skill setup and local libraries first. This release does not establish client-by-client runtime compatibility.
Next guides
Practical task guide
Compare frontend design skills by task: landing pages, product dashboards, Figma implementation, accessibility review and React performance. Explore editable examples.
Practical task guide
Understand official Remotion agent skills, their setup and limitations. Download an original React composition and MP4 example, and follow the render verification steps.
Practical task guide
Choose a PDF skill for Claude Code by task: digital text, tables, scanned-page OCR or markdown conversion. Check dependencies and reconcile the extracted output.
These original editorial fixtures demonstrate the deliverables and checks to ask for. Their production notes identify how they were made; they are separate from upstream Skill instructions.
Known revenue reconciles to $2,650.50. Editing one revenue updates the total; missing values stay unavailable. Workbook structure and both sheet previews are checked.
Produced with a spreadsheet authoring library, not a claimed runtime test of every listed XLSX skill. Native Excel was not executed.