spreadsheet

Create, edit, analyze, and format spreadsheet files using Python libraries.

6|Updated Jan 29, 2026

Search Tags:#automation #reporting #data analysis #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/KnoWhiz/DoWhiz --skill spreadsheet-knowhiz

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/KnoWhiz/DoWhiz/tree/main/.agents/skills/spreadsheet
Command: npx skills add https://github.com/KnoWhiz/DoWhiz --skill spreadsheet-knowhiz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, analysis, and formatting of spreadsheet files, streamlining data manipulation and reporting tasks.

Core Features & Use Cases

Workbook Creation & Editing: Generate new spreadsheets or modify existing ones with formulas, formatting, and data.
Data Analysis: Perform calculations, aggregations, and generate insights from tabular data.
Visualization: Create charts and format sheets for clear visual representation.
Use Case: Automatically generate a monthly sales report by pulling data from a CSV, applying formulas for totals and growth percentages, and formatting it for presentation.

Quick Start

Use the spreadsheet skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Profit'.

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 a CSV file?▼

Automate Excel report generation by using Python libraries like pandas to read CSV files and openpyxl to apply formulas, calculate aggregations, and format spreadsheets for presentation.

Can I modify an existing spreadsheet while preserving its formulas?▼

Yes, you can modify existing spreadsheets while preserving formulas by using openpyxl to execute formula-aware workflows, ensuring cached recalculation and data integrity are maintained during edits.

What file formats are supported for spreadsheet automation and analysis?▼

Spreadsheet automation supports .xlsx, .csv, and .tsv file formats, allowing you to create, edit, and analyze tabular data seamlessly using pandas and openpyxl libraries.

Does openpyxl support creating charts and visualizing tabular data?▼

Yes, openpyxl supports creating charts and visualizing tabular data, enabling you to format sheets and generate clear visual representations of your data analysis results.

What's the best way to analyze tabular data and calculate aggregations in Python?▼

The best way to analyze tabular data and calculate aggregations is using pandas for data manipulation combined with openpyxl for formula-aware workflows and cached recalculation in spreadsheet files.

How do you handle cached recalculation when automating spreadsheet workflows?▼

Handle cached recalculation in spreadsheet automation by leveraging openpyxl's formula-aware workflows, which preserve existing formulas and ensure correct value updates when modifying workbook data.