xlsx

Automate Excel workbook cleaning, transformation, and formula recalculation with openpyxl.

1.2k|101|Updated May 25, 2025

Search Tags:#automation #openpyxl #excel #xlsx #data-cleaning #workbook

Ready to run

npx skills add https://github.com/ZHangZHengEric/Sage --skill xlsx-zhangzhengeric

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ZHangZHengEric/Sage/tree/main/app/skills/xlsx
Command: npx skills add https://github.com/ZHangZHengEric/Sage --skill xlsx-zhangzhengeric

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates repetitive Excel workbook tasks, helping users clean, transform, format, and analyze data across .xlsx and related formats while reducing manual effort and errors.

Core Features & Use Cases

Automates data cleaning and restructuring in spreadsheets (e.g., header normalization, removing duplicates, formatting).
Applies formulas, generates basic analyses, and exports or converts workbooks to common formats (CSV, TSV).
Use Case: When you receive a collection of messy Excel files, the skill can standardize headers, compute key metrics, and deliver a clean workbook ready for reporting.

Quick Start

Run the Excel automation workflow on a sample workbook to see automated cleaning, formula application, and export results.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel data cleaning and workbook formatting in Python?▼

Automate Excel data cleaning and workbook formatting in Python by using openpyxl to standardize headers, remove duplicates, and restructure spreadsheets deterministically. This Python-based approach reduces manual effort and errors.

Can I recalculate and apply formulas to xlsx files without opening Excel?▼

Yes, you can recalculate and apply formulas to xlsx files without opening Excel by running the included recalc.py script with LibreOffice, ensuring formula outputs are deterministic and up to date.

Does openpyxl support converting Excel workbooks to CSV or TSV formats?▼

Yes, openpyxl combined with pandas supports converting Excel workbooks to CSV or TSV formats. The Skill exports and converts xlsx and xlsm spreadsheets to these common formats for downstream analytics.

What is the best way to normalize headers and remove duplicates in messy spreadsheets?▼

The best way to normalize headers and remove duplicates in messy spreadsheets is to apply automated Python workbook manipulation, standardizing data structures and formatting for clean reporting outputs.

Do I need LibreOffice installed to recalculate formulas in my Excel automation workflow?▼

Yes, you need LibreOffice installed to recalculate formulas in your Excel automation workflow, as the Skill's recalc.py script relies on it to perform deterministic formula recalculation on workbooks.

Can I automate xlsm file processing and data validation for finance reporting workflows?▼

Yes, you can automate xlsm file processing and data validation for finance reporting workflows. The Skill applies Python-based workbook manipulation to clean, validate, and transform spreadsheet data.