spreadsheet

Create, edit, analyze, and visualize spreadsheet files with Python libraries.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/tktaf/codex --skill spreadsheet-tktaf
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/tktaf/codex/tree/main/skills/spreadsheet
Command: npx skills add https://github.com/tktaf/codex --skill spreadsheet-tktaf

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, analysis, and visualization of spreadsheet files, automating complex data manipulation and formatting tasks.

Core Features & Use Cases

  • Workbook Creation & Editing: Build new .xlsx files with formulas, formatting, and charts, or modify existing ones without breaking structure.
  • Data Analysis: Perform filtering, aggregation, pivoting, and metric computation on tabular data using pandas.
  • Visualization: Generate charts and tables directly within Excel files.
  • Use Case: Automatically generate a monthly sales report from raw data, including calculations for growth, visualizations of trends, and proper financial formatting.

Quick Start

Create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

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 with Python?

Automate Excel report generation by using Python libraries like pandas and openpyxl to compute metrics from raw data and output formatted .xlsx files with charts. This handles data aggregation and visualization automatically.

Can I add formulas and formatting to an .xlsx file without breaking its structure?

Yes, you can edit existing .xlsx files to add formulas and formatting without breaking the structure. The Skill modifies workbooks programmatically, preserving original layouts while injecting new calculations and styles.

Does this approach work with CSV and TSV files or only Excel spreadsheets?

This approach works with CSV and TSV files in addition to Excel spreadsheets. You can perform filtering, aggregation, and pivoting on tabular data across these formats using pandas for analysis.

What Python packages do I need to create and visualize spreadsheet data?

You need the openpyxl, pandas, and matplotlib Python packages to create and visualize spreadsheet data. These dependencies handle workbook manipulation, data analysis, and chart generation respectively.

What is the best way to build a workbook with charts from raw tabular data?

The best way to build a workbook with charts from raw tabular data is using Python to process the data with pandas and generate visualizations with matplotlib directly within the .xlsx file.

Why do I need system tools for rendering when working with spreadsheets in Python?

System tools are optionally required for rendering when generating spreadsheet visualizations in Python. They support the matplotlib dependency in drawing and embedding charts directly into the final Excel files.