xlsx

Name: xlsx
Availability: InStock
Author: walsh-investment

Opens, reads, edits, and creates spreadsheets in .xlsx, .xlsm, .csv, and .tsv formats.

Updated Sep 1, 2025

Search Tags:#automation #spreadsheet #excel #xlsx #data-cleaning #format-conversion #header-restructure

Ready to run

npx skills add https://github.com/walsh-investment/clean-slate-import --skill xlsx-walsh-investment

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/walsh-investment/clean-slate-import/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/walsh-investment/clean-slate-import --skill xlsx-walsh-investment

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheet data is often scattered, messy, or misformatted across formats (.xlsx, .xlsm, .csv, .tsv); this skill provides reliable tools to open, read, edit, and create these files while preserving structure and enabling cleaning and transformation.

Core Features & Use Cases

Open, read, edit, or create spreadsheets in multiple formats (.xlsx, .xlsm, .csv, .tsv).
Clean and restructure tabular data, convert between tabular formats, and fix malformed headers.
Use Case: when you need to convert a CSV dump into a polished Excel workbook with clean headers and consistent formatting.

Quick Start

Load the source file, clean and restructure headers, and save the result as a new spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I clean and restructure messy headers in a CSV file?▼

You can convert CSV dumps into polished Excel workbooks by opening the source file, cleaning and restructuring headers, and saving the result as a new .xlsx file. This preserves templates and formatting conventions while ensuring consistent data structure.

Can I edit .xlsm files without breaking existing formulas?▼

Yes, you can modify .xlsm files without breaking formulas. The skill uses deterministic operations via libraries such as pandas and openpyxl, preserving templates and validating results to avoid broken formulas or misaligned headers during data transformation.

What is the best way to automate format conversion between .xlsx, .csv, and .tsv?▼

The best way to automate format conversion between .xlsx, .csv, and .tsv is to open the source file, read the tabular data, and save it in the target format. This approach uses deterministic operations to ensure outputs are well-formed spreadsheets suitable for downstream analysis.

Does spreadsheet data cleaning work with pandas and openpyxl for deterministic operations?▼

Yes, spreadsheet data cleaning is executed via libraries such as pandas and openpyxl for deterministic operations. This ensures reliable data transformation, preserves templates and formatting conventions, and validates results to avoid broken formulas or misaligned headers.

What are the limitations when preserving templates and formatting conventions during spreadsheet transformation?▼

The primary constraint is avoiding broken formulas or misaligned headers during modification. The skill mitigates this by validating results and applying deterministic operations via libraries such as pandas and openpyxl, ensuring outputs remain well-formed and formatting conventions are preserved.