xlsx

Clean, transform, and format XLSX, CSV, and TSV files with Python.

2|1|Updated Apr 1, 2026
One-click install
npx skills add https://github.com/miriamdong/mstack --skill xlsx-miriamdong
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/miriamdong/mstack/tree/main/xlsx
Command: npx skills add https://github.com/miriamdong/mstack --skill xlsx-miriamdong

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, defusedxml, validators.

What problem does it solve?

The Excel (xlsx) skill automates the repetitive manipulation of spreadsheet inputs and outputs, including reading, editing, cleaning, formatting, and converting between CSV/TSV and XLSX, delivering a final spreadsheet as the output.

Core Features & Use Cases

  • Open, modify, and save XLSX, CSV, and TSV files while preserving data integrity
  • Clean and reformat messy tabular data, apply consistent styles, and perform simple transformations
  • Create new spreadsheets from existing data sources or templates, and convert between tabular formats for sharing

Quick Start

Convert the provided data into a clean, formatted spreadsheet (XLSX) ready for review.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and format messy spreadsheet data automatically?

To clean and format spreadsheet data automatically, this Skill applies deterministic transformations to XLSX, CSV, and TSV files using pandas and openpyxl. It standardizes tabular inputs, applies consistent styles, and outputs a deliverable, action-ready spreadsheet file.

Can I convert CSV files to XLSX while preserving data integrity?

Yes, you can convert CSV files to XLSX while preserving data integrity. This Skill reads tabular formats and writes formatted XLSX files, allowing seamless conversion between CSV, TSV, and XLSX for sharing and report preparation without losing data structure.

What is the best way to prepare spreadsheet data for reporting?

The best way to prepare spreadsheet data for reporting is to automate the repetitive cleanup and transformation tasks. This Skill targets report preparation by reading your raw tabular data, applying consistent formatting and simple transformations, and delivering a validated spreadsheet file ready for review.

Does this spreadsheet automation tool work with both TSV and CSV formats?

Yes, this spreadsheet automation tool works with both TSV and CSV formats. It uses Python data tooling to open, modify, and save XLSX, CSV, and TSV files, enabling you to read and write across these tabular formats and convert between them as needed.

How do I create a new spreadsheet from existing data sources?

To create a new spreadsheet from existing data sources, this Skill reads your input tabular files and applies the necessary transformations. It uses pandas and openpyxl to generate a new, formatted XLSX file from your existing data or templates for immediate use.

What are the limitations of using pandas for spreadsheet formatting?

When using pandas for spreadsheet formatting, complex visual styling and advanced Excel features may be limited compared to native Excel operations. This Skill focuses on deterministic data transformations and basic formatting to produce deliverable spreadsheets rather than complex visual dashboards.