skills.rest
kongaharsha
kongaharshaCOMMUNITY
Explore all skills by this author →
GitHub

spreadsheet

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
One-click install
npx skills add https://github.com/kongaharsha/claude-skills --skill spreadsheet-kongaharsha
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
shalevaminshalevamin

spreadsheet

Create, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
omicverseomicverse
32

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

Official
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

group-by-analysis

Group multi-sheet Excel data into styled summary reports with charts.

Community
Intermediate
ClickHouseClickHouse
512

chdb-datastore

Run pandas-compatible tabular workflows on a ClickHouse-backed DataStore.

Official
Advanced