skills.rest
lubancafe
lubancafeCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Convert CSV data into Excel workbooks with charts and pivot summaries.

2|Updated Jan 13, 2026
Search Tags:#automation#Excel#data-analysis#chart#analyze#CSV#pivot
One-click install
npx skills add https://github.com/lubancafe/agent-skills --skill xlsx-lubancafe
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lubancafe/agent-skills/tree/main/xlsx
Command: npx skills add https://github.com/lubancafe/agent-skills --skill xlsx-lubancafe

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates spreadsheet workflows by turning raw CSV data into polished Excel workbooks with data analysis, charts, and templates, reducing manual data preparation time.

Core Features & Use Cases

  • Data analysis and statistics generation from CSV files into an Excel workbook.
  • Bar charts and pivot charts creation for visual data storytelling.
  • Pivot tables generation to summarize large datasets and surface key insights.
  • Recalculation of Excel formulas using LibreOffice via the recalc.py script to ensure up-to-date results.
  • Real-world use case: convert a sales CSV into a dashboard-ready Excel file with charts, summaries, and recalculated formulas.

Quick Start

  1. Create a Python environment and install dependencies from requirements.txt.
  2. Provide sample_data.csv (or your own CSV data) and run analyze_csv.py to generate Data and Summary sheets.
  3. Use create_bar_chart.py to generate a chart data sheet and embed a chart, or use create_pivot_chart.py to build pivot summaries with charts.
  4. Optionally run recalc.py on the resulting Excel file to refresh formulas after updates.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate converting CSV data into Excel workbooks with charts and pivot tables?▼

To automate converting CSV data into Excel workbooks, you can use Python scripts with pandas and openpyxl to generate formatted spreadsheets containing data summaries, bar charts, and pivot tables directly from raw CSV files.

Can I recalculate Excel formulas programmatically after updating spreadsheet data?▼

Yes, you can recalculate Excel formulas programmatically by running the recalc.py script, which uses LibreOffice to dynamically refresh and ensure formula results are up-to-date across your spreadsheets after data updates.

Do I need Python and LibreOffice to generate Excel pivot charts from CSV files?▼

Yes, you need Python with pandas and openpyxl installed to generate Excel pivot charts and data summaries from CSV files, and LibreOffice is required specifically for dynamic formula recalculation via the recalc.py script.

What is the best way to create a dashboard-ready Excel file from raw sales data?▼

The best way to create a dashboard-ready Excel file from raw sales data is using automated Python scripts that build Summary sheets, embed bar charts, generate pivot summaries, and recalculate formulas for finalized reporting.

Why does my Excel pivot chart not reflect updated CSV data after running the analysis script?▼

Your Excel pivot chart might not reflect updated CSV data because formula recalculation is pending, requiring you to run the recalc.py script with LibreOffice to refresh calculated values across the generated spreadsheet.

Can I use conda or venv to set up the environment for automating spreadsheet workflows?▼

Yes, you can use conda or venv to create an isolated Python environment and install dependencies from requirements.txt to start automating spreadsheet workflows and generating formatted Excel workbooks from your CSV data.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

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

Community
Advanced
Mo7amed-MahmoudMo7amed-Mahmoud

excel-generator

Generate and modify Excel workbooks with Python libraries.

Community
Intermediate
KnoWhizKnoWhiz
6

spreadsheet

Create, edit, analyze, and format spreadsheet files using Python libraries.

Official
Intermediate
heyzudeheyzude
4

spreadsheet

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

Community
Intermediate