xlsx

Repair, clean, convert, and generate XLSX/XLSM/CSV/TSV spreadsheet files.

199|41|Updated Oct 25, 2020
One-click install
npx skills add https://github.com/rvdbreemen/OTGW-firmware --skill xlsx-rvdbreemen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rvdbreemen/OTGW-firmware/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/rvdbreemen/OTGW-firmware --skill xlsx-rvdbreemen

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you open, repair, and transform spreadsheet files so your tabular data is accurate, usable, and error-free without manual spreadsheet-by-spreadsheet work.

Core Features & Use Cases

  • Create or edit spreadsheets (XLSX/XLSM/CSV/TSV): Build new workbooks from scratch, convert tabular inputs, and restructure data into proper spreadsheet layouts.
  • Clean messy or malformed data: Fix issues like misplaced headers, malformed rows, junk data, and other structural problems that prevent analysis.
  • Convert and output tabular files: Convert between tabular file formats and ensure the final deliverable is a spreadsheet file.

Quick Start

Use the xlsx skill any time the spreadsheet file you want to modify or produce is the primary input or output, and ask it to generate the corrected spreadsheet file from the attached data (for example: "Clean the messy .csv and output a corrected .xlsx with properly typed columns 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 CSV data and output a corrected XLSX file?

To clean messy CSV data and output a corrected XLSX file, you provide the malformed tabular input to be repaired. The skill fixes misplaced headers and junk rows, then generates a properly typed spreadsheet deliverable with zero Excel formula errors.

Can I convert a TSV file to XLSX while recalculating existing Excel formulas?

Yes, you can convert a TSV file to XLSX while recalculating existing Excel formulas. The skill uses LibreOffice-based recalculation when formulas are present to ensure the final spreadsheet output contains zero formula errors.

What is the best way to repair a malformed spreadsheet with structural issues?

The best way to repair a malformed spreadsheet with structural issues is to transform the tabular input into a valid, usable workbook output. The skill fixes misplaced headers, malformed rows, and junk data to ensure the file is error-free and ready for analysis.

Do I need a specific environment to build new XLSX files from data sources?

No specific external environment is required to build new XLSX files from data sources because the skill operates self-contained with no dependencies. It restructures tabular inputs into proper spreadsheet layouts and outputs valid XLSX/XLSM/CSV/TSV files.

Why does my spreadsheet conversion still show Excel formula errors?

Your spreadsheet conversion may show Excel formula errors if the input data is malformed or formulas are not recalculated. The skill addresses this by applying LibreOffice-based recalculation when formulas are present and enforcing zero Excel formula errors in the output.

Does the xlsx skill support updating existing spreadsheet templates?

Yes, the xlsx skill supports updating existing spreadsheet templates referenced by path or name. It transforms tabular inputs into valid, usable workbook outputs while maintaining the required XLSX/XLSM/CSV/TSV deliverable formats.