skills.rest
AnishWerkstatt
AnishWerkstattCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas.

Updated Feb 8, 2026
Search Tags:#automation#formatting#formulas#excel#data-analysis#xlsx
One-click install
npx skills add https://github.com/AnishWerkstatt/automated-budget-tools --skill xlsx-anishwerkstatt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/AnishWerkstatt/automated-budget-tools/tree/main/public/xlsx
Command: npx skills add https://github.com/AnishWerkstatt/automated-budget-tools --skill xlsx-anishwerkstatt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

Core Features & Use Cases

  • Create new spreadsheets from formulas and formatting templates, with consistent styling and validation.
  • Read, analyze, and visualize data inside Excel workbooks, maintaining existing formulas during edits.
  • Update or modify existing spreadsheets while preserving formulas and templates for repeatable reporting.
  • Use Case: Generate a quarterly financial workbook with budget, actuals, and charts from raw data, keeping formulas intact.

Quick Start

Generate a populated Excel workbook template for quarterly sales with built-in formulas and formatting.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I edit an existing Excel workbook while preserving formulas?▼

To edit an Excel workbook while preserving formulas, you can use this Skill to read, modify, and update existing spreadsheets. It maintains your formulas and templates intact during edits for repeatable reporting workflows.

Can I create a new Excel spreadsheet with formulas and formatting automatically?▼

Yes, you can create new spreadsheets automatically with formulas and formatting. This Skill generates populated Excel workbook templates from raw data, applying consistent styling, data validation, and built-in formulas for structured reporting.

What is the best way to analyze and visualize data inside an Excel workbook?▼

The best way to analyze and visualize data inside an Excel workbook is using this Skill's Python-based libraries. It enables data analysis and visualization directly within Excel files, allowing you to generate charts from raw data while recalculating formulas.

Does this Excel automation approach support CSV and TSV file formats?▼

Yes, this Excel automation approach supports CSV and TSV file formats. It comprehensively handles spreadsheet creation, editing, and analysis across formats like .xlsx, .xlsm, .csv, and .tsv for finance, operations, and analytics workflows.

How do I generate a quarterly financial workbook with budget and actuals charts?▼

You can generate a quarterly financial workbook with budget, actuals, and charts by feeding raw data into this Skill. It automatically builds the populated Excel workbook, applying built-in formulas, formatting, and data visualization while keeping formulas intact.

Related Skills

Explore More Data & Analytics Skills→
mxzinkemxzinke
2

xlsx

Read, clean, transform, and convert spreadsheet data across .xlsx, .csv, and .tsv formats.

Community
Intermediate
andreaswasitaandreaswasita
33

excel-analysis

Automate Excel data analysis, transformation, and visualization with Copilot.

Community
Intermediate
Li-Bai-GOATLi-Bai-GOAT

xlsx

Create, edit, and analyze spreadsheets with openpyxl and pandas.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-analytics-reporter

Analyze data, build statistical models, and generate business intelligence reports.

Community
Advanced