Verified:GitHub

xlsx

Name: xlsx
Availability: InStock
Author: cgm-free

Automates spreadsheet editing and cleaning for .xlsx, .xlsm, .csv, .tsv using pandas and openpyxl with LibreOffice recalculation.

Updated Mar 16, 2026

Search Tags:#automation #pandas #openpyxl #formulas #excel #xlsx #data-cleaning

Ready to run

npx skills add https://github.com/cgm-free/ai-education-platform --skill xlsx-cgm-free

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cgm-free/ai-education-platform/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/cgm-free/ai-education-platform --skill xlsx-cgm-free

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates repetitive spreadsheet editing and data cleaning, enabling users to open, read, edit, format, and convert across .xlsx, .xlsm, .csv, and .tsv files to produce polished spreadsheet deliverables with fewer manual steps.

Core Features & Use Cases

Open, read, edit, format, and convert spreadsheet files, and create new sheets from data sources.
Preserve formulas and cell references while applying deterministic transformations and formatting changes.
Use cases include cleaning messy tabular data, mass-formatting datasets, and converting between CSV and Excel for data pipelines.

Quick Start

Open a sample spreadsheet, apply a simple transformation (e.g., adjust a column's formatting), and save the result.

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 formatting across multiple xlsx files?▼

You can automate spreadsheet data cleaning by applying deterministic transformations across .xlsx, .xlsm, .csv, and .tsv files using pandas and openpyxl. This Skill handles mass-formatting, cleans messy tabular data, and outputs polished spreadsheet deliverables with fewer manual steps.

Can I preserve Excel formulas and cell references when editing spreadsheets programmatically?▼

Yes, you can preserve Excel formulas and cell references while applying deterministic transformations and formatting changes. This Skill uses a LibreOffice-based recalculation workflow to ensure zero formula errors in the output spreadsheets.

What is the best way to convert CSV files to Excel format for data pipelines?▼

The best way to convert CSV files to Excel format is by using automated spreadsheet editing tools that read .csv or .tsv inputs and output formatted .xlsx files. This supports data workflows by converting between formats seamlessly.

Does openpyxl support macro-enabled xlsm files for automated data workflows?▼

Yes, openpyxl supports macro-enabled .xlsm files. This Skill leverages openpyxl alongside pandas to open, read, edit, and format .xlsm files, enabling automated spreadsheet editing for business and research data workflows.

Why do my spreadsheet formulas break after automated format conversions?▼

Spreadsheet formulas often break during format conversions due to improper reference handling. This Skill prevents formula errors by preserving formulas and cell references during transformations and integrating a LibreOffice-based recalculation workflow.

Do I need Python pandas to clean messy tabular data in Excel files?▼

You need Python data tools like pandas and openpyxl to clean messy tabular data in Excel files. This Skill leverages these libraries to perform deterministic data cleaning and formatting on .xlsx, .csv, and .tsv inputs.