Can this skill modify my existing Excel templates?

Yes. The skill is specifically designed to study and match your existing formatting, styles, and conventions to ensure seamless updates without breaking your template's layout.

Why is it better to use formulas instead of hardcoding values?

Using formulas ensures the spreadsheet remains dynamic. If you change a source value later in Excel, the totals and calculations will update automatically, which wouldn't happen with hardcoded values.

Does it support industry-standard financial formatting?

Absolutely. It follows standard conventions such as blue text for hardcoded inputs, black for formulas, and green for internal sheet links, unless otherwise specified.

How does it ensure formulas are correct before I download the file?

It uses a built-in recalculation script via LibreOffice that scans every cell for errors like #REF! or #NAME?, allowing the AI to identify and fix issues automatically.

What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv files for both reading and writing operations.

XLSX & Spreadsheet Agent

Name: XLSX & Spreadsheet Agent
Author: partme-ai

bypartme-ai

•

Data Science & ML

Automates professional spreadsheet creation, financial modeling, and data analysis with strict formula integrity and industry-standard formatting.

The XLSX & Spreadsheet Agent is a high-fidelity skill that enables Claude to perform complex spreadsheet operations, ranging from simple data entry to sophisticated financial modeling. It emphasizes the use of dynamic formulas over hardcoded values and includes an automated recalculation engine to ensure zero formula errors. Designed for professional environments, it enforces industry-standard color coding, precise number formatting, and detailed source documentation, making it an essential tool for automated reporting, data visualization, and large-scale data manipulation across .xlsx, .xlsm, and CSV formats.

Key Features

01Industry-standard financial modeling with automated color-coding (Blue for inputs, Black for formulas).

02Dynamic spreadsheet generation that prioritizes live Excel formulas over static Python-calculated values.

03Template preservation logic that matches existing formatting and conventions when updating files.

04Deep data analysis and visualization capabilities using pandas and openpyxl integration.

0537 GitHub stars

06Zero-tolerance formula error prevention (#REF!, #DIV/0!, #VALUE!) via integrated recalculation scripts.

Use Cases

01Updating legacy spreadsheets while maintaining complex formatting and existing formula structures.

02Automating the migration and cleaning of large datasets into formatted Excel reports with charts.

03Building dynamic financial projection models with automated assumptions and source citations.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add partme-ai/full-stack-skills xlsx-agent

For use in Claude.ai and ChatGPT

Download Skill