xlsx

Name: xlsx
Availability: InStock
Author: kage1020

Open, read, edit, and convert spreadsheet files across XLSX, XLSM, CSV, and TSV formats.

Updated Mar 15, 2026

Search Tags:#spreadsheet #excel #xlsx #data-transformation #data-cleaning #format-conversion

Ready to run

npx skills add https://github.com/kage1020/dotfiles --skill xlsx-kage1020

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kage1020/dotfiles/tree/main/dot_claude/skills/xlsx
Command: npx skills add https://github.com/kage1020/dotfiles --skill xlsx-kage1020

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies the daily grind of working with spreadsheet files by providing a consistent workflow to open, read, edit, fix, and convert across XLSX, XLSM, CSV, and TSV formats. It helps ensure the deliverable is always a valid spreadsheet and reduces manual formatting overhead.

Core Features & Use Cases

Open, read, and edit Excel-compatible files (.xlsx, .xlsm) and related tabular formats (.csv, .tsv).
Add columns, apply formulas, format cells, clean messy data, and create simple charts.
Convert between common tabular formats (e.g., CSV/TSV to XLSX) or vice versa, preserving data structure.

Quick Start

Process the provided spreadsheet and output a new .xlsx file with the requested edits.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I convert CSV to XLSX without losing data structure?▼

You can convert CSV to XLSX by opening the CSV file and exporting it as an Excel spreadsheet. This Skill reads tabular formats and writes a valid XLSX deliverable while preserving data structure.

How do I clean messy data in an Excel spreadsheet?▼

Cleaning messy data in an Excel spreadsheet involves using Python tools to read and manipulate the file. This Skill applies formulas and formatting to fix disorganized data, outputting a clean XLSX deliverable.

Can I use openpyxl to add columns and create charts in XLSM files?▼

Yes, you can use openpyxl to add columns and create charts in XLSM files. This Skill leverages Python tools to read and edit Excel-compatible spreadsheets, applying formulas and formatting while maintaining data integrity.

What is the best way to edit XLSX and TSV files for data transformation?▼

The best way to edit XLSX and TSV files for data transformation is using a Python-based workflow. This Skill opens, reads, and edits tabular formats to apply changes and produce a valid spreadsheet deliverable.

Does this approach support converting TSV to XLSX format?▼

Yes, this approach supports converting TSV to XLSX format. It handles conversions across XLSX, XLSM, CSV, and TSV, transforming tab-separated files to produce a valid Excel-compatible spreadsheet deliverable.