xlsx

Automate spreadsheet preparation, editing, and conversion across .xlsx, .xlsm, .csv, and .tsv formats.

Updated Mar 23, 2026
One-click install
npx skills add https://github.com/binfen1/my-skills --skill xlsx-binfen1
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/binfen1/my-skills/tree/main/claude-code/xlsx
Command: npx skills add https://github.com/binfen1/my-skills --skill xlsx-binfen1

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The xlsx skill automates common spreadsheet file tasks like opening, reading, editing, cleaning, formatting, and converting .xlsx, .xlsm, .csv, and .tsv files, reducing manual data-work.

Core Features & Use Cases

  • Open and inspect spreadsheet files to apply consistent formatting and formulas.
  • Clean messy data by restructuring headers, standardizing columns, and converting between formats (CSV/TSV to XLSX, etc.).
  • Create new spreadsheets from data sources and export to XLSX or CSV while preserving formulas and styles.

Quick Start

Load a messy CSV and save a cleaned Excel workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning and formatting a messy CSV file into an Excel spreadsheet?

Convert CSV to XLSX by opening the source file, restructuring headers, standardizing columns, and applying formulas or styles. This automated cleaning and conversion process outputs a valid, formatted Excel spreadsheet without manual work.

Can I apply Excel formulas and styles to an existing .xlsx file programmatically?

You can programmatically open, edit, and apply Excel formulas and styles to existing .xlsx files. The workflow updates the workbook and exports a valid spreadsheet file with computed formulas and formatting preserved.

Does this spreadsheet automation approach support converting between CSV, TSV, and XLSX formats?

Yes, spreadsheet automation supports converting between CSV, TSV, XLSX, and XLSM formats. It opens, reads, and exports files across these formats, ensuring the final deliverable is always a valid spreadsheet file.

What is the best way to add columns and compute formulas in an Excel workbook automatically?

The best way to add columns and compute Excel formulas is through automated spreadsheet workflows that open, edit, and apply calculations programmatically. This directly applies formulas and styles, exporting a finalized spreadsheet file.

Do I need openpyxl to create new spreadsheets from data sources and export them?

Yes, openpyxl is required as a dependency to create new spreadsheets from data sources and export them. It enables automated application of formulas, styles, and formatting, ensuring exported files are valid XLSX or CSV documents.