xlsx

Create and edit XLSX, XLSM, CSV, and TSV spreadsheets with formulas and formatting.

1|Updated Apr 10, 2026
One-click install
npx skills add https://github.com/lava-chen/duya --skill xlsx-lava-chen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lava-chen/duya/tree/main/packages/agent/skills/office/xlsx
Command: npx skills add https://github.com/lava-chen/duya --skill xlsx-lava-chen

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill solves the challenge of creating, editing, validating, and maintaining spreadsheet files while reducing manual formatting mistakes, formula errors, and data cleanup effort.

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.
  • Data Processing and Analysis: Clean messy tabular data, analyze spreadsheet contents with pandas, and transform information into usable spreadsheet outputs.
  • Formula Validation and Document Quality: Recalculate formulas with LibreOffice, detect Excel errors, preserve templates, and validate Office document structures.
  • Use Case: A financial analyst can use this Skill to update an existing budgeting workbook, add dynamic formulas, apply professional formatting, and verify that the final spreadsheet contains no formula errors.

Quick Start

Use the xlsx skill to update the attached spreadsheet with cleaned data, formulas, and professional formatting.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook editing and data cleanup without losing formulas?

Automate Excel workbook editing and data cleanup by programmatically modifying XLSX, XLSM, CSV, and TSV files. This preserves formulas, formatting, and structured data while reducing manual spreadsheet cleanup effort.

What is the best way to validate formulas and detect errors in an existing spreadsheet?

The best way to validate spreadsheet formulas is to recalculate them using LibreOffice, detect Excel errors, and verify document structure integrity. This ensures your final workbook is free of formula calculation mistakes.

Can I clean messy tabular data and export it to a formatted XLSX file?

Yes, you can clean messy tabular data and analyze spreadsheet contents with pandas, then transform the information into usable, professionally formatted XLSX spreadsheet outputs.

How do I create a financial model in Excel and ensure the workbook has no formula errors?

Create a financial model in Excel by building a new workbook with dynamic formulas and professional formatting, then validate the Office document structure to verify the final spreadsheet contains no formula errors.

Does this spreadsheet processing approach work with XLSM and TSV files?

Yes, this spreadsheet processing approach works with XLSX, XLSM, CSV, and TSV files, applying data cleanup, formula validation, and document conversion workflows while preserving file integrity.

Why do I need openpyxl and LibreOffice to update spreadsheet files?

You need openpyxl to programmatically manage Excel workbook editing, and LibreOffice to recalculate formulas and detect Excel errors, ensuring the updated spreadsheet maintains formatting and formula integrity.