Can I use this for Investment Banking style models?

Absolutely. It includes specific requirements for IB layouts, including distinct color conventions, header formatting, and standardized financial cell styles.

How does it handle visual verification?

If LibreOffice and Poppler are available, the skill can render sheets to PDF or PNG to check for layout issues, clipping, or inconsistent styles before final delivery.

Does this skill support Excel formulas?

Yes, it specifically prioritizes using formulas for derived values rather than hardcoding results, ensuring workbooks remain dynamic and auditable.

Which file formats can I work with?

The skill supports .xlsx, .csv, and .tsv formats, utilizing openpyxl for Excel-specific features and pandas for robust tabular data analysis.

What Python libraries are required?

The skill primarily relies on openpyxl and pandas. It recommends using 'uv' for dependency management, but standard pip installation also works.

Spreadsheet & Data Analysis Automation

This skill empowers Claude to handle complex spreadsheet tasks involving Excel, CSV, and TSV files with a focus on data integrity and professional formatting. It leverages openpyxl and pandas to perform deep analysis, build financial models, and create native Excel charts while strictly adhering to best practices like using formulas for derived values, maintaining stable layouts, and performing visual reviews through PDF rendering. Whether you are generating periodic reports or building investment banking-style financial models, this skill ensures consistent, error-free spreadsheet outputs.

Características Principales

01Professional formatting standards including Investment Banking (IB) style layouts

02707 GitHub stars

03Formula-aware workflows that prioritize dynamic calculations over hardcoding

04Automated workbook creation and editing using openpyxl and pandas

05Integrated visual review via PDF/PNG rendering for layout verification

06Advanced data analysis, filtering, and pivot table generation from tabular data

Casos de Uso

01Building automated financial models with standard color-coding and linked references

02Generating periodic data reports from raw CSV/TSV logs into formatted Excel workbooks

03Analyzing large datasets to create summary tables and native Excel visualizations

Tieline — product intent grounded in code

Spreadsheet & Data Analysis

Características Principales

Casos de Uso

Sherpa ONNX Local Text-to-Speech

Humanity Score Checker

Gget Bioinformatics Toolkit

Características Principales

Casos de Uso