xlsx

Convert, clean, and produce spreadsheet files from .xlsx, .xlsm, .csv, or .tsv sources.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/silvio-l/copilot-skills --skill xlsx-silvio-l
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/silvio-l/copilot-skills/tree/main/xlsx
Command: npx skills add https://github.com/silvio-l/copilot-skills --skill xlsx-silvio-l

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

Many tasks require producing or fixing spreadsheet files as the primary deliverable, but users often face messy tabular inputs, broken formulas, inconsistent formatting, or lost templates. This Skill centralizes workflows for opening, reading, editing, cleaning, converting, and producing .xlsx/.xlsm/.csv/.tsv deliverables while enforcing formula-based calculations and professional formatting. It prevents incorrect triggers when the primary deliverable is a document, script, or database pipeline.

Core Features & Use Cases

  • Wide format support: Open, convert, and export .xlsx, .xlsm, .csv, and .tsv files while preserving workbook structure.
  • Data cleaning & restructuring: Fix malformed rows, detect and restore headers, remove junk data, and reshape tables into proper spreadsheets.
  • Formula-first workflows: Insert Excel formulas (not hardcoded values), run LibreOffice recalculation via scripts/recalc.py, and verify ZERO formula errors before delivery.
  • Template preservation & validation: Match existing template styles when updating files and use pack/unpack/validate utilities to ensure Office file integrity.
  • Automation & packaging: Use provided scripts to recalc formulas, unpack/pack Office files, and run schema validators for robust, production-ready outputs.

Quick Start

Open the file at Downloads/sales.csv, clean and normalize the headers and rows, add Excel formulas for totals, then save the result as cleaned-sales.xlsx.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert CSV to XLSX with formulas instead of hardcoded values?

To convert CSV to XLSX with formulas, use a spreadsheet workflow that inserts Excel formulas for calculations and runs LibreOffice recalculation to verify zero formula errors. This ensures professional, error-free deliverables without hardcoding values.

What is the best way to clean malformed rows and fix headers in a spreadsheet?

Cleaning malformed rows and restoring headers involves detecting junk data, normalizing inconsistent entries, and reshaping tables into proper spreadsheets. This data-cleaning process fixes broken structures while preserving the original workbook layout.

Can I use openpyxl to update an Excel template without losing existing formatting?

Yes, you can update an Excel template without losing formatting by using template preservation utilities. These tools match existing styles when updating files and validate Office file integrity through pack and unpack scripts.

Does converting XLSM to XLSX preserve macros and formula recalculation?

Converting XLSM to XLSX preserves workbook structure and supports formula recalculation via LibreOffice. However, XLSX does not support macros, so macro code will be dropped during the conversion while formula integrity remains intact.

Why does my spreadsheet conversion show formula errors after editing?

Spreadsheet formula errors after editing often occur when formulas are hardcoded or not recalculated. Running a LibreOffice recalculation script verifies zero formula errors before delivery, ensuring calculations are correct and dynamic.

When do I need to unpack and validate Office files during spreadsheet processing?

You need to unpack and validate Office files when ensuring robust, production-ready outputs after unpacking or packing operations. Schema validators check Office file integrity to prevent corruption when modifying XLSX or XLSM structures.