skills.rest
zmre
zmreCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

1|Updated Nov 23, 2025
Search Tags:#automation#reporting#spreadsheet#excel#xlsx#data entry#calculations
One-click install
npx skills add https://github.com/zmre/nix-pai --skill xlsx-zmre
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zmre/nix-pai/tree/main/claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/zmre/nix-pai --skill xlsx-zmre

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually handling Excel spreadsheets for data entry, calculations, or report generation is tedious and error-prone. This skill automates these tasks, ensuring accuracy and freeing up valuable time for more strategic work.

Core Features & Use Cases

  • Data Reading & Writing: Programmatically read data from and write data to Excel files, streamlining data transfer.
  • Automated Calculations: Perform complex calculations and update formulas within spreadsheets, eliminating manual formula entry.
  • Report Generation: Create structured Excel reports from raw data, including formatting, to automate routine reporting.
  • Use Case: You receive daily sales data in a CSV. Use this skill to automatically import the data into an Excel template, update pivot tables, recalculate totals, and generate a formatted daily sales report.

Quick Start

Use the xlsx skill to read data from the sheet named 'Sales' in the attached file 'sales_report.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 data entry and report generation from CSV files?▼

Automate Excel data entry by programmatically reading CSV files and writing data into Excel templates, then updating formulas and formatting to generate reports. This eliminates manual spreadsheet updates and ensures consistency across daily or recurring tasks.

Can I update Excel formulas and recalculate dependent cells automatically?▼

Yes. The skill updates formulas within existing .xlsx and .xlsm files while preserving template structure, then recalculates dependent formulas to reflect changes. This ensures all calculations remain accurate without manual intervention.

What Excel file formats and calculation errors does this skill handle?▼

The skill works with .xlsx, .xlsm, .csv, and .tsv files and resolves common formula errors like #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME?. It applies explicit formatting rules and uses Excel formulas rather than hardcoded values.

How do I create structured Excel reports with formatting and data analysis?▼

Create new spreadsheets with formulas, color-coding, and formatting standards applied programmatically. Read and analyze data from source files, then generate formatted reports that adhere to template conventions without manual layout work.

Can I preserve template conventions and formatting when updating existing spreadsheets?▼

Yes. The skill updates existing Excel templates while maintaining formulas, color-coding, and formatting standards. Data modifications respect the original structure, ensuring templates remain consistent across edits.

What's the best way to handle complex financial models and multi-file data workflows?▼

Use the skill to automate financial model updates across .xlsx and .csv files, ensuring zero formula errors and recalculating dependent values. This approach centralizes spreadsheet logic and eliminates manual formula maintenance across linked files.

Related Skills

Explore More Data & Analytics Skills→
EdgeHuntEdgeHunt

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.

Official
Advanced
AndersHsuehAndersHsueh

xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Community
Advanced
dthuy62dthuy62

ck:xlsx

Create and validate Excel workbooks with formulas, formatting, and data analysis.

Community
Advanced
hotriluanhotriluan

ck:xlsx

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

Community
Intermediate