skills.rest
luuspoo-create
luuspoo-createCOMMUNITY
Explore all skills by this author →
GitHub

dokument-xlsx

Open, read, edit, clean, and convert spreadsheet files with Excel formulas.

1|Updated Apr 11, 2026
Search Tags:#pandas#openpyxl#excel#xlsx#spreadsheet-automation#data-cleaning#recalc
One-click install
npx skills add https://github.com/luuspoo-create/claude-bildungs-skills --skill dokument-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dokument-xlsx
Source: https://github.com/luuspoo-create/claude-bildungs-skills/tree/main/dokument-xlsx
Command: npx skills add https://github.com/luuspoo-create/claude-bildungs-skills --skill dokument-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines any workflow where a spreadsheet file is the primary input or output, removing manual steps for opening, reading, editing, cleaning, converting, and producing .xlsx/.xlsm/.csv/.tsv deliverables while ensuring professional formatting and error-free formulas.

Core Features & Use Cases

  • Spreadsheet creation and conversion: Build new workbooks from data sources or convert CSV/TSV files into polished Excel files with proper headers, number formats, and charts.
  • Cleaning and restructuring: Repair malformed rows, fix misplaced headers, normalize types, and transform messy tabular exports into structured worksheets ready for analysis.
  • Formula-first modelling and verification: Insert Excel formulas (never hardcode calculations), enforce number and color-coding conventions for financial models, and validate that no formula errors remain using LibreOffice recalculation.
  • Use Case: Convert a teacher's exported grades CSV into a formatted .xlsx with calculated averages, conditional formatting, a summary sheet, and verified formulas.

Quick Start

Open 'grades.csv' and produce a formatted Excel workbook with formulas for averages, validated number formats, and a summary chart.

Frequently Asked Questions about dokument-xlsx

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

FAQPage Schema
How do I convert a CSV file into a formatted Excel workbook with formulas?▼

To convert a CSV file into a formatted Excel workbook with formulas, this Skill reads the tabular data, applies proper headers and number formats, inserts Excel formulas for calculations, and outputs a polished .xlsx file verified by LibreOffice recalculation.

What's the best way to clean and restructure messy spreadsheet exports for analysis?▼

The best way to clean and restructure messy spreadsheet exports is to repair malformed rows, fix misplaced headers, and normalize data types, transforming unstructured .csv or .tsv files into structured worksheets ready for analysis.

Can I use pandas and openpyxl to add columns and preserve Excel formulas in xlsx files?▼

Yes, you can use pandas and openpyxl to add columns and preserve Excel formulas in xlsx files. This Skill leverages those frameworks to edit spreadsheets, compute formulas, apply formatting, and ensure the final .xlsx or .xlsm output maintains error-free calculations.

Does this spreadsheet automation approach support creating charts and summary sheets in Excel?▼

Yes, this spreadsheet automation approach supports creating charts and summary sheets in Excel. It builds new workbooks from data sources, applies conditional formatting, generates summary charts, and produces a complete .xlsx deliverable for reporting.

Why do my spreadsheet formulas show errors after converting and editing xlsx files?▼

Spreadsheet formulas show errors after editing xlsx files when calculations are not properly recalculated. This Skill prevents errors by requiring LibreOffice recalculation via scripts/recalc.py whenever formulas are present, ensuring the final spreadsheet deliverable has zero formula errors.

Related Skills

Explore More Data & Analytics Skills→
zephyrwang6zephyrwang6
333

xlsx

Create, edit, and analyze spreadsheets in .xlsx, .xlsm, and CSV formats.

Community
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
jsolarzjsolarz

xlsx

Create, edit, and analyze Excel spreadsheets with formula recalculation.

Community
Advanced
YHWriteCodeYHWriteCode

xlsx

Create, read, edit, and convert spreadsheet files with formula recalculation.

Community
Advanced