Can it handle CSV and TSV files?

Absolutely. It can read, clean, and convert between .xlsx, .xlsm, .csv, and .tsv formats seamlessly while restructuring messy data.

Does this skill support existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions of your templates to ensure updates feel native to the original document.

How does it ensure formulas are correct?

The skill uses a specialized recalculation script and LibreOffice to verify all cell references and catch errors like #REF! or #DIV/0! before the file is delivered.

Why use this over a standard Python script?

Unlike basic scripts that hardcode results, this skill follows strict financial standards, ensures calculations remain as dynamic formulas, and applies professional visual formatting.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: payolajoker

bypayolajoker

0•

Productivity & Workflow

Automates the creation, editing, and analysis of Excel and tabular data files with professional formatting and dynamic formulas.

The xlsx skill empowers Claude to perform advanced spreadsheet operations, from cleaning malformed CSV data to building audit-ready financial models. It prioritizes the use of dynamic Excel formulas over hardcoded values, ensuring workbooks remain interactive and updateable. By integrating industry-standard formatting conventions—such as specific color-coding for inputs and calculations—and utilizing automated formula verification via LibreOffice, this skill guarantees professional-grade, error-free deliverables suitable for corporate and financial environments.

Key Features

01Dynamic spreadsheet creation and manipulation using pandas and openpyxl.

02Preservation of existing templates, styles, and conventions when updating legacy workbooks.

03Professional financial modeling with industry-standard color-coding (Blue for inputs, Black for formulas).

040 GitHub stars

05Data cleaning and restructuring of malformed CSV, TSV, and XLSX files into proper tables.

06Automated formula verification and error checking (#REF!, #DIV/0!) using LibreOffice integration.

Use Cases

01Updating an existing corporate budget template with new monthly data while maintaining all original styles.

02Cleaning a messy export of customer data from a CSV into a structured, searchable Excel workbook with charts.

03Generating a multi-year financial projection with dynamic growth assumptions and professional formatting.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add payolajoker/ai-agent-setting xlsx

For use in Claude.ai and ChatGPT

Download Skill