XLSX Creation, Editing, And Validation

Use this skill when the deliverable is an .xlsx, .xlsm, .csv, or .tsv file, or when an existing spreadsheet file must be read, fixed, edited, formatted, charted, cleaned, converted, or validated.

Do not use it when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration.

Required Inputs

Ask for or infer:

• Source file or source data, including sheet names and expected output path.
• Desired deliverable: new workbook, edited workbook, cleaned table, model, chart, template update, or format conversion.
• Required sheets, columns, formulas, charts, filters, pivots, tables, styling, and accessibility needs.
• Existing template conventions that must be preserved.
• Calculation expectations, formula dependencies, assumptions, and validation criteria.
• Whether formulas must remain live and recalculable.

Do not invent source data, validation output, financial assumptions, or formula results.