xlsx

Manipulate and analyze Excel workbooks with Python and LibreOffice.

Updated Mar 17, 2026

Search Tags:#automation #validation #formulas #spreadsheet #xlsx #data-cleaning

Ready to run

npx skills add https://github.com/jaypatrick/skills --skill xlsx-jaypatrick

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the repetitive handling of spreadsheets to reduce manual work, errors, and time spent on routine data tasks.

Core Features & Use Cases

Open, read, edit, and clean Excel workbooks (.xlsx) and related formats (xlsm, csv, tsv).
Apply formulas, format cells, create charts, and convert between tabular formats.
Use case: when you have a messy dataset, automate cleaning, restructuring, and generation of a ready-to-use workbook.

Quick Start

Load a messy spreadsheet and request automatic cleaning, reformatting, and calculation to produce a ready-to-use workbook.

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 for a messy spreadsheet?▼

Automating Excel data cleaning applies openpyxl scripts to restructure and format messy xlsx workbooks, producing a ready-to-use file with validated cell data.

Can I convert between xlsx, csv, and tsv files automatically?▼

Yes, converting between xlsx, csv, and tsv formats is supported by the spreadsheet automation pipeline, which transforms tabular inputs into your desired output format.

How do spreadsheet formulas evaluate without opening Excel?▼

Spreadsheet formulas evaluate using a LibreOffice recalculation pipeline, ensuring formula computation accuracy without requiring manual Excel application interaction.

Does this approach support macros in xlsm files?▼

This approach supports opening and editing xlsm files, but relies on openpyxl for workbook manipulation and LibreOffice for formula recalculation rather than macro execution.

What is the best way to format cells and create charts in an Excel workbook?▼

The best way to format cells and create charts in an Excel workbook is using openpyxl scripts, which apply programmatic cell formatting and chart generation to xlsx files.

Why do my spreadsheet formulas show errors after automated data manipulation?▼

Spreadsheet formula errors after data manipulation often require a recalculation step, which this pipeline handles via LibreOffice to ensure formulas evaluate correctly without manual intervention.