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

Ready to run

npx skills add https://github.com/loganylchen/skills --skill spreadsheet-loganylchen

💬 Prompt for ChatGPT / Claude Chat▼

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.