xlsx

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

Updated Jan 13, 2026
One-click install
npx skills add https://github.com/zeustriton/radarDigital_QA --skill xlsx-zeustriton
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zeustriton/radarDigital_QA/tree/main/skills/xlsx
Command: npx skills add https://github.com/zeustriton/radarDigital_QA --skill xlsx-zeustriton

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

  • Spreadsheet Creation & Formatting: Generate new workbooks with formulas and styling.
  • Data Analysis & Reading: Import, inspect, and analyze data across sheets.
  • Preserve Formulas: Modify existing spreadsheets while preserving formulas and structure.
  • Recalculation: Recompute formulas consistently using an integrated recalculation workflow.
  • Use Case: Example: automate monthly budget spreadsheets by generating templates, populating data, and validating results.

Quick Start

Use the xlsx skill to create a new workbook with a sample sheet and a simple formula.

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 spreadsheet without losing formulas?

To edit an existing Excel spreadsheet without losing formulas, you need a workflow that reads and modifies cell values while preserving the underlying formula structure and sheet formatting. This ensures updates remain intact without corrupting the original workbook logic.

How do I recalculate formulas in an Excel workbook after updating data?

Recalculating formulas in an Excel workbook after updating data requires a recalculation engine to recompute results consistently. An integrated LibreOffice-driven workflow can validate that formulas update correctly and the file remains a valid xlsx format.

Can I automate creating formatted Excel workbooks with formulas from data?

You can automate creating formatted Excel workbooks with formulas by using Python-based spreadsheet manipulation libraries. This allows you to generate new xlsx files complete with calculated formulas, populated data, and consistent cell styling.

What is the best way to read and analyze data across multiple Excel sheets?

The best way to read and analyze data across multiple Excel sheets is to programmatically import and inspect the spreadsheet data. This approach allows you to extract information across different sheets for comprehensive data analysis and visualization.

Does Python openpyxl support recalculating Excel formulas automatically?

Python openpyxl can manipulate Excel files and preserve formulas, but it does not natively recalculate them. A dedicated recalculation workflow, such as a LibreOffice-driven process, is needed alongside openpyxl to ensure formulas recompute and files stay valid.

What file formats are supported for spreadsheet data analysis and modification?

Spreadsheet data analysis and modification workflows commonly support xlsx and xlsm workbook formats, as well as csv and tsv plain text formats. This allows you to import, inspect, and analyze data across various spreadsheet structures.