xlsx

Read, edit, and convert XLSX, CSV, and TSV spreadsheet files.

Updated Apr 10, 2026
One-click install
npx skills add https://github.com/hamadah10/OML-Skills-Testing --skill xlsx-hamadah10
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hamadah10/OML-Skills-Testing/tree/main/.github/xlsx
Command: npx skills add https://github.com/hamadah10/OML-Skills-Testing --skill xlsx-hamadah10

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas.

What problem does it solve?

Automate repetitive spreadsheet chores across XLSX, CSV, and TSV formats, reducing manual edits, data cleaning, and format conversions.

Core Features & Use Cases

  • Open, read, edit, and fix spreadsheet files including .xlsx, .xlsm, .csv, and .tsv.
  • Create new spreadsheets from scratch or from data sources, including applying formulas, formatting, and charts.
  • Clean messy data (misplaced headers, junk rows) and reshape tabular data for reporting and analysis.

Quick Start

Convert a CSV to a clean, formatted XLSX with proper headers.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate converting a CSV file to a formatted XLSX spreadsheet?

To convert CSV to XLSX, the Skill reads tabular data via pandas and writes a formatted spreadsheet using openpyxl, applying proper headers and structure for analytic tasks.

Can I use openpyxl and pandas to clean messy spreadsheet data with misplaced headers?

Yes, you can clean messy spreadsheet data by leveraging pandas for data reshaping and openpyxl for deterministic Excel operations, fixing misplaced headers and removing junk rows.

What is the best way to apply Excel formulas to an existing XLSX file programmatically?

The best way to apply Excel formulas is through deterministic openpyxl operations, which allow you to open, edit, and inject formulas directly into XLSX cells for reporting tasks.

Does this approach support reading and editing both CSV and TSV files for data transformation?

Yes, the approach supports reading and editing common formats including XLSX, CSV, and TSV, enabling seamless data transformation and validation workflows across different file types.

How do I create a new spreadsheet from scratch with charts for financial reporting?

You can create a new spreadsheet from scratch by loading data into pandas, writing it to XLSX with openpyxl, and applying basic charting and formulas for financial reporting.