spreadsheet

Name: spreadsheet
Availability: InStock
Author: kongaharsha

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with openpyxl and pandas.

1|Updated Apr 2, 2026

Search Tags:#pandas #openpyxl #spreadsheet #excel #data-analysis #workflows

Ready to run

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

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/kongaharsha/claude-skills/tree/main/spreadsheet
Command: npx skills add https://github.com/kongaharsha/claude-skills --skill spreadsheet-kongaharsha

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill reduces the manual effort required to create, edit, and analyze spreadsheets while preserving formulas, formatting, and data integrity across Excel, CSV, and TSV workflows.

Core Features & Use Cases

Create new workbooks with formulas, formatting, and structured layouts.
Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
Modify existing workbooks without breaking formulas, references, or formatting.
Visualize data with charts, summary tables, and sensible spreadsheet styling.
Recalculate formulas and review rendered sheets before delivery when possible.
Use case: Import quarterly data, compute totals, and generate styled reports.

Quick Start

Create a sample workbook and run the starter workflow to import, analyze, and output a styled spreadsheet.

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 workbook without breaking formulas and formatting?▼

By using openpyxl, this skill modifies .xlsx files while preserving formulas, references, and formatting. It recalculates formulas when possible to ensure data integrity without manual effort.

Can I analyze CSV and TSV files using pandas without losing workbook styling?▼

Yes, pandas analyzes CSV and TSV files for filtering and aggregation. For .xlsx files, openpyxl applies formatting and charts while preserving existing styling across data workflows.

What is the best way to automate spreadsheet creation and data cleaning for reporting?▼

Automating spreadsheet creation and data cleaning is best handled through workflows that import data, compute metrics, and generate styled reports. This reduces manual effort and prevents formula breakage.

Does this spreadsheet tool support data visualization with charts and summary tables?▼

Yes, the spreadsheet tool supports data visualization by generating charts, summary tables, and sensible styling. It reviews rendered sheets before delivery to ensure accurate reporting outputs.

Why do my formulas break when modifying Excel files, and how can I prevent it?▼

Formulas break when scripts overwrite Excel files without preserving structure. This skill prevents formula breakage by using openpyxl to maintain references and recalculating formulas during modifications.

Do I need prior coding experience to run data analysis workflows on .xlsx and .csv files?▼

No extensive coding experience is needed to run data analysis workflows on .xlsx and .csv files. The skill automates pandas and openpyxl logic to import data, compute totals, and output styled spreadsheets.