skills.rest
Xueheng-Li
Xueheng-LiCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Convert messy tabular inputs into validated Excel workbooks with working formulas.

4|Updated Jan 30, 2026
Search Tags:#pandas#openpyxl#spreadsheet#excel#xlsx#libreoffice#data-cleaning
One-click install
npx skills add https://github.com/Xueheng-Li/ai-tools-installation --skill xlsx-xueheng-li
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Xueheng-Li/ai-tools-installation/tree/main/recommended_skills/xlsx
Command: npx skills add https://github.com/Xueheng-Li/ai-tools-installation --skill xlsx-xueheng-li

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Many workflows rely on tabular inputs or outputs but users frequently hand over malformed CSVs, inconsistent spreadsheets, or Excel files with broken formulas and lost formatting; this Skill produces well-formed .xlsx deliverables that recalculate correctly and preserve templates and styling.

Core Features & Use Cases

  • Automated reading and writing of .xlsx, .xlsm, .csv, and .tsv files with preservation of existing templates and professional fonts.
  • Enforce formula-driven models (avoid hardcoding), add Excel formulas, and guarantee zero formula errors by using the included LibreOffice recalculation script.
  • Data cleaning and restructuring for malformed rows, header recovery, type normalization, and conversion between tabular formats using pandas/openpyxl best practices.
  • Validation and repair workflows that scan for Excel errors, run scripts/recalc.py to recalculate formulas, and provide an error summary for iterative fixes.
  • Use case: convert an exported sales CSV with inconsistent rows into a multi-sheet financial model that uses cell-referenced assumptions, standardized formatting, and validated formulas.

Quick Start

Convert the messy CSV in your downloads into a validated, formula-driven Excel workbook and run the provided recalc script to ensure all formulas evaluate without errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a messy CSV with inconsistent rows into a validated Excel workbook?▼

To convert a messy CSV into a validated Excel workbook, the Skill applies data cleaning and restructuring using pandas and openpyxl, recovering headers and normalizing types to produce a well-formed .xlsx deliverable.

Can I preserve existing Excel templates and styling when writing data with openpyxl?▼

Yes, you can preserve existing Excel templates and professional fonts when writing data. The Skill uses openpyxl to read and write .xlsx and .xlsm files while maintaining the original formatting and template structure.

How do I ensure Excel formulas calculate correctly without hardcoded values?▼

To ensure Excel formulas calculate correctly without hardcoding, the Skill enforces formula-driven model construction and runs a LibreOffice recalculation script to validate that all formulas evaluate with zero errors.

What is the best way to fix broken formulas and Excel errors in my spreadsheets?▼

The best way to fix broken formulas and Excel errors is through the validation and repair workflow, which scans for errors, runs the recalculation script, and provides an error summary for iterative fixes using openpyxl and lxml.

Does this approach support converting tabular data between different formats like CSV and TSV?▼

Yes, this approach supports converting tabular data between formats like CSV and TSV. The Skill reads, cleans, and restructures malformed rows to convert between tabular formats for analysis and reporting.

Why do my exported spreadsheets lose formatting and formula references?▼

Exported spreadsheets lose formatting and formula references due to malformed inputs and broken formulas. This Skill repairs them by applying schema validation, cell-referenced assumptions, and standardized formatting to generate polished workbooks.

Related Skills

Explore More Finance & Accounting Skills→
stabilefrisurstabilefrisur

xlsx

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

Community
Intermediate
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
sergeyitalysergeyitaly
1

xlsx

Create, edit, and analyze Excel files with openpyxl and pandas.

Community
Advanced
InverterNetworkInverterNetwork

excel-author

Generate auditable financial workbooks with openpyxl and strict modeling conventions.

Official
Advanced