xlsx

Read, edit, clean, and convert .xlsx, .xlsm, .csv, and .tsv spreadsheets via Python scripts.

1|Updated Apr 10, 2026
One-click install
npx skills add https://github.com/Rysnz/OpenHarness --skill xlsx-rysnz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Rysnz/OpenHarness/tree/main/src/crates/core/builtin_skills/xlsx
Command: npx skills add https://github.com/Rysnz/OpenHarness --skill xlsx-rysnz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates comprehensive spreadsheet tasks, enabling users to open, read, edit, fix, format, and clean data across .xlsx, .xlsm, .csv, and .tsv files; it can create new workbooks and convert between tabular formats, delivering a finalized spreadsheet.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets (xlsx/xlsm/csv/tsv), including adding columns, applying formulas, formatting, and charting.
  • Create new spreadsheets from scratch or from data sources, and convert between tabular formats.
  • Use Case: Clean a messy data dump (bad headers, extra columns) and output a clean, well-formatted workbook ready for analysis.

Quick Start

Provide the input spreadsheet and specify the desired operation to return a cleaned, formatted workbook as the deliverable.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning a messy spreadsheet with bad headers and extra columns?

You can automate spreadsheet cleaning by applying Python scripts to restructure headers and remove extra columns, which outputs a finalized, well-formatted workbook ready for analysis.

Can I convert CSV or TSV files into a formatted XLSX workbook?

Yes, you can convert CSV and TSV files into XLSX by triggering conversion scripts that read tabular inputs and produce a new, formatted spreadsheet deliverable.

How do I add columns and compute formulas in an existing XLSX file?

To add columns and compute formulas in XLSX files, the skill applies Python scripts using openpyxl to edit existing workbooks and calculate the requested formulas.

Does this approach support creating charts and formatting in spreadsheet automation?

Yes, spreadsheet automation supports creating charts and applying formatting by executing Python scripts that modify the workbook and deliver the finalized file.

Can I use openpyxl to edit XLSM files and convert them to CSV?

Yes, you can edit XLSM files and convert them to CSV by referencing the file path, which triggers the underlying Python scripts to read, process, and export the tabular data.

What is the best way to generate a new spreadsheet from an existing data dump?

The best way to generate a new spreadsheet from a data dump is to specify the input data and desired operations, which triggers scripts to clean, format, and output a new workbook.