xlsx

Create, edit, and analyze Excel workbooks and CSV/TSV data with formulas.

1|Updated Nov 14, 2024
One-click install
npx skills add https://github.com/SangIlMo/.dotfiles --skill xlsx-sangilmo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/SangIlMo/.dotfiles/tree/main/.config/claude/skills/xlsx
Command: npx skills add https://github.com/SangIlMo/.dotfiles --skill xlsx-sangilmo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables automated creation, editing, and analysis of spreadsheets, reducing manual workloads in data-intensive tasks.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting to standard templates.
  • Read, analyze, and visualize data across formats such as .xlsx, .xlsm, .csv, and .tsv, while preserving formulas where possible.
  • Modify existing spreadsheets while preserving formulas, including recalculation and template compatibility for consistent results.
  • Use cases include financial modeling, data consolidation, and reporting dashboards that auto-refresh when data changes.

Quick Start

Create a new spreadsheet with a header row, a few data rows, and a simple sum formula.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation with formulas and formatting?

Automate Excel spreadsheet creation by generating new workbooks with standardized formulas and formatting. This approach supports data consolidation and reporting dashboards, ensuring template consistency while reducing manual data entry workloads.

Can I edit existing xlsx files while preserving formulas?

Yes, you can modify existing xlsx files while preserving formulas. The process supports recalculation and template compatibility across .xlsx and .xlsm formats, allowing consistent formula-preserving edits without breaking existing spreadsheet logic.

What is the best way to analyze CSV and TSV data for reporting dashboards?

Analyzing CSV and TSV data for reporting dashboards involves reading, processing, and visualizing information across multiple formats. This method handles financial modeling and data consolidation, enabling auto-refreshing reports when underlying data changes.

Does spreadsheet automation work with CSV and TSV file workflows?

Spreadsheet automation works with CSV and TSV file workflows alongside Excel formats. The process reads, analyzes, and visualizes data across .xlsx, .xlsm, .csv, and .tsv files, supporting format conversion and data consolidation tasks.

How do I maintain standard templates when modifying spreadsheets?

Maintain standard templates when modifying spreadsheets by applying formula-preserving edits with recalculation compatibility. This ensures consistent formatting and formula integrity across financial models and reporting dashboards during automated data updates.

What are the limitations of automated spreadsheet formula preservation?

Automated spreadsheet formula preservation works across .xlsx, .xlsm, .csv, and .tsv formats but may face constraints with complex nested formulas or specialized Excel functions. Template compatibility and recalculation accuracy depend on the original formula structure.