xlsx

Clean and convert spreadsheet data across XLSX, CSV, and TSV formats.

Updated Apr 4, 2026
One-click install
npx skills add https://github.com/kim1024/agent-skills --skill xlsx-kim1024
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kim1024/agent-skills/tree/main/skills/skills/xlsx
Command: npx skills add https://github.com/kim1024/agent-skills --skill xlsx-kim1024

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates cleaning, formatting, and transforming spreadsheet data across Excel, CSV, TSV, and similar tabular formats, reducing manual cleanup time and minimizing errors.

Core Features & Use Cases

  • Open, read, edit, or fix existing spreadsheets (.xlsx, .xlsm, .csv, .tsv) and convert between formats.
  • Create new spreadsheets from raw data sources and apply consistent formatting, formulas, and basic analytics.
  • Use cases include data cleaning (header alignment, removing junk rows) and converting messy data into polished spreadsheets for reporting.

Quick Start

Load a messy CSV file and have this skill convert, clean, and save it as a polished .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 cleaning and converting messy CSV files into formatted XLSX spreadsheets?

Automating CSV to XLSX conversion involves loading your messy CSV file to apply header alignment, remove junk rows, normalize data types, and export a polished spreadsheet with consistent formatting and formulas.

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

The best way to convert between XLSX, CSV, and TSV formats is to use a deterministic process that opens tabular inputs, applies type normalization and validation steps, and saves the data in your desired consistent spreadsheet format.

Can I use openpyxl to fix misaligned headers and apply formulas to existing Excel spreadsheets?

Yes, using openpyxl with this skill allows you to open, read, edit, or fix existing .xlsx and .xlsm spreadsheets by aligning headers, applying explicit formulas, and enforcing type normalization for accurate reporting.

Does automated spreadsheet data cleaning handle type normalization and error handling reproducibly?

Automated spreadsheet data cleaning ensures reproducible type normalization and deterministic error handling by applying explicit validation steps and formulas during the data preparation workflow.

How do I create a new formatted Excel spreadsheet from raw data sources for reporting workflows?

To create a formatted Excel spreadsheet from raw data sources, you load the raw data into the workflow to apply consistent formatting, basic analytics, and formulas, resulting in a polished .xlsx file ready for reporting.