What problem does it solve?
Manual cleanup of messy data across CSV/TSV formats into consistent spreadsheet formats is time-consuming and error-prone. This Skill automates the cleaning, restructuring, and conversion of tabular data into polished spreadsheets ready for analysis or reporting.
Core Features & Use Cases
- Open and normalize data: read .xlsx, .xlsm, .csv, or .tsv inputs and standardize headers, data types, and row structure.
- Data cleaning and formatting: remove junk rows, fix misaligned headers, and apply common formatting rules to improve readability.
- Formula and transformation support: apply deterministic formulas and transformations to generate derived metrics.
- Format conversion: convert between tabular formats (CSV/TSV to Excel and vice versa) while preserving data integrity.
- Use Case: take a messy CSV of sales data, clean headers, compute totals, and export a ready-to-share .xlsx workbook.
Quick Start
Load your input CSV, clean the data (fix headers, remove junk rows), apply a few formulas, and save the result as a new .xlsx.