skills.rest
Fergana-Labs
Fergana-LabsOFFICIAL
Explore all skills by this author →
GitHub

xlsx

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

27|3|Updated Nov 6, 2025
Search Tags:#automation#financial modeling#data analysis#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/Fergana-Labs/claude_agent_desktop --skill xlsx-fergana-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Fergana-Labs/claude_agent_desktop/tree/main/plugins/skills/xlsx
Command: npx skills add https://github.com/Fergana-Labs/claude_agent_desktop --skill xlsx-fergana-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manual spreadsheet work, formula errors, and complex data analysis steal valuable time. This Skill automates these tedious tasks, ensuring accuracy and freeing you to focus on strategic decisions.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new spreadsheets with complex formulas and precise formatting, ensuring data integrity from the start.
  • Advanced Data Analysis & Visualization: Effortlessly read, analyze, and visualize large datasets from various spreadsheet formats (e.g., .xlsx, .csv) using powerful tools like pandas.
  • Error-Free Modifications: Safely modify existing spreadsheets, preserving formulas and automatically validating for common errors like #REF! or #DIV/0!.
  • Use Case: Imagine you need to consolidate monthly sales data from multiple CSVs into a single, dynamic Excel dashboard. This Skill can automate the entire process: importing data, applying complex financial formulas, generating summary tables, and creating interactive charts, all while guaranteeing zero formula errors.

Quick Start

Create a new Excel file named 'quarterly_report.xlsx'. Add a sheet named 'Sales Data' and populate it with columns 'Month', 'Revenue', 'Expenses'. Add 3 months of dummy data. In a new column 'Profit', add a formula to calculate Revenue - Expenses. Ensure all formulas are recalculated.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation with formulas and formatting?▼

Automate spreadsheet creation by using openpyxl to generate new .xlsx files with formulas, formatting, and data in a single workflow. Define columns, apply financial formulas like profit calculations, and enforce color and number formatting to ensure accuracy from the start.

Can I modify existing Excel templates without breaking formulas?▼

Yes, safely modify existing spreadsheets while preserving formulas and validating for errors like #REF! or #DIV/0!. The Skill maintains template conventions and automatically recalculates formulas using LibreOffice to guarantee zero formula errors after edits.

What's the best way to consolidate data from multiple CSV files into Excel?▼

Import multiple CSV or TSV files using pandas, merge datasets into a single .xlsx workbook, apply formulas for calculations, and generate summary tables. This approach automates data consolidation while maintaining formula integrity across the entire workbook.

How do I analyze large datasets in spreadsheets with pandas and openpyxl together?▼

Read and analyze data from .xlsx, .csv, and .tsv formats using pandas for statistical operations, then write results back to Excel with openpyxl to preserve formulas and formatting. This combined approach enables in-workbook data analysis and visualization workflows.

Does this work with .xlsm macro-enabled files and .csv formats?▼

Yes, the Skill supports .xlsx, .xlsm, .csv, and .tsv formats for reading, creating, and modifying spreadsheets. Macro-enabled files preserve structure, and CSV imports integrate seamlessly into Excel workflows with formula application and recalculation.

What happens if formulas contain errors after I modify a spreadsheet?▼

The Skill automatically validates for formula errors including #REF!, #DIV/0!, and similar issues after modifications. Recalculate formulas using recalc.py with LibreOffice to ensure all calculations resolve correctly before export.

Related Skills

Explore More Finance & Accounting Skills→
Chanw-researchChanw-research
38

xlsx

Prepare and clean spreadsheet files in xlsx, xlsm, csv, or tsv formats.

Official
Intermediate
invariantlabs-aiinvariantlabs-ai
2.9k

xlsx

Create, edit, and analyze Excel workbooks with formula preservation and recalculation.

Official
Advanced
ironkid90ironkid90

xlsx

Manage and analyze Excel files using pandas and openpyxl.

Community
Advanced
tassiovaletassiovale
13

xlsx

Automate Excel spreadsheet operations with Python and openpyxl.

Community
Advanced