skills.rest
loganylchen
loganylchenCOMMUNITY
Explore all skills by this author →
Website𝕏@logan_cylGitHub

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv spreadsheets with Python.

Updated Feb 3, 2026
Search Tags:#automation#data analysis#pandas#openpyxl#spreadsheet#excel
One-click install
npx skills add https://github.com/loganylchen/skills --skill spreadsheet-loganylchen
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/loganylchen/skills/tree/main/spreadsheet
Command: npx skills add https://github.com/loganylchen/skills --skill spreadsheet-loganylchen

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, modification, analysis, and visualization of spreadsheets, eliminating manual data manipulation and ensuring data integrity.

Core Features & Use Cases

  • Workbook Creation: Build new .xlsx files with formulas, formatting, and charts.
  • Data Analysis: Analyze tabular data using pandas for filtering, aggregation, and computation.
  • Editing & Formatting: Modify existing spreadsheets while preserving formulas and styles.
  • Visualization: Generate charts and tables within spreadsheets.

Quick Start

Create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with today's sales data.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I edit an existing Excel file while preserving formulas and formatting?▼

Yes, you can edit existing .xlsx files while preserving formulas and formatting. This Skill uses openpyxl and pandas to manipulate spreadsheet data without overwriting existing styles, ensuring data integrity during modifications.

Can I use pandas to analyze a CSV file and export the results to Excel with charts?▼

Yes, you can use pandas to analyze CSV, TSV, or XLSX files and export the results to Excel. This Skill supports filtering, aggregation, and computation, and uses matplotlib and openpyxl to generate visualizations and charts within the spreadsheet.

What's the best way to automate financial reporting from tabular data?▼

Automating financial reporting is best handled by using Python to aggregate tabular data and generate formatted spreadsheets. This Skill streamlines creating .xlsx files with formulas, custom formatting, and charts for analytical reporting.

Does openpyxl support creating new workbooks with custom formatting and charts?▼

Yes, openpyxl supports creating new .xlsx workbooks with custom formatting and charts. This Skill leverages openpyxl alongside pandas and matplotlib to build spreadsheets, apply styles, and embed visualizations for analytical reporting.

Why does my spreadsheet data lose formulas when I save it with pandas?▼

Spreadsheet formulas are often lost when using pandas alone because it handles data values, not formula objects. This Skill uses openpyxl to preserve and write formulas in .xlsx files, ensuring your calculations remain intact during 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
Victory-HugoVictory-Hugo
1

markitdown

Convert PDF, DOCX, PPTX, XLSX, and other documents to Markdown.

Community
Advanced
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
States-MediaStates-Media

Excel Analysis

Analyze Excel spreadsheets with pandas and openpyxl for reports and charts.

Official
Intermediate