xlsx

Automate spreadsheet operations across xlsx, xlsm, csv, and tsv formats.

Updated Mar 5, 2026
One-click install
npx skills add https://github.com/ThanabordeeN/gemini-productivity-skills --skill xlsx-thanabordeen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ThanabordeeN/gemini-productivity-skills/tree/main/xlsx
Command: npx skills add https://github.com/ThanabordeeN/gemini-productivity-skills --skill xlsx-thanabordeen

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the tedious, error-prone work of working with spreadsheets, handling tasks like cleaning messy data, applying formulas, formatting, charting, and converting between .xlsx, .xlsm, .csv, and .tsv to produce a final, polished spreadsheet.

Core Features & Use Cases

  • Data cleaning and normalization: detect and repair malformed rows, header misalignments, and inconsistent data types for reliable analysis.
  • Formula and chart automation: automatically insert calculations, create charts, and enforce consistent styling across multi-sheet workbooks.
  • File format interoperability: open, transform, and save outputs across .xlsx, .xlsm, .csv, and .tsv formats, delivering a ready-to-use spreadsheet.

Quick Start

Open a workbook, apply cleaning, formatting, and formulas, and save the cleaned result as a new .xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate data cleaning and formula application across multiple spreadsheet formats?

Automating spreadsheet operations involves opening common formats like .xlsx and .csv, applying data normalization, inserting Excel formulas, and saving a polished workbook. This process repairs malformed rows and enforces consistent styling across multiple sheets.

What is the best way to convert CSV files to formatted Excel workbooks with charts?

Converting CSV files to formatted Excel workbooks requires opening the source data, applying structural cleaning, inserting calculations, and generating charts. The output is a production-ready .xlsx file with validated formulas and consistent multi-sheet styling.

Does openpyxl support automated spreadsheet validation to prevent #REF! and #VALUE! errors?

Automated spreadsheet validation uses openpyxl to enforce deterministic outputs via Excel formulas and templates. It validates final spreadsheets to proactively prevent #REF!, #VALUE!, or other formula errors before generating the finished file.

Can I use this Skill to normalize header misalignments and repair inconsistent data types in .xlsm files?

Normalizing header misalignments and repairing inconsistent data types in .xlsm files is fully supported. The process detects and repairs malformed rows to ensure reliable analysis, delivering a cleanly formatted and validated spreadsheet output.

What are the limitations of using Python scripts for Excel formula automation and charting?

Limitations of using Python scripts for Excel formula automation involve relying on deterministic template enforcement rather than dynamic recalculation. Outputs are validated to prevent formula errors, but complex dynamic charting beyond static template ranges may require manual adjustment.