skills.rest
LeonChaoX
LeonChaoXCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Open, clean, convert, and edit tabular files with Excel formulas.

783|65|Updated Feb 27, 2026
Search Tags:#xlsx#data cleaning#recalculation#tabular data#excel formulas#spreadsheet conversion#error validation
One-click install
npx skills add https://github.com/LeonChaoX/qinyan-academic-skills --skill xlsx-leonchaox
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/LeonChaoX/qinyan-academic-skills/tree/main/skills/14-%E6%96%87%E6%A1%A3%E5%A4%84%E7%90%86%E4%B8%8E%E6%95%B0%E6%8D%AE%E5%B7%A5%E5%85%B7/xlsx
Command: npx skills add https://github.com/LeonChaoX/qinyan-academic-skills --skill xlsx-leonchaox

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you repair and transform messy spreadsheet files while ensuring formulas stay correct and the final deliverable is a valid spreadsheet you can immediately use.

Core Features & Use Cases

  • Spreadsheet ingestion and transformation: Open, edit, clean, restructure, and convert tabular files such as .xlsx, .xlsm, .csv, and .tsv into a proper spreadsheet output.
  • Formula-safe editing: Enforces using Excel formulas (not Python-calculated hardcodes) so results remain dynamic and updateable.
  • Quality guardrails: Requires zero Excel formula errors after recalculation (no #REF!, #DIV/0!, #VALUE!, #N/A, etc.) and preserves existing templates/styles when modifying files.
  • Excel recalculation workflow: Uses a provided LibreOffice-based scripts/recalc.py process to recalculate formulas and scan for Excel errors.
  • Use case: You receive a CSV with broken headers, malformed rows, and inconsistent columns; you want a cleaned .xlsx with correct calculations, formatting, and error-free formulas.

Quick Start

Use the xlsx skill to convert "raw-data.tsv" into a cleaned "output.xlsx" spreadsheet with corrected headers and fully recalculated, zero-error 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 CSV data and convert it into a valid spreadsheet with correct formulas?▼

To clean messy CSV data and convert it into a valid spreadsheet, this tool repairs malformed rows and broken headers while enforcing Excel formulas rather than hardcoded values. It outputs a fully recalculated, error-free spreadsheet deliverable.

How do I recalculate Excel formulas and scan for errors like #REF! or #DIV/0!?▼

You can recalculate Excel formulas and scan for errors like #REF! or #DIV/0! using a LibreOffice-based recalculation script. The process guarantees zero formula errors before returning the final spreadsheet file.

Can I edit tabular files and preserve existing templates and styles?▼

Yes, you can edit tabular files and preserve existing templates and styles. The spreadsheet editing process enforces formula-safe modifications, ensuring results remain dynamic and updateable while maintaining the original formatting.

Does the spreadsheet conversion process support both CSV and TSV formats?▼

Yes, the spreadsheet conversion process supports both CSV and TSV formats. It can open, clean, restructure, and convert these tabular files into a proper spreadsheet output like .xlsx or .xlsm.

What is the best way to fix broken headers and inconsistent columns in tabular data?▼

The best way to fix broken headers and inconsistent columns in tabular data is through automated ingestion and restructuring. This process repairs malformed rows and corrects headers, delivering a clean, valid spreadsheet.

Why do my spreadsheet formulas show #VALUE! errors after converting from CSV?▼

Spreadsheet formulas show #VALUE! errors after converting from CSV because hardcoded calculated values often break during transformation. Using a formula-safe editing approach with a LibreOffice recalculation workflow verifies zero errors.

Related Skills

Explore More Data & Analytics Skills→
GayanKavindaGayanKavinda

xlsx

Create, edit, and repair spreadsheet files from raw tabular data.

Community
Advanced
miriamdongmiriamdong
2

xlsx

Clean, transform, and format XLSX, CSV, and TSV files with Python.

Community
Intermediate
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate
TakfesTakfes

xlsx

Create, edit, and repair XLSX, XLSM, CSV, and TSV spreadsheets.

Community
Advanced