xlsx

Read, clean, and rewrite .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

Updated Apr 6, 2026
One-click install
npx skills add https://github.com/duyle10xba1901/train-agent --skill xlsx-duyle10xba1901
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/duyle10xba1901/train-agent/tree/main/xlsx
Command: npx skills add https://github.com/duyle10xba1901/train-agent --skill xlsx-duyle10xba1901

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill ensures every spreadsheet-focused request is handled with spreadsheet-native edits so that opening, cleaning, converting, or fixing a workbook still produces a deliverable Excel file without corrupting existing templates.

Core Features & Use Cases

  • Spreadsheet-first workflow: Trigger whenever the primary input or output is an .xlsx, .xlsm, .csv, or .tsv so the deliverable remains tabular and the workflow honors the user’s referenced file names or paths.
  • Formula discipline: Enforce Excel-native formulas with cell references, no hardcoded math, and document any assumptions beside the hardcode to keep the workbook recalculable.
  • Validation & delivery: Use scripts/recalc.py powered by LibreOffice for recalculation, report zero Excel errors, and preserve existing styles and formatting conventions before handing the workbook back.

Quick Start

Ask the xlsx skill to load the provided sales-data.xlsx, clean the tabular rows, and return the refreshed workbook.

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 rewriting xlsx files without corrupting existing templates?

To clean xlsx files without corruption, the workflow reads the workbook, enforces Excel-native formulas, and rewrites the file while preserving existing styles. It uses LibreOffice recalculation and zero-error validation to guarantee an accurate spreadsheet deliverable.

What is Excel-native formula validation and when do I need it for spreadsheet deliverables?

Excel-native formula validation enforces cell references and prevents hardcoded math, ensuring the workbook remains recalculable. You need it when cleaning or converting spreadsheets to guarantee zero Excel errors in the final deliverable.

Can I use LibreOffice to recalculate Excel formulas in csv or tsv files?

Yes, LibreOffice recalculation supports .xlsx, .xlsm, .csv, and .tsv files. The process triggers whenever the primary input or output is a spreadsheet, running recalculation scripts and validating for zero Excel errors before delivery.

Does openpyxl support converting xlsm files while preserving existing formatting conventions?

Openpyxl handles .xlsm files by reading and rewriting the workbook while preserving existing styles and formatting conventions. The process enforces formula discipline and validates zero Excel errors before handing the recalculated workbook back.

Why does my spreadsheet deliverable show calculation errors after data cleaning?

Calculation errors often occur when formulas use hardcoded math instead of Excel-native cell references. Proper data cleaning enforces formula discipline, uses LibreOffice recalculation, and reports zero Excel errors before returning the workbook.

What is the best way to convert csv files into formatted Excel workbooks?

The best way to convert csv files into formatted Excel workbooks is using a spreadsheet-first workflow that reads the csv, cleans tabular rows, enforces Excel-native formulas, and rewrites an .xlsx deliverable with preserved styles and zero validation errors.