skills.rest
stefanbosak
stefanbosakCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Automate Excel creation, editing, and analysis with formula-safe workflows.

Updated Jan 22, 2026
Search Tags:#automation#formulas#spreadsheet#excel#data-analysis#xlsx#recalculation
One-click install
npx skills add https://github.com/stefanbosak/copilot-cli --skill xlsx-stefanbosak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/stefanbosak/copilot-cli/tree/main/.copilot/skills/xlsx
Command: npx skills add https://github.com/stefanbosak/copilot-cli --skill xlsx-stefanbosak

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines Excel-based workflows by enabling automated creation, editing, and analysis of spreadsheets while preserving formulas and templates.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting
  • Read, analyze, and visualize data in spreadsheets
  • Modify existing spreadsheets while preserving formulas and templates; recalculate formulas when data changes using LibreOffice via recalc.py

Quick Start

Provide an Excel file and describe the desired updates; I will apply formulas, preserve existing templates and formatting, and recalculate all formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel spreadsheet while preserving existing formulas and formatting?▼

You can edit a spreadsheet while preserving formulas and formatting by providing the .xlsx file and describing the updates needed. The Skill applies changes without breaking existing templates and recalculates all formulas automatically using LibreOffice via recalc.py.

Can I automate Excel creation for financial models and reporting templates?▼

Yes, you can automate Excel creation for financial models, dashboards, and reporting templates. The Skill generates new spreadsheets with formulas and formatting intact, supporting .xlsx, .xlsm, and CSV/TSV data formats for automated workflows.

Does this approach support recalculation of formulas when spreadsheet data changes?▼

Yes, formula recalculation when data changes is supported through a dedicated workflow using LibreOffice via recalc.py. This ensures all formulas in financial models and dashboards are recalculated accurately after modifications are applied.

How do I read and analyze data in Excel files using pandas?▼

You can read and analyze spreadsheet data using pandas integration built into the Skill. It reads .xlsx, .xlsm, and CSV/TSV files, enabling data analysis and visualization while maintaining formula-safe workflows across all supported formats.

What file formats are supported for Excel automation and data analysis?▼

Supported file formats for Excel automation and data analysis include .xlsx, .xlsm, and CSV/TSV. The Skill handles formula-safe creation, editing, and recalculation across all these formats for financial models and reporting templates.

What is the best way to modify existing Excel templates without breaking formulas?▼

The best way to modify existing Excel templates without breaking formulas is to provide the file and describe desired updates. The Skill preserves formulas and formatting, then recalculates all formulas via LibreOffice using recalc.py to ensure data integrity.

Related Skills

Explore More Data & Analytics Skills→
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
imvladikonimvladikon
3

xlsx

Automate Excel workbook editing with formulas via openpyxl and pandas.

Community
Intermediate
TNHoang2708TNHoang2708
1

ck:xlsx

Create and manipulate .xlsx files with openpyxl and pandas.

Community
Advanced
AndersHsuehAndersHsueh

xlsx

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

Community
Advanced