What problem does it solve?
This Skill automates handling of spreadsheet files by reading, cleaning, formatting, and transforming data across common tabular formats (xlsx, xlsm, csv, tsv), enabling quick creation of polished spreadsheets from messy inputs.
Core Features & Use Cases
- Automated cleaning & normalization: detect and fix malformed rows, normalize headers, and standardize data types across columns.
- Format conversion & export: convert between spreadsheet formats (e.g., CSV/TSV to XLSX) and ensure output is a valid spreadsheet file.
- Formula & formatting automation: apply formulas, reformat columns, and generate basic charts or summaries as part of the output.
- Use Case: imagine you have 200 CSV files with inconsistent headers; the xlsx skill can consolidate them into a single, clean Excel workbook with standardized headers and computed fields.
Quick Start
Provide the path to an input spreadsheet (or CSV/TSV) and request the tool to output a cleaned, formatted spreadsheet.