skills.rest
wearemssatoshi
wearemssatoshiCOMMUNITY
Explore all skills by this author →
𝕏@wearems_satoshiGitHub

xlsx

Creates, edits, and analyzes spreadsheet files (.xlsx, .csv, .tsv) using Pandas, PyODBC, and OpenPyXL; regenerates formulas with LibreOffice.

Updated Aug 27, 2026
Search Tags:#reporting#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill xlsx-wearemssatoshi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wearemssatoshi/talent-intelligence-calculator2/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill xlsx-wearemssatoshi

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to effortlessly create, edit, and analyze spreadsheet files, transforming raw data into actionable insights and professional reports.

Core Features & Use Cases

  • Data Manipulation: Read, write, and modify Excel files using Python's pandas and openpyxl libraries.
  • Formula Management: Ensure all Excel formulas are correctly implemented and error-free, with automatic recalculation and verification.
  • Use Case: Automatically generate a monthly sales report by pulling data from multiple sources, applying complex financial formulas, formatting the output professionally, and ensuring zero formula errors.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Revenue', and 'Profit'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula calculation and recalculation in Python?▼

Automate Excel formula calculation by using openpyxl to implement formulas and a LibreOffice script to recalculate them, ensuring zero formula errors in .xlsx and .xlsm files. This guarantees correct values without manual recalculation.

What is the best way to clean messy spreadsheet data and format it professionally?▼

Clean messy spreadsheet data and format it professionally by using pandas for data analysis and openpyxl for formatting, ensuring professional font usage and preserving existing templates in your .xlsx, .csv, or .tsv files.

Can I convert between .csv, .tsv, and .xlsx tabular file formats automatically?▼

You can convert between .csv, .tsv, .xlsx, and .xlsm tabular file formats automatically. The Skill reads raw data using pandas and writes it to your desired output format while maintaining data integrity and structure.

Does openpyxl support modifying existing Excel templates without breaking formatting?▼

openpyxl supports modifying existing Excel templates without breaking formatting. The Skill ensures preservation of existing templates while adding columns, computing formulas, and applying professional font usage to your spreadsheets.

How do I generate a formatted Excel report from multiple data sources?▼

Generate a formatted Excel report from multiple data sources by pulling data with pandas, applying financial formulas with openpyxl, and formatting the output professionally. This handles everything from data manipulation to charting.

Why do my Excel formulas show errors after modifying the file with Python?▼

Excel formulas show errors after Python modification due to missing recalculation. The Skill solves this by using openpyxl for formula implementation and a dedicated LibreOffice recalculation script to verify and ensure zero formula errors.

Related Skills

Explore More Finance & Accounting Skills→
gaos6egaos6e

xlsx

Read, edit, and format Excel and tabular files into .xlsx outputs.

Community
Intermediate
Ab0umarAb0umar

Spreadsheets

Create and modify multi-sheet .xlsx workbooks with formulas and charts.

Community
Intermediate
noahsilve123noahsilve123
1

xlsx

Create and edit Excel files with openpyxl and pandas.

Community
Advanced
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced