xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas.

Updated Jan 15, 2026
One-click install
npx skills add https://github.com/lips85/antigravity-skills-bootstrap --skill xlsx-lips85
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lips85/antigravity-skills-bootstrap/tree/main/skills/xlsx
Command: npx skills add https://github.com/lips85/antigravity-skills-bootstrap --skill xlsx-lips85

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data, ensuring accuracy and dynamic calculations through robust formula management and data integrity checks.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with complex formulas, formatting, and data validation.
  • Data Analysis & Manipulation: Read, analyze, and modify existing spreadsheets using pandas for data science workflows.
  • Formula Recalculation & Error Checking: Utilizes LibreOffice via recalc.py to ensure all formulas are correctly calculated and to identify/resolve errors like #REF! or #DIV/0!.
  • Use Case: Analyze quarterly sales data from an existing spreadsheet, apply financial forecasting formulas, and ensure all calculations are error-free before generating a final report.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Growth Rate', and add formulas to calculate the monthly growth rate.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I recalculate Excel formulas and check for errors automatically?

To recalculate spreadsheet formulas and check for errors, this Skill uses LibreOffice via `recalc.py` to process files, ensuring calculations are dynamic and identifying issues like `#REF!` or `#DIV/0!`.

Can I use pandas to analyze and modify existing xlsx files?

Yes, you can use pandas to read, analyze, and modify existing spreadsheets. This Skill supports data analysis and manipulation workflows for `.xlsx`, `.xlsm`, `.csv`, and `.tsv` files.

What's the best way to create a new spreadsheet with formulas and formatting?

The best way to create a new spreadsheet with formulas and formatting is using this Skill's dynamic spreadsheet creation feature, which builds `.xlsx` files complete with complex formulas and data validation.

Does this spreadsheet analysis tool support CSV and TSV files?

Yes, this spreadsheet analysis tool supports CSV and TSV files. It facilitates comprehensive operations including creation, editing, and analysis across `.xlsx`, `.xlsm`, `.csv`, and `.tsv` formats.

How do I handle spreadsheet formula errors like #DIV/0! in my data?

To handle spreadsheet formula errors like `#DIV/0!`, the Skill performs mandatory formula recalculation and error verification using LibreOffice, resolving calculation errors before generating final reports.

Why are my spreadsheet formulas not calculating correctly?

Spreadsheet formulas may not calculate correctly if dynamic recalculation is skipped. This Skill enforces mandatory formula recalculation using LibreOffice via `recalc.py` to ensure all calculations are accurate.