xlsx

Read, modify, and write xlsx, csv, tsv, and xlsm spreadsheets with Python.

15|6|Updated May 7, 2026
One-click install
npx skills add https://github.com/MinhThang1009/dotclaude --skill xlsx-minhthang1009
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MinhThang1009/dotclaude/tree/main/plugins/xlsx/skills/xlsx
Command: npx skills add https://github.com/MinhThang1009/dotclaude --skill xlsx-minhthang1009

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines heavy spreadsheet work by enabling automated handling of input and output files such as .xlsx, .xlsm, .csv, and .tsv. It covers opening, reading, editing, cleaning, formatting, and converting tabular data to produce a finalized spreadsheet deliverable.

Core Features & Use Cases

  • Open, read, edit, and format spreadsheets across common formats (xlsx, csv, tsv, xlsm) and restructure messy data.
  • Apply formulas, create computed columns, generate charts, and convert between tabular formats as part of a data-wrangling workflow.
  • Use Case: Convert a messy CSV into a clean XLSX with standardized headers, computed totals, and consistent formatting ready for sharing.

Quick Start

Convert a dataset to a cleaned, formatted XLSX file.

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 and convert a CSV to a formatted XLSX file?

Automated spreadsheet data cleaning converts a messy CSV to a formatted XLSX file by reading tabular data, standardizing headers, applying computed formulas, and writing the finalized output with consistent formatting.

Does openpyxl preserve existing formulas and templates when modifying an XLSX file?

Yes, openpyxl preserves existing formulas and templates when modifying an XLSX file. The spreadsheet wrangling process reads, modifies, and writes tabular data while maintaining the original template structure and formula logic.

Can I use Python to apply formulas and create computed columns across business datasets?

You can use Python to apply formulas and create computed columns across business datasets by reading input files like XLSX, XLSM, CSV, and TSV, then writing the modified spreadsheet with the new calculated fields included.

What is the best way to convert tabular data between XLSX, CSV, and TSV formats?

The best way to convert tabular data between XLSX, CSV, and TSV formats is through automated data wrangling scripts that read the source file, restructure the underlying data, and write the output directly into the desired target format.

How do I handle spreadsheet formatting and data wrangling for large business datasets?

Handling spreadsheet formatting and data wrangling for large business datasets involves using Python libraries like openpyxl and lxml to programmatically read, clean, format, and write the tabular data into a finalized deliverable.