skills.rest
smukerji
smukerjiCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze spreadsheet files using openpyxl and pandas.

1|Updated Mar 15, 2026
Search Tags:#data analysis#pandas#openpyxl#spreadsheet#excel#xlsx#csv
One-click install
npx skills add https://github.com/smukerji/openTorriAI --skill xlsx-smukerji
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/smukerji/openTorriAI/tree/main/apps/api/skills/bundled/xlsx
Command: npx skills add https://github.com/smukerji/openTorriAI --skill xlsx-smukerji

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, eliminating manual data manipulation and ensuring data integrity.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Data Analysis: Utilize pandas for in-depth data analysis and manipulation of tabular data.
  • Formula Implementation: Ensure all calculations use dynamic Excel formulas, not hardcoded values, for maintainability.
  • Use Case: Convert a messy CSV file into a well-formatted Excel spreadsheet with proper headers, data types, and essential formulas for financial analysis.

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 convert a CSV file into a formatted Excel spreadsheet with formulas?▼

Yes, pandas handles in-depth data analysis and manipulation of tabular data, while openpyxl manages the actual spreadsheet file manipulation, ensuring data integrity throughout the editing process.

Does this approach support creating xlsx files from scratch with dynamic formulas?▼

Yes, you can generate new xlsx files from scratch or other data sources, ensuring all calculations use dynamic Excel formulas rather than hardcoded values for ongoing maintainability.

Can I edit and fix existing xlsx and xlsm files using pandas and openpyxl?▼

You can open, read, edit, and fix existing xlsx and xlsm files by leveraging openpyxl for spreadsheet manipulation and pandas for underlying data analysis to correct formatting or data issues.

What is the best way to convert between different tabular file formats like tsv and xlsx?▼

The best way to convert between tabular formats like tsv, csv, and xlsx is using pandas to parse the source data and openpyxl to write the output spreadsheet, ensuring accurate data type mapping.

Why use dynamic Excel formulas instead of hardcoded values when creating spreadsheets?▼

Using dynamic Excel formulas instead of hardcoded values ensures that your spreadsheet calculations remain accurate and maintainable when underlying data changes, eliminating manual data manipulation.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

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

Community
Intermediate
georgekhananaevgeorgekhananaev
27

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

Community
Advanced
northseadlnorthseadl

spreadsheet

Create, edit, and analyze .xlsx, .csv, and .tsv files with Python.

Community
Intermediate
enoch-robinsonenoch-robinson

xlsx

Read, create, and edit Excel workbooks using pandas and openpyxl.

Community
Intermediate