xlsx

Process and clean spreadsheet data across XLSX, XLSM, CSV, and TSV formats.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/gong-type/skills --skill xlsx-gong-type
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/gong-type/skills/tree/main/xlsx
Command: npx skills add https://github.com/gong-type/skills --skill xlsx-gong-type

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the handling of spreadsheet data across multiple formats, enabling you to open, read, edit, or fix .xlsx, .xlsm, .csv, and .tsv files without manual repetitive steps.

Core Features & Use Cases

  • Open and standardize tabular data from diverse sources (Excel workbooks, CSV/TSV).
  • Apply transformations like adding columns, computing formulas, formatting, and charting; convert between formats; clean messy data and restructure malformed rows.
  • Use Case: When you receive a messy CSV from a vendor, run this Skill to clean, reshape, and export a clean Excel workbook.

Quick Start

Clean the provided dataset and export a normalized XLSX 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 spreadsheet data and export a normalized Excel workbook?

Cleaning messy spreadsheet data involves validating inputs, restructuring malformed rows, and applying formulas to standardize columns. This process converts disorganized CSV or TSV sources into a structured, format-preserving Excel workbook.

Can I convert CSV files to XLSX while preserving formatting and adding computed columns?

Yes, converting CSV files to XLSX can include applying formulas, adding computed columns, and enforcing formatting. This transforms raw tabular data into a structured Excel workbook with normalized rows and preserved output formatting.

Does openpyxl support applying formulas and formatting across multiple Excel files?

Yes, openpyxl supports applying formulas and formatting across multiple Excel files. It enables automated transformations like column additions and charting while enforcing robust input validation and error handling for single or multiple workbooks.

What is the best way to automate data wrangling for vendor CSV exports?

Automating data wrangling for vendor CSV exports requires a process that cleans, reshapes, and standardizes tabular data. This approach handles malformed rows and applies format conversions to deliver a clean, structured workbook output.

Why does my spreadsheet format conversion result in malformed rows or data loss?

Spreadsheet format conversion can result in malformed rows or data loss without robust input validation and error handling. Enforcing format-preserving output during transformations ensures the deliverable remains a clean, structured workbook file.