What file formats are supported?

The skill supports a wide range of spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv.

Can I use this for professional financial modeling?

Yes, it includes built-in standards for financial modeling, including industry-standard color-coding for inputs, formulas, and external links.

Will it break my existing Excel templates?

No, the skill is designed to study and match existing formats, styles, and conventions when modifying established files to ensure consistency.

Does this skill support Excel formulas or just static data?

It specifically prioritizes Excel formulas over hardcoded values to ensure spreadsheets remain dynamic and updateable by the user.

How does the skill ensure there are no formula errors?

The skill uses a dedicated recalculation script (recalc.py) that utilizes LibreOffice to evaluate formulas and verify that no errors like #REF! or #DIV/0! exist.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: partme-ai

bypartme-ai

•

Data Science & ML

Automates professional spreadsheet creation, editing, and data analysis with a focus on formula integrity and financial modeling standards.

About

The xlsx skill enables Claude to perform high-level spreadsheet engineering, from basic data processing to building complex, production-grade financial models. It leverages powerful Python libraries like pandas and openpyxl to manipulate .xlsx, .xlsm, and .csv files while ensuring that all calculations remain dynamic through Excel formulas rather than hardcoded results. By integrating a dedicated recalculation script powered by LibreOffice, the skill guarantees zero-error outputs (#REF!, #DIV/0!) and maintains strict adherence to industry-standard formatting conventions, making it an essential tool for automated reporting, data visualization, and template management.

Key Features

Advanced data analysis and visualization using pandas and openpyxl
37 GitHub stars
Professional financial modeling standards for color-coding and cell formatting
Automated error detection for formula references and division by zero
Template preservation that matches existing styles and structural conventions
Dynamic formula creation and automated recalculation using LibreOffice

Use Cases

Transforming raw data sets into formatted Excel dashboards with charts and summaries
Generating automated financial reports with dynamic projections and standardized styling
Modifying legacy spreadsheets while preserving complex existing formulas and templates

About

Key Features

Advanced data analysis and visualization using pandas and openpyxl
37 GitHub stars
Professional financial modeling standards for color-coding and cell formatting
Automated error detection for formula references and division by zero
Template preservation that matches existing styles and structural conventions
Dynamic formula creation and automated recalculation using LibreOffice

Use Cases

Transforming raw data sets into formatted Excel dashboards with charts and summaries
Generating automated financial reports with dynamic projections and standardized styling
Modifying legacy spreadsheets while preserving complex existing formulas and templates