Which Python libraries are used for spreadsheet tasks?

The skill primarily uses openpyxl for .xlsx manipulation and formatting, and pandas for high-performance data analysis and CSV/TSV processing.

Does it support professional financial formatting?

Absolutely. The skill includes specific requirements for Investment Banking layouts, including header styling, unit specifications, and color-coding conventions (blue for inputs, black for formulas).

Can this skill handle complex Excel formulas?

Yes, it creates and preserves formulas for derived values. While openpyxl does not evaluate the results internally, the formulas remain intact and will calculate correctly when the file is opened in Excel or Google Sheets.

How can I verify the layout of the generated spreadsheet?

If LibreOffice and Poppler are installed, the skill can render sheets into PDF or PNG files, allowing Claude to visually inspect the layout and formatting before finalizing the task.

Spreadsheet Management & Data Analysis

Name: Spreadsheet Management & Data Analysis
Author: payolajoker

bypayolajoker

0•

Data Science & ML

Creates, edits, and analyzes complex spreadsheets while preserving formulas, formatting, and professional layouts using Python libraries.

This skill empowers Claude to handle sophisticated spreadsheet tasks involving .xlsx, .csv, and .tsv files by leveraging the power of openpyxl and pandas. It goes beyond simple data entry by maintaining cell formulas, implementing professional formatting standards (including Investment Banking layouts), and generating visual previews for verification. Whether you are building complex financial models, performing deep data analysis, or automating report generation, this skill ensures data integrity and aesthetic consistency throughout the automation workflow.

Key Features

010 GitHub stars

02Professional formatting with support for Investment Banking and financial modeling layouts.

03Automated styling conventions including standardized color-coding for inputs, formulas, and constants.

04Advanced data analysis, filtering, and aggregation using integrated pandas workflows.

05Maintains and validates complex Excel formulas and cell references without breaking existing logic.

06Visual verification through headless rendering of spreadsheets to PDF and PNG formats.

Use Cases

01Transforming raw CSV data into formatted, executive-ready Excel reports with charts.

02Generating automated financial models such as LBO, DCF, or 3-statement valuation layouts.

03Modifying existing workbooks to update data points while preserving legacy formatting and styling.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add payolajoker/ai-agent-setting spreadsheet

For use in Claude.ai and ChatGPT

Download Skill