xlsx

Create, edit, analyze, and validate Excel spreadsheet files with pandas and openpyxl.

96|1|Updated Jun 4, 2026
One-click install
npx skills add https://github.com/langbyyi/CyberStrikeAI-SRC --skill xlsx-langbyyi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/langbyyi/CyberStrikeAI-SRC/tree/main/skills/xlsx
Command: npx skills add https://github.com/langbyyi/CyberStrikeAI-SRC --skill xlsx-langbyyi

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Working with Excel and spreadsheet files often requires specialized knowledge of formatting standards, formula syntax, and data cleaning techniques. This Skill provides an AI-powered assistant that handles the full lifecycle of spreadsheet operations, from creating professional workbooks to analyzing messy data and validating complex financial models.

Core Features & Use Cases

  • Professional Spreadsheet Creation: Build .xlsx files from scratch or from data sources using openpyxl, with support for formulas, formatting, and industry-standard financial model conventions.
  • Data Analysis & Cleaning: Read and analyze .xlsx, .csv, .tsv, and .xlsm files using pandas, handling malformed rows, misplaced headers, and junk data to produce clean, structured spreadsheets.
  • Formula Management & Validation: Ensure zero formula errors with mandatory LibreOffice recalculation, comprehensive error scanning for #REF!, #DIV/0!, #VALUE!, and other Excel errors.
  • Financial Modeling Standards: Apply color-coded inputs (blue), formulas (black), cross-sheet links (green), and external links (red), with proper number formatting and assumption documentation.
  • Use Case: A data analyst receives a messy CSV of sales records with missing headers and inconsistent formatting. This Skill cleans the data, creates a properly formatted Excel workbook with pivot tables and charts, and validates all formulas for errors.

Quick Start

Use the xlsx skill to analyze the attached 'sales_data.xlsx' file and generate a formatted summary report with pivot tables.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel file creation from messy CSV data?

To automate Excel file creation from messy CSV data, this tool uses pandas to clean misplaced headers and malformed rows, then applies openpyxl to generate a formatted .xlsx workbook with structured data, pivot tables, and charts.

Can I validate Excel formulas and check for errors like #REF! automatically?

Yes, you can validate Excel formulas and check for errors like #REF! automatically by running mandatory LibreOffice recalculation, which scans the workbook to detect #DIV/0!, #VALUE!, and other formula errors deterministically.

Does openpyxl support applying financial modeling standards to spreadsheets?

Yes, openpyxl supports applying financial modeling standards to spreadsheets by enforcing color-coded inputs (blue), formulas (black), cross-sheet links (green), and external links (red) alongside proper number formatting and assumption documentation.

What is the best way to convert between xlsx, csv, and tsv formats?

The best way to convert between .xlsx, .csv, and .tsv formats is to use pandas for data manipulation and openpyxl for spreadsheet control, enabling seamless conversion between tabular formats for business and administrative workflows.

Do I need LibreOffice to recalculate formulas in an xlsx workflow?

Yes, you need LibreOffice to recalculate formulas in an xlsx workflow because it provides deterministic formula recalculation and comprehensive error detection that ensures zero formula errors before finalizing the spreadsheet.

Why does pandas drop rows when reading a malformed spreadsheet?

Pandas may drop rows when reading a malformed spreadsheet due to inconsistent column counts or misplaced headers, but this tool handles junk data and malformed rows to produce clean, structured spreadsheets without losing valid records.