xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas.

Updated Mar 5, 2026
One-click install
npx skills add https://github.com/Euraxluo/skill-manager --skill xlsx-euraxluo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Euraxluo/skill-manager/tree/main/library/xlsx
Command: npx skills add https://github.com/Euraxluo/skill-manager --skill xlsx-euraxluo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing spreadsheets, ensuring formulas function correctly and formatting adheres to industry standards for professional deliverables.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Build new .xlsx/.xlsm files or modify existing spreadsheets while preserving existing formulas and formatting, with support for industry-standard financial model color coding and number formatting rules.
  • Data Analysis & Visualization: Use pandas to read, analyze, and export spreadsheet data, plus generate visualizations directly from spreadsheet datasets for quick insights.
  • Formula Error Prevention: Automatically recalculate all Excel formulas using LibreOffice, scan for errors like #REF! or #DIV/0!, and provide detailed error reports to ensure zero-error deliverables. Use Case: If you have a CSV of quarterly sales data, you can use this Skill to build a formatted financial projection model with linked growth rate formulas, then recalculate it to confirm all values are accurate.

Quick Start

Use the xlsx skill to create a formatted sales forecast spreadsheet with linked growth rate formulas from the provided quarterly sales data, and recalculate it to confirm there are no formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and ensure my Excel formulas have no errors?

You can automate spreadsheet creation and verify formulas by programmatically generating .xlsx files and using a recalculation engine to scan for errors like #REF! or #DIV/0!. This builds formatted spreadsheets while verifying all linked formulas compute accurately.

What is the best way to edit existing .xlsx files without breaking their formulas?

The best way to edit existing .xlsx files without breaking formulas is to use a spreadsheet manipulation library that preserves existing formatting and calculations. This allows you to modify data while maintaining the integrity of the original financial models.

How do I convert CSV data into a formatted financial model in Excel?

Converting CSV data into a formatted financial model requires reading the raw data and mapping it into a spreadsheet structure with applied industry-standard color coding and number formatting. You can then implement linked growth rate formulas to build the projection.

Can I use pandas for bulk spreadsheet data analysis and visualization?

Yes, you can use pandas for bulk spreadsheet data analysis by reading .xlsx or .csv datasets directly into dataframes. This allows you to perform data operations and generate visualizations directly from the spreadsheet datasets for quick insights.

Does openpyxl support recalculating Excel formulas and scanning for errors?

openpyxl handles spreadsheet manipulation for creating and editing files, but requires LibreOffice for formula recalculation and error scanning. This combination automatically checks for formula errors to ensure zero-error deliverables.

What are the limitations of using openpyxl for complex financial models?

A limitation of using openpyxl for complex financial models is that it cannot natively recalculate formulas or scan for errors. You must integrate an external engine like LibreOffice to verify calculations and confirm values are accurate.