xlsx

Parse, clean, and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

1|Updated Jan 28, 2026

Search Tags:#spreadsheet #excel #xlsx #csv #data-transformation #data-cleaning

Ready to run

npx skills add https://github.com/Benmore-Studio/Benmore-Meridian --skill xlsx-benmore-studio

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Benmore-Studio/Benmore-Meridian/tree/main/skills/xlsx
Command: npx skills add https://github.com/Benmore-Studio/Benmore-Meridian --skill xlsx-benmore-studio

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Automate tedious spreadsheet work by enabling reliable data cleaning, formatting, and transformation across common spreadsheet formats (.xlsx, .xlsm, .csv, .tsv).

Also support reformatting columns, applying basic formulas, and converting between formats to standardize datasets for downstream analytics.

Core Features & Use Cases

Data cleaning and normalization across tabular inputs (missing values, inconsistent formatting, type casting).
Format conversions and schema alignment across .xlsx, .xlsm, .csv, and .tsv to support data pipelines.
Reproducible spreadsheet transformations that preserve formulas and cell formatting where possible; ideal for data preparation and reporting.

Quick Start

Open an input spreadsheet, specify your cleaning/formatting rules, and save the result as a new file.

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 normalization for messy spreadsheet rows?▼

Automate data cleaning by parsing .xlsx, .xlsm, .csv, and .tsv files to handle missing values, fix inconsistent formatting, and cast types. This process produces consistent, analysis-ready outputs for downstream data pipelines.

What is the best way to convert CSV to XLSX while preserving formulas and formatting?▼

Convert CSV to XLSX using a Python-based deterministic workflow with openpyxl. This approach standardizes datasets across formats while preserving existing formulas and cell formatting where possible to support reproducible reporting.

Does openpyxl support reformatting columns and applying basic formulas in Excel files?▼

Yes, openpyxl supports reformatting columns and computing simple formulas in .xlsx and .xlsm files. It reads and writes Excel files while preserving formulas and cell formatting, making it ideal for data preparation and reporting tasks.

Can I use this spreadsheet transformation approach for data migration across different tabular formats?▼

Yes, you can use this approach for data migration by aligning schemas and converting between .xlsx, .xlsm, .csv, and .tsv formats. It standardizes tabular inputs to ensure consistent dataset migration for downstream analytics.

What are the limitations of using openpyxl for spreadsheet workflows?▼

Limitations of openpyxl include handling only .xlsx, .xlsm, .csv, and .tsv formats and computing simple formulas rather than complex array formulas. It is designed for deterministic workflows and may not suit highly complex spreadsheet transformations requiring advanced macro execution.