skills.rest
rustykuntz
rustykuntzCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx and .csv spreadsheets with pandas and LibreOffice.

1|Updated Feb 15, 2026
Search Tags:#financial modeling#data analysis#pandas#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/rustykuntz/rocie-tools --skill xlsx-rustykuntz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rustykuntz/rocie-tools/tree/main/skills/xlsx
Command: npx skills add https://github.com/rustykuntz/rocie-tools --skill xlsx-rustykuntz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, libreoffice, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data efficiently, handling everything from complex formulas and formatting to data analysis and visualization.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Data Analysis: Leverage pandas for in-depth data manipulation, statistical analysis, and generating insights.
  • Formula Recalculation & Verification: Ensure all formulas are error-free and accurately calculated using LibreOffice.
  • Use Case: Automatically generate a financial projection model, populate it with assumptions, apply industry-standard formatting, and verify all calculations are correct before delivery.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add the formula '=SUM(C2:C10)' to cell C1.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate financial modeling and spreadsheet creation with Python?▼

You can automate spreadsheet creation by generating .xlsx files, populating them with assumptions, applying formatting, and verifying formula calculations using pandas and LibreOffice recalculation.

How do I ensure formula integrity and recalculate xlsx files outside of Excel?▼

To ensure formula integrity, LibreOffice recalculation is used to verify that all formulas in your xlsx files are error-free and accurately calculated without needing Microsoft Excel.

Do I need pandas and openpyxl to analyze spreadsheet data?▼

Yes, pandas and openpyxl are required dependencies to leverage in-depth data manipulation, statistical analysis, and editing capabilities for .xlsx and .csv spreadsheet files.

Can I format spreadsheets and apply formulas to existing csv files?▼

Yes, you can edit existing spreadsheet files by adding formulas like =SUM(C2:C10), applying industry-standard formatting, and performing data manipulation on both .xlsx and .csv formats.

What is the best way to generate a financial projection model and verify calculations?▼

The best way is to generate a financial projection model, populate it with assumptions, apply formatting, and use LibreOffice to verify all calculations are correct before delivery.

Are there limitations when using LibreOffice for spreadsheet formula recalculation?▼

While LibreOffice handles formula recalculation and verification, its recalculation engine may differ slightly from Microsoft Excel's native engine for highly complex or specialized financial formulas.

Related Skills

Explore More Finance & Accounting Skills→
Ced3-hanCed3-han

xlsx

Automates Excel file operations and data analysis using pandas and LibreFormula.

Community
Advanced
MooseGoose0701MooseGoose0701
1.1k

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.

Community
Intermediate
RamanEbrahimiRamanEbrahimi
3

xlsx

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

Community
Advanced
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced