Does Claude evaluate the results of formulas within the skill?

No, openpyxl does not evaluate formulas. The formulas are written to the file and will calculate automatically when the file is opened in Excel or Google Sheets.

How does the skill handle visual review of spreadsheets?

If system tools like LibreOffice and Poppler are available, the skill can render sheets into PNG images for Claude to visually inspect the layout and formatting.

Can this skill modify existing Excel files without breaking formulas?

Yes, the skill is specifically designed to use openpyxl to edit workbooks while preserving existing formulas, references, and styles.

Can I use this skill for investment banking style formatting?

Absolutely. The skill includes specific instructions for IB-style layouts, including specific color conventions (blue for inputs, black for formulas) and header formatting.

Spreadsheet Automation & Analysis

Name: Spreadsheet Automation & Analysis
Author: jjeremycai

byjjeremycai

0•

Data Science & ML

Automates the creation, editing, and professional analysis of spreadsheets using Python-based tools while preserving complex formulas and layouts.

This skill empowers Claude to act as a data analyst and spreadsheet architect by leveraging openpyxl and pandas. It handles everything from simple CSV data manipulation to the construction of complex, formatted Excel workbooks featuring professional investment banking-style layouts, native charts, and preserved formulas. By integrating visual rendering capabilities, it ensures that layout accuracy is maintained even when working within headless environments, making it ideal for financial modeling, automated reporting, and large-scale data processing.

Key Features

01Native Excel chart generation using openpyxl.chart

020 GitHub stars

03Visual verification through PDF and PNG rendering of sheets

04Supports .xlsx, .csv, and .tsv formats with formula preservation

05Professional formatting including IB-style layouts and color-coded conventions

06Advanced data analysis, filtering, and pivoting via pandas

Use Cases

01Cleaning and aggregating large datasets into structured reports

02Building automated financial models and investment banking valuations

03Generating formatted business dashboards with native spreadsheet visualizations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jjeremycai/claudekit spreadsheet

For use in Claude.ai and ChatGPT

Download Skill