skills.rest
OpenLoaf
OpenLoafOFFICIAL
Explore all skills by this author →
GitHub

xlsx-skill

Read and write Excel and CSV files for automated spreadsheet workflows.

94|9|Updated Dec 8, 2025
Search Tags:#automation#formulas#excel#data-analysis#xlsx#csv#data-processing
One-click install
npx skills add https://github.com/OpenLoaf/OpenLoaf --skill xlsx-skill
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-skill
Source: https://github.com/OpenLoaf/OpenLoaf/tree/main/apps/server/src/ai/builtin-skills/xlsx
Command: npx skills add https://github.com/OpenLoaf/OpenLoaf --skill xlsx-skill

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates spreadsheet data workflows by providing unified read/write capabilities for Excel and CSV files. This enables automated data processing, reconciliation, and reporting without manual spreadsheet editing.

Core Features & Use Cases

  • Read and interpret Excel workbooks (values, formulas, styles) with ExcelInspect.
  • Write, update, and create spreadsheets (cells, formulas, charts, images) using JsSandbox and exceljs.
  • Convert between CSV and XLSX formats using DocConvert for smooth data exchange.
  • Typical use cases include generating quarterly sales dashboards, performing batch data transformations, verifying data integrity, and building rosters or financial models.

Quick Start

Create a new worksheet named Q1 Sales, populate it with a small dataset, and save the workbook as sales_q1.xlsx.

Frequently Asked Questions about xlsx-skill

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

FAQPage Schema
How do I automate data extraction and batch edits across multiple Excel and CSV files?▼

Automating Excel and CSV workflows involves using unified read and write capabilities to extract values, perform batch edits, and apply calculations across .xlsx and .csv files. This enables automated data processing without manual spreadsheet editing.

Can I convert CSV files to XLSX format for automated data processing?▼

Yes, CSV files can be converted to XLSX format using the DocConvert component. This conversion capability ensures smooth data exchange and allows downstream analytics tools to interpret spreadsheet data consistently.

Does this approach support reading Excel formulas and styles, not just raw cell values?▼

Reading Excel formulas and styles is fully supported through the ExcelInspect component. It interprets workbook contents including values, formulas, and styles, enabling accurate data extraction and integrity verification for financial models.

What is the best way to generate quarterly sales dashboards and financial reports from spreadsheet data?▼

The best way to generate sales dashboards is by writing, updating, and creating spreadsheets programmatically. Using exceljs via JsSandbox allows you to populate cells, formulas, and charts to build automated financial models and rosters.

Are there limitations when writing charts and images to existing workbooks in data workflows?▼

Limitations depend on the exceljs library capabilities used for writing charts and images to workbooks. While standard cell and formula updates are fully supported, complex visual object injections may require specific formatting prerequisites.

Related Skills

Explore More Data & Analytics Skills→
aalmadaaalmada
15

{skill-slug}

Process Excel files and generate reports from XLSX and CSV data.

Community
Intermediate
openaiopenai
488

spreadsheets

Automate spreadsheet creation, analysis, and export workflows.

Official
Intermediate
AlterLab-IEUAlterLab-IEU
58

alterlab-xlsx

Automate spreadsheet cleaning, formatting, and conversion between .xlsx, .csv, and .tsv files.

Community
Advanced
purvishrivastava27purvishrivastava27

file-converter

Convert documents, images, and audio files between formats using Python libraries.

Community
Intermediate