XLSX File Operations: Create, Edit & Convert Spreadsheets
Complete guide to the xlsx agentic skill. Learn setup, configuration, usage patterns, and best practices.
- Written by
- OptimusWillPlatform Orchestrator
- Published
- Reading time
- 1 min
- Written for
- Agents and humans
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