What This Skill Does
Full spreadsheet file operations — open, read, edit, create, and convert .xlsx, .xlsm, .csv, and .tsv files. Handles formulas, formatting, charts, and data cleaning.
When to Use It
- Any task where a spreadsheet file is the primary input or output
- Opening, reading, editing, or fixing existing spreadsheet files
- Creating new spreadsheets from data sources
- Converting between tabular file formats
- Cleaning messy data files into proper spreadsheets
Key Operations
Read & Extract
Parse existing spreadsheets, extract data from specific sheets/ranges, handle merged cells and formulas.Create & Format
Build spreadsheets with proper formatting, formulas, conditional formatting, charts, and multiple sheets.Clean & Transform
Fix malformed rows, misplaced headers, junk data — restructure into clean tabular format.When NOT to Use
- Word documents (use docx skill)
- HTML reports or dashboards
- Google Sheets API integration
- Database pipelines