skills.rest
bakwankawa
bakwankawaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Automates editing, formatting, cleaning, restructuring and converting tabular files (.xlsx, .xlsm, .csv, .tsv) using Python libraries openpyxl and pandas.

1|Updated Feb 1, 2026
Search Tags:#automation#formatting#spreadsheet#xlsx#conversion#data-cleaning
One-click install
npx skills add https://github.com/bakwankawa/lazy-code-skill --skill xlsx-bakwankawa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/bakwankawa/lazy-code-skill/tree/main/.cursor/skills/anthropic/xlsx
Command: npx skills add https://github.com/bakwankawa/lazy-code-skill --skill xlsx-bakwankawa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users manage spreadsheet files by providing automated editing, formatting, cleaning, and format conversion workflows, reducing repetitive manual work and ensuring consistent results.

Core Features & Use Cases

  • Automated editing & formatting: Open, modify, and format .xlsx, .xlsm, .csv, and .tsv files with repeatable rules.
  • Data cleaning & restructuring: Clean headers, normalize data, and restructure tabular content for downstream tasks.
  • Format conversion: Convert between tabular formats (e.g., CSV to XLSX) while preserving data integrity and formulas where possible.
  • Use Case: Imagine you need to standardize 50 CSV reports, consolidate them into a single Excel workbook, and apply a uniform header style.

Quick Start

Use the xlsx skill to convert a messy Orders.csv into Orders.xlsx after applying basic cleanup.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate converting CSV to XLSX while applying data cleaning rules?▼

Automating CSV to XLSX conversion with data cleaning uses Python libraries like pandas and openpyxl to restructure tabular content, normalize headers, and enforce consistent styling while preserving data integrity.

Can I preserve Excel formulas when converting between spreadsheet formats?▼

Yes, preserving Excel formulas during format conversion between .xlsx, .xlsm, .csv, and .tsv files relies on openpyxl to manipulate data while maintaining formula integrity and applying consistent styling.

What is the best way to standardize and consolidate multiple CSV reports into a single Excel workbook?▼

Standardizing multiple CSV reports into a single Excel workbook involves automated editing and data restructuring workflows that clean headers, normalize data, and apply uniform formatting across all consolidated spreadsheets.

Does this spreadsheet automation approach support .xlsm files with macros?▼

Yes, the spreadsheet automation approach supports .xlsm files alongside .xlsx, .csv, and .tsv formats, enabling automated editing, formatting, and data restructuring workflows across these tabular file types.

What are the limitations of using pandas and openpyxl for spreadsheet formatting and conversion?▼

Limitations of using pandas and openpyxl for spreadsheet formatting include potential constraints with highly complex macro execution in .xlsm files, though standard data cleaning, restructuring, and format conversion tasks are fully supported.

Related Skills

Explore More Data & Analytics Skills→
Chanw-researchChanw-research
38

xlsx

Prepare and clean spreadsheet files in xlsx, xlsm, csv, or tsv formats.

Official
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
xiechyxiechy
3

dask

Parallelize pandas and NumPy workflows with Dask DataFrames and Arrays.

Community
Intermediate