xlsx

Open, read, edit, and fix .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

512|64|Updated Mar 13, 2025
One-click install
npx skills add https://github.com/agnt-gg/agnt --skill xlsx-agnt-gg
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/agnt-gg/agnt/tree/main/backend/skills/xlsx
Command: npx skills add https://github.com/agnt-gg/agnt --skill xlsx-agnt-gg

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Core Features & Use Cases

  • Open, read, edit, and fix .xlsx/.xlsm/.csv/.tsv files, including adding columns, applying formulas, formatting, and basic data transformations.
  • Convert between common tabular formats (Excel, CSV, TSV) and generate clean, well-structured spreadsheets from messy inputs.
  • Real-world example: take a messy CSV export, clean headers, compute a summary row, and export a polished .xlsx ready for reporting.

Quick Start

Clean and format the provided spreadsheet, apply requested formulas, and export the result as a new .xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy CSV data and format it into a usable spreadsheet?

Spreadsheet files in .xlsx, .xlsm, .csv, or .tsv formats are fully supported. You can open, read, edit, and fix these tabular files to automate data cleanup, apply formulas, or convert between common formats like Excel and CSV.

Can I convert a CSV file to an Excel xlsx format automatically?

Yes, converting CSV to xlsx format is a core tabular format conversion feature. The process reads the source file, cleans and restructures the messy input data, and generates a clean, well-structured .xlsx file ready for reporting.

What is the best way to apply formulas to an existing xlsx file?

Applying formulas to an xlsx file requires opening the spreadsheet, targeting the specific columns, and computing the desired mathematical or logical operations. The final result is an updated spreadsheet deliverable with the new formula columns applied.

Does spreadsheet automation work with macro-enabled xlsm files?

Spreadsheet automation supports .xlsm files alongside standard .xlsx, .csv, and .tsv formats. You can open, read, edit, and fix macro-enabled spreadsheets to execute tabular data tasks like adding columns, formatting, and data transformations.

When should I not use spreadsheet automation for tabular data tasks?

You should not use spreadsheet automation if the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration. It is strictly designed to produce a final spreadsheet file as the output.