xlsx

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

Updated Mar 17, 2026
One-click install
npx skills add https://github.com/GayanKavinda/gayankavinda.github.io --skill xlsx-gayankavinda
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/GayanKavinda/gayankavinda.github.io/tree/main/skills/skills/xlsx
Command: npx skills add https://github.com/GayanKavinda/gayankavinda.github.io --skill xlsx-gayankavinda

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the manual burden of opening, cleaning, editing, converting, and repairing spreadsheet files so tabular work stays accurate and updateable.

Core Features & Use Cases

  • Spreadsheet Creation and Editing: Build new workbooks or modify existing .xlsx, .xlsm, .csv, and .tsv files without losing structure.
  • Data Cleaning and Restructuring: Fix malformed rows, misplaced headers, duplicated fields, and other messy tabular data into a proper spreadsheet.
  • Formatting and Model Preservation: Keep existing templates, styles, formulas, and workbook conventions intact while adding columns, calculations, charts, or new sheets.
  • Use Case: If you receive a broken sales export with inconsistent columns and need a polished workbook with totals and formatting, this Skill can clean it, recalculate it, and return a usable file.

Quick Start

Use the xlsx skill to clean the attached spreadsheet, preserve its formatting, and return a corrected workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy tabular data and fix malformed rows in an Excel spreadsheet?

To clean messy tabular data, this Skill fixes misplaced headers, duplicated fields, and malformed rows in your Excel spreadsheet, returning a structured and usable workbook without manual editing.

Can I edit an existing xlsx file and keep formulas and formatting intact?

Yes, you can edit an existing xlsx file and keep formulas and formatting intact, as this Skill preserves templates, styles, and workbook conventions while adding calculations or new sheets.

What is the best way to convert raw CSV or TSV files into a formatted Excel workbook?

The best way to convert raw CSV or TSV files into a formatted Excel workbook is using this Skill, which structures raw tabular data and applies workbook formatting while keeping outputs dynamically updateable.

Does spreadsheet repair and formula recalculation prevent Excel errors when adding new columns?

Spreadsheet repair and formula recalculation validate calculations to prevent Excel errors when adding new columns, ensuring your workbook formulas remain accurate and dynamically updateable.

Why do my Excel formulas break after data cleaning and how can I fix them?

Excel formulas break after data cleaning due to structural changes, but this Skill applies formula recalculation with validation to prevent errors and keep your workbook outputs dynamically updateable.

Can I create charts in an xlsx workbook from raw tabular data without losing template styles?

Yes, you can create charts in an xlsx workbook from raw tabular data without losing template styles, as this Skill preserves existing formatting and conventions while adding visualizations.