xlsx

Repair, transform, and validate XLSX/XLSM and CSV/TSV spreadsheet files.

Updated May 4, 2026
One-click install
npx skills add https://github.com/234194027-cpu/xianclaw --skill xlsx-234194027-cpu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/234194027-cpu/xianclaw/tree/main/resources/openclaw/config/skills/xlsx
Command: npx skills add https://github.com/234194027-cpu/xianclaw --skill xlsx-234194027-cpu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you repair, analyze, and transform spreadsheet files (Excel and tabular CSV/TSV inputs) so you can reliably produce a valid spreadsheet result for real tasks without manual spreadsheet fixing.

Core Features & Use Cases

  • Spreadsheet creation, conversion, and cleanup: Create new spreadsheets from scratch, convert between tabular formats (XLSX/XLSM/CSV/TSV), and clean messy tabular data into proper spreadsheet structure.
  • Spreadsheet editing and fixes: Open an existing spreadsheet and perform tasks like adding columns, restructuring headers, computing formulas, formatting, and preparing charts.
  • Financial model readiness: When building financial models, enforce professional formatting rules (including cell color conventions for assumptions/inputs/links) and ensure formulas produce zero Excel errors.

Quick Start

Use the xlsx skill to clean and restructure the attached spreadsheet file 'data.xlsx' into a properly formatted table with correct columns and formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy spreadsheet data and fix Excel formula errors automatically?

Spreadsheet cleaning and formula error fixing can be automated by validating XLSX/XLSM and CSV/TSV tabular inputs, restructuring headers, and recalculating formulas to produce Excel-ready outputs with zero formula errors.

What is the best way to convert CSV or TSV files into a properly formatted Excel spreadsheet?

Converting CSV or TSV files into Excel spreadsheets involves transforming tabular inputs into XLSX format while applying UTF-8 encoding with BOM to ensure proper data alignment and compatibility for downstream use.

How do I build a financial model in Excel that enforces professional formatting rules?

Building a financial model in Excel requires applying professional formatting rules, such as cell color conventions for assumptions and links, while computing formulas to ensure the spreadsheet produces zero Excel errors.

Can I restructure headers and add computed columns to an existing XLSX spreadsheet without manual editing?

Restructuring headers and adding computed columns to an existing XLSX spreadsheet can be done programmatically by opening the file, editing the tabular structure, computing formulas, and exporting a valid updated spreadsheet deliverable.

Why does my CSV file display garbled characters when imported into Excel?

Garbled characters in CSV files imported into Excel often occur due to incorrect encoding; applying UTF-8 with BOM encoding during CSV file conversion ensures proper character rendering and data integrity.

Does this spreadsheet repair process support both XLSX and XLSM file formats?

Yes, the spreadsheet repair and transformation process supports both XLSX and XLSM file formats, validating inputs and applying optional LibreOffice-based formula recalculation to produce error-free spreadsheet deliverables.