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

Ready to run

npx skills add https://github.com/bl1nk-bot/skills-cli --skill spreadsheet-bl1nk-bot

💬 Prompt for ChatGPT / Claude Chat▼

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.