skills.rest
kage1020
kage1020COMMUNITY
Explore all skills by this author →
Website𝕏@kage1020GitHub

xlsx

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
One-click install
npx skills add https://github.com/kage1020/dotfiles --skill xlsx-kage1020
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

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

Community
Intermediate
aayushsoamaayushsoam
1

PowerBI Master

Automate Power BI Desktop dashboard creation with Power Query scripting.

Community
Intermediate
crazymsncrazymsn
22

xlsx

Create, edit, format, and convert spreadsheets to .xlsx from CSV or TSV inputs.

Community
Advanced
Serg28Serg28

pandas-pro

Clean, aggregate, and reshape pandas DataFrames with vectorized operations.

Community
Intermediate