skills.rest
leexb-wp21-prog
leexb-wp21-progCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Convert, clean, and create Excel-compatible spreadsheets from tabular inputs.

Updated Apr 28, 2026
Search Tags:#xlsx#data cleaning#LibreOffice recalculation#excel formulas#spreadsheet conversion#tabular restructuring
One-click install
npx skills add https://github.com/leexb-wp21-prog/Azure-Ticket-Helpdesk --skill xlsx-leexb-wp21-prog
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/leexb-wp21-prog/Azure-Ticket-Helpdesk/tree/main/.cursor/skills/skills-main/skills-main/skills/xlsx
Command: npx skills add https://github.com/leexb-wp21-prog/Azure-Ticket-Helpdesk --skill xlsx-leexb-wp21-prog

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you reliably open, repair, convert, and generate spreadsheet files when the source data is messy or when formulas fail, producing a correct Excel deliverable.

Core Features & Use Cases

  • Read, edit, and clean tabular files: Fix malformed CSV/TSV/Excel data (bad rows, misplaced headers, junk data) and restructure it into a proper spreadsheet.
  • Create or convert spreadsheets: Build new spreadsheets from scratch or convert between tabular formats while preserving structure.
  • Formula correctness for Excel outputs: Ensure generated/modified models contain ZERO Excel formula errors and recalculate when formulas are used.

Quick Start

Use the xlsx skill to clean and restructure the spreadsheet at 'data/dirty.xlsx' and return a corrected Excel file with working formulas and no Excel errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy Excel data with misaligned headers and bad rows?▼

Spreadsheet cleaning fixes malformed CSV, TSV, or Excel data by restructuring misplaced headers and removing junk data, then returning a corrected Excel file. It repairs bad rows and restructures tabular data into a proper spreadsheet format.

Can I convert a CSV file to a formatted Excel spreadsheet with working formulas?▼

Converting CSV to Excel preserves tabular structure while building new spreadsheets with working formulas. The output undergoes mandatory LibreOffice recalculation to ensure formula correctness and verify zero Excel error strings like #REF! or #DIV/0!.

Why does my Excel file show formula errors like #REF! and #NAME? after editing?▼

Formula errors like #REF!, #NAME?, #VALUE!, #N/A, and #DIV/0! appear when spreadsheet edits break cell references or syntax. Enforcing deterministic output constraints with LibreOffice recalculation verifies zero error strings and updates formula dependencies correctly.

What's the best way to restructure tabular data from a TSV file into a proper spreadsheet?▼

Restructuring tabular data from TSV files involves reading the source, fixing malformed rows and misplaced headers, and converting it into a proper spreadsheet format. The process produces a clean Excel-compatible output with corrected structure and no formula errors.

Does spreadsheet conversion work with .xlsm macro-enabled files?▼

Spreadsheet conversion supports .xlsm macro-enabled files alongside .xlsx, .csv, and .tsv inputs. It opens existing workbooks, applies formula-safe editing, and produces Excel-compatible outputs with mandatory LibreOffice recalculation to verify formula correctness.

How do I ensure my generated spreadsheet has zero Excel formula errors?▼

Ensuring zero Excel formula errors requires enforcing deterministic output constraints that check for #REF!, #DIV/0!, #VALUE!, #NAME?, and #N/A strings. Mandatory LibreOffice recalculation updates all formulas and verifies the final Excel deliverable contains no error values.

Related Skills

Explore More Data & Analytics Skills→
PatkikPatkik

xlsx

Clean and structure spreadsheet data from .xlsx, .xlsm, .csv, and .tsv inputs.

Community
Intermediate
stefanbosakstefanbosak

xlsx

Automate Excel creation, editing, and analysis with formula-safe workflows.

Community
Advanced
acefrost511acefrost511

data-analyst

Analyze SQL, spreadsheet, and warehouse data with cleaning and reporting workflows.

Community
Advanced
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced