skills.rest
bl1nk-bot
bl1nk-botOFFICIAL
Explore all skills by this author →
GitHub

spreadsheet

Create and edit .xlsx, .csv, and .tsv files with openpyxl and pandas.

3|Updated Feb 13, 2026
Search Tags:#python#pandas#openpyxl#spreadsheet#excel#data-analysis#csv
One-click install
npx skills add https://github.com/bl1nk-bot/skills-cli --skill spreadsheet-bl1nk-bot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/bl1nk-bot/skills-cli/tree/main/skills/spreadsheet
Command: npx skills add https://github.com/bl1nk-bot/skills-cli --skill spreadsheet-bl1nk-bot

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Spreadsheets are central to data work, but automating their creation, updates, and analysis can be error-prone and time-consuming. This Skill enables programmatic handling of .xlsx, .csv, and .tsv files using Python libraries like openpyxl and pandas, while preserving formulas, references, and formatting.

Core Features & Use Cases

  • Create and edit spreadsheets programmatically with Python using openpyxl for Excel files and pandas for data analysis.
  • Preserve formulas and cell formatting when modifying workbooks and generate reliable, reproducible outputs.
  • Use cases include preparing dashboards, consolidating data from multiple sheets, and generating reports from raw data.

Quick Start

Create a new workbook for a project, add at least one sheet, and save the results using openpyxl.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate editing Excel files while preserving formulas and formatting in Python?▼

Automate editing Excel files while preserving formulas and formatting by using the openpyxl library in Python. This Skill modifies .xlsx workbooks programmatically, ensuring cell references and styling remain intact for reliable and reproducible outputs.

What's the best way to consolidate data from multiple spreadsheets using Python?▼

Consolidating data from multiple spreadsheets is best handled with Python pandas. This Skill reads .xlsx, .csv, and .tsv files, consolidating data from multiple sheets into a unified DataFrame for analysis and report generation.

Does this Python spreadsheet Skill support CSV and TSV files for data analysis?▼

Yes, this Python spreadsheet Skill supports CSV and TSV files. It uses pandas to read, edit, and analyze .csv and .tsv files alongside .xlsx workbooks, covering data workflows from raw data processing to report generation.

Can I create a new Excel workbook and add sheets programmatically with Python?▼

Yes, you can create a new Excel workbook and add sheets programmatically with Python using openpyxl. This Skill provides a quick-start workflow to initialize a workbook, add at least one sheet, and save the results.

Why do my existing Excel formulas disappear when I update spreadsheets with pandas?▼

Excel formulas often disappear when pandas updates spreadsheets because it overwrites cell values. This Skill uses openpyxl to preserve formulas and cell formatting when modifying workbooks, preventing data loss during updates.

Related Skills

Explore More Data & Analytics Skills→
jscraikjscraik
8

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.

Community
Advanced
crossxwillcrossxwill
5

ydata-eda-profiling

Generate reproducible ydata-profiling EDA reports from pandas DataFrames.

Community
Intermediate
trungdo9trungdo9
3

xlsx

Create, edit, and analyze .xlsx files with Python and openpyxl.

Community
Advanced
locdinh209locdinh209

xlsx

Create, edit, and analyze Excel spreadsheets with openpyxl and pandas.

Community
Advanced