xlsx

Create and edit Excel workbooks from CSV data with formulas and formatting.

Updated Nov 26, 2025
One-click install
npx skills add https://github.com/guiledo/dotfiles --skill xlsx-guiledo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/guiledo/dotfiles/tree/main/opencode/.config/opencode/skills/xlsx
Command: npx skills add https://github.com/guiledo/dotfiles --skill xlsx-guiledo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, validators.

What problem does it solve?

This Skill streamlines the end-to-end management of spreadsheet workloads by enabling creation, editing, formatting, and formula-based validation of Excel workbooks from data sources, ensuring consistency with templates and governance requirements.

Core Features & Use Cases

  • Workbook creation from data sources: generate new .xlsx files from CSVs or datasets using consistent templates.
  • Editing & formatting: apply styles, fonts, and layout conventions to deliver professional spreadsheets.
  • Formula integrity & recalculation: set up formulas and trigger recalculation to guarantee zero formula errors across models.
  • Use Case: when preparing an annual budget from multiple CSV exports, generate a single workbook that follows templates, computes totals, and validates results.

Quick Start

Create a new Excel workbook from a CSV, apply the standard formatting, and ensure all formulas recalculate without errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel workbook from CSV files with formulas and formatting?

Create an Excel workbook from CSV files by using openpyxl to convert datasets into standards-compliant spreadsheets, applying formatting templates, generating formulas, and triggering recalculation to ensure zero formula errors across the final output.

What is the best way to automate spreadsheet creation for budgeting and reporting workflows?

Automate spreadsheet creation for budgeting and reporting by converting data sources into .xlsx files using consistent templates, applying styles and layout conventions, and computing totals with automated formula recalculation to validate final results.

How does automated formula recalculation work for Excel spreadsheets?

Automated formula recalculation for Excel spreadsheets works by setting up formulas within the workbook and triggering a dedicated recalculation process to guarantee zero formula errors across financial models and data preparation outputs.

Does openpyxl support applying styles and layout conventions for professional spreadsheet generation?

Yes, openpyxl supports applying styles, fonts, and layout conventions to generate professional Excel spreadsheets, ensuring outputs adhere to formatting templates and governance requirements during data preparation workflows.

How do I validate data in an Excel workbook to prevent common formula errors?

Validate data in an Excel workbook by applying formula-based validation and triggering automated recalculation, which checks results to prevent common Excel errors and ensures consistency with formatting templates.

Can I edit an existing xlsx file to apply new formatting templates and compute totals?

Yes, you can edit an existing xlsx file to apply new formatting templates, set up formulas to compute totals, and trigger recalculation to guarantee that all updates adhere to governance requirements without formula errors.