xlsx

Fix, create, and convert spreadsheet files while preserving formulas and formatting.

Updated Jul 8, 2026
One-click install
npx skills add https://github.com/CeeKay1901/pilot-skillmarkt --skill xlsx-ceekay1901
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/CeeKay1901/pilot-skillmarkt/tree/main/skills/xlsx
Command: npx skills add https://github.com/CeeKay1901/pilot-skillmarkt --skill xlsx-ceekay1901

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles spreadsheet files when you need to open, clean, fix, convert, or create tabular workbooks and related files without losing formulas or formatting.

Core Features & Use Cases

  • Spreadsheet Editing: Update existing .xlsx, .xlsm, .csv, or .tsv files, including adding columns, correcting formulas, formatting cells, and restructuring messy data.
  • Workbook Creation and Conversion: Build new spreadsheets from scratch or convert tabular data between common spreadsheet formats.
  • Validation and Recalculation: Recalculate formulas with LibreOffice, detect Excel errors, and preserve document integrity through office-file packing, unpacking, and XML validation.
  • Use Case: A user can bring a broken workbook with formula errors or a raw CSV export and turn it into a clean, validated Excel file ready to share.

Quick Start

Use the xlsx skill to fix the attached spreadsheet file and return a polished, error-free workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix a broken Excel workbook with formula errors?

To fix a broken Excel workbook, this Skill repairs malformed spreadsheets by validating XML, recalculating formulas with LibreOffice, and repacking Office files to restore document integrity. It detects and corrects formula errors while preserving the original cell formatting and workbook structure.

What's the best way to clean raw CSV exports and convert them to Excel?

The best way to clean raw CSV exports is by importing the tabular data and restructuring it into a polished Excel file. This Skill cleans messy tabular data, adds necessary columns, and converts formats like CSV or TSV into validated .xlsx workbooks without losing formatting.

Does openpyxl support editing complex Excel models with existing formulas?

Yes, openpyxl supports editing complex Excel models by allowing you to update existing .xlsx files while preserving formulas. This Skill leverages openpyxl alongside pandas to add columns, correct formulas, and restructure data without dropping your existing spreadsheet logic.

Can I convert TSV files to xlsx while maintaining cell formatting?

Yes, you can convert TSV files to xlsx while maintaining cell formatting through spreadsheet-aware processing. This Skill imports raw TSV data, applies necessary cell formatting, and exports a fully structured Excel workbook ready for sharing.

Why does my spreadsheet lose formulas when I edit tabular data?

Your spreadsheet loses formulas when editing tools overwrite the underlying XML structure instead of applying spreadsheet-aware processing. This Skill prevents formula loss by validating XML, packing and unpacking Office files correctly, and recalculating formulas with LibreOffice.

When do I need XML validation for spreadsheet repair?

You need XML validation for spreadsheet repair when a workbook is malformed and standard applications cannot open it. This Skill applies XML validation alongside Office file packing and unpacking to detect structural errors and restore the broken Excel file to a working state.