skills.rest
felix-howard
felix-howardCOMMUNITY
Explore all skills by this author →
GitHub

ck:xlsx

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

Updated Jan 11, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/felix-howard/ella --skill ck-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:xlsx
Source: https://github.com/felix-howard/ella/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/felix-howard/ella --skill ck-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, modification, and analysis of spreadsheet files, ensuring data integrity and adherence to professional formatting standards.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Data Analysis: Utilize pandas for in-depth data manipulation and analysis.
  • Formula Recalculation & Validation: Ensure all formulas are error-free and correctly calculated using LibreOffice.
  • Use Case: Automatically generate a financial projection spreadsheet, populate it with assumptions, add complex formulas, and then verify all calculations are correct before delivering it.

Quick Start

Use the ck:xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided data.

Frequently Asked Questions about ck:xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet with formulas and ensure there are zero calculation errors?▼

You can create an Excel spreadsheet with formulas and guarantee zero calculation errors by using this Skill, which leverages openpyxl for formula generation and LibreOffice via recalc.py to validate and recalculate all outputs.

Can I edit an existing .xlsx file without losing its original template formatting?▼

Yes, you can edit an existing .xlsx file without losing its original template formatting because this Skill preserves existing template formats when updating, utilizing openpyxl for precise formatting control alongside pandas for data manipulation.

Does pandas support pivot tables and chart generation for .xlsx and .csv files?▼

Pandas supports pivot tables and chart generation for .xlsx and .csv files within this workflow, enabling in-depth data manipulation and visualization directly from the spreadsheet data.

What is the best way to automate financial projection spreadsheet generation and populate it with assumptions?▼

The best way to automate financial projection spreadsheet generation is using this Skill to populate data with assumptions, add complex formulas, and verify calculations before delivering a finalized, error-free .xlsx file.

How do I analyze data across .xlsx, .csv, and .tsv formats using openpyxl and pandas?▼

To analyze data across .xlsx, .csv, and .tsv formats, this Skill uses pandas for in-depth data manipulation and openpyxl for formatting control, allowing seamless creation, editing, and analysis of multiple spreadsheet formats.

Related Skills

Explore More Finance & Accounting Skills→
shalevaminshalevamin

spreadsheet

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

Community
Intermediate
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
cbbkrd-techcbbkrd-tech

xlsx

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

Community
Advanced