xlsx

Clean, transform, and standardize spreadsheet data across XLSX, CSV, and TSV inputs.

Updated Mar 12, 2026
One-click install
npx skills add https://github.com/alexjcm/agent-skillset --skill xlsx-alexjcm
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/alexjcm/agent-skillset/tree/main/skills/tools/skill-creator/xlsx
Command: npx skills add https://github.com/alexjcm/agent-skillset --skill xlsx-alexjcm

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates common spreadsheet tasks so you can open, read, edit, and fix data across formats like .xlsx, .xlsm, .csv, and .tsv, turning manual work into repeatable, reliable results.

Core Features & Use Cases

  • Open, edit, format, and clean tabular data in Excel-compatible files.
  • Convert between tabular formats (xlsx, csv, tsv) and normalize data for downstream analysis.
  • Use Case: you receive 200 customer records in CSV, clean, deduplicate, format dates, and export as a ready-to-use XLSX.

Quick Start

Process the provided spreadsheet to clean and standardize data, returning a normalized XLSX.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate data cleaning and normalize columns in a spreadsheet?

To automate data cleaning, you can process spreadsheet files to deduplicate records, normalize columns, and format dates, producing a standardized output file using libraries like pandas and openpyxl.

Can I convert CSV to XLSX while preserving formulas and formatting?

Yes, you can convert CSV files to XLSX format while updating or preserving formulas and formatting by parsing input data and writing it into a structured spreadsheet deliverable.

Does this approach work with TSV and XLSM files?

Yes, this approach supports opening, reading, editing, and fixing tabular data across XLSM, XLSX, CSV, and TSV file formats to normalize data for downstream analysis.

What is the best way to standardize 200 customer records from a CSV file?

The best way to standardize customer records is to clean, deduplicate, and format dates within the CSV, then export the normalized data as a ready-to-use XLSX file.

Do I need pandas and openpyxl to parse and write spreadsheet data?

Yes, parsing, manipulating, and writing spreadsheet data while preserving or updating formulas and formatting requires libraries such as pandas and openpyxl.