xlsx
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
Author
Category
Document ProcessingInstall
Download and extract to your skills directory
Copy command and send to OpenClaw for auto-install:
xlsx Smart Spreadsheet Processing Skill
Skill Overview
xlsx is an AI skill specialized in handling spreadsheet files, supporting operations for opening, reading, editing, and repairing various spreadsheet formats such as Excel and CSV.
Applicable Scenarios
When you need to organize messy spreadsheet data, xlsx can automatically remove duplicates, fix formatting issues, and standardize data conventions, turning chaotic data into well-organized tables.
When multiple Excel files require the same handling, you can apply format adjustments, add formulas, update data, and other repetitive operations in one go, greatly improving work efficiency.
When you need to convert between different spreadsheet formats or repair corrupted files that cannot be opened, xlsx can handle a variety of formats including xlsx, xlsm, csv, and tsv.
Core Features
Automatically generate and validate Excel formulas to ensure calculation results are accurate, avoiding common errors like #REF!, #DIV/0!, etc. Supports complex financial models and data analysis.
Provides industry-standard data formatting, including color coding for financial models, numeric format conventions, professional font settings, and more, making spreadsheets appear more professional.
Supports conversion between multiple spreadsheet formats, can identify and fix formatting issues within data, and handles data quality problems such as misaligned headers, blank rows, and outliers.
Frequently Asked Questions
Which file formats does the xlsx skill support?
It supports four main spreadsheet formats: .xlsx, .xlsm, .csv, and .tsv. It can read existing files for editing, create new files, or convert between different formats.
Can it handle spreadsheets with large amounts of data and complex formulas?
Yes. The xlsx skill can process large spreadsheet files and ensure all formulas calculate correctly. For professional spreadsheets such as financial models, it follows industry-standard formatting guidelines, including color coding and numeric formats.
How do you ensure processed spreadsheets have no formula errors?
The xlsx skill includes a built-in formula validation mechanism that checks all generated formulas for errors such as #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME?, and ensures zero formula errors at delivery.