skills.rest
polyuiislab
polyuiislabCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Edit and generate .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

1.2k|53|Updated Dec 24, 2025
Search Tags:#pandas#openpyxl#spreadsheet#excel#xlsx#libreoffice#data-cleaning
One-click install
npx skills add https://github.com/polyuiislab/infiAgent --skill xlsx-polyuiislab
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/polyuiislab/infiAgent/tree/main/skills/xlsx
Command: npx skills add https://github.com/polyuiislab/infiAgent --skill xlsx-polyuiislab

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Many workflows require reading, fixing, converting, or generating spreadsheet files while avoiding broken formulas, lost templates, and manual formatting. This Skill centralizes best-practice Excel workflows so users can clean messy tabular data, preserve templates, create dynamic models using formulas, and produce deliverable .xlsx/.xlsm/.csv/.tsv files with zero formula errors.

Core Features & Use Cases

  • Robust file handling: Open, read, edit, and convert .xlsx, .xlsm, .csv, and .tsv files while preserving existing templates and styles.
  • Formula-first workflows: Insert Excel formulas (not hardcoded values), maintain cell references, and validate that no formula errors exist.
  • Data cleaning & restructuring: Repair malformed rows, normalize headers, and transform messy tabular exports into production-ready spreadsheets.
  • Recalculation & verification: Recalculate formulas using the provided LibreOffice-backed scripts/recalc.py and report any Excel error types (e.g., #REF!, #DIV/0!).
  • Use case: Clean a downloads export with misplaced headers, add calculated columns and summary sheets, run the recalculation script to verify, and return a validated .xlsx deliverable.

Quick Start

Use the xlsx skill to clean 'downloads/sales.csv', convert it to a styled .xlsx, add dynamic formulas for totals and growth, run the recalculation script, and return the final workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy CSV exports and convert them to a formatted Excel file?▼

This Skill cleans messy CSV exports by using pandas to repair malformed rows and normalize headers, then converts the data into a styled .xlsx deliverable while preserving existing templates and enforcing formula-first edits.

Can I insert dynamic Excel formulas instead of hardcoded values in an existing spreadsheet?▼

Yes, you can insert dynamic Excel formulas instead of hardcoded values. This Skill uses openpyxl-based modifications to maintain cell references and validate that no formula errors exist in the final spreadsheet.

Does openpyxl support recalculating formulas to check for errors like #REF! or #DIV/0!?▼

While openpyxl handles formula modifications, this Skill uses a LibreOffice-backed recalculation script to verify formulas and report Excel error types like #REF! and #DIV/0!, ensuring zero formula errors in the generated spreadsheet.

What is the best way to restructure tabular data from .tsv inputs into a production-ready spreadsheet?▼

The best way to restructure .tsv inputs into a production-ready spreadsheet is using this Skill to apply pandas data transformations, add calculated columns, and export a validated .xlsx or .xlsm file with preserved styles.

Why do my spreadsheet formulas break when converting between CSV and xlsx formats?▼

Spreadsheet formulas often break during CSV to xlsx conversion due to lost cell references and hardcoded values. This Skill prevents this by using openpyxl to preserve templates and running LibreOffice recalculation to verify zero formula errors.

Related Skills

Explore More Finance & Accounting Skills→
zephyrwang6zephyrwang6
333

xlsx

Create, edit, and analyze spreadsheets in .xlsx, .xlsm, and CSV formats.

Community
Advanced
loganylchenloganylchen

xlsx

Create and edit Excel spreadsheets with formulas and pandas analysis.

Community
Advanced
Phife726Phife726

xlsx

Automate spreadsheet data processing and cleanup for XLSX, CSV, and TSV workbooks.

Community
Intermediate
YHWriteCodeYHWriteCode

xlsx

Create, read, edit, and convert spreadsheet files with formula recalculation.

Community
Advanced