xlsx

Open, edit, and convert spreadsheet files between XLSX, CSV, and TSV formats.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates repetitive spreadsheet work by enabling programmatic open, read, edit, and fix operations on common spreadsheet formats (.xlsx, .xlsm, .csv, .tsv). It also supports creating new spreadsheets from scratch or from other data sources and converting between tabular formats, triggering whenever a user references a spreadsheet file by name or path and requiring a final spreadsheet deliverable.

Core Features & Use Cases

  • Open, read, validate, and preserve formulas and formatting across .xlsx, .xlsm, .csv, and .tsv files.
  • Edit workflows: add columns, apply simple formulas, apply formatting, and clean messy data to produce clean, ready-to-use spreadsheets.
  • Convert and export: transform between tabular formats (e.g., Excel to CSV/TSV and vice versa) and assemble data into a new workbook when needed.
  • Use case: clean a messy CSV and convert it into a well-formatted XLSX with computed fields and consistent styling.

Quick Start

Provide a sample dataset and ask the agent to return a completed spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a CSV file to a formatted XLSX spreadsheet with formulas?▼

To convert a CSV file to a formatted XLSX spreadsheet with formulas, provide the dataset and request the agent to transform, apply computations, and export it as a clean workbook.

Can I open and edit XLSM files while preserving existing cell formatting?▼

Yes, you can open and edit XLSM files while preserving existing cell formatting. The process reads .xlsm files, validates data, applies edits, and retains original styling.

What is the best way to clean messy spreadsheet data and export it to TSV?▼

The best way to clean messy spreadsheet data and export it to TSV is to open the source file, remove inconsistencies, apply formatting, and convert it directly into a TSV output.

Does spreadsheet conversion work with tabular formats like XLSX and CSV without losing formulas?▼

Yes, spreadsheet conversion works with tabular formats like XLSX and CSV without losing formulas. The mechanism preserves formulas and formatting across .xlsx, .xlsm, .csv, and .tsv files.

How do I add columns with computed fields to an existing spreadsheet programmatically?▼

To add columns with computed fields to an existing spreadsheet programmatically, open the file, specify the new columns, apply simple formulas to the data, and export the updated workbook.

What Python libraries are used to automate Excel data processing and formatting?▼

The Python libraries used to automate Excel data processing and formatting are openpyxl and pandas, which handle reading, editing, applying formulas, and converting tabular formats.