skills.rest
nmoralescyber
nmoralescyberCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, modify, and validate spreadsheet deliverables across .xlsx, .xlsm, .csv, and .tsv formats.

Updated Apr 25, 2026
Search Tags:#formulas#spreadsheet#excel#xlsx#data-validation#workbook#conditional-formatting
One-click install
npx skills add https://github.com/nmoralescyber/claude-skill-optimization --skill xlsx-nmoralescyber
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/nmoralescyber/claude-skill-optimization/tree/main/skills/admin/xlsx
Command: npx skills add https://github.com/nmoralescyber/claude-skill-optimization --skill xlsx-nmoralescyber

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create, read, and modify spreadsheet deliverables across common formats (.xlsx, .xlsm, .csv, .tsv) to eliminate manual workbook edits and data-entry drudgery.

Core Features & Use Cases

  • Spreadsheet creation, reading, editing, and formatting across multiple formats.
  • Formula-driven calculations with full Excel compatibility (no hard-coded results).
  • Workflow examples: financial models, asset inventories, vendor risk registers, KPI dashboards, and audit workpapers.

Quick Start

Open or create a spreadsheet, implement formulas and formatting, and save the result as an .xlsx file.

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 and formatting without manual data entry?▼

You can automate spreadsheet creation by opening or creating a workbook, applying formulas and formatting, and saving the output as an .xlsx file to eliminate manual data entry.

Can I preserve Excel formulas and template conventions when modifying existing spreadsheets?▼

Yes, spreadsheet modification preserves template conventions, dates, numeric precision, and explicit formula-driven calculations to ensure full Excel compatibility without hard-coding results.

Does this spreadsheet automation tool support building financial models and audit workpapers?▼

Yes, spreadsheet automation supports generating financial models, asset inventories, vendor risk registers, KPI dashboards, and audit workpapers, including bilingual ES/EN trackers.

How do I apply data validation and conditional formatting to an .xlsx file programmatically?▼

You apply data validation and conditional formatting by opening or creating a spreadsheet, implementing the rules and formulas, and saving the validated .xlsx output.

What is the best way to maintain numeric precision and dates when editing Excel workbooks?▼

Maintaining numeric precision and dates during workbook editing is handled through an audit-friendly metadata workflow that explicitly preserves these values across .xlsx and .csv formats.

Are there limitations when working with .xlsm files compared to standard .xlsx spreadsheets?▼

Both .xlsx and .xlsm formats are supported for creation, reading, editing, and formatting, though the automation focuses on formula-driven calculations rather than executing macro code.

Related Skills

Explore More Finance & Accounting Skills→
UNO998UNO998

xlsx

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

Community
Advanced
prateekprateek

Excel

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

Community
Intermediate
MaxServDevMaxServDev

leitura-arquivos

Extract structured text, tables, and insights from PDF, DOCX, XLSX, CSV, TXT, and Markdown files.

Community
Intermediate
jscraikjscraik
8

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.

Community
Advanced