xlsx

Automate spreadsheet preparation and formatting across Excel-compatible files.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the repetitive, error-prone tasks of working with spreadsheets, enabling you to open, read, edit, or convert data across common formats (.xlsx, .xlsm, .csv, .tsv) with consistent outputs.

Core Features & Use Cases

  • Read, edit, and format existing spreadsheets; create new spreadsheets from data sources; convert between tabular formats; clean and restructure messy data.
  • Use cases include cleaning large CSV exports, updating budgets, and converting data between CSV and Excel formats.
  • Example: convert a messy CSV into a clean XLSX with formulas and formatting.

Quick Start

Process the attached CSV to produce a cleaned 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 automate cleaning and formatting messy CSV exports?

Automate CSV cleaning by processing the file to restructure messy data, apply formulas, and produce a new, formatted spreadsheet file ready for analysis.

Can I convert data between CSV, TSV, and XLSX formats?

Yes, you can convert tabular data between CSV, TSV, and XLSX formats while applying deterministic processing to ensure consistent outputs across Excel-compatible files.

Does this spreadsheet automation approach preserve existing Excel templates?

Yes, this approach preserves existing Excel templates when reading and editing .xlsx or .xlsm files, ensuring your original formatting and structure remain intact during data updates.

What is the best way to apply formulas and pivots to large spreadsheet files?

Apply formulas and pivots to large spreadsheet files by loading the data on demand via a defined script interface, enabling automated calculations and restructuring without manual intervention.

Are there limitations when working with .xlsm files for data cleaning?

When working with .xlsm files, the process focuses on deterministic data cleaning and formatting tasks; complex macro execution or generation is not part of the standard spreadsheet preparation workflow.