
Xlsx
Open, edit, create, and transform spreadsheet files in Excel and CSV formats
What You Can Do
This skill lets you handle spreadsheet files as primary inputs and outputs. You can open and read existing Excel or CSV files, edit them by adding columns, computing formulas, and applying formatting, clean up messy or malformed data into proper spreadsheets, create new spreadsheets from scratch or from other data sources, and convert between tabular file formats. Every output file is delivered error-free and production-ready.
Features
Example Output
Example 1: Data Cleanup Input: Messy CSV with duplicate rows, missing headers, and inconsistent formatting Output: Clean .xlsx file with proper headers, deduplicated data, consistent formatting, and a summary tab showing row counts before/after
Example 2: Financial Model Input: Existing quarterly budget template Output: Updated spreadsheet with new Q4 data, formulas linked to input cells (color-coded blue), calculation cells (black), and a summary dashboard with charts
Example 3: Format Conversion Input: Multiple .csv files from different sources Output: Single consolidated .xlsx workbook with separate sheets for each source, consistent formatting, and a master index sheet
What's Included
- SKILL.md: Complete instructions for triggering and executing spreadsheet tasks
- Formula validation checklist: Step-by-step process to eliminate errors before delivery
- Professional formatting template: Font, color, and style standards for Excel outputs
- Data cleaning workflow: Systematic approach for handling messy or malformed tabular data
- Color coding guide: Industry-standard conventions for financial models and input/output cells
Who It's For
- Data analysts — preparing datasets for analysis and visualization
- Financial professionals — building and maintaining budget, forecast, and valuation models
- Business administrators — organizing and consolidating operational data
- Researchers — cleaning and structuring survey or experimental data
- Operations managers — converting raw reports into actionable spreadsheets
Best For
- Opening and editing Excel files with formulas and formatting intact
- Converting between .xlsx, .csv, and .tsv file formats
- Cleaning messy data with inconsistent formatting, duplicates, or missing headers
- Building financial models with color-coded inputs and calculated outputs
- Creating new spreadsheets from raw data or combining multiple data sources







