What problem does it solve?
Many workflows require extracting, sampling, converting, or editing data stored in local Excel workbooks, which is time-consuming and risks accidental data leaks or processing huge files into the AI context. This skill provides a safe, guided way to inspect spreadsheets, estimate token impact, sample large files, convert sheets to CSV/TSV, and create or edit XLSX outputs while enforcing PII and security checks.
Core Features & Use Cases
- Overview & Analysis: Get file metadata, sheet list, row counts, and estimated token usage to plan efficient processing.
- Extraction & Conversion: Extract full or sampled sheet data as JSON, export sheets to CSV/TSV, and convert CSV into new XLSX files.
- Create & Edit Workflows: Create new workbooks from headers/rows or CSV, edit cells and formulas, and add sheets with formatting and auto column widths.
- Use Case: Sample a large sales workbook, mask PII, convert the target sheet to CSV for downstream analysis, and output the cleaned file to reports/xlsx-output/.
Quick Start
Use the xlsx skill to inspect reports/data.xlsx and return sheet metadata, estimated token count, and a recommended extraction plan.