skills.rest
xu-mengnan
xu-mengnanCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Nov 9, 2025
Search Tags:#formatting#data analysis#spreadsheet#excel#xlsx#csv#formula
One-click install
npx skills add https://github.com/xu-mengnan/bilibili --skill xlsx-xu-mengnan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/xu-mengnan/bilibili/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/xu-mengnan/bilibili --skill xlsx-xu-mengnan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing spreadsheets, removing the need to manually handle formulas, formatting, and data calculations.

Core Features & Use Cases

  • Comprehensive Spreadsheet Operations: Create new spreadsheets with custom formulas and formatting, edit existing files while preserving original templates and formulas, and analyze spreadsheet data for actionable insights.
  • Error Prevention & Recovery: Enforces zero formula error requirements, includes formula verification checklists, and uses automated recalculation tools to fix common errors like #REF! and #DIV/0!.
  • Use Case: If you have a CSV of monthly sales data, use this Skill to generate a formatted Excel tracker with automatic sum, growth rate, and average formulas, no manual formula writing required.

Quick Start

Use the xlsx skill to create a formatted sales performance spreadsheet from the provided monthly sales CSV file, with automatic total and growth rate formulas applied.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automatically create an Excel spreadsheet with formulas from a CSV file?▼

To create an Excel spreadsheet with formulas from a CSV file, this skill automates the generation of formatted .xlsx files, applying custom formulas like sums and growth rates without manual input.

Can I edit existing Excel files while preserving original templates and formatting?▼

Yes, you can edit existing .xlsx and .xlsm files while preserving original templates, as this skill enforces custom formatting standards and maintains template conventions during modifications.

What is the best way to fix formula errors like #REF! and #DIV/0! in spreadsheets?▼

The best way to fix formula errors like #REF! and #DIV/0! is using automated recalculation tools, which enforce a zero formula error requirement through verification checklists and recovery mechanisms.

Does this spreadsheet automation approach support financial modeling color coding standards?▼

Yes, this approach supports financial modeling by enforcing custom formatting and specific color coding standards, ensuring error-free spreadsheet modeling and compliance with established conventions.

How do I analyze spreadsheet data across different formats like .csv and .tsv?▼

To analyze spreadsheet data across .csv and .tsv formats, this skill processes multiple file types to extract actionable insights, applying formulas and custom formatting to streamline data analysis workflows.

Related Skills

Explore More Data & Analytics Skills→
alijilani-devalijilani-dev
1

xlsx

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

Community
Advanced
beyondkmpbeyondkmp
1

Excel Analysis

Analyze Excel .xlsx data with Python pandas using groupby and pivot tables.

Community
Intermediate
snake-dev-teamsnake-dev-team

ck:xlsx

Manages Excel file creation, editing and analysis with pandas and openpyxl.

Official
Advanced
groeimetaigroeimetai
77

reporting-dashboards

Create and manage reports and dashboards within the ServiceNow platform.

Community
Intermediate