skills.rest
UholySmokes
UholySmokesCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel files with formulas and pandas.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data efficiently, handling complex formulas, formatting, and data manipulation tasks.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new Excel files or modify existing ones with data, formulas, and formatting.
  • Formula Management: Ensure formula accuracy, recalculate values, and identify errors.
  • Data Analysis: Utilize pandas for in-depth data manipulation and analysis.
  • Use Case: Automatically generate a financial projection model in Excel, complete with industry-standard formatting and formulas, based on provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create and format an Excel spreadsheet from provided data?▼

To create and format an Excel spreadsheet, you can generate new .xlsx files or modify existing ones by applying industry-standard formatting, inserting data, and implementing formulas automatically.

Can I use pandas for data analysis on existing Excel files?▼

Yes, pandas is integrated for in-depth data manipulation and analysis on existing Excel files, enabling efficient processing of .xlsx, .xlsm, .csv, and .tsv formats for reporting tasks.

How do I check Excel formulas for errors and recalculate values?▼

You can check Excel formulas for errors and recalculate values using LibreOffice, which ensures formula accuracy and identifies calculation issues within your spreadsheet models.

Does this approach support building automated financial projection models?▼

Yes, this approach supports building automated financial projection models by generating Excel files complete with formulas and formatting based on your provided financial assumptions.

What is the best way to convert CSV data into a formatted Excel report?▼

The best way to convert CSV data into a formatted Excel report is by utilizing pandas for data manipulation and openpyxl for applying formatting and formulas to the final .xlsx file.

What spreadsheet file formats are supported for editing and data analysis?▼

Supported spreadsheet file formats for editing and data analysis include .xlsx, .xlsm, .csv, and .tsv, allowing comprehensive management across various tabular data structures.

Related Skills

Explore More Finance & Accounting Skills→
dp-archivedp-archive
1.1k

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting for .xlsx, .csv, and .tsv files.

Community
Intermediate
w7panelw7panel
182

xlsx

Automate Excel file creation, editing, and analysis with openpyxl and pandas.

Official
Advanced
KILWA73KILWA73

data-visualization

Generate publication-quality PNG charts from pre-processed numeric data using pandas, matplotlib, and seaborn.

Community
Advanced
safzanpiranisafzanpirani
1

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced