skills.rest
mkalhitti-cloud
mkalhitti-cloudCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas and charts.

2|3|Updated Jan 11, 2026
Search Tags:#data analysis#Excel#formulas#xlsx#spreadsheet automation#recalc
One-click install
npx skills add https://github.com/mkalhitti-cloud/universal-or-strategy --skill xlsx-mkalhitti-cloud
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mkalhitti-cloud/universal-or-strategy/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/mkalhitti-cloud/universal-or-strategy --skill xlsx-mkalhitti-cloud

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill eliminates the repetitive, error-prone task of creating, updating, and analyzing spreadsheets by programmatically generating workbooks, preserving formulas, and producing consistent data visuals.

Core Features & Use Cases

  • Automated Workbook Creation: Generate new workbooks with formulas and formatting from data sources (CSV, TSV, or direct data).
  • Data Reading & Analysis: Load and analyze data across sheets, summarize results, and generate reports.
  • Template Preservation & Recalculation: Modify existing templates while preserving formulas; recalculate using a LibreOffice-based tool to ensure correctness.
  • Use Case: Automate a monthly sales report by ingesting CSV data, building a workbook with charts, and exporting a CSV snapshot.

Quick Start

Create or edit a workbook (example: sales_dashboard.xlsx) and then run recalc.py to refresh formulas. Example steps:

  1. Prepare data file (e.g., data.csv).
  2. Use this skill to create or update an Excel workbook (e.g., sales_dashboard.xlsx) with formulas and charts.
  3. Run the recalc.py script to refresh all formulas:
    • python recalc.py sales_dashboard.xlsx

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation with formulas and formatting from CSV data?▼

You can automate Excel workbook creation by programmatically generating new .xlsx files with formulas and formatting directly from CSV or TSV data sources. This approach eliminates repetitive manual spreadsheet work and ensures consistent data visuals.

Does openpyxl preserve formulas when editing existing Excel templates?▼

Yes, openpyxl preserves formulas when modifying existing Excel templates. The Skill enforces explicit cell references and maintains formatting conventions while a LibreOffice-based recalculation workflow ensures zero formula errors after edits.

What is the best way to recalculate formulas in an automated xlsx workflow?▼

The best way to recalculate formulas in an automated xlsx workflow is running the recalc.py script with a LibreOffice-based tool. This ensures all formulas refresh correctly and produces a workbook with zero formula errors.

Can I read and analyze data across multiple Excel sheets for reporting?▼

Yes, you can read and analyze data across multiple Excel sheets for reporting. The Skill loads data across sheets, summarizes results, and generates reports while supporting .xlsx, .xlsm, .csv, and .tsv formats.

What spreadsheet formats are supported for automated data analysis and validation?▼

Supported spreadsheet formats for automated data analysis and validation include .xlsx, .xlsm, .csv, and .tsv. The Skill enforces formatting conventions and validates data across these file types during workbook creation and editing.

Related Skills

Explore More Data & Analytics Skills→
cookeyholdercookeyholder

xlsx

Open, edit, clean, and convert XLSX, XLSM, CSV, and TSV spreadsheets.

Community
Intermediate
LuizEduPPLuizEduPP

xlsx

Create, edit, and convert spreadsheet files with formulas and formatting.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

group-by-analysis

Automates Excel data grouping, summarization, and visualization across multiple sheets.

Official
Intermediate
vZulinvZulin

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Community
Advanced