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.