skills.rest
cookeyholder
cookeyholderCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Open, edit, clean, and convert XLSX, XLSM, CSV, and TSV spreadsheets.

Updated Apr 9, 2026
Search Tags:#automation#formatting#spreadsheet#xlsx#data-cleaning#data-conversion
One-click install
npx skills add https://github.com/cookeyholder/django-devcontainer-template --skill xlsx-cookeyholder
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cookeyholder/django-devcontainer-template/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/cookeyholder/django-devcontainer-template --skill xlsx-cookeyholder

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users automate and manage spreadsheet workloads across XLSX, XLSM, CSV, and TSV files. It enables opening, reading, editing, cleaning messy data, adding columns, formulas, formatting, and creating new spreadsheets from scratch or other data sources. It also supports converting between tabular file formats. Trigger especially when a user references a specific spreadsheet by name or path and wants automated processing that results in a deliverable spreadsheet file.

Core Features & Use Cases

  • Open, read, edit, fix and convert spreadsheets in multiple formats (.xlsx, .xlsm, .csv, .tsv).
  • Create new spreadsheets from scratch or from other data sources.
  • Clean and restructure messy tabular data (misplaced headers, junk rows) into proper spreadsheets.
  • Use Case: When you have a messy dataset in CSV and need a clean XLSX with formatted headers and formulas.

Quick Start

Open the target spreadsheet and ask the Skill to apply formatting/cleaning, then save the result as a new 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 formatting for a messy CSV file?▼

This Skill automates spreadsheet data cleaning by opening CSV files, fixing misplaced headers, removing junk rows, applying formulas, and exporting a formatted XLSX file. It restructures messy tabular data into a polished deliverable.

Can I convert XLSX, XLSM, CSV, and TSV files into different formats?▼

Yes, you can convert between XLSX, XLSM, CSV, and TSV formats. The process opens the source file and exports it to your desired destination format while preserving data integrity and applying formatting.

What's the best way to add formulas and new columns to an existing spreadsheet?▼

The best way to add formulas and augment columns is to open the existing spreadsheet, apply the required calculations to the new columns, and save the updated workbook. This automates workbook manipulation while preserving data integrity.

Do I need OpenPyXL to edit XLSX files?▼

Yes, OpenPyXL is required for workbook manipulation when editing XLSX files. DefusedXML and LXML are also necessary dependencies for secure XML handling during the spreadsheet preparation and format conversion process.

Does spreadsheet automation work for creating new files from scratch?▼

Yes, spreadsheet automation works for creating new files from scratch or from other data sources. It generates a clean, formatted spreadsheet file with augmented columns and applied formulas as the final deliverable output.

Related Skills

Explore More Data & Analytics Skills→
Sacred-GSacred-G
2

xlsx

Open, edit, format, and convert spreadsheet files across xlsx, csv, and tsv formats.

Community
Intermediate
ArtemXTechArtemXTech
531

wispr-flow

Analyze Wispr Flow SQLite data to generate statistics, transcripts, exports, and dashboards.

Community
Intermediate
sandmark78sandmark78

data-analyst

Analyze raw data with SQL and Python to generate business insights.

Community
Advanced
HaykTarkhanyanHaykTarkhanyan

vaex

Process large tabular datasets beyond RAM with lazy, out-of-core DataFrames.

Community
Intermediate