skills.rest
Within-7
Within-7OFFICIAL
Explore all skills by this author →
GitHub

skills-xlsx

Create, edit, and analyze Excel and CSV spreadsheets using Python and openpyxl.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill streamlines the day-to-day burden of spreadsheet work by enabling automated creation, editing, and analysis of Excel and CSV files, reducing manual errors and saving time.

Core Features & Use Cases

  • Spreadsheet automation: Create new workbooks with formulas, apply formatting, and automate data updates.
  • Data analysis & reporting: Read and analyze data across sheets to derive insights and generate summaries.
  • Use Case: Imagine daily exports in CSV or XLSX; this Skill can generate consolidated workbooks, preserve existing formulas when updating data, and produce ready-to-share reports.

Quick Start

Use the skills-xlsx skill to create a workbook from a sample CSV and verify formulas across sheets.

Frequently Asked Questions about skills-xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and data analysis?▼

Automate spreadsheet creation and data analysis by using Python with openpyxl to generate workbooks, apply formulas, and read data across sheets. This streamlines daily reporting tasks and consolidates CSV or XLSX exports into ready-to-share files.

How do I update existing Excel templates without overwriting formulas?▼

Update existing Excel templates without overwriting formulas by using openpyxl to load and modify the workbook while preserving the original cell formulas. This ensures automated data updates maintain your predefined spreadsheet calculations.

Does openpyxl support spreadsheet formula recalculation?▼

openpyxl does not natively recalculate formulas, but this spreadsheet automation approach includes a recalc script relying on LibreOffice. This allows you to compute updated formula values after modifying your XLSX data.

What is the best way to consolidate multiple CSV files into a single workbook?▼

The best way to consolidate multiple CSV files into a single workbook is to automate the process with Python and openpyxl. This enables automated data reading, consolidation, and generation of a unified XLSX file with applied formulas.

Can I generate workbooks with formulas across multiple sheets?▼

Yes, you can generate workbooks with formulas across multiple sheets using openpyxl. This spreadsheet automation capability allows you to create new files, apply formatting, and link data between sheets while preserving your formulas.

Related Skills

Explore More Data & Analytics Skills→
JetBrainsJetBrains
302

xlsx

Create, edit, and validate Excel spreadsheets with openpyxl and LibreOffice.

Official
Advanced
pascallammerspascallammers
1

document-processing-xlsx

Creates, parses, and manipulates Excel spreadsheets (.xlsx, .xls) using SheetJS.

Community
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
EvezArtEvezArt
3

xlsx

Create, modify, and analyze Excel files using pandas and openpyxl.

Community
Advanced