xlsx

Create, edit, validate, and recalculate xlsx, xlsm, csv, and tsv files.

1|Updated Mar 19, 2026
One-click install
npx skills add https://github.com/ian-pascoe/dotfiles-chezmoi --skill xlsx-ian-pascoe
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ian-pascoe/dotfiles-chezmoi/tree/main/dot_agents/skills/xlsx
Command: npx skills add https://github.com/ian-pascoe/dotfiles-chezmoi --skill xlsx-ian-pascoe

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the manual burden of opening, cleaning, formatting, validating, and recalculating spreadsheet files so tabular work stays reliable and editable.

Core Features & Use Cases

  • Spreadsheet creation and editing: Build new workbooks or update existing xlsx, xlsm, csv, and tsv files without breaking formulas or formatting.
  • Data cleanup and restructuring: Fix messy tables, shift headers, add columns, standardize layouts, and convert between tabular formats.
  • Model validation and recalculation: Preserve templates, enforce zero formula errors, and recalculate workbooks with deterministic checks.
  • Example: Use it to turn a messy sales export into a polished workbook with formulas, formatting, and corrected sheet structure.

Quick Start

Ask the xlsx skill to open the attached spreadsheet, clean the table, add the requested formulas, and save a corrected workbook.

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 a messy spreadsheet export without breaking existing formulas?

Spreadsheet cleanup and restructuring fixes messy tables, shifts headers, and standardizes layouts while preserving templates and enforcing zero formula errors. It handles workbook cleanup and template-preserving updates to keep tabular work reliable and editable.

Can I convert CSV or TSV files into a formatted xlsx workbook with formulas?

Yes, CSV or TSV conversion into a formatted xlsx workbook is fully supported. The process builds new workbooks or updates existing files, applies formulas and formatting, and saves a corrected workbook without breaking existing formula-driven models.

What is workbook recalculation and why do I need it for formula validation?

Workbook recalculation recomputes formula values to ensure accuracy and deterministic checks. You need it for model validation to preserve templates, enforce zero formula errors, and keep formula-driven models reliable and intact.

Do I need LibreOffice and openpyxl to recalculate and edit xlsx files?

Yes, editing and recalculating xlsx files requires openpyxl, defusedxml, and lxml, alongside LibreOffice-based recalculation. These dependencies work together to keep formulas accurate and maintain workbook integrity during template-preserving updates.

What is the best way to fix formula errors in an existing xlsm file?

The best way to fix formula errors in an existing xlsm file is through model validation and recalculation. This approach preserves spreadsheet templates, enforces zero formula errors, and applies deterministic checks to keep workbook integrity intact.