skills.rest
hidariutiwa
hidariutiwaCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Mar 28, 2026
Search Tags:#data analysis#pandas#openpyxl#spreadsheet#excel#xlsx#formula
One-click install
npx skills add https://github.com/hidariutiwa/flask-learning --skill xlsx-hidariutiwa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hidariutiwa/flask-learning/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/hidariutiwa/flask-learning --skill xlsx-hidariutiwa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing Excel spreadsheets, removing the risk of hardcoded values, formula errors, and inconsistent formatting that lead to hours of revision.

Core Features & Use Cases

  • Full Spreadsheet Lifecycle Support: Create new spreadsheets with formulas and custom formatting, edit existing files while preserving all formulas and template conventions, and analyze tabular data for statistical insights.
  • Financial Modeling Standards: Built-in industry-standard color coding, number formatting, and formula construction rules for building accurate, professional financial projection models.
  • Automated Error Validation: Integrated formula recalculation and scanning to catch errors like #REF!, #DIV/0!, and #VALUE! before finalizing files.
  • Use Case: For example, you can build a multi-sheet sales forecast with linked assumption cells, apply standard blue input/green cross-sheet link formatting, and verify all calculations are error-free in minutes.

Quick Start

Ask the AI to create a monthly sales tracking spreadsheet with SUM formulas for quarterly totals, conditional formatting for values above target, and a summary sheet that pulls data from the monthly tabs.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit existing Excel spreadsheets without breaking formulas and formatting?▼

To create Excel financial models, apply standard industry conventions like blue input cells, green cross-sheet links, and custom number formatting to ensure accurate, professional projections without manual errors.

Can I analyze bulk tabular data from CSV files using pandas?▼

Yes, you can analyze bulk tabular data from .csv and .tsv files using pandas for statistical insights, while using openpyxl to handle formula operations within .xlsx and .xlsm spreadsheet files.

How do I find and fix #REF! and #DIV/0! errors in an Excel spreadsheet?▼

To fix Excel spreadsheet errors like #REF! and #DIV/0!, use integrated formula recalculation and scanning via LibreOffice to validate calculations and identify errors before finalizing the file.

Does this approach support .xlsm and .tsv file formats for spreadsheet analysis?▼

Yes, spreadsheet analysis and modification support .xlsx, .xlsm, .csv, and .tsv file formats, using openpyxl for formula operations and pandas for bulk tabular data processing.

What is the best way to build a multi-sheet financial model with linked assumption cells?▼

The best way to build multi-sheet financial models is automating formula construction with linked assumption cells, applying industry-standard color coding, and validating calculations to eliminate manual errors.

Related Skills

Explore More Data & Analytics Skills→
YouMingYehYouMingYeh
2

xlsx

Clean, transform, and convert spreadsheet files between xlsx, csv, and tsv formats.

Community
Intermediate
mahyarmalekiimahyarmalekii

comps-analysis

Construct Excel comparable company analysis reports with financial metrics and valuation multiples.

Community
Advanced
yuexpsyuexps
3

xlsx-en

Automate Excel spreadsheet analysis, formatting, and formula management with openpyxl and pandas.

Community
Intermediate
claude-office-skillsclaude-office-skills
368

data-analysis

Analyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.

Official
Intermediate