xlsx

Open, edit, clean, and convert spreadsheet files into a final deliverable.

1|Updated Mar 10, 2026
One-click install
npx skills add https://github.com/iasiv5/skills --skill xlsx-iasiv5
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/iasiv5/skills/tree/main/xlsx
Command: npx skills add https://github.com/iasiv5/skills --skill xlsx-iasiv5

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles spreadsheet-centric workflows where Excel work is the primary input or output, enabling you to open, read, edit, fix, format, and repackage .xlsx, .xlsm, .csv, and .tsv data into a final spreadsheet deliverable.

Core Features & Use Cases

  • Open, read, edit, clean, and restructure tabular data across Excel and CSV formats.
  • Apply formulas, formatting, and basic data transformations; convert between tabular formats as needed.
  • Trigger when a user references a spreadsheet by name or path and needs deterministic spreadsheet outputs (e.g., cleaned data, reports, or converted files).

Quick Start

Run the spreadsheet automation on a sample file to produce a finalized spreadsheet output.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel data cleaning and formatting across xlsx and csv files?

You can automate spreadsheet data cleaning by opening, editing, and restructuring tabular data across xlsx, xlsm, csv, and tsv formats to produce a finalized spreadsheet deliverable. This process applies formulas and formatting deterministically with reproducible outputs.

Can I convert a csv file to xlsx and apply formulas at the same time?

Yes, you can convert between tabular formats like csv and xlsx while simultaneously applying formulas, formatting, and basic data transformations. The workflow repackages the converted data into a final spreadsheet output.

Does openpyxl support recalculating Excel formulas automatically?

openpyxl handles opening, editing, and formatting xlsx files, while an included LibreOffice-based workflow handles optional formula recalculation. This combination ensures deterministic spreadsheet operations with reproducible outputs.

What is the best way to clean messy spreadsheet data and add computed columns?

The best way to clean messy spreadsheet data is to apply deterministic on-demand operations that open, edit, and restructure the input file. You can add computed columns, apply formulas, and format the data into a finalized spreadsheet.

What are the limitations of using python for spreadsheet automation with xlsm files?

Using python for spreadsheet automation supports opening, editing, and repackaging xlsm files, but complex macro execution is outside the scope of this workflow. It focuses on deterministic data processing, formatting, and optional formula recalculation rather than interactive macro scripting.

Do I need LibreOffice to process tsv files and convert them to xlsx?

You do not need LibreOffice to convert tsv files to xlsx, as openpyxl handles reading and writing tabular formats. LibreOffice is only required if you need optional formula recalculation during the spreadsheet automation process.