skills.rest
TMYTiMidlY
TMYTiMidlYCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Process Excel and CSV files to read, edit, validate, and convert tabular data.

1|1|Updated Apr 5, 2026
Search Tags:#openpyxl#spreadsheet#excel#libreoffice#data-cleaning#formula-validation#tabular-conversion
One-click install
npx skills add https://github.com/TMYTiMidlY/skills --skill xlsx-tmytimidly
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/TMYTiMidlY/skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/TMYTiMidlY/skills --skill xlsx-tmytimidly

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the pain of handling spreadsheet files as the main input or output, ensuring every edit, cleanup, analysis, or conversion stays within Excel formats while preserving templates, formulas, and professional styling.

Core Features & Use Cases

  • Spreadsheet-safe editing: Workbooks, CSVs, XLSMs, and TSVs remain the deliverable while formulas stay dynamic, LibreOffice recalculation scripts run, and Word/HTML/script outputs are avoided.
  • Data hygiene & transformation: Clean messy rows, restructure headers, add columns, and build new .xlsx deliverables from other data sources while honoring existing templates and formatting conventions.
  • Use Case: When a download folder holds a broken budget.xlsx, repair the model, fix references, reformat numbers, and regenerate the file with the correct formulas and professional font palette.

Quick Start

Use the xlsx skill to load the attached workbook and describe the edits you want so the output remains an .xlsx spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix broken formulas in an Excel workbook without losing existing templates?▼

To fix broken formulas in an Excel workbook while keeping templates intact, load the file to validate references, reformat numbers, and run LibreOffice recalculation scripts with error checks before delivering the repaired .xlsx spreadsheet.

What is the best way to clean messy rows and restructure headers in a spreadsheet?▼

Cleaning messy rows and restructuring headers in a spreadsheet involves reading the tabular data, editing malformed rows, adding columns, and enforcing professional font palettes while preserving the original Excel or CSV formatting conventions.

Can I convert CSV or TSV files into a formatted .xlsx workbook?▼

You can convert CSV or TSV files into a formatted .xlsx workbook by building new deliverables from those data sources, ensuring the output remains a spreadsheet with dynamic formulas and professional styling.

Does openpyxl support running LibreOffice recalculation to check for formula errors?▼

Yes, openpyxl supports reading and editing workbooks, and the process runs LibreOffice recalculation scripts with error checks to validate formulas and ensure the final spreadsheet is error-free before delivery.

How do I automate reading and validating tabular data while avoiding Word or HTML outputs?▼

Automate reading and validating tabular data by processing Excel and CSV files directly, ensuring the output remains a spreadsheet deliverable while avoiding Word, HTML, or script outputs throughout the data hygiene workflow.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate
ev3rlitev3rlit

xlsx

Create, edit, and analyze Excel workbooks with preserved formulas via LibreOffice.

Community
Advanced
AgentTeam-TaichuAIAgentTeam-TaichuAI
630

xlsx

Process and validate XLSX workbooks offline using openpyxl.

Community
Advanced
icyzhicyzh
1

xlsx

Create, read, and edit Excel spreadsheets with formulas and formatting.

Community
Advanced