skills.rest
zakarooo
zakaroooCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables programmatic creation, editing, and analysis of spreadsheets while preserving formulas and formatting across common file formats such as .xlsx, .xlsm, and .csv.

Core Features & Use Cases

  • Create new workbooks with formulas and custom formatting.
  • Read, analyze, and summarize data from existing spreadsheets.
  • Update existing spreadsheets without breaking formulas, while maintaining templates and styling.
  • Produce simple data-driven reports and visuals by leveraging Python libraries (OpenPyXL) and LibreOffice-based recalculation for formula integrity.

Quick Start

Create a new workbook named report.xlsx with a sheet named "Sales", populate sample data, include a total formula, and save.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create a new Excel spreadsheet with formulas programmatically?▼

Create spreadsheets with formulas using OpenPyXL by defining cells, inserting formulas, and saving as .xlsx. The Skill handles formula syntax and file structure, allowing you to generate workbooks with calculations without manual Excel entry.

Can I edit existing .xlsx files without breaking the formulas?▼

Yes, you can update cells, add data, and modify formatting while preserving existing formulas and templates. The Skill maintains formula integrity and structure when editing, ensuring recalculation accuracy across your workbook.

What's the best way to read and analyze data from spreadsheets programmatically?▼

Use OpenPyXL to read .xlsx, .xlsm, and .csv files, extract cell values and formulas, then analyze data with Python. The Skill extracts structured data for summarization and reporting without manual spreadsheet navigation.

Can I automate report generation by combining spreadsheet data with formulas?▼

Automate report creation by generating workbooks with populated data, calculated totals via formulas, and custom formatting. The Skill enables end-to-end report production, leveraging LibreOffice for formula recalculation and Python for data processing.

Does this work with .xlsm files and macro-enabled spreadsheets?▼

Yes, the Skill supports .xlsm files alongside standard .xlsx and .csv formats. It preserves file structure and formatting when reading or editing macro-enabled workbooks, maintaining compatibility across common Excel file types.

What happens when I need formulas recalculated after updating cell values?▼

LibreOffice integration recalculates formulas after data updates, ensuring accurate results without manual Excel refresh. The Skill manages recalculation automatically, maintaining formula chain integrity across dependent cells.

Related Skills

Explore More Data & Analytics Skills→
OutfinityResearchOutfinityResearch

xlsx-lite

Totalize a numeric column in CSV data and append a Totals row.

Official
Intermediate
IPADS-SAIIPADS-SAI
44

xlsx

Edit and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

Official
Advanced
EstomEstom

spreadsheet

Manipulate and analyze .xlsx, .csv, and .tsv files while preserving formulas and formatting.

Community
Intermediate
beyondkmpbeyondkmp
1

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas across .xlsx/.xlsm/.csv formats.

Community
Advanced