xlsx

Manipulate spreadsheet data in xlsx, xlsm, csv, and tsv files.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Use this skill to rapidly manipulate spreadsheet files (xlsx/xlsm/csv/tsv) — reading, editing, formatting, computing formulas, cleaning messy data, converting between tabular formats, and exporting the result as a spreadsheet file. It triggers when a user references a spreadsheet by name or path and requires the deliverable to be a spreadsheet.

Core Features & Use Cases

  • Open, read, edit, and fix .xlsx, .xlsm, .csv, or .tsv files.
  • Compute formulas, apply formatting, restructure data, and convert between tabular formats.
  • Example use case: clean a messy dataset, add computed columns, and export a polished sheet for sharing.

Quick Start

Open your input spreadsheet, apply the requested edits (add columns, compute formulas, format, and clean data), and export the result as a new .xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet data cleaning and formatting for xlsx files?

Automate spreadsheet data cleaning and formatting by reading .xlsx, .xlsm, .csv, or .tsv inputs, applying restructuring rules, and exporting the result as a single polished spreadsheet file.

Can I compute formulas and convert CSV to xlsx while preserving formatting?

Yes, you can compute formulas and convert CSV to xlsx while applying formatting. The process reads tabular inputs, calculates formulas, and exports a single spreadsheet file preserving the applied formatting.

Does openpyxl support converting between xlsx, xlsm, csv, and tsv formats?

Yes, openpyxl supports converting between xlsx, xlsm, csv, and tsv formats. The skill uses this dependency to open, read, edit, and restructure tabular data before exporting the final result as a spreadsheet file.

What is the best way to fix messy data and add computed columns in a spreadsheet?

The best way to fix messy data and add computed columns is to open the input spreadsheet, apply data cleaning rules, compute new formula-based columns, and export the restructured data as a new .xlsx file.

Are there limitations when exporting spreadsheet files with formulas and formatting?

A key limitation is that exports must produce a single spreadsheet file. The process preserves formulas and formatting during export, but the deliverable is strictly limited to one spreadsheet file per task.