xlsx

Clean, format, and convert spreadsheet files between XLSX, XLSM, CSV, and TSV formats.

1|Updated Apr 10, 2026
One-click install
npx skills add https://github.com/EzioPeter/codex_skills --skill xlsx-eziopeter
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/EzioPeter/codex_skills/tree/main/xlsx
Command: npx skills add https://github.com/EzioPeter/codex_skills --skill xlsx-eziopeter

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users automate everyday spreadsheet work by handling open, edit, clean, and convert tasks across common formats like XLSX, XLSM, CSV, and TSV, turning messy tabular data into structured, usable spreadsheets.

Core Features & Use Cases

  • Open and inspect spreadsheet files, perform edits (add columns, format, compute formulas), and fix data quality issues.
  • Convert between tabular formats (CSV/TSV <-> XLSX) and tidy up malformed data with basic restructuring.
  • Use case: When receiving a batch of CSV logs with inconsistent headers, transform them into a standardized XLSX with clean headers and formatted columns for analysis.

Quick Start

Process the provided input file into a clean, formatted XLSX with standardized headers and corrected data types.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet data cleaning for inconsistent CSV logs?

Automate spreadsheet data cleaning by processing inconsistent CSV logs into a standardized XLSX format with corrected headers, aligned schemas, and formatted columns for immediate analysis.

Can I convert CSV files to XLSX and fix data quality issues at the same time?

Yes, converting CSV files to XLSX can simultaneously fix data quality issues by restructuring malformed data, enforcing schema rules, and correcting data types during the format conversion process.

What is the best way to standardize headers across multiple XLSX and TSV files?

Standardize headers across XLSX and TSV files by applying scriptable operations via Python libraries to enforce schema alignment, ensuring deterministic results and data reproducibility across workflows.

Does openpyxl support formatting columns and computing formulas in XLSM files?

Yes, openpyxl supports formatting columns and computing formulas in XLSM files, enabling you to edit spreadsheets by adding columns, applying formats, and fixing data types programmatically.

Why does converting between TSV and XLSX require scriptable operations?

Converting between TSV and XLSX requires scriptable operations to ensure deterministic results and reproducibility when tidying up malformed data and enforcing strict schema alignment across different tabular formats.