skills.rest
walsh-investment
walsh-investmentOFFICIAL
Explore all skills by this author →
GitHub

xlsx

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
One-click install
npx skills add https://github.com/walsh-investment/clean-slate-import --skill xlsx-walsh-investment
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
gaos6egaos6e

xlsx

Read, edit, and format Excel and tabular files into .xlsx outputs.

Community
Intermediate
appautomatonappautomaton
143

xlsx

Automate spreadsheet creation, editing, and analysis with formulas in Excel-compatible files.

Official
Advanced
hgxszhj-pixelhgxszhj-pixel
2

minimax-xlsx

Open, create, edit, analyze, and validate Excel files with Python.

Community
Advanced
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced