xlsx

Open, read, edit, and fix spreadsheet files using openpyxl.

94|11|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/swaruplab/operon --skill xlsx-swaruplab
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/swaruplab/operon/tree/main/src-tauri/protocols/xlsx
Command: npx skills add https://github.com/swaruplab/operon --skill xlsx-swaruplab

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The xlsx skill helps users automate end-to-end spreadsheet tasks, turning manual spreadsheet work into repeatable, reliable processes.

Core Features & Use Cases

  • Open, read, edit, and fix spreadsheet files (.xlsx, .xlsm, .csv, .tsv) and output a ready-to-use spreadsheet.
  • Clean messy tabular data, apply formulas and formatting, and convert between tabular formats for reporting and analytics.
  • Use in real-world scenarios like consolidating monthly sales data, formatting a budget, or generating a formatted report from raw data.

Quick Start

Clean and format the xlsx file in my downloads and export the updated workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and format an xlsx spreadsheet automatically?

You can clean and format an xlsx spreadsheet by automating data processing tasks to fix errors and apply formulas. This approach handles data consolidation, formatting, and format conversions to deliver a ready-to-use workbook.

Does openpyxl work with csv and tsv format conversions?

Yes, openpyxl supports csv and tsv format conversions alongside xlsx and xlsm files. It manipulates workbooks to convert between tabular formats, allowing you to transform raw data into a ready-to-use spreadsheet for reporting.

Can I generate Excel formulas programmatically without errors?

You can generate Excel formulas programmatically using Python tools like openpyxl to manipulate workbook cells directly. This automation ensures zero formula errors in the delivered file while applying necessary formatting and data cleaning.

What is the best way to consolidate monthly sales data in Excel?

The best way to consolidate monthly sales data is to automate spreadsheet tasks end-to-end using Python. This method reads, edits, and fixes workbook files to merge data reliably while preserving existing templates and styles.

Will automating spreadsheet edits preserve my existing templates and styles?

Yes, automating spreadsheet edits preserves your existing templates and styles. The process uses openpyxl for workbook manipulation to ensure that your formatting remains intact while cleaning data and fixing formula errors.