xlsx

Read and transform Excel, CSV, and TSV files into polished spreadsheet outputs.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies handling spreadsheet data by treating a spreadsheet file (xlsx/xlsm/csv/tsv) as the primary input or output. It enables you to open, read, edit, fix, and convert spreadsheets with minimal manual steps, and to generate polished outputs ready for reporting or analysis.

Core Features & Use Cases

  • Open, read, format, clean, and transform spreadsheet data, including applying formulas and basic chart-ready formatting.
  • Create new spreadsheets from scratch or from existing data and convert between formats (CSV, TSV, XLSX, XLSM).
  • Real-world scenario: take a messy CSV, clean headers and rows, apply a few formulas, and export a ready-to-use .xlsx.

Quick Start

Clean and structure the provided file to produce a ready-to-use spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and format a messy CSV file for reporting?

This Skill cleans and formats messy CSV files by reading input data, fixing headers, applying formulas, and writing a polished .xlsx file ready for analysis. It automates deterministic spreadsheet transformations without manual steps.

Can I convert between CSV, TSV, and XLSX spreadsheet formats?

Yes, you can convert between CSV, TSV, XLSX, and XLSM formats. The Skill reads the source spreadsheet, performs the required transformations, and writes a new file in the target format.

What is the best way to automate applying formulas to an existing spreadsheet?

The best way to apply formulas to a spreadsheet is to reference the file by name or path. The Skill reads the input, applies formulas, and outputs a formatted spreadsheet file ready for reporting.

Does this spreadsheet automation tool support generating chart-ready sheets?

Yes, it supports generating chart-ready sheets. When you reference a spreadsheet by name or path, the Skill reads the input, applies formatting, and produces a polished output file structured for charting.

What file types can I use to create a new spreadsheet from scratch?

You can create new spreadsheets from scratch or existing data using CSV, TSV, XLSX, and XLSM file types. The Skill takes your input data, performs transformations, and writes a polished spreadsheet file.

Are there limitations to processing spreadsheets with openpyxl and lxml?

Processing spreadsheets with openpyxl and lxml is limited to deterministic transformations on the provided file. It reads the input, applies cleaning and formatting, and writes a single polished output file.