xlsx

Clean, edit, and convert spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

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 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

  • Reading/Editing: Open, read, and modify existing spreadsheets in various formats (.xlsx, .xlsm, .csv, .tsv).
  • Creation/Conversion: Generate new spreadsheets or convert between tabular formats, including exporting to multiple formats.
  • Real-World Example: If you have a messy CSV and need a clean .xlsx with formulas and formatting, this skill will automate the process and output a ready-to-use file.

Quick Start

Open the provided CSV and output a cleaned, formatted XLSX ready for use.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning a messy CSV and outputting a formatted xlsx file?

To automate spreadsheet data cleaning, use script-based operations to restructure malformed rows, fix misplaced headers, and export a formatted .xlsx file with formulas applied.

Can I convert between csv, tsv, and xlsm formats while preserving formulas?

Yes, spreadsheet format conversion supports cross-format export between .csv, .tsv, .xlsx, and .xlsm inputs while preserving templates, formulas, and formatting for ready-to-use outputs.

Does openpyxl support editing existing xlsx files with hardcoded values?

openpyxl supports opening, reading, and modifying existing .xlsx files, allowing you to add columns, compute formulas, and document hardcoded values and data sources for auditability.

What is the best way to create a new spreadsheet from other data sources?

The best way to create a new spreadsheet from other data sources is using deterministic script-based operations that generate cross-format outputs with proper formatting and documented data lineage.

When should I not use a spreadsheet automation skill for tabular data?

You should not use spreadsheet automation 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.

Why does my spreadsheet automation task require a spreadsheet file as the primary output?

Spreadsheet automation requires a spreadsheet file as the primary output because the skill is designed to produce ready-to-use .xlsx, .xlsm, .csv, or .tsv deliverables rather than non-tabular formats.