Spreadsheets
Use this skill when the input or deliverable is a spreadsheet: .xlsx, .xlsm,
.csv, .tsv, or a table that should become one of those formats.
Workflow
- Identify whether the task is cleaning, analysis, formatting, charting, or
workbook generation.
- Preserve source files. Write a new output workbook unless the user asked for
an in-place edit.
- Use appropriate tools:
- Python
csv or pandas for data cleaning and analysis
openpyxl for XLSX formulas, styles, tables, filters, freeze panes, and
charts- LibreOffice only when conversion or recalculation is needed and available
- Keep raw data separate from summary sheets when that helps auditability.
- Use formulas when the workbook should remain interactive; use fixed values
when the result must be stable and reproducible.
- Verify by loading the workbook, checking sheet names, row/column counts,
formulas, and representative cell values. For CSV/TSV, check delimiters,
quoting, headers, and row widths.
If dependencies are missing, ask before installing packages. Never silently
drop rows, change date/time semantics, or coerce IDs with leading zeroes into
numbers.
1---2name: spreadsheets3description: Create, edit, analyze, clean, or convert spreadsheets including XLSX, CSV, TSV, formulas, charts, and tabular reports.4---56# Spreadsheets78Use this skill when the input or deliverable is a spreadsheet: `.xlsx`, `.xlsm`,9`.csv`, `.tsv`, or a table that should become one of those formats.1011## Workflow12131. Identify whether the task is cleaning, analysis, formatting, charting, or14 workbook generation.152. Preserve source files. Write a new output workbook unless the user asked for16 an in-place edit.173. Use appropriate tools:18 - Python `csv` or `pandas` for data cleaning and analysis19 - `openpyxl` for XLSX formulas, styles, tables, filters, freeze panes, and20 charts21 - LibreOffice only when conversion or recalculation is needed and available224. Keep raw data separate from summary sheets when that helps auditability.235. Use formulas when the workbook should remain interactive; use fixed values24 when the result must be stable and reproducible.256. Verify by loading the workbook, checking sheet names, row/column counts,26 formulas, and representative cell values. For CSV/TSV, check delimiters,27 quoting, headers, and row widths.2829If dependencies are missing, ask before installing packages. Never silently30drop rows, change date/time semantics, or coerce IDs with leading zeroes into31numbers.
xiaomingx