Clean an inconsistent table
Normalize misplaced headers, malformed rows, and column types while preserving the meaning of the source data and marking ambiguous values.
XLSX by Anthropic
Use XLSX by Anthropic to create, read, clean, or edit spreadsheet files with an agent. Organize source data, preserve an existing workbook’s conventions, and build formulas that respond to changing inputs, then recalculate and check the output before delivering the spreadsheet.
Install and get started
Choose your agent to see how to get started. In Floatboat, copy a request that asks the agent to read the original instructions. Other options show the Skill installation command or the publisher’s native setup steps.
Choose an agent
Start in Floatboat
Copy the request into a Floatboat conversation
Read the original XLSX instructions at https://github.com/anthropics/skills/blob/main/skills/xlsx/SKILL.md. Explain its purpose, required tools, and installation options, then help me use it.Let the agent read the original instructions and check how to use them in your environment.
Download Floatboat ↗Try this request
Clean this sales CSV and create an XLSX summary by month and product. Preserve the source rows, use formulas for totals, document assumptions, and recalculate before delivering the workbook.
About XLSX
XLSX is Anthropic’s document Skill for tasks whose primary input or output is a spreadsheet file. It covers workbook creation and editing, tabular-data cleanup, formulas, formatting, charts, and supported file conversions. The source distinguishes formula text from cached results and requires recalculation when formulas are present, so a file that opens is not the final check. Existing workbook conventions and designated input cells also matter when making changes. Provide the source files, column meanings, calculations, and required output before execution. The environment needs the libraries and recalculation utilities used by the selected workflow. This Skill is source-available under Anthropic’s proprietary document license.
Use Cases for XLSX
Explore tasks where the deliverable needs to remain a usable spreadsheet. Clean a messy table, add formula-driven calculations, or update an established workbook while preserving its input conventions, then verify recalculated values, references, and the structure of the saved file.
Build a formula-driven workbook
Express calculations as spreadsheet formulas so the model can respond to new inputs, with assumptions placed where the reader can inspect them.
Update an established spreadsheet
Follow the workbook’s existing styles and input conventions. Change only the intended area and check that remaining formulas and references still work.
How to Use XLSX
Provide the source workbook or table, explain the column meanings, and define the required calculations. Ask the agent to edit the intended cells or build the requested output, then recalculate formulas, inspect reported errors, and compare representative results with the source before delivery.
- 01
Explain data and calculations
Share files, column definitions, and the required output. Identify designated input cells and calculations that must be preserved.
- 02
Build or edit the workbook
Ask the agent to apply the relevant file workflow. Keep source meaning intact and use formulas where the output must update with inputs.
- 03
Recalculate and verify
Run the source’s recalculation workflow for formulas and fix reported errors. Compare sample values, references, and formatting with the requested result.
Explore More Agent Skills
Read another Skill guide and check its original source before using it.
XLSX FAQ
Can it process CSV or TSV input?
Yes. The documented scope includes tabular input such as CSV and TSV when the task’s primary deliverable is a spreadsheet. State the encoding, delimiter, headers, and output format if they are not clear.
Why are formulas not enough without recalculation?
The source notes that some editing libraries write formulas without cached results. Recalculation produces values for readers and previewers, and its report helps locate formula errors before delivery.
Can it change an existing financial model?
It can assist with the file, but the requested input areas, assumptions, and formulas need to be explicit. Validate calculations against known cases; a technically valid workbook does not establish financial correctness.
Is this a live Google Sheets integration?
No. The source explicitly separates spreadsheet-file deliverables from Google Sheets API integration. A cloud-sheet workflow needs its own access and editing mechanism.
What should be preserved when editing a workbook?
Identify the established input cells, formulas, sheet names, styles, and references before editing. Ask for bounded changes and inspect both modified cells and representative dependent calculations.
Can I freely redistribute the XLSX Skill?
Do not infer that from its public repository. Anthropic provides the document Skill as source-available with a proprietary LICENSE.txt. Follow the official installation guidance and consult the applicable terms for package reuse.