xlsx

Clean, edit, analyze, and generate Excel, CSV, and TSV spreadsheets with formula validation.

Updated May 5, 2026
One-click install
npx skills add https://github.com/XCmiaow/cc-deploy --skill xlsx-xcmiaow
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/XCmiaow/cc-deploy/tree/main/skills/xlsx
Command: npx skills add https://github.com/XCmiaow/cc-deploy --skill xlsx-xcmiaow

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you open, clean, transform, and create spreadsheet files (Excel/CSV/TSV) while ensuring the final workbook stays reliable—especially by preventing and detecting Excel formula errors.

Core Features & Use Cases

  • Spreadsheet creation & conversion: Generate new spreadsheets from scratch or convert tabular files (e.g., CSV/TSV) into structured Excel workbooks.
  • Spreadsheet editing & restructuring: Fix messy tabular data (malformed rows, misplaced headers, junk rows) and reshape it into a proper workbook layout.
  • Formula safety & validation: Enforce the rule of delivering Excel files with ZERO formula errors by recalculating formulas via LibreOffice and scanning for common Excel error types.

Example use case: You receive a messy CSV export with inconsistent columns and wrong header placement; ask for a cleaned, analysis-ready .xlsx with computed totals and charts, and the Skill produces a spreadsheet with recalculated, error-free formulas.

Quick Start

Use the xlsx skill to clean the spreadsheet at path "input.csv" and create a new Excel file "output.xlsx" with correct headers and formulas.

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 my spreadsheet?

To convert a messy CSV export into a clean Excel file, restructure misplaced headers and malformed rows to reshape the tabular data. This generates a structured analysis-ready .xlsx workbook with correct columns and computed totals.

How do I convert a messy CSV export into a clean Excel file with correct headers?

To convert a messy CSV export into a clean Excel file, restructure misplaced headers and malformed rows to reshape the tabular data. This generates a structured analysis-ready .xlsx workbook with correct columns and computed totals.

How does LibreOffice recalculation work for validating spreadsheet formulas?

Yes, you can generate a new spreadsheet model from scratch. By defining the required headers and columns, the process builds a new structured workbook and populates it with calculated formulas that are validated as error-free.

Can I generate a new spreadsheet model from scratch with error-free formulas?

Yes, you can generate a new spreadsheet model from scratch. By defining the required headers and columns, the process builds a new structured workbook and populates it with calculated formulas that are validated as error-free.

Does this spreadsheet cleaning approach support converting between CSV, TSV, and xlsx formats?

To restructure tabular data with junk rows, clean the spreadsheet by removing the junk and fixing malformed rows. This reshapes the data into a proper workbook layout with accurate headers and recalculated formulas.

What is the best way to restructure tabular data with junk rows and misplaced headers?

To restructure tabular data with junk rows, clean the spreadsheet by removing the junk and fixing malformed rows. This reshapes the data into a proper workbook layout with accurate headers and recalculated formulas.