skills.rest
wangx7
wangx7COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit .xlsx, .xlsm, .csv, and .tsv files with formulas and formatting.

Updated Jun 26, 2026
Search Tags:#financial modeling#pandas#openpyxl#formulas#spreadsheet#excel#data cleaning
One-click install
npx skills add https://github.com/wangx7/skills-collection --skill xlsx-wangx7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wangx7/skills-collection/tree/main/anthropics-skills/skills/xlsx
Command: npx skills add https://github.com/wangx7/skills-collection --skill xlsx-wangx7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

This Skill solves the challenges of working with spreadsheet files as primary inputs or outputs, where manual formatting, formula errors, and inconsistent standards often lead to unreliable models and time-consuming fixes. It ensures deliverables meet professional standards for fonts, color coding, number formatting, and formula integrity.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Build new .xlsx/.xlsm/.csv/.tsv files or modify existing ones using pandas and openpyxl, with full support for formulas, formatting, and multi-sheet workbooks.
  • Financial Modeling Standards: Enforce industry-standard color conventions (blue for inputs, black for formulas, green for internal links, red for external links, yellow for key assumptions) and precise number formatting for currency, percentages, and multiples.
  • Data Cleaning & Transformation: Restructure messy tabular data with malformed rows, misplaced headers, or junk data into clean, properly formatted spreadsheets.
  • Formula Integrity & Recalculation: Automatically recalculate all formulas using LibreOffice, scan for errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?), and provide detailed error reporting with locations.

Quick Start

Use the xlsx skill to create a new financial model from the sales data in 'sales_data.csv' with proper formatting and formulas, then recalculate and verify there are no errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula recalculation and scan for spreadsheet errors?▼

Automate Excel formula recalculation by running LibreOffice to recompute all formulas, then scan spreadsheets for errors like #REF!, #DIV/0!, and #VALUE!, providing detailed location reporting to ensure zero-formula-error standards.

What is the best way to apply financial modeling color conventions to an xlsx file?▼

Apply financial modeling color conventions to xlsx files by programmatically setting fonts using openpyxl: blue for inputs, black for formulas, green for internal links, red for external links, and yellow for key assumptions to meet professional industry standards.

Can I use pandas and openpyxl to clean messy CSV data into formatted spreadsheets?▼

Use pandas and openpyxl to clean messy CSV data by restructuring malformed rows, fixing misplaced headers, and removing junk data, transforming the output into clean, properly formatted spreadsheets with precise number formatting.

Does this spreadsheet automation approach support both .xlsm and .tsv file formats?▼

This spreadsheet automation approach supports .xlsm and .tsv file formats, alongside .xlsx and .csv, allowing you to create, edit, and analyze tabular data workflows while maintaining full formula integrity across these formats.

How do I build a financial model from a CSV file without manual formatting?▼

Build a financial model from a CSV file by using automation to generate new spreadsheets with formulas, enforce industry color-coding conventions, apply precise currency and percentage formatting, and automatically verify formula integrity.

Why do my spreadsheet formulas show errors after automated data cleaning?▼

Spreadsheet formulas show errors after automated data cleaning due to broken references or invalid operations; running a comprehensive error scan identifies exact locations of #N/A or #NAME? issues to enforce zero-formula-error deliverables.

Related Skills

Explore More Finance & Accounting Skills→
JosephWoodallJosephWoodall
1

xlsx

Process and transform XLSX, CSV, and TSV spreadsheets using openpyxl.

Community
Intermediate
eesha000009-deveesha000009-dev
1

xlsx

Create and edit .xlsx spreadsheets with preserved formulas and formatting.

Community
Advanced
xlsamaxlsama

xlsx

Create, edit, and analyze spreadsheet files using pandas and openpyxl.

Community
Advanced
xu-mengnanxu-mengnan

xlsx

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

Community
Advanced