xlsx

Create and validate Excel workbooks with formulas and formatting.

Updated May 5, 2026
One-click install
npx skills add https://github.com/yanochka11/harness_bro --skill xlsx-yanochka11
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yanochka11/harness_bro/tree/main/.claude/skills/curated/xlsx
Command: npx skills add https://github.com/yanochka11/harness_bro --skill xlsx-yanochka11

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users reliably create, edit, validate, and analyze spreadsheet files while avoiding common Excel formatting and formula errors.

Core Features & Use Cases

  • Spreadsheet Creation and Editing: Build new Excel workbooks or modify existing XLSX, XLSM, CSV, and TSV files with formulas, formatting, and structured data.
  • Formula and Quality Validation: Recalculate formulas, detect spreadsheet errors, and preserve professional modeling standards during workbook updates.
  • Use Case: When working with a financial model or messy tabular dataset, use this Skill to clean the data, apply correct spreadsheet structures, and deliver a validated Excel workbook.

Quick Start

Use the xlsx skill to update the attached spreadsheet by cleaning the data, preserving formulas, and returning a validated Excel file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy tabular data and return a validated Excel workbook?

To clean messy tabular data into a validated Excel workbook, automated spreadsheet editing restructures datasets, verifies formulas, and applies professional formatting. This process removes input errors while preserving the structural integrity of your financial models.

Can I modify existing XLSX and XLSM files without breaking formulas?

Yes, you can modify existing XLSX and XLSM files without breaking formulas. The process recalculates embedded formulas during workbook updates and performs quality checks to preserve formatting standards and maintain error-free spreadsheet outputs.

Does openpyxl support automated formula validation and recalculation?

openpyxl supports automated formula validation and recalculation when combined with LibreOffice-based recalculation support. This integration detects spreadsheet errors during workbook updates and ensures formulas maintain accurate calculated values across your data.

What is the best way to automate Excel workbook editing for tabular data cleanup?

The best way to automate Excel workbook editing for tabular data cleanup is using a Python-driven approach with openpyxl and lxml. This automates structural modifications, applies formatting standards, and outputs validated spreadsheet files.

Why does spreadsheet formatting break when updating CSV and TSV files?

Spreadsheet formatting breaks when updating CSV and TSV files because these formats lack native styling and formula support. Converting them into structured XLSX workbooks with validated formatting standards resolves these structural inconsistencies.