skills.rest
nimeshgurung
nimeshgurungCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx files with formulas and formatting.

1|Updated Nov 17, 2025
Search Tags:#financial modeling#data analysis#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/nimeshgurung/artifact-hub-collections --skill xlsx-nimeshgurung
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/nimeshgurung/artifact-hub-collections/tree/main/skills/raw/anthropics/skills/document-skills/xlsx
Command: npx skills add https://github.com/nimeshgurung/artifact-hub-collections --skill xlsx-nimeshgurung

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, handling complex formulas, formatting, and data manipulation tasks efficiently.

Core Features & Use Cases

  • Formula Creation & Management: Generate and manage complex Excel formulas, ensuring accuracy and adherence to best practices.
  • Data Analysis & Visualization: Analyze data within spreadsheets using Python libraries and prepare it for visualization.
  • Formatting & Styling: Apply industry-standard color coding and number formatting to financial models and other spreadsheets.
  • Use Case: Automatically generate a financial projection model in Excel, complete with accurate formulas, industry-standard formatting, and clear assumption documentation.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with sample data.

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 financial model with formulas and formatting?▼

You can create an Excel financial model by using this skill to generate .xlsx files complete with formula management via openpyxl, data analysis through pandas, and industry-standard color coding.

What's the best way to automate spreadsheet updates and data reporting?▼

Automate spreadsheet updates by using this skill for dynamic data manipulation and reporting, leveraging pandas for data analysis and openpyxl to apply formatting and formulas within .xlsx files.

Do I need pandas and openpyxl to manage Excel formulas?▼

Yes, you need pandas for data analysis and openpyxl for formula and formatting control within .xlsx files, while LibreOffice handles formula recalculation via recalc.py to ensure accurate results.

Can I apply industry-standard formatting to financial projections in Excel?▼

Yes, you can apply industry-standard color coding and number formatting to financial projections, ensuring accurate formulas and clear assumption documentation are embedded directly within the .xlsx file.

How does spreadsheet formula recalculation work with LibreOffice?▼

Formula recalculation works by processing the generated .xlsx files through recalc.py, which uses LibreOffice to compute and update formula values accurately for your financial models.

Related Skills

Explore More Finance & Accounting Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

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

Community
Intermediate
stromy-orgstromy-org

format-xlsx

Automate spreadsheet creation, editing, and analysis with formulas and visualization.

Official
Advanced
logeshv586-codelogeshv586-code

xlsx

Analyze spreadsheet data and create charts with openpyxl, pandas, and matplotlib.

Community
Advanced
vinayakgvinayakg

xlsx

Create and edit Excel files with formulas, formatting, and pandas analysis.

Community
Advanced