xlsx

Read, edit, and convert Excel and tabular files with Python libraries.

3|Updated Feb 6, 2026
One-click install
npx skills add https://github.com/pinion05/skills --skill xlsx-pinion05
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/pinion05/skills/tree/main/xlsx
Command: npx skills add https://github.com/pinion05/skills --skill xlsx-pinion05

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires defusedxml, lxml, openpyxl.

What problem does it solve?

This Skill streamlines spreadsheet workflows by enabling automated reading, editing, formatting, deriving formulas, and converting between Excel and other tabular formats, reducing manual data handling.

Core Features & Use Cases

  • Import, modify, and export .xlsx/.xlsm files with consistent formatting.
  • Apply formulas, adjust column widths, clean messy data, and convert between CSV, TSV, and Excel formats.
  • Use Case: You have a messy CSV of customer orders; this Skill cleans, enriches, and outputs a clean Excel workbook ready for reporting.

Quick Start

Use the xlsx skill to process an input workbook and save the result to output.xlsx.

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 convert CSV files to xlsx?

Automating Excel data cleaning and converting CSV to xlsx involves reading messy tabular data, applying formatting, adjusting columns, and exporting a ready-to-use workbook using openpyxl. This Skill handles the full workflow automatically to deliver clean spreadsheet outputs.

Can I apply formulas and adjust column widths when editing xlsx files?

Applying formulas and adjusting column widths when editing xlsx files is fully supported. You can import, modify, and export .xlsx or .xlsm files while deriving formulas and ensuring consistent formatting across the workbook.

What is the best way to convert between CSV, TSV, and Excel formats?

The best way to convert between CSV, TSV, and Excel formats is to use a solution that reads the source tabular data, cleans and enriches it, and exports it directly to the target format. This ensures reliable cross-format conversion without manual data handling.

Does openpyxl support reading and writing xlsm files with formatting?

Openpyxl supports reading and writing both .xlsx and .xlsm files with consistent formatting. This Skill relies on openpyxl to manipulate workbooks, apply formulas, and export results while preserving the required spreadsheet structure.

Why does my spreadsheet conversion lose formatting or misalign data?

Spreadsheet conversion loses formatting or misaligns data when manual handling disrupts the tabular structure. Using an automated approach with openpyxl and lxml ensures reliable formatting, data cleaning, and accurate cross-format conversions.