skills.rest
cdman28
cdman28COMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Feb 27, 2026
Search Tags:#financial modeling#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/cdman28/safe-file-launcher --skill xlsx-cdman28
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cdman28/safe-file-launcher/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/cdman28/safe-file-launcher --skill xlsx-cdman28

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze complex Excel spreadsheets, automating tasks that would otherwise be time-consuming and error-prone.

Core Features & Use Cases

  • Formula Creation & Management: Generate and recalculate intricate Excel formulas, ensuring data accuracy and dynamic updates.
  • Data Analysis & Visualization: Leverage pandas for powerful data manipulation and prepare data for insightful visualizations.
  • Formatting & Styling: Apply industry-standard formatting, color-coding, and number conventions for professional financial models.
  • Use Case: Automatically generate a financial projection model in Excel, complete with assumptions, formulas, and standard formatting, based on provided business metrics.

Quick Start

Use the xlsx skill to create a new Excel file 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 spreadsheet with formulas and formatting from scratch?▼

To create an Excel spreadsheet with formulas and formatting, use this Skill to generate new .xlsx files complete with industry-standard styling, dynamic formulas, and populated data based on your provided metrics.

Can I modify an existing Excel file without breaking its formulas?▼

Yes, you can modify existing Excel spreadsheets while preserving formulas. The Skill reads and edits .xlsx or .xlsm files, ensuring your original formula logic and data structures remain intact during updates.

Does this tool support data analysis and visualization for financial modeling?▼

Yes, this tool supports data analysis and visualization for financial modeling by leveraging pandas for data manipulation, preparing your spreadsheet data for insightful visualizations and accurate reporting.

How do I recalculate Excel formulas automatically outside of the Excel application?▼

To recalculate Excel formulas automatically outside of the application, this Skill uses LibreOffice to process and re-evaluate intricate formulas, ensuring data accuracy and dynamic updates within your .xlsx files.

What is the best way to parse and analyze CSV or TSV files for financial reporting?▼

The best way to parse and analyze CSV or TSV files for financial reporting is using this Skill, which leverages pandas to read, manipulate, and analyze tabular data before exporting to a formatted Excel spreadsheet.

Do I need pandas and openpyxl to automate Excel spreadsheet operations?▼

Yes, you need pandas and openpyxl to automate Excel spreadsheet operations. This Skill uses pandas for data analysis and openpyxl for handling .xlsx file creation, formatting, and formula management.

Related Skills

Explore More Finance & Accounting Skills→
thanhquan3010thanhquan3010

spreadsheet

Automate creation, editing, and analysis of spreadsheet files with formulas.

Community
Intermediate
fantay0312fantay0312

xlsx

Create and edit Excel spreadsheets with formulas via LibreOffice recalculation.

Community
Advanced
safzanpiranisafzanpirani
1

xlsx

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

Community
Advanced
jiyangnanjiyangnan
2

xlsx

Create, read, edit, and analyze Excel spreadsheets with openpyxl and pandas.

Community
Intermediate