CSV to XLSX Skill Workflow: Clean Data and Check Formulas
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.
Choose the input and output
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.
- Clean a messy CSV: Trim labels, normalize types, identify exact duplicates and preserve missing or invalid values for review.
- Build an editable analysis: Use typed numeric cells and formulas, then verify calculations and the saved workbook.
Keep evidence with the deliverable
Source review, an editorial example and a successful runtime test answer different questions. Record which one you actually have.
- Keep the supplied input, selected source revision, runtime and output file together.
- Check the saved artifact and record any limitations or failures.
- The examples identify how they were produced; they are not a comparative benchmark.
Steps
- Prepare
Keep the original CSV and define a record key and explicit cleanup rules.
- Choose
Normalize numbers and dates, remove only duplicates allowed by the rule, and leave missing values unavailable.
- Create
Create a workbook with the cleaned table, review flags and a total for known values.
- Verify
Reconcile record counts and totals, change an input to check recalculation, and inspect the layout before delivery.
What does a Claude Excel skill produce?
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.
Should blank or invalid numbers become zero?
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.
Can I use this spreadsheet workflow with Codex?
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.