xlsx

Open, edit, and convert .xlsx, .xlsm, .csv, and .tsv spreadsheets.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The Skill streamlines spreadsheet workflows by enabling quick opening, editing, formatting, cleaning, and converting across .xlsx, .xlsm, .csv, and .tsv files to accelerate data preparation and reporting.

Core Features & Use Cases

  • Open and inspect spreadsheets across common formats, preserving data integrity.
  • Edit content, apply formulas, format cells, and convert between CSV/TSV and Excel formats for data cleaning and reporting.
  • Use cases include transforming messy CSV into a clean XLSX for analysis, updating formulas across large sheets, and exporting results to CSV for downstream pipelines.

Quick Start

Open a CSV, apply a simple cleanup, and export as XLSX.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a messy CSV file into a clean XLSX spreadsheet for analysis?

To convert a messy CSV into a clean XLSX spreadsheet, you can open the CSV file, apply data cleaning operations to standardize the content, and export the results as an XLSX file to prepare structured data for analysis.

Can I update and recalculate formulas across large spreadsheets automatically?

Yes, you can update and recalculate formulas across large spreadsheets automatically by applying formula updates and leveraging Python tooling like openpyxl for recalculation during the editing process.

Does openpyxl work with both CSV and XLSM file formats for data cleaning?

Yes, openpyxl works with CSV and XLSM file formats for data cleaning. The tooling supports opening, editing, and converting across .xlsx, .xlsm, .csv, and .tsv files while preserving data integrity.

What is the best way to repair and validate a corrupted OOXML spreadsheet structure?

The best way to repair and validate a corrupted OOXML spreadsheet structure is by using Python tooling like defusedxml and lxml, which perform validation, repair, and formula recalculation on the internal OOXML structures.

How do I export spreadsheet results to TSV format for downstream pipelines?

To export spreadsheet results to TSV format for downstream pipelines, open your XLSX or CSV file, apply the necessary formatting and data cleaning, and convert the output directly into a TSV file format.

Are there limitations when converting between Excel and CSV formats?

Limitations when converting between Excel and CSV formats include potential loss of cell formatting and formulas, as CSV and TSV are plain text formats that only support raw data without OOXML structural features.