skills.rest
dp-archive
dp-archiveCOMMUNITY
Explore all skills by this author →
GitHub

spreadsheet

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, modification, and analysis of spreadsheet files, streamlining data management and reporting tasks.

Core Features & Use Cases

  • Workbook Creation: Build new .xlsx files with formulas, formatting, and structured layouts.
  • Data Analysis: Read, filter, aggregate, and compute metrics from tabular data using pandas.
  • Formula Preservation: Edit existing workbooks while maintaining formula integrity.
  • Visualization: Create charts and tables with appropriate formatting.
  • Use Case: Generate a monthly sales report by analyzing raw sales data, calculating key performance indicators, and presenting the results in a formatted Excel file with charts.

Quick Start

Create a new spreadsheet named 'sales_report.xlsx' in the 'output/spreadsheet/' directory with columns for 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel report generation from raw data?▼

Yes, you can edit existing .xlsx files while preserving formula integrity by using openpyxl. This allows you to update workbook content, modify structured layouts, and apply formatting without breaking the embedded spreadsheet formulas.

Can I analyze CSV and TSV files using pandas for data reporting?▼

Yes, you can analyze CSV and TSV files using pandas to read, filter, and aggregate tabular data. This data analysis process computes key metrics from your datasets, which can then be exported into a formatted Excel file for reporting.

How do I create charts and tables in an Excel workbook?▼

To create charts and tables in an Excel workbook, you use openpyxl to apply appropriate formatting and visualizations to your tabular data. This enables the generation of structured layouts and visual data representations directly within .xlsx files.

Does this spreadsheet automation approach support formula preservation?▼

Yes, this spreadsheet automation approach supports formula preservation when modifying .xlsx files. It uses openpyxl to ensure that existing formulas remain intact while you edit workbook content, structure, and formatting.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

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

Community
Intermediate
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
Buntyarora97Buntyarora97

excel-generator

Create Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced
ruuxiruuxi
29

officecli-data-dashboard

Convert CSV data into Excel dashboards with live-linked KPIs and charts.

Community
Advanced