skills.rest
skyymar69-rgb
skyymar69-rgbCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Clean, restructure, and convert spreadsheet workbooks while preserving formatting and formulas.

1|Updated Mar 11, 2026
Search Tags:#xlsx#data cleaning#financial model#excel formula repair#spreadsheet conversion#libreoffice recalculation
One-click install
npx skills add https://github.com/skyymar69-rgb/Nexus-seo-websit --skill xlsx-skyymar69-rgb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/skyymar69-rgb/Nexus-seo-websit/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/skyymar69-rgb/Nexus-seo-websit --skill xlsx-skyymar69-rgb

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

You have messy or formula-broken spreadsheets and need a reliable way to clean, edit, analyze, convert, and deliver a corrected Excel file without Excel error values.

Core Features & Use Cases

  • Spreadsheet creation & conversion: Generate new spreadsheets, convert tabular formats (e.g., XLSX/CSV/TSV), and restructure data for downstream use.
  • Safe editing of existing workbooks: Read workbooks, modify cells/sheets, preserve templates and established formatting, and keep formulas dynamic rather than hardcoding results.
  • Formula reliability & error prevention: Recalculate formulas using LibreOffice (via scripts/recalc.py) and verify the output contains ZERO Excel formula errors such as #REF!, #DIV/0!, #VALUE!, or #NAME?.

Use case: Clean a CSV export with malformed rows and wrong headers, rebuild it into a properly structured XLSX model, then ensure all computed outputs recalculate to a correct, error-free workbook.

Quick Start

Ask the AI to “clean and restructure the attached spreadsheet file, fix any formula errors, preserve the existing layout where applicable, and return a corrected .xlsx workbook.”

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix Excel formula errors like #REF! and #DIV/0! in a spreadsheet?▼

To fix Excel formula errors like #REF! and #DIV/0!, this Skill recalculates workbooks using LibreOffice and verifies the output contains zero errors. It cleans tabular inputs, repairs formulas, and delivers a corrected XLSX file.

Can I convert CSV to XLSX while preserving existing templates and formatting?▼

Yes, you can convert CSV to XLSX while preserving existing templates and formatting. The Skill safely reads existing workbooks, restructures tabular data, and maintains established layouts without hardcoding calculated values.

What is the best way to clean messy spreadsheet data and rebuild it into a financial model?▼

The best way to clean messy spreadsheet data and rebuild a financial model is to clean malformed rows, correct headers, restructure the data, and apply dynamic Excel formulas. This ensures all computed outputs recalculate correctly.

How do you ensure formula correctness when editing an existing XLSM file?▼

Formula correctness when editing an existing XLSM file is ensured by keeping formulas dynamic rather than hardcoding results, then running a LibreOffice-based recalculation. The final workbook is verified to contain zero Excel formula errors.

Does this spreadsheet conversion tool support TSV and XLSX formats?▼

Yes, this spreadsheet conversion tool supports TSV, XLSX, XLSM, and CSV formats. It generates new spreadsheets, converts between these tabular formats, and restructures data for downstream analytical use.

Why do my spreadsheet formulas break after converting tabular data formats?▼

Spreadsheet formulas break after format conversion when calculated values are hardcoded or references misalign. This Skill prevents this by using dynamic Excel formulas during editing and verifying the recalculated output has zero errors.

Related Skills

Explore More Data & Analytics Skills→
yuyalun-allenyuyalun-allen

xlsx

Edit spreadsheet files to clean tabular data and verify Excel formulas.

Community
Advanced
zinohomezinohome

xlsx

Create and validate XLSX workbooks with automated formula recalculation and error checking.

Community
Advanced
canvascodingcanvascoding
10

xlsx

Clean, format, and convert spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
GratefulJinx77GratefulJinx77

Xlsx

Create and analyze Excel workbooks with openpyxl and pandas.

Community
Advanced