xlsx

Create, clean, and transform spreadsheet data into XLSX files with openpyxl.

651|34|Updated Jan 24, 2026
One-click install
npx skills add https://github.com/XiaoMaColtAI/math-modeling-skill --skill xlsx-xiaomacoltai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/XiaoMaColtAI/math-modeling-skill/tree/main/tools/xlsx
Command: npx skills add https://github.com/XiaoMaColtAI/math-modeling-skill --skill xlsx-xiaomacoltai

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Use this skill to automate the creation, cleaning, formatting, and transformation of spreadsheet files, turning messy tabular data into well-structured XLSX deliverables.

Core Features & Use Cases

  • Open, read, edit, or fix existing .xlsx, .xlsm, .csv, or .tsv files (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data).
  • Create a new spreadsheet from scratch or from other data sources.
  • Convert between tabular formats (CSV/TSV to XLSX) and restructure messy data into clean spreadsheets.

Quick Start

Provide an input spreadsheet and request cleaning, formatting, or formula updates to produce a finalized XLSX deliverable.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert CSV or TSV files into a formatted XLSX spreadsheet?

To convert CSV or TSV files into a formatted XLSX spreadsheet, the skill uses openpyxl to ingest messy tabular data, restructure it, and output a clean, well-structured XLSX deliverable with applied formatting.

How do I clean messy spreadsheet data and add computed formulas in Excel?

You can clean messy spreadsheet data and add computed formulas by applying openpyxl to parse existing files, append new columns, calculate formulas, and format cells, producing an error-free polished XLSX output.

Does openpyxl support creating charts and computing formulas in existing XLSX files?

Yes, openpyxl supports creating charts and computing formulas in existing XLSX files by opening the workbook, updating cell logic, applying visual charting elements, and validating XML structure for error-free deliverables.

What is the best way to automate Excel data cleaning and structural transformation?

The best way to automate Excel data cleaning and structural transformation is scripting the workflow with openpyxl and XML validation tools, ensuring formulas are maintained and the final XLSX structure remains error-free.

Why does my XLSX file break after adding formulas, and how can I validate its structure?

An XLSX file might break after adding formulas due to XML corruption, but you can validate its structure using defusedxml and lxml libraries to ensure structural integrity and error-free formulas in the final deliverable.

Can I create a new spreadsheet from scratch and apply formatting using Python?

Yes, you can create a new spreadsheet from scratch and apply formatting using Python by leveraging openpyxl to build the workbook, define formulas, and generate a polished XLSX file ready for delivery.