xlsx

Create, edit, and convert spreadsheet files with formulas and formatting.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The xlsx skill ensures any request that mentions a spreadsheet file is answered with spreadsheet-only deliverables, preserving templates, enforcing professional fonts, and eliminating formula or formatting errors.

Core Features & Use Cases

  • Spreadsheet-first trigger: Activates whenever .xlsx, .xlsm, .csv, or .tsv files are referenced so that non-spreadsheet outputs are never returned.
  • Formula and template discipline: Requires Excel formulas instead of hardcoded values, matches existing formatting conventions, and documents assumptions next to any necessary hardcoded inputs.
  • LibreOffice-backed recalculations: Uses scripts/recalc.py with LibreOffice to recalculate every workbook and catch #REF!, #DIV/0!, and other formula errors before delivery.
  • Use Case: Take messy tabular data from downloads, clean the rows and headers, apply industry-standard formatting, and convert the sequence into a final Excel workbook ready for analysis or charting.

Quick Start

Ask the assistant to open the referenced spreadsheet file, perform the requested transformations, and keep the result as a formatted Excel 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 data and export it as a formatted Excel workbook?

To clean messy CSV data and export it as a formatted Excel workbook, you can load the file, fix malformed rows, apply industry-standard formatting, and save the result as an .xlsx file while preserving templates and fonts.

Why does my spreadsheet show formula errors after converting from CSV to XLSX?

Spreadsheet formula errors like #REF! or #DIV/0! often occur when hardcoded values replace formulas. Running a LibreOffice recalculation validates formulas and catches these errors before delivery.

Does openpyxl support maintaining fonts and templates when editing an XLSX file?

Yes, openpyxl supports maintaining fonts and templates when editing an XLSX file, ensuring that spreadsheet deliverables preserve existing formatting conventions rather than stripping them during data transformations.

What's the best way to validate formulas in an Excel workbook before sharing?

The best way to validate formulas in an Excel workbook is to use a LibreOffice-backed recalculation script that processes the workbook and catches formula errors like #REF! and #DIV/0! before shipping.

Can I convert TSV files to XLSX while keeping formulas instead of hardcoded values?

Yes, you can convert TSV files to XLSX while keeping formulas instead of hardcoded values by applying formula discipline during the transformation and documenting any necessary hardcoded inputs next to the data.