skills.rest
dobrinz123
dobrinz123COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Process spreadsheet files to create, read, edit, clean, and convert .xlsx, .xlsm, .csv, and .tsv formats.

Updated Apr 9, 2026
Search Tags:#openpyxl#spreadsheet#excel#xlsx#libreoffice#data-cleaning#lxml
One-click install
npx skills add https://github.com/dobrinz123/claude-skills-share --skill xlsx-dobrinz123
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dobrinz123/claude-skills-share/tree/main/anthropic-skills/xlsx
Command: npx skills add https://github.com/dobrinz123/claude-skills-share --skill xlsx-dobrinz123

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles any task where a spreadsheet file is the primary input or deliverable, including opening, reading, editing, cleaning, restructuring, formatting, charting, and converting .xlsx, .xlsm, .csv, and .tsv files. It reduces manual spreadsheet cleanup, prevents broken formulas, and ensures deliverables are produced as ready-to-use Excel workbooks.

Core Features & Use Cases

  • File handling: Open, preserve, or modify existing Excel workbooks and templates (.xlsx/.xlsm) and convert or import/export delimited files (.csv, .tsv).
  • Data cleaning & restructuring: Fix malformed rows, detect/move misplaced headers, normalize columns, and transform junk tabular data into structured sheets.
  • Formula-first workflows: Insert formulas (not hardcoded results), enforce formatting and numeric conventions, and guarantee zero formula errors by recalculating with LibreOffice via scripts/recalc.py.
  • Financial model standards: Apply color-coding, number-formatting, assumptions placement, and documentation rules for professional financial workbooks.
  • Validation & packaging: Use validators and pack/unpack utilities to inspect Office XML, validate relationships/schemas, and create repaired Office files.
  • Use Case: Convert a messy exported transactions CSV into a multi-sheet, formula-driven financial workbook that preserves the original template style and passes formula-error validation.

Quick Start

Open the attached file 'data.xlsx', clean and normalize headers and rows, add required formula-driven summary sheets, run the recalculation script, and return the updated 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 normalize messy CSV or TSV data into a structured Excel workbook?▼

To clean messy tabular data, this Skill fixes malformed rows, detects misplaced headers, and normalizes columns to transform junk delimited files into structured .xlsx sheets. It restructures exports into ready-to-use Excel workbooks automatically.

Can I insert Excel formulas instead of hardcoded values when editing an xlsx file?▼

Yes, you can insert live Excel formulas instead of hardcoded values. The Skill enforces a formula-first workflow, preserving existing templates and adding formula-driven summary sheets for your financial models.

How do I ensure zero formula errors in a spreadsheet after adding new calculations?▼

To ensure zero formula errors in your spreadsheet, the Skill uses a recalculation script powered by LibreOffice. This process validates and recalculates formulas, guaranteeing the final workbook passes error checks.

Does this approach support preserving existing Excel templates and formatting styles?▼

Yes, this approach fully supports preserving existing Excel templates and formatting styles. It opens and modifies .xlsx and .xlsm workbooks while maintaining the original layout, color-coding, and numeric conventions.

What is the best way to convert a transactions export into a formatted financial model?▼

The best way to convert transaction exports into financial models is using a formula-first workflow that applies professional standards. This Skill adds assumptions placement, documentation rules, and color-coding to produce professional workbooks.

Can openpyxl handle converting between xlsx, xlsm, csv, and tsv file formats?▼

Yes, openpyxl combined with LibreOffice scripts handles converting between .xlsx, .xlsm, .csv, and .tsv file formats. The Skill imports, exports, and converts delimited files while validating the Office XML structure.

Related Skills

Explore More Finance & Accounting Skills→
GayanKavindaGayanKavinda

xlsx

Create, edit, and repair spreadsheet files from raw tabular data.

Community
Advanced
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
Shockwave2kShockwave2k

xlsx

Validate and recalculate XLSX workbooks using LibreOffice-based tooling.

Community
Advanced
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate