xlsx

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

Updated Mar 9, 2026
One-click install
npx skills add https://github.com/cbbkrd-tech/jl-finishes --skill xlsx-cbbkrd-tech
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cbbkrd-tech/jl-finishes/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/cbbkrd-tech/jl-finishes --skill xlsx-cbbkrd-tech

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring data accuracy, professional formatting, and dynamic calculations.

Core Features & Use Cases

  • Data Manipulation: Read, write, and modify data in .xlsx, .xlsm, .csv, and .tsv files using pandas.
  • Formula Management: Create, preserve, and recalculate complex Excel formulas using openpyxl and LibreOffice.
  • Formatting & Standards: Apply professional formatting, color-coding, and adhere to financial modeling standards.
  • Use Case: Convert messy tabular data from a CSV into a well-formatted Excel report with calculated totals and growth rates, ensuring all formulas are error-free.

Quick Start

Use the xlsx skill to create a new Excel file named 'financial_report.xlsx' with columns for 'Month' and 'Revenue', and populate it with data for the last quarter.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a messy CSV into a formatted Excel report with formulas?

To convert a messy CSV into a formatted Excel report, you can read the data using pandas, apply professional formatting and color-coding with openpyxl, and add dynamic formulas for calculated totals and growth rates to ensure accuracy.

Can I preserve and recalculate complex Excel formulas in an xlsx file using Python?

Yes, you can preserve and recalculate complex Excel formulas in an xlsx file by managing them with openpyxl and utilizing the LibreOffice suite for accurate formula evaluation and recalculation.

Does this spreadsheet analysis approach support both .xlsm and .tsv file formats?

Yes, this spreadsheet analysis approach supports .xlsm and .tsv file formats, alongside .xlsx and .csv, allowing you to read, write, and modify tabular data across all these formats using pandas.

What do I need to create financial models that adhere to professional formatting standards?

To create financial models adhering to professional formatting standards, you need the Python libraries pandas and openpyxl for data manipulation and formatting, plus the LibreOffice suite for formula evaluation.

What is the best way to apply color-coding and financial modeling standards to spreadsheet data?

The best way to apply color-coding and financial modeling standards to spreadsheet data is by using openpyxl to enforce formatting rules directly within .xlsx or .xlsm files during data manipulation.

Why are my Excel formulas not evaluating when I modify spreadsheets with pandas?

Excel formulas may not evaluate when modifying spreadsheets with pandas because pandas handles raw data, not formula logic; you must use openpyxl to manage formulas and LibreOffice for recalculation.