skills.rest
bhisoftware
bhisoftwareCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas and pandas.

Updated Aug 27, 2026
Search Tags:#financial modeling#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/bhisoftware/page-refresh --skill xlsx-bhisoftware
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/bhisoftware/page-refresh/tree/main/library/bhi-claude-skills/spreadsheets
Command: npx skills add https://github.com/bhisoftware/page-refresh --skill xlsx-bhisoftware

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 spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with advanced formula management, data manipulation, and visualization capabilities, eliminating manual errors and saving significant time.

Core Features & Use Cases

  • Formula Creation & Management: Generate complex formulas, ensure zero formula errors, and preserve existing templates.
  • Data Analysis & Visualization: Utilize pandas for data manipulation, analysis, and generating insights from spreadsheet data.
  • Use Case: Automatically generate a financial projection model in Excel, complete with industry-standard color coding, number formatting, and dynamic formulas that can be updated with new assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet with columns for 'Product' and 'Sales', add rows of sample data, and include a formula in the 'Total Sales' column that sums the sales 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 dynamic formulas and color coding?▼

Excel financial modeling with dynamic formulas and strict color-coding standards is generated automatically. It creates .xlsx files with zero formula errors, utilizing pandas for data manipulation and LibreOffice for recalculation checks.

Can I use pandas to edit and analyze existing .xlsx spreadsheet files?▼

Yes, pandas is used to edit and analyze existing .xlsx spreadsheet files. It enables comprehensive data manipulation, analysis, and insight generation while preserving your existing spreadsheet templates and formulas.

Does openpyxl support generating complex formulas without manual errors?▼

Openpyxl supports generating complex formulas without manual errors by automating formula creation and management. It ensures zero formula errors and preserves existing templates during spreadsheet editing and creation tasks.

What is the best way to automate data analysis for .csv and .tsv files?▼

The best way to automate data analysis for .csv and .tsv files is using pandas for data manipulation. This approach enables comprehensive spreadsheet operations including creation, editing, and analysis across multiple file formats.

How do spreadsheet error checking and formula recalculation work in automated workflows?▼

Spreadsheet error checking and formula recalculation work by using LibreOffice to validate formulas. This ensures zero formula errors are present in the generated .xlsx and .xlsm files before finalizing data manipulation tasks.

Related Skills

Explore More Finance & Accounting Skills→
zjy-devzjy-dev
2

xlsx

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

Community
Advanced
danieldekaydanieldekay
1

xlsx

Automate spreadsheet creation, editing, and analysis across Excel-compatible formats.

Community
Advanced
georgekhananaevgeorgekhananaev
27

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

Community
Advanced
7126112171261121

xlsx

Create, edit, and analyze Excel spreadsheet files with formulas and formatting.

Community
Advanced