xlsx

Read, transform, and export spreadsheets from .xlsx, .xlsm, .csv, and .tsv inputs.

Updated Mar 19, 2026
One-click install
npx skills add https://github.com/stabilefrisur/panmetis --skill xlsx-stabilefrisur
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/stabilefrisur/panmetis/tree/main/src/panmetis/skills/xlsx
Command: npx skills add https://github.com/stabilefrisur/panmetis --skill xlsx-stabilefrisur

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates repetitive spreadsheet tasks, turning manual Excel work into repeatable, reliable workflows by handling common file operations on spreadsheets.

Core Features & Use Cases

  • Read, edit, transform, format, and create new spreadsheets from .xlsx, .xlsm, .csv, or .tsv inputs.
  • Convert between tabular formats and clean messy data (misaligned headers, malformed rows) to produce clean deliverables.
  • Apply formulas, add columns, generate charts, and format outputs to meet downstream requirements.

Quick Start

Process an input spreadsheet to read data, apply a set of transformations, and output a new spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet data processing and transformation?

Yes, converting CSV files to XLSX format is supported by reading the tabular input data, applying any required data cleaning for misaligned headers or malformed rows, and exporting a properly formatted spreadsheet deliverable.

What is the best way to clean messy spreadsheet data with misaligned headers?

Cleaning messy spreadsheet data with misaligned headers is handled by reading the malformed input rows, applying structural transformations to align the data, and exporting a clean spreadsheet file with validated formatting.

Can I add columns and generate charts in an existing XLSX file programmatically?

Adding columns and generating charts in an existing XLSX file is achieved by reading the input spreadsheet, computing formulas and applying formatting transformations, then exporting the updated spreadsheet with the new visualizations.

Does openpyxl support converting XLSM files while preserving macro functionality?

Converting XLSM files is supported as an input format for reading and transforming spreadsheet data; however, the implementation focuses on deterministic data workflows and output validation rather than macro execution or preservation.

What are the limitations of automating spreadsheet tasks with Python scripts?

Limitations of automating spreadsheet tasks with Python scripts include a focus on deterministic data transformations and format conversion, meaning complex native Excel features like embedded objects or dynamic macro execution are outside the scope of this processing logic.