skills.rest
FrankAsanteVanLaarhoven
FrankAsanteVanLaarhovenCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit xlsx, csv, and tsv spreadsheets with formulas and formatting.

Updated Aug 23, 2026
Search Tags:#automation#formulas#spreadsheet#excel#data-analysis#xlsx#libreoffice
One-click install
npx skills add https://github.com/FrankAsanteVanLaarhoven/navarobotic-learn --skill xlsx-frankasantevanlaarhoven
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/FrankAsanteVanLaarhoven/navarobotic-learn/tree/main/skills/document-skills/xlsx
Command: npx skills add https://github.com/FrankAsanteVanLaarhoven/navarobotic-learn --skill xlsx-frankasantevanlaarhoven

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates spreadsheet creation, editing, and analysis with formulas, formatting, and data visualization to reduce manual workbook toil.

Core Features & Use Cases

  • Automated spreadsheet creation with formulas and formatting
  • Read and analyze data from .xlsx, .xlsm, .csv, and .tsv files using pandas and openpyxl
  • Modify existing workbooks while preserving formulas, templates, and styles
  • Recalculate formulas across sheets using LibreOffice when needed for end-to-end workflows

Quick Start

Create a new Excel workbook named report.xlsx and add a data sheet with formulas that automatically recalculate when input values change.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and analysis with formulas?▼

Automating spreadsheet creation and analysis is handled by generating xlsx files with formula support and formatting. The Skill uses pandas and openpyxl to ingest data and apply formulas automatically, reducing manual workbook toil.

Can I modify an existing Excel template while preserving formulas?▼

Yes, you can modify existing Excel templates while preserving formulas, styles, and layouts. The Skill reads .xlsx and .xlsm files with openpyxl to update data or apply formatting without breaking your existing formula logic.

Does this approach support reading and analyzing csv and tsv files?▼

Reading and analyzing csv and tsv files is fully supported alongside xlsx and xlsm formats. The Skill uses pandas to ingest these flat files, allowing you to parse raw data and perform automated analysis within your spreadsheet workflows.

Do I need LibreOffice to recalculate formulas across spreadsheets?▼

You need LibreOffice specifically for recalculating formulas across spreadsheets. While pandas and openpyxl handle data ingestion and file creation, LibreOffice is required to execute end-to-end workflows that demand live formula recalculation.

What is the best way to generate formatted Excel reports from raw data?▼

The best way to generate formatted Excel reports from raw data is to use an automated workflow that ingests csv or tsv files via pandas and outputs formatted xlsx files. This process applies formulas and styles automatically to produce ready-to-use reports.

Related Skills

Explore More Data & Analytics Skills→
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
PostalocityPostalocity
1

xlsx

Clean, transform, and generate .xlsx workbooks from .xlsx, .xlsm, .csv, and .tsv inputs.

Official
Intermediate
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate
kamal81684kamal81684

xlsx

Create, edit, and validate Excel workbooks with formulas using openpyxl and pandas.

Community
Advanced