xlsx

Automate spreadsheet processing across XLSX, XLSM, CSV, and TSV files.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the end-to-end handling of spreadsheet tasks to reduce manual editing errors when working with .xlsx, .xlsm, .csv, or .tsv data.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets (xlsx/xlsm), or create new ones from datasets.
  • Compute formulas, apply formatting, and generate charts or convert between tabular formats to support data workflows.
  • Use case: take a messy CSV, clean headers, apply normalization, and export a ready-to-analyze XLSX.

Quick Start

Format the provided spreadsheet and convert it to a clean XLSX ready for analysis.

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 to a clean XLSX format for analysis?

To convert a messy CSV to a clean XLSX, this Skill cleans headers, applies normalization, and exports the dataset as a ready-to-analyze spreadsheet. It automates formatting and cross-format conversion to streamline your data workflows.

Can I use openpyxl to apply formulas and generate charts in existing spreadsheets?

Yes, you can use openpyxl via this Skill to apply formulas and generate charts in existing spreadsheets. It manipulates workbooks to compute formulas, apply formatting, and edit XLSX or XLSM files while maintaining formula integrity.

Does this spreadsheet automation handle XLSM files and recalculate formulas?

This spreadsheet automation handles XLSM files and recalculates formulas using LibreOffice scripts. It ensures formula integrity by validating XML with lxml and defusedxml while manipulating workbook data across XLSX and XLSM formats.

What is the best way to automate data cleaning and column additions across multiple tabular formats?

The best way to automate data cleaning and column additions across tabular formats is using this Skill. It processes XLSX, XLSM, CSV, and TSV files to apply normalization, add columns, and convert between formats efficiently.

Are there limitations when processing XLSX files with openpyxl for formula recalculation?

A limitation when processing XLSX files with openpyxl for formula recalculation is that openpyxl alone does not compute formula results. This Skill overcomes the limitation by using LibreOffice-based scripts to recalculate formulas and ensure accurate values.