xlsx

Create, edit, and analyze Excel files with openpyxl and LibreOffice.

11|Updated May 6, 2026
One-click install
npx skills add https://github.com/open-neko/openneko --skill xlsx-open-neko
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/open-neko/openneko/tree/main/packages/llm/assets/builtin-skills/xlsx
Command: npx skills add https://github.com/open-neko/openneko --skill xlsx-open-neko

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Working with Excel files often requires professional formatting, accurate formulas, and clean data structures, but manual spreadsheet work is error-prone and time-consuming. This Skill automates the creation, editing, and analysis of .xlsx, .xlsm, .csv, and .tsv files while enforcing industry standards for financial models and data integrity.

Core Features & Use Cases

  • Professional Spreadsheet Creation: Build new Excel workbooks from scratch or from data sources using openpyxl, with proper fonts, colors, and number formats.
  • Formula-Driven Editing: Modify existing spreadsheets while preserving formulas and templates, recalculating with LibreOffice to catch errors like #REF! or #DIV/0!.
  • Data Cleaning & Restructuring: Transform messy tabular data with malformed rows, misplaced headers, or junk values into clean, properly formatted spreadsheets.
  • Financial Modeling: Apply color-coded conventions (blue for inputs, black for formulas, green for internal links) and strict documentation requirements for assumptions.

Quick Start

Use the xlsx skill to open the file 'sales_data.xlsx' from your downloads, clean the malformed headers and duplicate rows, and save it as a professionally formatted spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel creation and data cleaning for .xlsx files?

Automate Excel creation and data cleaning by using openpyxl to build workbooks and restructure malformed tabular data. This process transforms messy rows, misplaced headers, and junk values into clean, professionally formatted spreadsheets.

Can I edit existing spreadsheet formulas without breaking template formatting?

You can edit existing spreadsheet formulas while preserving template formatting by using openpyxl for modifications and LibreOffice for recalculation. This ensures formula integrity and catches validation errors like #REF! or #DIV/0!.

What is the best way to apply financial modeling conventions to a spreadsheet?

The best way to apply financial modeling conventions is to automate the enforcement of color-coded standards, such as blue for inputs and black for formulas. This ensures strict documentation requirements for model assumptions are met.

Does openpyxl support formula validation and recalculating .xlsm files?

openpyxl supports manipulating .xlsm files, but requires LibreOffice to perform formula validation and recalculation. This combination accurately processes spreadsheet files and identifies calculation errors that openpyxl alone cannot detect.

Why does my spreadsheet automation fail to catch formula errors like #DIV/0!?

Spreadsheet automation fails to catch formula errors like #DIV/0! when only using openpyxl, as it does not calculate formulas. Integrating LibreOffice for formula recalculation and error validation is required to detect these issues accurately.