skills.rest
kcaldas
kcaldasCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and formatting.

12|Updated Jun 16, 2025
Search Tags:#data analysis#formulas#spreadsheet#excel#xlsx#csv
One-click install
npx skills add https://github.com/kcaldas/genie --skill xlsx-kcaldas
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kcaldas/genie/tree/main/.genie/skills/xlsx
Command: npx skills add https://github.com/kcaldas/genie --skill xlsx-kcaldas

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, and analysis of spreadsheet files (.xlsx, .csv, .tsv), freeing you from manual data manipulation and complex formula management.

Core Features & Use Cases

  • Spreadsheet Creation: Generate new spreadsheets with formulas and formatting.
  • Data Analysis: Read, analyze, and visualize data using powerful libraries like pandas.
  • Formula Management: Ensure formulas are correctly written, preserve existing ones, and recalculate them reliably.
  • Use Case: You need to analyze sales data from a CSV file, calculate growth percentages, and present the findings in a formatted Excel report, all while ensuring all calculations are dynamic.

Quick Start

Create an Excel file named 'sales_report.xlsx' with columns 'Date', 'Sales', and 'Profit'. Add a formula in cell C2 to calculate profit as Sales * 0.15.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet with formulas and formatting?▼

Use this Skill to generate .xlsx files with dynamic formulas and industry-standard formatting. It automates spreadsheet creation, applies formulas for all calculations, and preserves formatting conventions so your data stays accurate and professional.

Can I read and analyze data from CSV and Excel files together?▼

Yes. This Skill reads .csv, .tsv, and .xlsx files, analyzes data using pandas, and lets you work with multiple formats in a single workflow. It handles data extraction and analysis across all three formats seamlessly.

How do I preserve formulas when editing an existing Excel workbook?▼

This Skill modifies existing .xlsx and .xlsm files while keeping formulas intact and recalculating them correctly. It ensures zero formula errors and maintains your original template structure during edits.

What's the best way to automate data analysis and reporting with spreadsheets?▼

Combine spreadsheet creation, formula management, and data visualization in one workflow. This Skill automates the full pipeline—read data, calculate metrics with formulas, format results, and generate formatted Excel reports without manual steps.

Do I need to manually recalculate formulas after editing a spreadsheet?▼

No. This Skill includes automated formula recalculation via the recalc.py script, so formulas update dynamically after edits. All calculations stay current without requiring manual refresh.

Can this handle complex data analysis tasks like calculating growth percentages?▼

Yes. Using pandas and openpyxl, this Skill performs data analysis and calculation tasks—like growth percentages, profit margins, and aggregations—within formatted Excel reports with full formula support.

Related Skills

Explore More Data & Analytics Skills→
stevessrstevessr

xlsx

Open, clean, format, and transform spreadsheet data across XLSX, CSV, and TSV inputs.

Community
Intermediate
ToXMonToXMon

domino-launchers

Create parameterized web launchers for Domino jobs with typed inputs and result storage.

Community
Intermediate
nirajrathod19nirajrathod19

excel-generator

Generate .xlsx Excel spreadsheets with Python using openpyxl and xlsxwriter.

Community
Intermediate
tkhongsaptkhongsap
1

xlsx

Create and edit Excel spreadsheets with formulas and formatting.

Community
Advanced