skills.rest
malue-ai
malue-aiOFFICIAL
Explore all skills by this author →
GitHub

excel-fixer

Detect and fix formatting issues in Excel and CSV files using pandas and openpyxl.

36|2|Updated Feb 9, 2026
Search Tags:#formatting#data quality#standardization#excel#csv#data cleaning
One-click install
npx skills add https://github.com/malue-ai/dazee-small --skill excel-fixer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-fixer
Source: https://github.com/malue-ai/dazee-small/tree/main/instances/xiaodazi/skills/excel-fixer
Command: npx skills add https://github.com/malue-ai/dazee-small --skill excel-fixer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, chardet, and includes scripts (resource) components.

What problem does it solve?

This Skill automatically detects and fixes common formatting issues in Excel and CSV files, ensuring data accuracy and consistency before analysis or further processing.

Core Features & Use Cases

  • Encoding Correction: Fixes garbled text in CSV files caused by incorrect encoding.
  • Cell Merging: Unmerges cells and fills down values to ensure a flat, usable table structure.
  • Header Cleaning: Identifies and removes duplicate or misplaced header rows.
  • Type Standardization: Detects and flags columns with inconsistent data types.
  • Category Normalization: Standardizes text in categorical columns by merging similar values (e.g., "华东" and "华东地区").

Quick Start

Use the excel-fixer skill to automatically clean and standardize the attached file 'sales_data.xlsx'.

Frequently Asked Questions about excel-fixer

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

FAQPage Schema
How do I fix garbled text and encoding issues in CSV files?▼

To fix garbled text caused by incorrect encoding in CSV files, the process automatically detects the correct character encoding using chardet and re-reads the data to restore readable text.

How do I unmerge cells in Excel and fill down values for a flat table?▼

Unmerging cells in Excel creates a flat table structure by separating merged regions and automatically filling down the values into all newly unmerged rows for immediate analysis.

What is the best way to standardize categorical text in Excel data?▼

Standardizing categorical text in Excel involves automatically detecting and merging similar values, such as normalizing "华东" and "华东地区" into a single consistent category.

How do I remove duplicate headers from an Excel sheet?▼

Removing duplicate headers from an Excel sheet involves identifying misplaced or repeated header rows within the data block and deleting them to ensure a single clean structural top row.

Can pandas and openpyxl detect inconsistent data types in Excel columns?▼

Yes, using pandas and openpyxl, the process detects columns with inconsistent data types, flags the mixed type inconsistencies, and reports on all changes made to the spreadsheet.

Why does Excel data cleaning report on all changes made to the file?▼

Excel data cleaning reports on all changes made to the file to provide full visibility into automated standardization, ensuring you can verify every encoding fix, header removal, and type correction.

Related Skills

Explore More Data & Analytics Skills→
zjy-devzjy-dev
2

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced
JonathanMitchell1234JonathanMitchell1234

data-science-expert

Perform data cleaning, feature engineering, and statistical modeling with pandas and scikit-learn.

Community
Advanced
ovachieverovachiever
52

skill-review

Audit claude-skills documentation for standards violations and version drift.

Community
Advanced
kiryteokiryteo
1

data-exploration

Profile datasets to assess shape, quality, and patterns before analysis.

Community
Advanced