How does this skill handle Excel formula errors?

The skill includes a mandatory recalculation process using a LibreOffice-powered script that identifies and reports errors like #REF!, #DIV/0!, and #VALUE!, ensuring zero-error delivery.

How do I add diagrams to my spreadsheets?

The skill integrates with scientific-schematics, allowing you to describe a workflow or architecture in natural language to generate publication-quality diagrams.

Does it preserve my existing Excel templates?

Yes, the skill is designed to study and match existing styles, formats, and conventions when modifying your current files rather than imposing new ones.

Does it support industry-standard financial formatting?

Yes, it defaults to standard conventions such as blue text for inputs, black for formulas, and specific formatting for currency, percentages, and multiples.

Can I use it to analyze large datasets?

Absolutely. It utilizes the pandas library to perform high-speed data manipulation, statistical analysis, and bulk operations on .xlsx and .csv files.

Excel & Data Analysis Toolkit

Name: Excel & Data Analysis Toolkit
Author: K-Dense-AI

byK-Dense-AI

•

3,719

•

Data Science & ML

Creates, edits, and analyzes Excel spreadsheets with production-grade formulas, formatting, and scientific visualizations.

The xlsx skill is a comprehensive spreadsheet processing engine for Claude, designed to handle everything from complex financial modeling to scientific data analysis. It enforces industry standards such as color-coded inputs, zero-error formula validation, and professional number formatting. By leveraging pandas and openpyxl, it allows for dynamic data manipulation while ensuring that all spreadsheets remain updateable through native Excel formulas rather than hardcoded values. Unique to this skill is its integration with scientific schematics and a dedicated recalculation script to guarantee publication-quality, error-free outputs.

Key Features

01Ability to generate and embed AI-powered scientific schematics and diagrams.

02Seamless integration with pandas for high-performance data analysis and visualization.

03Automated formula recalculation and error detection using LibreOffice integration.

04Professional financial modeling with standardized color coding and cell formatting.

053,719 GitHub stars

06Dynamic formula generation to ensure spreadsheets remain interactive and updateable.

Use Cases

01Modifying existing Excel templates while strictly preserving original styles and logic.

02Processing and cleaning large scientific datasets for publication-ready reports.

03Building automated financial models with industry-standard input/output conventions.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add k-dense-ai/claude-scientific-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill