What problem does it solve?
This Skill helps you open, clean, transform, and create spreadsheet files (Excel/CSV/TSV) while ensuring the final workbook stays reliable—especially by preventing and detecting Excel formula errors.
Core Features & Use Cases
- Spreadsheet creation & conversion: Generate new spreadsheets from scratch or convert tabular files (e.g., CSV/TSV) into structured Excel workbooks.
- Spreadsheet editing & restructuring: Fix messy tabular data (malformed rows, misplaced headers, junk rows) and reshape it into a proper workbook layout.
- Formula safety & validation: Enforce the rule of delivering Excel files with ZERO formula errors by recalculating formulas via LibreOffice and scanning for common Excel error types.
Example use case: You receive a messy CSV export with inconsistent columns and wrong header placement; ask for a cleaned, analysis-ready .xlsx with computed totals and charts, and the Skill produces a spreadsheet with recalculated, error-free formulas.
Quick Start
Use the xlsx skill to clean the spreadsheet at path "input.csv" and create a new Excel file "output.xlsx" with correct headers and formulas.