xlsx

Convert and repair CSV/TSV and Excel files into error-free workbooks.

Updated Mar 16, 2026
One-click install
npx skills add https://github.com/zlovexforever/zlx-claude-skills --skill xlsx-zlovexforever
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zlovexforever/zlx-claude-skills/tree/main/xlsx
Command: npx skills add https://github.com/zlovexforever/zlx-claude-skills --skill xlsx-zlovexforever

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires LibreOffice (soffice), openpyxl, pandas, lxml, defusedxml, validators, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps you create, edit, clean, and validate spreadsheet files (especially .xlsx/.xlsm and tabular CSV/TSV inputs) while preventing common calculation and formatting mistakes.

Core Features & Use Cases

  • Create or convert spreadsheets: Build new Excel workbooks from provided tabular data, or convert between tabular file formats such as CSV/TSV and Excel.
  • Edit and restructure existing files: Add columns, reorganize messy tables, and fix malformed or poorly structured datasets into clean spreadsheets.
  • Financial-model safety guardrails: Produces deliverables with professional formatting rules and prevents broken models by ensuring zero Excel formula errors (no #REF!, #DIV/0!, #VALUE!, #N/A, etc.) after recalculation.
  • On-demand formula recalculation: Uses LibreOffice-based recalculation for formula evaluation and error detection after edits.

Quick Start

Use the xlsx skill to clean and convert the spreadsheet file "messy-data.csv" into a valid, error-free Excel workbook called "cleaned.xlsx".

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert messy CSV files into clean Excel workbooks without formula errors?

To convert messy CSV files into clean Excel workbooks, the xlsx skill restructures tabular data and applies professional formatting. It enforces zero Excel error markers like #REF! and #DIV/0! by using LibreOffice recalculation to validate formulas.

What's the best way to fix broken spreadsheet formulas like #REF! and #VALUE!?

Fixing broken spreadsheet formulas like #REF! and #VALUE! requires deterministic recalculation. The xlsx skill uses LibreOffice to evaluate formulas and enforce zero error markers, ensuring financial models are rebuilt with correct calculations.

How do I edit existing xlsx templates while preserving workbook conventions?

Editing existing xlsx templates while preserving workbook conventions involves opening the file and restructuring data without overwriting existing formulas. The xlsx skill adds columns and reorganizes tables while maintaining original formatting rules.

Does LibreOffice recalculation ensure accurate formula validation for financial modeling?

LibreOffice recalculation ensures accurate formula validation for financial modeling by evaluating formulas after edits. The xlsx skill mandates this recalculation process to detect and eliminate calculation errors before generating the final spreadsheet deliverable.

Can I build financial models from scratch using Excel formulas instead of hardcoding values?

Building financial models from scratch using Excel formulas instead of hardcoding values is the core approach. The xlsx skill ensures deterministic spreadsheet generation by applying Excel formulas for calculated values and validating them through LibreOffice.

Why does my spreadsheet conversion produce Excel formula errors after editing?

Spreadsheet conversion produces Excel formula errors when calculated values are hardcoded or formulas are not recalculated. The xlsx skill prevents this by enforcing LibreOffice-based formula recalculation and checking for zero error markers like #NAME? and #N/A.